Accessing a sybase anywhere 5.0 server
Quote:
> 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