Accessing a sybase anywhere 5.0 server
I am trying to write I web-user interface that can make queries against a
Sybase Anywhere 5.0 Database. On the test setup, the Database server will
and IIS will be running on the same machine. My problem lies when I try to
make I connection to the database.
string strConnection="DSN=USData";
string strSelect="SELECT * FROM bl";
OdbcConnection odbcConnection=new OdbcConnection(strConnection);
OdbcCommand odbcCommand=new OdbcCommand(strSelect,odbcConnection);
OdbcDataAdapter odbcDataAdapter=new OdbcDataAdapter(odbcCommand);
odbcConnection.Open();
I get this error:
ERROR [08001] [Sybase][ODBC Driver]Unable to connect to database server:
unable to start database engine ERROR [01000] [Microsoft][ODBC Driver
Manager] The driver doesn't support the version of ODBC behavior that the
application requested (see SQLSetEnvAttr).
But from the server i can start sybase central with no problem using the
same settings as in the system-dsn USData.
Thanks much for any insight you might have,
Nathan Going