odbc connection fails in Office 2010
in [General]
|
Prev: MDE
Next: shared Access 2000 db in Access 2007
From: magick on 20 May 2010 12:33 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.
From: Tom van Stiphout on 20 May 2010 23:29 On Thu, 20 May 2010 09:33:01 -0700, magick <magick(a)discussions.microsoft.com> 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.
From: magick on 21 May 2010 08:26 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 > <magick(a)discussions.microsoft.com> 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. > . >
From: Tom van Stiphout on 21 May 2010 10:08 On Fri, 21 May 2010 05:26:01 -0700, magick <magick(a)discussions.microsoft.com> 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 >> <magick(a)discussions.microsoft.com> 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. >> . >>
From: magick on 21 May 2010 12:38
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 > <magick(a)discussions.microsoft.com> 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 > >> <magick(a)discussions.microsoft.com> 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. > >> . > >> > . > |