Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 31st, 2005, 12:13 AM
Registered User
Join Date: May 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default connecting web server and remote db server via asp

im a newbie in asp and totally new to forums like this.
my prob is i have 2 different computers, one that runs my asp pages and the other my database server (mySQL). im working on my local and trying to connect my remote database with my remote webserver using DSNless connection string as more advisable. I installed a myodbc (driver) in my local, supplied the connection details in the data source configuration. (i followed this http://www.devarticles.com/c/a/ASP/...base-Via-ASP/3/ instructions about either connecting to the mySQL db using a System DSN or the Connection String.)

although i was able to query the db already using the System DSN way but only via localhost as testing webserver. i want to connect the remote mysql db to the remote webserver the DSNless connection string approach.

via System DSN:
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "DSN=mysql_dsn"

via DSNless connection string:
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "Driver={mySQL}; Server=; Port=3306; Option=0; Socket=; Stmt=; Database=testdb; Uid=root; Pwd=;"

PLS HELP ME!!! Heaps of thanks!!!!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to a remote database server pratap_routray Oracle 3 October 18th, 2007 08:21 AM
Linking Remote Sql Server with Web server yeetesh Pro VB Databases 1 May 26th, 2005 04:13 AM
how i can connect to remote sql server db yoord ADO.NET 16 June 16th, 2004 01:40 AM
Connecting to a DB from another server... dungey PHP Databases 1 May 7th, 2004 11:13 AM
connecting to remote server moushumi SQL Server 2000 3 March 29th, 2004 07:52 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.