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

["H.P. Noordam" <bno@xxxxxxxxxxxx>]

> -----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.