ASP连接Sybase SQL Anywhere 5.0数据库哪里有问题？

[zhouqf]

我连接Sybase SQL Anywhere 5.0数据库语句是这样写的：
StrConn= "ODBC; Driver=Sybase SQL Anywhere 5.0;DefaultDir=C:\Program Files\Sybase\SQL Anywhere 5.0\win32\;Dbf=E:\hlzhbs\DataBase\FXBBDATA.DB;Uid=dba;Pwd=sql;Dsn=fxbbdata"

但是总是提示错误：
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序

我不知道我错在哪里，并且我想问一下DefaultDir到底是指的什么路径？

[zhouqf]

dsn已经建好了，就是在程序里连接不上

[myvicy]

Function GetSybaseConnection( Computer, UserID, Password, Db )
Dim Params, conn

Set GetSQLServerConnection = Nothing
Params = "Provider=Adaptive Server Anywhere 7.0"
Params = Params & ";Data Source=" & Computer
Params = Params & ";User ID=" & UserID
Params = Params & ";Password=" & Password
Params = Params & ";Initial Catalog=" & Db
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Params
Set GetSQLServerConnection = conn
End Function

[myvicy]

Function GetSybaseConnection( Computer, UserID, Password, Db )
Dim Params, conn

Set GetSybaseConnection = Nothing
Params = "Provider=Adaptive Server Anywhere 7.0"
Params = Params & ";Data Source=" & Computer
Params = Params & ";User ID=" & UserID
Params = Params & ";Password=" & Password
Params = Params & ";Initial Catalog=" & Db
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Params
Set GetSybaseConnection = conn
End Function
你可以选择没有log。

[zhouqf]

5.0和7.0的不一样，数据库是用5.0设计好的

[hbhbhbhbhb1021]

你在VB中建个的data project工程，用ADO连接下，看看属性中的connectstring或者delphi中的ado控件连接下也可以查看到

[zhouqf]

你所说的也就是所谓的万能连接的那条语句，我也试过了，还是不行

[笨笨兔兔兔兔兔]

sybase的数据库连接方法很困难那的,你给笨狼发短消息他做过的,在网上也很难找到的

[mayi545]

没有过，帮顶

[hbhbhbhbhb1021]

先建个dsn