Post reply

Problem between access and sql2005

  • March 11, 2010 at 5:01 am

    #386479

    Hi people.

    I have a problem between Access and Sql2005.

    I use a linked table inside temporary access mdb.

    Client have sqlexpress insalled (two version : one is 9.0.053 and the other 9.0.035)

    With sql2005 with 9.0.035 everithing work good.

    With sql2005 with 9.0.053 a "ODBC - Call failed " appear when i try to executa an "INSERT INTO SQLXXX FROM SELECT * FROM ACCESSXXX"

    someone can help me ????????

  • March 11, 2010 at 7:37 am

    #1132041

    Alberto.Omini (3/11/2010)

    Hi people.

    I have a problem between Access and Sql2005.

    I use a linked table inside temporary access mdb.

    Client have sqlexpress insalled (two version : one is 9.0.053 and the other 9.0.035)

    With sql2005 with 9.0.035 everithing work good.

    With sql2005 with 9.0.053 a "ODBC - Call failed " appear when i try to executa an "INSERT INTO SQLXXX FROM SELECT * FROM ACCESSXXX"

    someone can help me ????????

    It looks like the syntax is wrong. I would think it should be:

    INSERT INTO SQLXXX (col1,col2)

    SELECT othercol1, othercol2

    FROM ACCESSXXX

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply