DARRAH
asked on
DBEXPRESS DRIVERS -
Two questions related to dbexpress drivers:
1) I first tried using the dbexpmss.dll, but first got was unable to find driver. I then found the dbxdriver.ini file and added the parameters to the file:
[MSSQL]
GetDriverFunc=getSQLDriver MSSQL
LibraryName=dbexpmss.dll
VendorLib=oledb
BlobSize=-1
Hostname=
Database=
User_Name=
Password=
I did update the paramters in the TSQLConnection. But when I try to connect, I get error message:
SQL Error: Error mapping failed.
What is the problem there?
2) I also tried dbexpsda.dll (downloaded from www.crlab.com). This one connects fine but the problem here is that it does not return more than six columns in the TSQLQuery.
Any ideas there?
1) I first tried using the dbexpmss.dll, but first got was unable to find driver. I then found the dbxdriver.ini file and added the parameters to the file:
[MSSQL]
GetDriverFunc=getSQLDriver
LibraryName=dbexpmss.dll
VendorLib=oledb
BlobSize=-1
Hostname=
Database=
User_Name=
Password=
I did update the paramters in the TSQLConnection. But when I try to connect, I get error message:
SQL Error: Error mapping failed.
What is the problem there?
2) I also tried dbexpsda.dll (downloaded from www.crlab.com). This one connects fine but the problem here is that it does not return more than six columns in the TSQLQuery.
Any ideas there?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.crlab.com/dbx/download.html
dbExpress drivers Download
You can download trial versions of our products to try using them. Trial versions of dbExpress drivers have functional limitation. It allows to fetch only first six fields of result set.