Eviews/Oracle - jogging my foggy brain

[richbranch]

About a year ago I started automating some data pulls by writing some code that eviews (v12) is pulling right from our Oracle tables. It works great.

The problem I'm having is when my team runs these same programs they get an error along the lines of "ODBC Error unable to connect to driver....."

What we've done or made sure we've done:
1. set the TIMEOUT in the line so a high number (1800 to be exact)
2. ensured that the DSN is set exactly the same
3. server permissions are set (i.e. they are using the same user/password)

But that error pops up almost immediately after hitting run so it makes me think it's not timing out and I'm trying to remember if I needed to install or set something up on my PC (like a driver outside of EViews) so that this would work.

I've been searching through the forum and doing some googling but I can't put my finger on it.

Any thoughts/suggestions???

Thanks!

[EViews Steve]

The "unable to connect to driver" error means EViews can't seem to find the Oracle driver on those machines. Perhaps you setup your DSN under 32-bit ODBC instead of 64-bit? EViews 12 (and newer) only runs in 64-bit so it requires 64-bit ODBC drivers and a 64-bit DSN. It can't use any 32-bit versions of these files.

To double-check this, click the Windows key and then type in: odbcad32.exe. This should launch the ODBC Data Source Administrator application. Make sure the title of the window that pops up says "(64-bit)" and not "(32-bit)". Check for your Oracle driver in the Drivers tab and create and test your DSN using this 64-bit window.

Finally, if you're still having trouble, try using the same DSN ODBC datasource from Microsoft Excel 64-bit (if you have that version installed) to see if that can use it successfully. It may also give you different error msgs that could be helpful in troubleshooting the issue.

Steve