...

View Full Version : mySQL



NancyJ
08-22-2005, 09:52 PM
I know its possible to connect to ms sql from php but can you access mySQL from asp? If so, how?
I have a client that I suspect(though not yet confirmed) has asp hosting, SQL Server hosting is pricey and I dont think an access database is going to cut it for 10k products

miranda
08-23-2005, 12:10 AM
yes, here are examples for odbc connection strings for MySql

"Driver={MySQL ODBC 3.51 Driver}; Server=servername; Database=dbname; UID=username; PWD=password; Option=3"

driver={MySQL}; server=localhost; uid=username; pwd=password; database=databasename"

Bullschmidt
08-23-2005, 06:23 AM
And for a great connections site:

Connection String Home Page
http://www.carlprothman.net/Default.aspx?tabid=81

NancyJ
08-25-2005, 12:21 PM
thanks!

oracleguy
08-25-2005, 07:41 PM
We've also discussed asp/mysql in this forum before a few times so search first if you run into any trouble.

ghell
08-26-2005, 08:45 PM
another great connection strings site:
http://www.connectionstrings.com/
hehe :D



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum