DAO Sybase system 11

[John]

Hi,

Has anyone coonected via ADO with Sybase System 11 driver or Sybase ASE
driver?

I think there is a problem with the ODB driver. I got the same error when
using ADO, DAO and a pass through query.

along the lines of [INTERSOLV][ODBC SQL Server driver]... could not find
table name...

 

[Tom van Stiphout]

I have never connected to Sybase, but ODBC drivers mostly work the
same way regardless of what you are connecting to.
connectionstrings.com may have some more connection info for you.
On some database systems it's not enough to specify the tablename as
in:
select * from SomeTable
but you have to specify the owner as well. If this were SQL Server I
could write:
select * from dbo.SomeTable

Of course you always have to connect with an account that has
sufficient rights to do what you need to do. With SQL Server I use
their utilities (e.g. Management Studio) to login as that user and try
things out, just to make sure I have rights.

-Tom.