简单的问题---用SQLConnection 连接SQL Server 2000 时出现错误"unable to load libmysql.dll"???

Question

连接InterBase就可以何故？我就只要能连接上SQL Server 2000 就可以了设置SQLConnection属性的时候除了 DATABASE 那栏要填以外，其它还要设置吗？

Answer 1

提供者：Microsoft OLE DB Provider for SQL Server
连接：1.选择SQL服务器
      2.填写用户名和密码
      3.选择要连接的数据库
测试连接或者  ADOC.ConnectionString:='Provider=SQLOLEDB.1;Password='+密码+';Persist Security Info=True;User ID='+用户名+';Initial Catalog='+数据库名+';Data Source='+SQLServer;

Answer 2

眼神不大好吧，把MySql看成MSSQL了 :)

Answer 3

哈哈，对啊对啊好了，大家把注意力集中到这一楼来了，上面的提问不算了啊，咳咳问题：连接MSSQL时，提示输入用户名密码后，等了一小会后，出现以下这个错误：
      “sql server does not exist or access denied”
      之前已在dbxconnections.ini和dbxdrivers.ini中设置好了！何故呀？

Answer 4

粘出你的dbxconnections.ini和dbxdrivers.ini代码看看!

Answer 5

dbxconnections代码：[DB2Connection]
BlobSize=-1
Database=DBNAME
DriverName=DB2
ErrorResourceFile=
LocaleCode=0000
Password=password
DB2 TransIsolation=ReadCommited
User_Name=user[MSConnection]
BlobSize=-1
Database=DBNAME
DriverName=MYSQL
ErrorResourceFile=
HostName=ServerName
LocaleCode=0000
Password=password
User_Name=user[IBLocal]
BlobSize=-1
CommitRetain=False
Database=database.gdb
DriverName=Interbase
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=1
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True
[CHINESEDEMO]
DriverName=Interbase
BlobSize=-1
CommitRetain=False
Database=C:\Documents and Settings\Administrator\桌面\2003061715483629822\CHINESEDEMO.GDB
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=big5
SQLDialect=1
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True
[Oracle]
BlobSize=-1
DataBase=Database Name
DriverName=Oracle
ErrorResourceFile=
LocaleCode=0000
Password=password
Oracle TransIsolation=ReadCommited
User_Name=user[mssql]
DriverName=MSSQL
HostName=ServerName
DataBase=F:\Program Files\Microsoft SQL Server\MSSQL\Data\rrh_Data.MDF
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=Falsedbxdrivers.ini 代码：[Installed Drivers]
DB2=1
Interbase=1
MYSQL=1
Oracle=1
MSSQL=1[DB2]
GetDriverFunc=getSQLDriverDB2
LibraryName=DBEXPDB2.DLL
VendorLib=db2cli.dll
BlobSize=-1
Database=DBNAME
ErrorResourceFile=
LocaleCode=0000
Password=password
DB2 TransIsolation=ReadCommited
User_Name=user[Interbase]
GetDriverFunc=getSQLDriverINTERBASE
LibraryName=dbexpint.dll
VendorLib=GDS32.DLL
BlobSize=-1
CommitRetain=False
Database=database.gdb
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=1
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True[MYSQL]
GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbexpmys.dll
VendorLib=LIBMYSQL.dll
BlobSize=-1
Database=DBNAME
ErrorResourceFile=
HostName=ServerName
LocaleCode=0000
Password=password
User_Name=user[Oracle]
GetDriverFunc=getSQLDriverORACLE  
LibraryName=dbexpora.dll
VendorLib=OCI.DLL
BlobSize=-1
DataBase=Database Name
ErrorResourceFile=
LocaleCode=0000
Password=password
Oracle TransIsolation=ReadCommited
User_Name=user
[MSSQL]
GetDriverFunc=getSQLDriverMSSQL  
LibraryName=dbexpmss.dll
VendorLib=oledb
HostName=ServerName
DataBase=Database Name
User_Name=user
Password=password
BlobSize=-1
ErrorResourceFile=
LocaleCode=0000
MSSQL TransIsolation=ReadCommited
OS Authentication=False[AutoCommit]
False=0
True=1[BlockingMode]
False=0
True=1[WaitOnLocks]
False=1
True=0[CommitRetain]
False=0
True=1[DB2 TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2[Interbase TransIsolation]
ReadCommited=1
RepeatableRead=2[Oracle TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2
[MSSQL TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2[SQLDialect]
1=0
2=1
3=2