Re: DAO Sybase system 11
- From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
- Date: Sat, 19 Apr 2008 15:17:18 -0700
On Sat, 19 Apr 2008 15:32:28 +0100, "John" <john@xxxxxxxxxxx> wrote:
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.
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...
- References:
- DAO Sybase system 11
- From: John
- DAO Sybase system 11
- Prev by Date: Re: Manipluating Word docs in Access VBA?
- Next by Date: Re: How to perform insert on Linked tables
- Previous by thread: DAO Sybase system 11
- Next by thread: Manipluating Word docs in Access VBA?
- Index(es):
Relevant Pages
|
