Database tables not showing in database profile although connection is established successfully

[Former Member]

I am using jdbc driver jtds 1.2.6 to connect to sybase db via powerbuilder.The connection is established successfully,still,it just shows the profile as connected but loads no table or contents of databse in that coonnection.

Do I have to run any stored procedure in sybase db for this?

Any clue?Please help.

[Former Member]

Yes, you do need to run a stored procedure. It's described in the PowerBuilder documentation.

As Chris said you'd be far better off using the native interface driver. I've never heard of it being separated out anywhere, so if your installation software for ASE does not include OpenClient, then I doubt that it's a genuine copy of the software.

[Former Member]

Try running PowerBuilder as administrator.

[Former Member]

Please be more specific about what you mean by "sybase db". Is it ASE? Is it SQL Anywhere? What version?

[Former Member]

Its ASE

[Former Member]

Hi M;

  May I ask ...  Why not use the Sybase ASE "open client" native drivers?

Regards ... Chris

[Former Member]

Hi Chris,

Open client is a paid component.Its not free here with sybase ASE.

Jtds jdbc driver is free.

[Former Member]

Open Client is free, the installer comes with the ASE server installer. The server might be setup for per client licensing but the jdbc connection will still be counted by the license monitoring function.

[Former Member]

Hi M;

  Roland is correct ... OC is free and it comes with the ASE installation. While ASE requires a license, the OC can be installed on any number of PC's.

Regards ... Chris