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

[Harvey Raybould <harvey@xxxxxxxxxxx>]

Hi,

Thanks for the suggestion. When I tried it it came up with
the following;

The connection to the database failed
Error: Invalid operation on closed object

I think the problem lies with the fact that I am running
mysql 3.23.43 and only have the odbc driver for 3.22 in the
Raq 4 ASP settings.

Is there anyway of updating this driver? Or will I have to
uninstall this copy of mysql and load the pkg available from
cobalt.

Thanks in advance

Harvey

> Message: 13
> From: "Ervin Tarkhanian" <ervin@xxxxxxxxxx>
> To: <cobalt-users@xxxxxxxxxxxxxxx>
> Subject: RE: [cobalt-users] ASP expert required - Please
> Date: Fri, 11 Jan 2002 14:41:02 -0800
> Reply-To: cobalt-users@xxxxxxxxxxxxxxx
> 
> 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;p
wd=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
> 
> _______________________________________________