SelectEtoile : Base de connaissance SGBD

Posts Tagged 'odbc driver'

SYBASE ASE - Connection String

ASE ODBC Driver and OLE DB Provider Migration Technical Whitepaper

ASE ADO.NET Data Provider

 

Standard

Data Source='myASEserver';Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

 

En spécifiant un fichier sql.ini :

DSURL='file://c:\sybase\ini\sql.ini?SQL_MIDOFF_OPC1';Database=myDataBase; UID=myUsername;PWD=myPassword;APP=myAppName;

 

 

Adaptive Server Anywhere OLE DB Provider

Standard

Provider=ASAProv;Data source=myASA;

 

TCP/IP

Provider=ASAProv.90;Eng=server.database_name;Uid=myUsername;Pwd=myPassword; Links=tcpip(Host=servername);

 

 

Sybase ASE OLE DB Provider

 

With Data Source .IDS file

Provider=Sybase ASE OLE DB Provider;Data source=myASE;

 

 

Adaptive Server Enterprise (ASE) alternative 1

Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDataBase;User Id=myUsername;Password=myPassword;

 

Adaptive Server Enterprise (ASE) alternative 2

Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

 

Adaptive Server Enterprise (ASE) 12.5

Provider=Sybase.ASEOLEDBProvider.2;Server Name=myASEserver;Server Port Address=5000;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

 

Adaptive Server Enterprise (ASE) 15.0

Provider=ASEOLEDB;Data Source=myASEserver:5000;Catalog=myDataBase;User Id=myUsername;Password=myPassword;

 

Adaptive Server Enterprise (ASE) 15.0 alternative

Provider=ASEOLEDB;Data Source=myASEserver:5000;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

 

 

.NET Framework Data Provider for OLE DB

Provider=ASAProv;Data source=myASA;

 

 

 

Adaptive Server Enterprise ODBC driver

Adaptive Server Enterprise 15.0

Driver=={Adaptive Server Enterprise};app=myAppName;server=myServerAddress;port=myPortnumber; db=myDataBase;uid=myUsername;pwd=myPassword;

 

Standard Sybase System 12 Enterprise Open Client

Driver={SYBASE ASE ODBC Driver};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword;

 

Standard Sybase System 12.5 Enterprise Open Client

Driver={SYBASE ASE ODBC Driver};NA=Hostname,Portnumber;Uid=myUsername;Pwd=myPassword;

 

TDS based ODBC driver (from Sybase OCS 12.5)

Driver={Sybase ASE ODBC Driver};NetworkAddress=myServerAddress,5000;Db=myDataBase; Uid=myUsername;Pwd=myPassword;

 

Standard Sybase System 11

Driver={SYBASE SYSTEM 11};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword;Database=myDataBase;

 

 

 

Sybase SQL Anywhere (former Watcom SQL) ODBC driver

ODBC;Driver=Sybase SQL Anywhere 5.0;DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db; Uid=myUsername;Pwd=myPassword;Dsn="";

 

 

 

.NET Framework Data Provider for ODBC

Driver=={Adaptive Server Enterprise};server=myServerAddress;port=myPortnumber; db=myDataBase;uid=myUsername;pwd=myPassword;