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

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

> 
> 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()
%>