Sybase table naming ?, Table not found!

Paul Peterson

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Sybase table naming ?, Table not found!

I can access our Sybase database with DbExplorer and see the tables, but
when my App tries, it gets "<TableName> not found, use
'Owner.Objectname' or use sp_help to check weithe...". We tried
prepending 'DBo.' to each table name but it still can't find the tables.

What is the special thing you need to do to the table name to open
Sybase tables ???

Later,
Paul

June

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sybase table naming ?, Table not found!

Paul,

the tablenames of the Sybase SQL Server are case sensitive. So try to write
the tablenames only in UPPERCASE.

HTH,

J. Bauer
Bau...@bauer-software.de

Patrick Benne

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sybase table naming ?, Table not found!

Quote

"Junel" <camilla.ju...@t-online.de> wrote:
>Paul,

>the tablenames of the Sybase SQL Server are case sensitive. So try to write
>the tablenames only in UPPERCASE.

They're only case-sensitive if case-sensitivity is enabled on the server.
Paul, if this is your problem you can change the 'sort order' in Server Config
to fix this.
-------------------------------------------
Patrick Bennett
Acraline Products, Inc.
pbenn...@acraline.com

Other Threads

1. Table repair utility error table not found

2. SyBase - Table naming ? Table not found!

3. RequestLive = True fails if Sybase Name Full (db.dbo.table)

4. SYBASE and D3 and INVALID TABLE NAME

5. How copy a paradox table ---> sybase table

6. How to find the table name from DBEDIT?

7. Sybase - table not uniquely indexed ?!

8. Sybase Transaction does not span multiple tables

9. Function Nor Found RTRIM..Module Name or Entry point not found

10. Quering names of all the tables, and the fieldtypes in the tables