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

["Ken Marcus - Precision Web Hosting" <ken@xxxxxxxxxxxxxxxx>]

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


>
>
> > -----Oorspronkelijk bericht-----
> > Van: Spades [mailto:spades@xxxxxxxxxxxxx]
> > Verzonden: maandag 13 oktober 2003 1:07
> > Aan: cobalt-users@xxxxxxxxxxxxxxx
> > Onderwerp: Re: [cobalt-users] ASP + mysql on RAQ4
> >
> >
> > 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
> >
> > _____________________________________
> > 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
> >
> >
> >
>
>
> Check the existence of /tmp/mysql.sock, and if it points to the correct
> location. These errors are typicaly generated after [some] sun patches
> which remove the mysql.sock file.
>
> Bob.
>


When I had this problem I jsut upgraded to the Chillisoft 3.6.2 and it took
care of it. Maybe it fixed the missing mysql.sock  file during the upgrade.



----
Ken Marcus
Precision Web Hosting
ken@xxxxxxxxxxxxxxxx
http://www.precisionweb.net