Current Position:Home > Database tables not showing in database profile although connection is established successfully

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

Update:11-30Source: network consolidation
Advertisement
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.

The Best Answer

Advertisement
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.
  • Database tables not showing in database profile although connection is established successfully Update:11-30

    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 sto

  • BR0978W Database profile alert - level: WARNING, parameter: STATISTICS_LEVE Update:11-30

    Hi, While doing DBCheck one of my system i found this error BR0973W Database operation alert - level: WARNING, operation: cdvkvbva.sta, time: 2007-06-07 06.05.02, condition: Last update optimizer stati BR0976W Database message alert - level: WARNING,

  • How to remove database profile in report Update:10-11

    Hello, We have a report right now and upon accessing it, a window asking for a Database Profile comes out. This causes the program to have additional selection parameters for Project Definiton, WBS element etc. Before we just ran the report for Perio

  • Delete Parameter from Database profile Update:11-30

    Hi forums, I have a doubt. I have SAP BW 7.0 on Windows with Oracle 10.2.0.2. The session of GoLive recommend me the following: Parameter: shared_pool_reserved_size Description: Part of Shared Pool for large statements      Current Value: 47799336   

  • BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, val Update:11-30

    Dear SAP Gurus, We are getting the following error in Check Database in DB13 BR0978W Database profile alert - level: WARNING, parameter: LOG_BUFFER, value: 14254080 (>< 4096,512 KB) The current Parameter : 14254080 We have change the parameter as pe

  • Changing database Profile to EBS Schemas Update:11-30

    Hi, SOX and some other regulations force using strong passwords in EBS . Currently all owr EBS Schemas are assigned to the DEFAULT database profile. (select profile from dba_users where profile='DEFAULT') I would like to know if there are any restric

  • BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKS Update:11-30

    Dear all: Running the CheckDB in the transaction DB13 and i get the following message of error: "BR0978W Database profile alert - level: WARNING, parameter: DB_BLOCK_CHECKSUM, value: TRUE (<> FALSE)" Other Details :- OS :- Win 2003 server

  • BR0978W Database profile alert Update:11-30

    Hi, DB02-----> Check DB it's showing these warnings. Please checks it and suggest me. BR0978W Database profile alert - level: WARNING, parameter: DB_WRITER_PROCESSES, value: 4 (<> 1)                 BR0978W Database profile alert - level: WARNING

  • BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX Update:11-30

    Hai Experts When I executes DBChek i am getting following error BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_COST_ADJ, value: 20 (<= 20) already checked the database parameter for OPTIMIZER_INDEX_COST_ADJ is 20, Thanks

  • Using database link to connect to two databases Update:10-11

    Hi guys, Here's my question. I need to give a contractor Select rights on tables located in two schemas located on two different servers. One server is dev and one is prod. Let's say we have schema user: EMPLOYEE on dev and schema user: DEPARTMENT on