Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQLSetConnectAttr error with Excel - converting to an older database?
Hello,
Recently my place of work switched servers to a new product. I have a number of queries that would run from within Excel (MS Query), hit the database and return data
What's happened is that with the wipeout of the old database, I am stuck with a whole wack of useless queries and files. If I try and refresh the query, I get the error in the title. I initally knew this would be an issue and so we kept our database online as a backup for a month or so, and I converted everything over. You need to actually get into the query via MSQuery in order to view, edit, or change the query parameters, including the database location and DSN.
Is there any way that I can somehow force MSQuery to get into the query built and change the location and DSN of the database? The new database has all of the same data - just a new name, a couple digits off on the server address.
My thanks.
-S
Received on Wed Feb 21 2007 - 15:01:51 CST