OLE DB Provider for Sybase Adaptive Server Anywhere (ASA)
oConn.Open "Provider=ASAProv;" & _
"Data source=myASA"
For more information, see: ASA Programming Interfaces Guide and ASA User's Guide OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
"Data source=myASEServer"
' Or
oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName;" & _
"Password=myUserPassword"
Where:
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD
- 5000 is the port number for Sybase.Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.
oConn.Open "Provider=ASAProv;" & _
"Data source=myASA"
For more information, see: ASA Programming Interfaces Guide and ASA User's Guide OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
"Data source=myASEServer"
' Or
oConn.Open "Provider=Sybase.ASEOLEDBProvider;" & _
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName;" & _
"Password=myUserPassword"
Where:
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD
- 5000 is the port number for Sybase.Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.
解决方案 »
- .net(C#)窗体中的webbrowser加载URL页面中有文件下载链接的问题
- C# 菜鸟继续提问!
- 到底怎么才能发送邮件呢?网上的代码怎么都不好使啊?
- c#引用类型对象的删除问题
- 一个关于capicom加密解密的比较难的问题。
- 如何2次循环读出数据库记录
- 请问如何用C#实现vista风格的winform
- (高手请进,我都等了好几天了,急啊,有没有人帮助我啊)winform:datagrid中怎样设置各列复杂的计算关系?
- process
- 请问有谁了解pc2phone是怎么回事
- 如何在安装类里获取WEB安装项目在安装时用户输入的虚拟目录?急!
- 用C#编Web时的一个问题:MessageBox()怎么调用?我找了几天了都没有找到呀~~~~~~~~~~晕死我了.
SqlConnection con=(Configuration.GetDBConnectionString("ctais"));//ctais是连接字串的标示。可是napsoft的连接是OdbcConnection 我在.net里面找不到阿。奇怪了
我用odbc Ole连接,死活连不上去,兜风了
下OLEDB驱动(12.5)的。先安装ASE 12.0 OLE DB & ODBC EBF for NT
然后用ODBC/ OLE DB EBF for SDK12.5(Conn12.5 ESD&7)补一下。
连接串是:
Provider=Sybase.ASEOLEDBProvider;Initial Catalog=database;Password=pass;User ID=userid;Server Name=192.168.0.1;Server Port Address=5000;
最好用向导生成,然后复制生成的联接串。
可用驱动中的sydaadm.exe配制一下看一看地址。