RE: [cobalt-users] ASP expert required - Please

["Ervin Tarkhanian" <ervin@xxxxxxxxxx>]

If you're trying the "Test DSN" in the ASP admin section, forget about it,
they've got some bugs that don't allow it to run.

You can make your own ASP page and try the following connection string to
see if it will work:

<%
ConnectionString =
"driver={MySQL};server=MyServerName;database=MyDatabase;uid=MyUserName;pwd=M
yUserName;"

On Error Resume Next
SET Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnectionString, "MyUserName", "MyUserName"
Conn.Close
SET conn = Nothing

If Err Then
Response.write "The connection to the database failed<BR><BR>"
Response.Write "Error: " & Err.Description
Else
Response.write "The connection to the database was successful!"
End If
%>

Hope that helps

Regards,
Erin

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Harvey Raybould
Sent: Friday, January 11, 2002 11:49 AM
To: 'cobalt-users@xxxxxxxxxxxxxxx'
Subject: [cobalt-users] ASP expert required - Please

Hi Everyone,

I have a couple of Raq4s that I cannot get the ASP to
connect to mysql. Both come up with different error
messages.
____________________________________________

This is the error message on one of them

Test connecton failed

Error: -2147418113
Description: Can not load OBDC driver
_____________________________________________

When I click test on the other it comes up with

The requested URL was not found on this server.

I have tried various fixes from here and the Chilisoft ASP
site, so now I am really desperate and need some
professional help, which obviously I am willing to pay for.

So please can you contact me off list if you are able to help.

Thanks

Harvey

_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users