ODBC connection works for windows form but not for web
Specs: I am running windows XP on my machine, the location of the datasource is on a 2003 server. The database I'm trying to connect to is an advantage database.
Code:
string connectionString = "Dsn=myDataSource;uid=user;pwd=password;";
using (OdbcConnection connection = new OdbcConnection(connectionString)) {
...
connection.Open();
}
Error Message:
System.Data.Odbc.OdbcException: ERROR [HY000] [Extended Systems][Advantage SQL][ASA] Error 5033: No connected server was found for the given drive letter.
ERROR [HY000] [Extended Systems][Advantage SQL][ASA] Error 5033: No connected server was found for the given drive letter.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()

