Problem with ASP connection to MySQL

[Dwalker]

I'm using the following code to try to connect to an existing MySQL database
that I can connect to with MySQL-Front. But I'm getting a 500 error.
<%
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open "Driver={mySQL};" & _
"Server=00.00.00.00;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=dbName;" & _
"Uid=UserName;" & _
"Pwd=Password"
oConn.close
%>
Is the problem with the IP address? Do I need to supply the Server reference
in some other format? The Database name, userid and password although not
correct in this example are the same ones used in MySQL-front.
What is the Option= statement

[Ray at home]

"Dwalker" <dl_walker@hotmail.com> wrote in message
news:uNN9b.1826$sO4.1508@bignews1.bellsouth.net...

> I'm using the following code to try to connect to an existing MySQL

database

> that I can connect to with MySQL-Front. But I'm getting a 500 error.

First thing to do is find out what the error really is. See here.
[url]http://www.aspfaq.com/2109[/url]

> <%
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.open "Driver={mySQL};" & _
> "Server=00.00.00.00;" & _
> "Port=3306;" & _
> "Option=131072;" & _
> "Stmt=;" & _
> "Database=dbName;" & _
> "Uid=UserName;" & _
> "Pwd=Password"
> oConn.close
> %>
> Is the problem with the IP address?

That's probably a good guess. Take a look at the sample connection strings
for MySQL here. [url]http://www.connectionstrings.com/[/url] The one you'd want to
try first is the OLE DB one.

Ray at home

[Dwalker]

Thanks. Here's the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

/testmysql.asp, line 4

Line 4 is: oConn.open "Driver={mySQL};" & _


"Ray at home" <myfirstname at lane 34 . komm> wrote in message
news:%23%23EiNQMfDHA.128@tk2msftngp13.phx.gbl...

>
> "Dwalker" <dl_walker@hotmail.com> wrote in message
> news:uNN9b.1826$sO4.1508@bignews1.bellsouth.net...

> > I'm using the following code to try to connect to an existing MySQL

> database

> > that I can connect to with MySQL-Front. But I'm getting a 500 error.

>
> First thing to do is find out what the error really is. See here.
> [url]http://www.aspfaq.com/2109[/url]
>
>
>

> > <%
> > Set oConn = Server.CreateObject("ADODB.Connection")
> > oConn.open "Driver={mySQL};" & _
> > "Server=00.00.00.00;" & _
> > "Port=3306;" & _
> > "Option=131072;" & _
> > "Stmt=;" & _
> > "Database=dbName;" & _
> > "Uid=UserName;" & _
> > "Pwd=Password"
> > oConn.close
> > %>
> > Is the problem with the IP address?

>
> That's probably a good guess. Take a look at the sample connection

strings

> for MySQL here. [url]http://www.connectionstrings.com/[/url] The one you'd want to
> try first is the OLE DB one.
>
> Ray at home
>
>
>

[Ray at]

Did you install MySQL drivers?

Ray at work

"Dwalker" <dl_walker@hotmail.com> wrote in message
news:o%3ab.6086$1u6.3101@bignews4.bellsouth.net...

> Thanks. Here's the error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
> /testmysql.asp, line 4
>
> Line 4 is: oConn.open "Driver={mySQL};" & _

[Dwalker]

I thought this might be the problem. The MySQL database is on the hosting
company's server. I'll have to contact them and ask them if they'll install
it. Any other considerations?

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:O6TfQDWfDHA.560@tk2msftngp13.phx.gbl...

> Did you install MySQL drivers?
>
> Ray at work
>
> "Dwalker" <dl_walker@hotmail.com> wrote in message
> news:o%3ab.6086$1u6.3101@bignews4.bellsouth.net...

> > Thanks. Here's the error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Driver Manager] Data source name not found and no

default

> > driver specified
> >
> > /testmysql.asp, line 4
> >
> > Line 4 is: oConn.open "Driver={mySQL};" & _

>
>