1.6w+
社区成员
- 全部
- VBS
- .NET技术
- VBA
- VB网络编程
- VB多媒体
- VB数据库
- VB控件
- VB COM/DCOM
- VB基础类
- VB API
- 问答
vb.net 如何连接SYBASE数据库 在线等 急急急
我以前是作SQL SERVER的，现在到新公司了，新公司要用SYBASE数据库
我不是很清楚怎么连接，请各位高手指点一下，放50分。
我不是很清楚怎么连接，请各位高手指点一下，放50分。
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
daisi 2005-02-25
就是用ODBC可以连接，具体代码如下：
strconn="Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
strconn="Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"
liweigz 2005-02-25
是否未在系统里创建数据源？
mathsword 2005-02-24
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的就行了
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的就行了
babyfast 2005-02-24
http://www.connectionstrings.com/
看看能不能帮你
看看能不能帮你
tongzw 2005-02-24
换了一下， "Provider=Sybase ASE ODBC Driver;Srvr =GITSERVER;database=loan_gz_dev;uid=sa;pwd="
错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊
错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊
tongzw 2005-02-24
我试过了 出错了
"Driver={Sybase System 11};Srvr =GITSERVER;database=loan_gz_dev;uid=sa;pwd="
错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊
"Driver={Sybase System 11};Srvr =GITSERVER;database=loan_gz_dev;uid=sa;pwd="
错误提示：
未发现数据源名称并且未指定默认的驱动程序
这是怎么回事啊
jialiang 2005-02-24
http://community.csdn.net/Expert/topic/3606/3606401.xml?temp=.5465509
jialiang 2005-02-24
http://community.csdn.net/Expert/topic/3606/3606401.xml?temp=.1737329
haoztao 2005-02-24
到网上搜一下连接串不就行拉！
