Sybase ODBC - Connecting to ASE 12.5 with C#.NET

Author

Connecting to ASE 12.5 with C#.NET

Jerry

2005-12-08, 8:23 pm

We are trying to connect to a Sybase ASE 12.5 database using .NET/C#. The
connection string is:

ConnectionString ="Driver={SYBASE ASE ODBC Driver};" +
"Srvr=ADVPROD;" +
"Database=advprod;" +
"Uid=Guest;" +
"Pwd=Guest;";

When connecting, the error message is:

ERROR [01S00] [DataDirect][ODBC Sybase Wire Protocol driver]Invalid
attribute in connection string: Srvr.

Any help would be greatly appreciated.

Thanks,

Jerry

Paul

2005-12-09, 8:23 pm

Hi Jerry,

The "Sybase ASE ODBC Driver" is an OEM product of Sybase that is not
supported in the .NET environment. However, you can try Sybase native ASE
ADO.NET Provider in cluded in Sybase SDK 12.5.1 and 15.0 (also on sdk cds
accompanying ASE 12.5.2 and up). These SDKs also contain this Sybase ASE
ODBC Driver and also the ASE ODBC Driver by Sybase (developed by Sybase
Engineering).

You may still try this driver but you do not provide the file version of the
SYODASE.DLL file which is the driver.

For the current driver you need to :

use "Sybase ASE ODBC Driver" for driver name
replace Srvr with NetworkAddress and set this as ASE_HOSTName:Port

If you are using the Client Library version then try using Server instead of
Srvr.

Also before using .NET try using ODBC Test or some odbc based app to verify
the connection string

-Paul

"Jerry" <jerry@ia.ucsb.edu> wrote in message news:4398d89c$1@foru
ms-2-dub...
> We are trying to connect to a Sybase ASE 12.5 database using .NET/C#. The
> connection string is:
>
> ConnectionString ="Driver={SYBASE ASE ODBC Driver};" +
> "Srvr=ADVPROD;" +
> "Database=advprod;" +
> "Uid=Guest;" +
> "Pwd=Guest;";
>
> When connecting, the error message is:
>
> ERROR [01S00] [DataDirect][ODBC Sybase Wire Protocol driver]Invalid
> attribute in connection string: Srvr.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Jerry
>
>
>

Sponsored Links