<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello all!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've posted several messages related to database
management and CGI scripting with Revolution 2.02 but don't need any answer...
:-(</FONT></DIV>
<DIV><FONT face=Arial size=2>Are my questions so stupid? </FONT><FONT face=Arial
size=2>I am an educator, not a professionnal programmer...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Presently I have problems to get linked to an
online ODBC database. Here is the script... Can anyone give some help?
Everything is OK when the same script is used to access the dbase locally (using
<FONT face=Helvetica><put revOpenDatabase("ODBC","revo",,,) into myDB>
with a DSN defined with the ODBC database source manager)</FONT>. The database
is a MS Access db. It has no user or psw defined. I'm using this on a PC XP Home
machine.</FONT></DIV>
<DIV><FONT face=Arial size=2>
<P>on mouseUp</P>
<P>local myDB,myRecSet<BR>put
revOpenDatabase("ODBC","myserver.org","/myserver.org/db/revolution.mdb","","")
into myDB<BR>put the result into field "Errors"<BR>put
revQueryDatabase(MyDB,"SELECT * FROM Users where id = 4") into myRecSet<BR>put
revDatabaseColumnNamed(myRecSet,"noun") into field "MyData"<BR>revCloseDatabase
MyDB</P>
<P>end mouseUp</P>
<P>The Errors field shows [Microsoft][ODBC driver manager] Unavailable
datasource and unspecified driver name</P>
<P>This message is shown immediately and it seems access to the Internet is not
even launched thus I guess this is a problem locally... Do I need to use a DSN
here too? How.</P>
<P>...</P>
<P> </P>
<P>André</P></FONT></DIV></BODY></HTML>