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

["Davide Crudo" <nekos@xxxxxxxxxxx>]

Hi there!

I currently use the following for my DBs in MySQL:

(Please note that I've created an ASP driver DSN connection
with the name 'db_name' where I specified the password as well
in the CHILIASP Web interface)

I prefer not to specify the password in the ASP code.

I hope it helps!

Cheers!

Dave

<%

Public dbOne
Public rsOne

Dim strSQL

Set dbOne = Server.CreateObject("ADODB.Connection")
dbOne.open("db_name")

StrSQL = "SELECT * from table_name"

Set rsOne = Server.CreateObject("ADODB.Recordset")
rsOne.Open strSQL, dbOne, 3

%>

<% =rsRecordset("prefix")%>


----- Original Message ----- 
From: "Spades" <spades@xxxxxxxxxxxxx>
To: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Sunday, October 12, 2003 5:59 PM
Subject: 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