Link Tables Error

[guest]

Hi, I need help on this error.

I am trying to link tables from a Sybase Database to MS Access, using Sybase system 11.

I tried conneting to the database using SQL advantage and it does connect and is working.

But when i try to link tables via MS access it gives me this error ......WARNING rather
[INTERSOLV][ODBC SQL Server Driver][SQL SERVER]ASA error- 611 : Transact SQL feature not supported

any clue any one what i can do to resolve this

[PEB]

Do u use any functions in your query?

Maybe the SQL is transmited to Sybase to be treated... And Access is only Front end...

Try using a specific function for Access: something like Left(String,pos itions)
to force Access to treat you query in Jet Engine locally on your machine..

:)

[guest]

The first step would be to get the connection,

I cannot run a query untill i link up the tables and see them in Access.

Do u use any functions in your query?

Maybe the SQL is transmited to Sybase to be treated... And Access is only Front end...

Try using a specific function for Access: something like Left(String,pos itions)
to force Access to treat you query in Jet Engine locally on your machine..

:)

[guest]

I did some searching in Google and found out i can connect to Sybase using
Sybase Adaptive Server IQ drivers..

I could not find them on the net though..if you know where i can find these drivers that would be great.

coz i think my problem is due to the Sybase System 11 driver.!

[PEB]

Is there an ODBC provided?

[PEB]

Yeah ther is a lot to see about...

Type in Google SYBASE ODBC

:)

[guest]

Yes i have a Sybase Client Installed

SQL advantage, am using its ODBC driver "Sybase system 11"

Is there an ODBC provided?

[PEB]

Obviously you aren't the only with problems about this connection... In Google I found a manual to establish the ODBC connection.... Imagine...

Have a nice chance...

:)