November 16, 2004 at 3:55 am
Greetings,
there's a problem I've encountered. We have a geographic information system, and the database is an oracle 9i.
For many other applications, our SQL Server 2000 does all the work.
Many people use self-written Access97 applications, which should be migrated to Access 2002 using SQL Server 2000 as often as possible.
My problem is: There are some Access-Databases which use oracle-data. They were connected through ODBC. This had the disadvantage of the need of installing an Oracle client on all of those machines.
I tried to work around that problem by linking the oracle server in MSSQL2K and making the needed tables available by using the openquery statement in a MSSQL2K view.
Then, I have linked this view into my Access application. The result is: it's slow, extremely slow.
Do you have a hint how to get it to run smoothly?
Thanks!
Alex
November 19, 2004 at 8:00 am
This was removed by the editor as SPAM
November 20, 2004 at 9:32 am
Using a linked server and openquery yields a very slow connection, due to the number of layers of OLEDB/ODBC between you and your data.
In trying to model a customer's system, I created a linked server connecting to another SQL database on the same server, and even that was very slow from QA, let alone from Access which adds still another connection layer.
IMO you'll need the Oracle client installed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply