Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2006
    Posts
    11

    Unanswered: Link Tables Error

    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

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    My first thought is that it's some sort of driver problem. Maybe a different driver?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Sep 2006
    Posts
    11
    Do you know where i can find bundeled ODBC drivers..everywhere i lokked it seems i will have to buy some product or another to get the drivers..

    Quote Originally Posted by pkstormy
    My first thought is that it's some sort of driver problem. Maybe a different driver?

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Aren't the drivers found and supplied via the MDAC installation (I think you can download that via Microsoft)? Not sure.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •