ODBC :
Standard Sybase System 12 (or 12.5) Enterprise Open Client:
"Driver={SY BASE ASE ODBC Driver};Srvr=Ar on1;Uid=usernam e;Pwd=password"
Standard Sybase System 11:
"Driver={SY BASE SYSTEM 11};Srvr=Aron1; Uid=username;Pw d=password;"
Intersolv 3.10:
"Driver={INTERS OLV 3.10 32-BIT Sybase};Srvr=Ar on1;Uid=usernam e;Pwd=password; "
Sybase SQL Anywhere (former Watcom SQL ODBC driver):
"ODBC; Driver=Sybase SQL Anywhere 5.0;
DefaultDir=c:\d bfolder\;Dbf=c: \mydatabase.db; Uid=username;Pw d=password;Dsn= """""
Note! The two double quota following the DSN parameter at the end are escaped quotas (VB
syntax), you may have to change this to your language specific escape syntax. The empty
DSN parameter is indeed critical as not including it will result in error 7778.
AseConnection (.NET)
Standard:
"Data Source='myASEse rver';Port=5000 ;Database='myDB name';UID='user name';PWD='pass word';"
Declare the AseConnection:
C#:
using Sybase.Data.Ase Client;
AseConnection oCon = new AseConnection() ;
oCon.Connection String="my connection string";
oCon.Open();
VB.NET:
Imports System.Data.Ase Client
Dim oCon As AseConnection = New AseConnection()
oCon.Connection String="my connection string"
oCon.Open()
Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
=============== =======
"xinhuanet. com" <in****@xinhuan et.com> wrote in message
news:Od******** ******@TK2MSFTN GP14.phx.gbl...
can you tell me how to connect to sybase database with vb.net? please give
me one
example.thank you!