 |
ASP FAQ |
How can I make a DSN-less connection to a mySQL database?
1) Define a connection string.
Ex: strConnectString = "Driver={MySQL};Server=servername;Database=
dbnam;Uid=userid;Pwd=password"
2) Create a database connection instance.
Ex: set Connection = Server.CreateObject("ADODB.Connection")
3) Open the database connection.
Ex: Connection.Open strConnectString
4)You may also want to set the connection timeout value.
Ex: connection.ConnectionTimesout = 100
5) You can then execute your database queries.
Ex: result = Connection.Execute("SELECT * FROM table");
|
