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"
etc..
via DSNless connection string:
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "Driver={mySQL}; Server=192.168.1.35; Port=3306; Option=0; Socket=; Stmt=; Database=testdb; Uid=root; Pwd=;"
PLS HELP ME!!! Heaps of thanks!!!!
