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

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

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