All geek questions in one place

Which use OLEDB or ODBC for SYbase

I cannot determine which drivers should I use. Even I do not know what I have.

When I try to create a connection string via a .udl file, it only shows SYbase ASE OleDB Provider

While in the installation folder I see the driver in the Syabse Ase ODBC driver list, but it cannot pick up the driver in the connection string, here I used Driver = (Sybase ASE ODBC driver)

Why should i go

thank

+3
source share
1 answer

Using udl, you have the option to generate a connection string that uses the oledb provider. The Sybase ODBC connection string will look like this:

"ODBC;Driver={SYBASE ASE ODBC Driver};Srvr=myServerName;Database=my_db;UID=myUsername;PWD=myPassword"

, DSN odbc ( ODBC), , ​​

"ODBC;DSN=my_DSN;UID=myUsername;PWD=myPassword;"

.net, Sybase.Data.AseClient(Adaptive Server Enterprise Managed Provider). :

Dim cn As New AseConnection("Data Source='servername';Port='5000';UID='myUsername';PWD='myPassword';Database='my_db';")
+4

Source: https://habr.com/ru/post/1747486/

More articles:


All Articles