Re: [cobalt-users] ASP + mysql on RAQ4

["Spades" <spades@xxxxxxxxxxxxx>]

server - default
Test DSN - ems4you

----------------------------------------------------------------------------
----

Test connecton failed

Error: -2147418113
Description: Can not load OBDC driver



----- Original Message ----- 
From: "H.P. Noordam" <bno@xxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Monday, October 13, 2003 1:21 AM
Subject: RE: [cobalt-users] ASP + mysql on RAQ4


>
>
> > -----Oorspronkelijk bericht-----
> > Van: Spades [mailto:spades@xxxxxxxxxxxxx]
> > Verzonden: zondag 12 oktober 2003 18:00
> > Aan: cobalt-users@xxxxxxxxxxxxxxx
> > Onderwerp: Re: [cobalt-users] ASP + mysql on RAQ4
> >
> >
> > Hi, i did all that, and it still gives me
> >
> > ADODB.Connection.1 error '80004005'
> > SQLState: IM003
> > Native Error Code: 80
> > Specified driver could not be loaded
> >
> > The driver i'm using is MyODBC 2.50.28
> >
> > ----- Original Message ----- 
> > From: "H.P. Noordam" <bno@xxxxxxxxxxxx>
> > To: <cobalt-users@xxxxxxxxxxxxxxx>
> > Sent: Sunday, October 12, 2003 7:08 PM
> > Subject: RE: [cobalt-users] ASP + mysql on RAQ4
> >
> >
> > >
> > > >
> > > > Hi guys,
> > > >
> > > > I'm having problems running my .asp site and
> > > > keep getting error as below. how do i install
> > > > the specified driver?
> > > >
> > > > ADODB.Connection.1 error '80004005'
> > > > SQLState: IM003
> > > > Native Error Code: 80
> > > > Specified driver could not be loaded
> > > >
> > > >
> > > > /student.asp, line 6
> > > >
> > > >
> > > > This is the codes:
> > > >
> > > > <%
> > > > Dim ConnString, Conn
> > > > 'ConnString = "Driver={MySQL ODBC 3.51
> > > >
> > Driver};SERVER=[ems.com];DATABASE=[ems];UID=[ems4you];PASSWORD=[xxx]"
> > > > Set Conn = Server.CreateObject("ADODB.Connection")
> > > > Conn.Open "Driver={MySQL ODBC 3.51
> > > >
> > Driver};SERVER=ems.com;DATABASE=db.ems4you;UID=ems4you;PASSWORD=xxx"
> > > > %>
> > > >
> > > > Please advise.
> > > >
> > > > Thanks.
> > > >
> > > > Bryan
> > > >
> > > > _____________________________________
> > >
> > >
> > > Hi,
> > >
> > > Setup a dsn in the chiliasp manager to connect to your
> > database, then
> > > use code like this to connect to the dsn.
> > >
> > > Bob.
> > >
> > >
> > > <%
> > > dsn_STRING = "dsn=pforum;"
> > > ' init voor het later bijzoeken van de teksten van de posts Dim
> > > Recordset2 Set Recordset2 = server.Createobject("ADODB.Recordset")
> > > Recordset2.Activeconnection = dsn_STRING
> > > Recordset2.Source = "SELECT * FROM phpbb_posts_text WHERE
> > post_id = " &
> > > recordset1.fields.item("topic_id").value
> > > Recordset2.open()
> > > %>
> > >
> > >
> > > _____________________________________
> > > cobalt-users mailing list
> > > cobalt-users@xxxxxxxxxxxxxxx
> > > To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> > > http://list.cobalt.com/mailman/listinfo/cobalt-users
> >
> > _____________________________________
> > cobalt-users mailing list
> > cobalt-users@xxxxxxxxxxxxxxx
> > To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> > http://list.cobalt.com/mailman/listinfo/cobalt> -users
> >
> >
>
>
> ADODB.Connection.1 error '80004005'   is typicaly returned if either
> mysql is not running, or the sock file is not in /tmp. You can easily
> verify this with the "test dsn" option in chiliasp. If if fails the
> test, look into the mysql server and sock file. If it passes the test,
> your code does not connect to the dsn.
>
> _____________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users