Sybase Drivers for Delphi 2010

3
votes

We are migrating from Delphi 6 to Delphi 2010,earlier we were using BDE engine to connect to Sybase Database from Delphi 6. We found out that Delphi 2010 does not support BDE.

We are trying with dbexpress but we are not able to catch the exception(raise error) thrown by Sybase.

Could you please let me know if there is any other driver except dbexpress to connect to Sybase Database from Delphi 2010.

Thanks.

Regards, AS

5
delphidelphi-2010driverssap-ase
Assuming you got Delphi 2010 pro, you might be interested to know that an upgrade to Delphi XE Enterprise is on at a reduced price right now. That would get you the dbExpress connection to Sybase, which you need. - Warren P

5 Answers

2
votes

You could try a workaround:

  1. Install Delphi 6
  2. Update BDE to the latest available version (there should be some updates on Embarcadero site, I hope)
  3. Install Delphi 2010

IIRC the available SQL Links should not be removed (otherwise it would break the older version), and they should still work in Delphi 2010. But that's really a stopgap try.

Devart's UniDac can connect to Sybase without using dbExpress, but I never used it.

5
votes

You can use AnyDAC to connect to:

  • Sybase SQL Anywhere (AnyDAC native driver)
  • Sybase Adaptive Server (AnyDAC ODBC bridge).
3
votes

I suspect your real problem is that you have the Professional version of Delphi rather than Enterprise. As far as I know, BDE can still be used with Delphi 2010.

With Delphi 6 the Professional version allowed connections to remote databases. Somewhere between Delphi 6 and Delphi 2010 that policy was changed.

Anyway, you really need to give up on BDE and move forward.

Edit: (jeroen) The BDE for relational access (aka the BDE SQL Links technology) has been deprecated since 2002, about 2 years after the introduction of dbExpress in Kylix and Delphi 6.

2
votes

Sybase drivers for dbExpress is included in Enterprise version of Delphi. If that is not an option you can use dbGO (ADO) that is included in Professional.

1
votes

You can try ZEOSLIB which contains SyBase connectivity, along with many other SQL dbs.

As far as I can see, it requires you to remove your Query/Table objects and replace them with its own Table and Query replacement objects, but then, so would moving from BDE to ADO/dbGo or dBExpress.

And you really should get the BDE out of your application. It's dead as a doornail.