vb.net 如何连接SYBASE数据库 在线等 急急急

[tongzw]

我以前是作SQL SERVER的，现在到新公司了，新公司要用SYBASE数据库
我不是很清楚怎么连接，请各位高手指点一下，放50分。

[haoztao]

到网上搜一下连接串不就行拉！

[jialiang]

http://community.csdn.net/Expert/topic/3606/3606401.xml?temp=.1737329

[jialiang]

http://community.csdn.net/Expert/topic/3606/3606401.xml?temp=.5465509

[tongzw]

我试过了 出错了
"Driver={Sybase System 11};Srvr =GITSERVER;database=loan_gz_dev;uid=sa;pwd="

错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊

[tongzw]

换了一下， "Provider=Sybase ASE ODBC Driver;Srvr =GITSERVER;database=loan_gz_dev;uid=sa;pwd="

错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊

[babyfast]

http://www.connectionstrings.com/
看看能不能帮你

[mathsword]

ODBC
Standard Sybase System 12 (or 12.5) Enterprise Open Client:

"Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"
Standard Sybase System 11:

"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"

Intersolv 3.10:

"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"

Sybase SQL Anywhere (former Watcom SQL ODBC driver):

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

OLE DB
Adaptive Server Anywhere (ASA):

"Provider=ASAProv;Data source=myASA"

Adaptive Server Enterprise (ASE) with Data Source .IDS file:

"Provider=Sybase ASE OLE DB Provider; Data source=myASE"
Adaptive Server Enterprise (ASE):

"Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog=myDBname;User Id=username;Password=password"


AseConnection (.NET)
"Data Source='myASEserver';Port=5000;Database='myDBname';UID='username';PWD='password';"
C#:
using Sybase.Data.AseClient;
AseConnection oCon = new AseConnection();
oCon.ConnectionString="my connection string";
oCon.Open();



VB.NET:
Imports System.Data.AseClient
Dim oCon As AseConnection = New AseConnection()
oCon.ConnectionString="my connection string"
oCon.Open()

你试试.net的就行了

[liweigz]

是否未在系统里创建数据源？

[daisi]

就是用ODBC可以连接，具体代码如下：

strconn="Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"