Anyone Anyone , please shed some light.
We have upgraded our existing NT4, SQL 7 MIS server to a W2K, SQL 2K
server
On this I have install all the latests service packs for all
applications.
I am running Client Access v4r5 SP67276(latest).
I have setup all users, permissions, logins, links, dsn's, etc. as per
the old server.
However, when I run a openquery in query analyser it pulls one line and
the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [IBM][Client Access Express ODBC
Driver (32-bit)]Driver not capable.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows
returned 0x80004005: ].
I have changed the record blocking and other properties including a
manual connection string in the linked server in sql. Nothing seems to
work
I am at a lose right now and would appriciate any input that I can try
to resolve the problem as right now it's all not working. Does anyone
know if this version of Client Access we using is infact capable of
this on the new system? This is one product where we have lost v5 cd's
for and would need to source them if there is a know issue with the
current version
Many Thanks!