Forum Moderators: open

Message Too Old, No Replies

Where mysql Driver to be placed in a PWS server to access through ASP?

Where mysql Driver to be placed in a PWS server to access through ASP?

         

svr_karthik

4:46 am on Jul 16, 2001 (gmt 0)



I have the org.gjt.mm.mysql.Driver to connect with mysql using Asp. But i don't know where should i place this driver. My program is giving me the error as Driver can't find. I am using Personal Web server. My files are
in wwwroot directory.

If any one found the solution please help me.

Thankyou.

rpking

9:15 am on Jul 16, 2001 (gmt 0)

10+ Year Member



It's a while since I did it but...

1) install the mySQl driver
2) open up control panel/ODBC Data sources
3) add new mySQl system DSN called for example mySQLnew
4) in ASP, use

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "dsn=mySQLnew;"

You should now be connected.