Sybase-连接字符串 [英] Sybase - connection string

查看:81
本文介绍了Sybase-连接字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好......

我为将sybase数据库连接到aspx页面所定义的连接字符串如下....
< pre lang ="cs">将myConnection设置为OdbcConnection
Dim sConnString As String = _
"Driver = {随时随地的Sybase SQL};"& _
"SRVR = kcncdata;" & _
"DB = kcncdata;" & _
"UID = dba;" & _
; PWD = sql;" & _
"DSN =;
myConnection =新的OdbcConnection(sConnString)
myConnection.Open()

但是我收到一条错误消息:错误[IM002] [Microsoft] [ODBC驱动程序管理器]找不到数据源名称,并且未指定默认驱动程序
请问该如何纠正...?有人可以提供解决方案吗?
Rod为他的纠正特别鸣谢... thankuu

hi guys....

The connection string which i have defined for connecting my sybase database to aspx page is as follows....
<pre lang="cs">Dim myConnection As OdbcConnection
Dim sConnString As String = _
"Driver={Sybase SQL anywhere};"& _
"SRVR=kcncdata;" & _
"DB=kcncdata;" & _
"UID=dba;" & _
";PWD=sql;" & _
"DSN=;
myConnection = New OdbcConnection(sConnString)
myConnection.Open()

but i am getting an error message : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
How can this be rectified...?can anyone give a solution,pls

special thaks to Rod for his correction...thankuu

推荐答案

我有一个解决方案.....它可能会帮助其他人.....

我连接的驱动程序不是"Sybase SQL Anywhere",而是
Adaptive Server Anywhere 8.0处的任何地方……都进行了相同的更改....更正了错误.....
i have got a solution.....it may help others.....

The driver for my connection is not ''Sybase SQL anywhere'',but
Adaptive Server anywhere 8.0......changed the same....rectified the error.....


这篇关于Sybase-连接字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆