p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   ASP Connection to MySQL (http://p2p.wrox.com/showthread.php?t=17015)

fs22 August 17th, 2004 11:28 PM

ASP Connection to MySQL
 
I am attempting to connect to a MySQL database but I cannot seem to get the connection string to work. Here is my string as it stands now...

var MM_connBiblereading_STRING = Server.CreateObject ("ADODB.Connection")
MM_connBiblereading_STRING.Open ("Driver={MySQL}; SERVER=localhost; Port=3306; Option=0; Socket=/tmp/mysql.sock; DATABASE=bibletruthchapel_org; UID=userid; PWD=password;")

Any thoughts as to why it is not working?

Clay Hess

happygv August 18th, 2004 11:35 PM

Not sure if you got to use Socket=/tmp/mysql.sock; there in your connection string.

Try without that.

Check this out for standard connection strings.

Cheers!

_________________________
- Vijay G
Strive for Perfection


All times are GMT -4. The time now is 05:12 PM.

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