On Thursday, August 7, 2003, at 03:17 AM, Andre Rombauts wrote:
Thanks again...BTW your original posts probably just got lost in the noise. It's just a busy list.
Online means the db is on an external server. I have all rights on the
directory and I put myself the db on the server.
I have to use ODBC because the database will also be accessed through ASP
pages.
I mentionned that even no Internet access has started when I'm running the
script. And the Error message doesn't seem to be issued by Revolution (Run
Rev guys can give their opinion?). Thus there seem to be a problem between
Windows and RunRev when executing
put
revOpenDatabase("ODBC","myserver.org","/myserver.org/db/ revolution.mdb","","
") into myDB
The problem with Valentina is
1) that if there is indeed a driver for remote access there is no Standalone
application for building, managing the db on the Win platform - or I am
wrong;
2) I'm not sure it will be possible to convert .ASP pages to handle
Valentina stuff (?)
1) I am no Windows expert- Andr�, isn't ASP pages a server side scripting language for Web Pages, not for database connectivity? Shouldn't you be using http GET and POST operations to the URL of the webserver, not trying to connect directly to the database from Rev? Then the ASP script on the server side would make the database connection, format the data, and send it to the http client?
2) If it's really an ODBC connection that is required, I think Bernard nailed it. You must to define an ODBC DSN on the local machine and on the remote server so it would look something like this.
Local Remote Rev <-> ODBC DSN <- Network -> ODBC DSN <-> SQL server
But notice ASP web scripting is nowhere in that picture- so something is confusing about what the requirements are.
Alex Rice, Software Developer Architectural Research Consultants, Inc. http://ARCplanning.com
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
