Database management

[Andre Rombauts]

Hello all!   I've posted several messages related to database management and CGI scripting with Revolution 2.02 but don't need any answer... :-( Are my questions so stupid? I am an educator, not a professionnal programmer...   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 <put revOpenDatabase("ODBC","revo",,,) into myDB> with a DSN defined with the ODBC database source manager). The database is a MS Access db. It has no user or psw defined. I'm using this on a PC XP Home machine. on mouseUp local myDB,myRecSet put revOpenDatabase("ODBC","myserver.org","/myserver.org/db/revolution.mdb","","") into myDB put the result into field "Errors" put revQueryDatabase(MyDB,"SELECT * FROM Users where id = 4") into myRecSet put revDatabaseColumnNamed(myRecSet,"noun") into field "MyData" revCloseDatabase MyDB end mouseUp The Errors field shows [Microsoft][ODBC driver manager] Unavailable datasource and unspecified driver name 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. ...   Andr�