Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: problems connection to Informix database

    Hi,

    I have a MS SQL 7 running on one machine and want to connect to a Informix database on another machine.

    But I always get the error
    Server: Msg 7319, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'ind_new_id' with incorrect bookmark ordinal 0.

    I have installed the newest version of "Microsoft Data Access Components" and I have the latest Informix odbc driver

    When I try to test the connection in the ODBC Data Source Administrator the test returns fine.

    Anyone knows what my problem might be?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    One of the post in this forum refers
    The problem is caused because most providers including SQL Server OLE DB provider do
    not support index seek.

    The 'index as access path' should not be checked when creating a linked server using
    the SQL OLEDB. There is a provider level option which is read by the SQL Server from
    the following registry.
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Providers\SQLOLEDB\IndexAs
    Accesspath. Please check whether the value of the above registry key is 0. If it
    isn't , please change it to 0 and try the remote query again.

    If it doesn't work, I suggest you rebuild a linked server using the SQL OLEDB without
    checking 'index as access path'.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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