MySQL connection works in PHP but not ASP

Question

I have to do a MySQL-Database connection to a remote server using ASP. When I use normal PHP everything is fine. If I use following ASP code

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=MSDASQL;" & _  
           "Driver={SQL Server};" & _
           "Server=mysqlsvr.domain.com;" & _
           "Database=database1;" & _
           "Uid=username;" & _
           "Pwd=password"

I always get the error that the database is not reachable or permission denied... but with PHP everything works fine?! Do you know where the problem is?

Thanks in advance. Regards.

Are ASP and PHP on the same server?

Louis Huppenbauer
– Louis Huppenbauer

2013-01-25 13:12:10 +00:00
Commented Jan 25, 2013 at 13:12 — Louis Huppenbauer
– Louis Huppenbauer, Commented Jan 25, 2013 at 13:12
if the db is MySQL why are you using Driver={SQL Server};?

barvaz
– barvaz

2013-01-25 13:17:06 +00:00
Commented Jan 25, 2013 at 13:17 — barvaz
– barvaz, Commented Jan 25, 2013 at 13:17

Marat · Accepted Answer · 2013-01-25 13:24:03Z

1

connection string is wrong. Try:

"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=mysqlsvr.domain.com; DATABASE=database1; UID=username;PASSWORD=password;"

You need Mysql ODBC driver installed

answered Jan 25, 2013 at 13:24

Marat

15.9k3 gold badges44 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rush · Accepted Answer · 2013-01-25 13:45:36Z

Connect without a DSN

'define the connection string, specify database driver

ConnString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Your_Mysql_DB; " &_ "UID=mysql_username;PASSWORD=mysql_password; OPTION=3"

'create an instance of the ADO connection and recordset objects

 Set Connection = Server.CreateObject("ADODB.Connection")
 Set Recordset = Server.CreateObject("ADODB.Recordset")

Connection with DSN

'create an instance of the ADO connection and recordset objects

Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'open the connection to the database

Connection.Open "DSN=dsn_name"

'Open the recordset object executing the SQL statement and return records

Recordset.Open SQL,Connection

Collectives™ on Stack Overflow

MySQL connection works in PHP but not ASP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related