Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > access > answers

Link Tables Error

Newbie
  
Join Date: May 2006
Posts: 26
#1: Sep 22 '06
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's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#2: Sep 22 '06

re: Link Tables Error

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,positions)
to force Access to treat you query in Jet Engine locally on your machine..

:)
Newbie
  
Join Date: May 2006
Posts: 26
#3: Sep 22 '06

re: Link Tables Error

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.

Quote:

Originally Posted by 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,positions)
to force Access to treat you query in Jet Engine locally on your machine..

:)
Newbie
  
Join Date: May 2006
Posts: 26
#4: Sep 22 '06

re: Link Tables Error

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's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#5: Sep 22 '06

re: Link Tables Error

Is there an ODBC provided?
PEB's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#6: Sep 22 '06

re: Link Tables Error

Yeah ther is a lot to see about...

Type in Google SYBASE ODBC

:)
Newbie
  
Join Date: May 2006
Posts: 26
#7: Sep 22 '06

re: Link Tables Error

Yes i have a Sybase Client Installed

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

Originally Posted by PEB

Is there an ODBC provided?
PEB's Avatar
PEB PEB is offline
Expert
  
Join Date: Aug 2006
Location: Bulgaria
Posts: 1,380
#8: Sep 22 '06

re: Link Tables Error

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...

:)
Reply

« previous question | next question »

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved