odbc connection fails in Office 2010

[magick]

i recently got a new computer with win7, and also purchased Office 2010. A
database that i have had for years is producing odbc connection failed
errors. i had no problems with 2007 (with win7). i have gone throught the
"sandbox" security change in the registry that i found in the online help. i
have also added it to trusted sites, enabled macros, but still no luck. the
test connection in odbc administrator works fine.

 

[Tom van Stiphout]

On Thu, 20 May 2010 09:33:01 -0700, magick

What is the exact error? What is the app trying to do at that time?
Maybe you can post some code. Is that ODBC database on the machine? Is
an ODBC Data Source Name (DSN) setup in the ODBC applet?

-Tom.
Microsoft Access MVP

 

[magick]

the oracle database is on a server, not local. the app runs numerous
reports, macros, queries, from various combo boxes or command buttons on
forms. Depending on what it is running, the macro error box comes up, then
when you click the "stop all macros" button, i get a "connection to '|'
failed" error. If it isn't a macro, I get the odbc call failed error
immediately. It never brings up the odbc driver connect login window. yes,
the dsn has been set up, and as i said, the test connection brings up the
odbc connect login window as expected, and is successful. i have this app
running successfully on hundreds of machines with a variety of operating
systems and office versions - this is the first install with office 2010.
what code would be helpful to post? thanks!

 

[Tom van Stiphout]

On Fri, 21 May 2010 05:26:01 -0700, magick

Perhaps this machine has Office 2010 64-bit installed against all
recommendations, and the drivers are eh, sub-optimal.

-Tom.
Microsoft Access MVP

 

[magick]

i am using the oracle odbc driver - is something else sub-optimal?

 

[magick]

ps - it is the 32 bit version.

On Fri, 21 May 2010 05:26:01 -0700, magick

Perhaps this machine has Office 2010 64-bit installed against all
recommendations, and the drivers are eh, sub-optimal.

-Tom.
Microsoft Access MVP


.