Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 16, 2012, 05:19:42 PM

Pages: [1]   Go Down
  Print  
Author Topic: ASP + MYSQL  (Read 913 times)
upfor0
Newbie
*
Offline Offline

Posts: 2


« on: October 03, 2008, 03:59:16 AM »

Hi All,

  I have subscribed ASP from lunarpages.

  And I have created a database through CPANEL.

  Now, what is the connection string using for ASP coding?

 eg. dim cn
      cn.open "??","??","??"

  I see the conection string example in PHP in CPANEL. But what about ASP?

  Please advise.

Kenneth
Logged
arbpen
Newbie
*
Offline Offline

Posts: 2


« Reply #1 on: December 27, 2008, 04:48:58 PM »

Your connection should look something like:

set oconn = server.createobject("ADODB.Connection")
oconn.open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; " & _
"DATABASE=yourdb; UID=user; PASSWORD=password; OPTION=3"

You can also go to http://connectionstrings.com for more examples.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: