473,386 Members | 1,754 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Link Tables Error

25
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
Sep 22 '06 #1
7 2490
PEB
1,418 Expert 1GB
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..

:)
Sep 22 '06 #2
guest
25
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,positions)
to force Access to treat you query in Jet Engine locally on your machine..

:)
Sep 22 '06 #3
guest
25
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.!
Sep 22 '06 #4
PEB
1,418 Expert 1GB
Is there an ODBC provided?
Sep 22 '06 #5
PEB
1,418 Expert 1GB
Yeah ther is a lot to see about...

Type in Google SYBASE ODBC

:)
Sep 22 '06 #6
guest
25
Yes i have a Sybase Client Installed

SQL advantage, am using its ODBC driver "Sybase system 11"
Is there an ODBC provided?
Sep 22 '06 #7
PEB
1,418 Expert 1GB
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...

:)
Sep 22 '06 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Lothar Armbr?ster | last post by:
Hello out there, this morning I had to get some rows via flashback query. Since my undo retention is just 3h, the undo segments were already aged out. But I have a physical standby database that...
8
by: ZRexRider | last post by:
Hi, I have an application that uses MS-SQL Linked tables. I have a utility routine that drops all links and re-establishes them. It works great when my connection string is a DSN connection...
2
by: scott | last post by:
Hi all First off, thank you for any one that can help. I have a problem trying to link a DataGrideTableStyle to a DataGrid. I have a dataset which reads from a file a xml schema and a xml...
3
by: debbie | last post by:
I have an Access 2002 program that I install using Wise. The first thing my program does when a front end is opened is re-link, then it checks the version and if needed upgrades the backend. My...
7
by: Lisa | last post by:
I have an Access 2000 application that uses the following function to re-link my tables when I switch from my Current back end to a Dummy back end. I also use it to refresh my links. Function...
13
by: rdemyan via AccessMonster.com | last post by:
My front-end code manually links to the backend file. I was wondering what stops Access from linking to the system tables in the backend file. Is it just by virtue that they are hidden? This...
4
by: sbowman | last post by:
I'm linking a bunch of tables that are in SQL to my Access db and I get the following error on 3 of the tables: "Seq.Group is not a valid name." I tried doing an import instead of a link, but I got...
1
by: pemigh | last post by:
I'm almost done with an application, and trying to lock it down tightly. But I still want users to be able to point to a new location for the data file. The code below fires off to detect and...
7
by: ApexData | last post by:
Hello I currently Link the FE/BE using the LinkTables Option and the Linked Table Manager. Any time I need to move the BE to another location, I have to go through this process over again. I...
3
by: Vee007 | last post by:
Following is my code: Dim objCatalog As ADOX.Catalog Dim objTableLink As ADOX.Table Dim objADOConnection As ADODB.Connection Try objADOConnection = New...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.