Good Day!
I am using Excel 2007 and with Windows 7 32bit OS.
With the other computers I have no problem in doing a query to automatically update the data in my excel from my server.
The procedures I am doing as follows below,
Data Tab >
From Other Sources >
From Microsoft Query >
On the Databases tab <New Data Source>
*I input the name of the data source
*Then I choose microsoft odbc for oracle for the driver
Upon clicking connect the error displayed was "ora-06413 connection not open. driver's sqlsetconnectattr"
Seeking your assistance regarding this matter.
Thank you.
Bookmarks