🚀 go-pugleaf

I think I posted this in the wrong group earlier, so please excuse if this 
looks like cross-posting.

What I'm trying to do is to connect to ASA 9 from an ASP.Net application, 
just a simple trial with a DataGrid. I presume that will be possible (?) 
I'm also assuming there is no official BDP for ASA, but I might be wrong 
(I hope I am, because things look a lot easier with BDP.) So I'm trying to 
do it with a Web controls DataGrid, SQLConnection, SQLDataAdapter and SQLDataset.

The ASA tables and data can be accessed from Data Explorer, but no matter 
what I do with TSQLConnection it always comes up with runtime error "SQL 
Server not available or access denied", as if it's reverting to MS SQL Server. 


I know that when I drop it on the form and click Configure Connection, it 
defaults to MS, but on the Provider page I then select Sybase provider version 
9, which happens to be at the bottom of the list. It doesn't work either 
if I select OleDB Provider for ODBC, which it should as well. Ok, I fill 
in the details, click Test and it tests ok, but that's as far as I can get. 

Adding a SQLDataAdapter, linking it to the SQLConnection and filling in "select 
* from customers" as the select command ("customers" being a table in the 
Sybase demo database), then clicking on Generate Dataset produces the error 
message I mentioned above "SQL Server not available or access denied". 

Equally putting code in the PageLoad event and wiring the components up only 
leads to the same error message on trying to do SQLConnection.Open. By the 
way, I have got MSDE installed as well - and Interbase. Interbase works fine 
with exactly the same tests, no problem. The problem is only with ASA.

I've tried the Visoco third party driver as well and it won't work either. 
This is Delphi 2006 Pro with latest update, and Sybase 9 current release 
(free developer download - I have an earlier full edition too, 8.03 and that 
didn't work either, even with the latest updates.)

I think I've got the dbxdrivers.ini and dbxconnections.ini files setup correctly. 
I'll paste them here just for completeness. If anyone can come up with any 
ideas, superb. Those are the ASA default user-id and password in there, by 
the way.

==========
dbxdrivers.ini
==========
[Installed Drivers]
Interbase=1
MYSQL=1
ASA=1

[Interbase]
GetDriverFunc=getSQLDriverINTERBASE
LibraryName=dbxint30.dll
VendorLib=GDS32.DLL
BlobSize=-1
CommitRetain=False
Database=database.gdb
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=3
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True
Trim Char=False

[MYSQL]
GetDriverFunc=getSQLDriverMYSQL
LibraryName=dbxmys30.dll
VendorLib=LIBMYSQL.dll
BlobSize=-1
Database=DBNAME
ErrorResourceFile=
HostName=ServerName
LocaleCode=0000
Password=password
User_Name=user
Compressed=False
Encrypted=False

[ASA]
GetDriverFunc=getSQLDriverASA
LibraryName=dbxasa30.dll
VendorLib=dbodbc9.dll
BlobSize=-1
Database=Database Name
ErrorResourceFile=./DbxMSSErr.msg
HostName=ServerName
LocaleCode=0000
ASA TransIsolation=ReadCommited
Password=password
User_Name=user
OS Authentication=False

[AutoCommit]
False=0
True=1

[BlockingMode]
False=0
True=1

[WaitOnLocks]
False=1
True=0

[CommitRetain]
False=0
True=1

[Interbase TransIsolation]
ReadCommited=1
RepeatableRead=2

[ASA TransIsolation]
DirtyRead=0
ReadCommited=1
RepeatableRead=2

[SQLDialect]
1=0
2=1
3=2

[Bdp Providers]
Interbase=Interbase
MySql=MySql

==============
dbxconnections.ini
==============
[IBCONNECTION]
BlobSize=-1
CommitRetain=False
Database=database.gdb
DriverName=Interbase
ErrorResourceFile=
LocaleCode=0000
Password=masterkey
RoleName=RoleName
ServerCharSet=
SQLDialect=3
Interbase TransIsolation=ReadCommited
User_Name=sysdba
WaitOnLocks=True

[MYSQLCONNECTION]
BlobSize=-1
Database=DBNAME
DriverName=MySQL
ErrorResourceFile=
HostName=ServerName
LocaleCode=0000
Password=password
User_Name=user
Compressed=False
Encrypted=False

[ASALocal]
DriverName=ASA
DATABASE=ASA 9.0 Sample
HOSTNAME=
ASA TRANSISOLATION=ReadCommited
PASSWORD=sql
USER_NAME=dba
ERRORRESOURCEFILE=./DbxMSSErr.msg
LOCALECODE=0000
BLOBSIZE=-1
OS AUTHENTICATION=False
 
--
Steve M