codeslinger
February 11th, 2005, 01:18 PM
I'm attempting to connect to a Sybase SQLAnywhere 7.0 database from from ASP.NET using the SQLAnywhere ODBC driver. I've had not problems connecting on my development machine with the database running locally. However, when I deploy my web app to the production Webserver I'm unable to connect to SQLAnywhere running on a remote server. I've used the following connectstring:
DRIVER={Adaptive Server Anywhere 7.0};DSN=(INSOSRVR.EXPADMIN);DATABASE=ExpAdmin;UID=exp;PWD=sql
When attempting to connect I get "Unable to connect to database server; No database file specified."
The DSN is supplied by Primavera Expedition and connects successfully when I test it outside the web app. When I run the web app on the development machine I'm able to connect without a DSN, just providing the SQLAnywhere Server name.
Any ideas?
Thanks..
DRIVER={Adaptive Server Anywhere 7.0};DSN=(INSOSRVR.EXPADMIN);DATABASE=ExpAdmin;UID=exp;PWD=sql
When attempting to connect I get "Unable to connect to database server; No database file specified."
The DSN is supplied by Primavera Expedition and connects successfully when I test it outside the web app. When I run the web app on the development machine I'm able to connect without a DSN, just providing the SQLAnywhere Server name.
Any ideas?
Thanks..