Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to MySQL

Status
Not open for further replies.

dbrooks74

Programmer
Nov 13, 2001
105
US
I'm trying to learn MySQL and would like to know how to connect to it using ASP without having to use a DSN. Do I need a special driver like with Access? A friend of mine said I could do it in pearl but was unsure with ASP. Any ideas? Thanks. d-b
 
snowboardr has some good tutorials on using MySql. That is the link to his site.

The connection strings are not much diff from connecting to access.
admin@onpntwebdesigns.com
 
install MyODBC and use something like:
ConnectionString = "DRIVER={MySQL}; SERVER=localhost; DATABASE=test; USER=monty; PASSWORD=monty; OPTION=3;"
OR
connect_string = "Driver={Mysql}; Server=localhost; Database=mydatabase; UID=myuser; PWD=mypassword"

see >>>>>>
for more info

ES
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top