Accessing a sybase anywhere 5.0 server 
Author Message
 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



Fri, 04 Feb 2005 17:43:24 GMT  
 Accessing a sybase anywhere 5.0 server
Hi

Quote:
> 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).

I'v this problem too and try sovle it in many ways. In my case this error
occured when IIS try stard DB Engine od DB Client. When I do this manually
all goes fine. I don't know reason of this behaviour but this should help.
You can manipulate options in DSN configuration - maby it's help (in my
machine doesn't help).

Good luck

Ziemowit Skowro?ski
-------------------------------------------------------
ComputerLand S.A. - Poland - Gdansk Branch
PL-83-000 Pruszcz Gdanski, Czolgistow 8/10
phone: +48 58 69 29 236 ,  mobile: +48 608 468 186

-------------------------------------------------------



Sat, 05 Feb 2005 17:26:07 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing a sybase anywhere 5.0 server

2. Accessing a sybase anywhere 5.0 server

3. GetBookmark w/ Sybase Anywhere 5.0

4. C++ Library for database access (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase and ODBC)

5. CDaoTableDef.GetIndexInfo fails with ODBC Sybase SQL Anywhere

6. CDaoRecordset.AddNew() fails with ODBC Sybase SQL Anywhere

7. How about Sybase SQL Anywhere?

8. CDaoRecordset.AddNew() fails with ODBC Sybase SQL Anywhere

9. VC 5.0 Enterprise Edition & Sybase

10. Adaptive Server Anywhere LONG BINARY problem

11. CDaoDatabase to connect to Adaptive Server Anywhere 6.0

12. Sybase Open Server (Passing Parameters/Pointers)

 

 
Powered by phpBB® Forum Software