mySQL

NancyJ

08-22-2005, 08: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-22-2005, 11:10 PM

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, 05:23 AM

And for a great connections site:

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

NancyJ

08-25-2005, 11:21 AM

thanks!

oracleguy

08-25-2005, 06: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, 07:45 PM

another great connection strings site:
http://www.connectionstrings.com/
hehe :D