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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MYSQL Connection String
- Thread starter rmccoy
- Start date
Use this if pointing to an ODBC.ini file (you would need to set these values in the ODBC.ini file on your web server along with port address usually 3306) - assumes ODBC MySQL driver is installed.
conn = "DSN=[database name]; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]; DATABASE=[database name]"
Use this for OLEDB or ODBC. You will need to install the MySQL ODBC driver
conn = "Driver{MySQL}; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]; DATABASE=[database name]"
wher conn is connection string.
Books: MySQL & mSQL by O'RIELLY publishers. Written by Randy Jay Yarger, George Reese & Tim King.
conn = "DSN=[database name]; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]; DATABASE=[database name]"
Use this for OLEDB or ODBC. You will need to install the MySQL ODBC driver
conn = "Driver{MySQL}; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]; DATABASE=[database name]"
wher conn is connection string.
Books: MySQL & mSQL by O'RIELLY publishers. Written by Randy Jay Yarger, George Reese & Tim King.
- Status
