If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
odbc connection fails in Office 2010
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. |
#2
|
|||
|
|||
odbc connection fails in Office 2010
On Thu, 20 May 2010 09:33:01 -0700, magick
wrote: 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 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. |
#3
|
|||
|
|||
odbc connection fails in Office 2010
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" wrote: On Thu, 20 May 2010 09:33:01 -0700, magick wrote: 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 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. . |
#4
|
|||
|
|||
odbc connection fails in Office 2010
On Fri, 21 May 2010 05:26:01 -0700, magick
wrote: Perhaps this machine has Office 2010 64-bit installed against all recommendations, and the drivers are eh, sub-optimal. -Tom. Microsoft Access MVP 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" wrote: On Thu, 20 May 2010 09:33:01 -0700, magick wrote: 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 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. . |
#5
|
|||
|
|||
odbc connection fails in Office 2010
i am using the oracle odbc driver - is something else sub-optimal?
"Tom van Stiphout" wrote: On Fri, 21 May 2010 05:26:01 -0700, magick wrote: Perhaps this machine has Office 2010 64-bit installed against all recommendations, and the drivers are eh, sub-optimal. -Tom. Microsoft Access MVP 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" wrote: On Thu, 20 May 2010 09:33:01 -0700, magick wrote: 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 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. . . |
#6
|
|||
|
|||
odbc connection fails in Office 2010
ps - it is the 32 bit version.
"Tom van Stiphout" wrote: On Fri, 21 May 2010 05:26:01 -0700, magick wrote: Perhaps this machine has Office 2010 64-bit installed against all recommendations, and the drivers are eh, sub-optimal. -Tom. Microsoft Access MVP 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" wrote: On Thu, 20 May 2010 09:33:01 -0700, magick wrote: 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 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. . . |
Thread Tools | |
Display Modes | |
|
|