Board index » delphi » Cannot acces Adaptive Server Anywhere 6.0

Cannot acces Adaptive Server Anywhere 6.0

I am experiencing problems when trying to access an ASA database (v 6.0)
using the SQLLinks SYBASE driver (provided with Delphi 5 Enterprise).
I can properly access the DB through ODBC but I would like to avoid this.
So the problem is the following:
- Open Client Runtime is installed (from Adaptive Server Enterprise CD-ROM)
and configured through DSEDIT to access a local ASA database.
- I have created an ASE compatible DB as explained in the documentation.
- I created a new alias in SQL Explorer using the SYBASE driver.
- I can connect to the database, see stored procedures, the list of tables
and some other infos BUT I get the following error when I try to browse data
types or columns: 'property allownulls does not exist'. I also get the error
'ASA Error - 143: column 'name' not found' when I try to browse the data.

Can anyone help ??

 

Re:Cannot acces Adaptive Server Anywhere 6.0


The Sybase native driver that comes with the BDE is for use with the
Sybase SQL, not ASA. If you want to properly access ASA databases you
have to use ODBC.

Juan

Quote
Philippe Randour wrote:

> I am experiencing problems when trying to access an ASA database (v 6.0)
> using the SQLLinks SYBASE driver (provided with Delphi 5 Enterprise).
> I can properly access the DB through ODBC but I would like to avoid this.
> So the problem is the following:
> - Open Client Runtime is installed (from Adaptive Server Enterprise CD-ROM)
> and configured through DSEDIT to access a local ASA database.
> - I have created an ASE compatible DB as explained in the documentation.
> - I created a new alias in SQL Explorer using the SYBASE driver.
> - I can connect to the database, see stored procedures, the list of tables
> and some other infos BUT I get the following error when I try to browse data
> types or columns: 'property allownulls does not exist'. I also get the error
> 'ASA Error - 143: column 'name' not found' when I try to browse the data.

> Can anyone help ??

Other Threads