Thanks for the help (attempts anyway). My Access version is 2016 and is 32bit.
I can't comment on MySQL as I'm only using MS Access with FB. I accept it is possibly a Microsoft issue but I'm guessing that it was an MS Access upgrade that has caused the change (I subsequently updated the ODBC drivers to see if it would help). However, I'm not very confident that Microsoft will care in the least hence pursing the FB route for a solution. I'm not sure how the drivers determine whether to use 32bit or 64bit as there is no option to choose 32 or 64 when creating a new source. When I open the option with MS Access to select a linked table, you just get presented with a list of databases to choose from. I can open both the 32 and 64bit ODBC Data Source Administrators from Windows and they both show the same content so I'm guessing that Windows must either create both, or they can work with both simultaneously. I'd assume that as Access is 32bit it is selecting the 32 bit ones. I have being doing exactly the same thing with MS Access and multiple FB databases for about 15 years without an issue. Now if I have two tables linked from two identical FB databases I can open tables in from either in separate sessions, (I.e. Open one table from the first source, close Access, then open a table from the second source) but if I try to open a table from a second source in the same session it always crashes. I'm not sure what is changed but a memory clash would seem like a potential cause for this. I'm happy to provide sample databases (2 x FB and 1x MS Access) if anyone wants to dig further into this. I might try seeing if I can install Access 2013 somewhere and try it in that. Might help isolate the problem. Cheerio Nick -----Original Message----- From: Morten H Pedersen [mailto:hoe...@gmail.com] Sent: Thursday, 7 September 2017 1:24 AM To: firebird-odbc-devel@lists.sourceforge.net Subject: Re: [Firebird-odbc-devel] MS Access 2016 crashing when using two Firebird ODBCs I have now tried the same with MySQL ODBC driver, connecting to two different tables in each of the three different databases (i.e. 6 tables) on same server using 3 different / unique ODBC data sources. This works without any issues. When you get to the third ODBC source with the FB connector, it crashes when looking at the data or when starting the load. Could there be any memory clash (a shared static variable or something in the FB connector code?) I have three active ODBC sources using the FB ODBC connector. I can load data from any combination of two sources without any issues. As soon as I touch a third, Access crashes. That is not an issue with the MySQL connector. I tried to toggle between fbclient.dll and gds32.dll - no apparent difference. I tried with the "read" checkmark on and off - no difference. Access crashes when you add the third ODBC connection. Only differences I can see are : FB ODBC connecter is both 32 and 64 bit. Is it in the same dll or are there two and how do you choose between the two (my Access and Excel are both 32 bit on Windows 10 64-bit)? kind regards, Morten Høgholm Pedersen -----Original Message----- From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] Sent: 2017-09-06 13:27 To: firebird-odbc-devel@lists.sourceforge.net Subject: Re: [Firebird-odbc-devel] MS Access 2016 crashing when using two Firebird ODBCs 06.09.2017 13:23, Morten H Pedersen wrote: > here is what I got debugging from Visual > Studio: I see no sign of Firebird ODBC here. I think this is a question for MS support, not Firebird one. -- WBR, SD. ---------------------------------------------------------------------------- -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel ---------------------------------------------------------------------------- -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel --- This email has been checked for viruses by AVG. http://www.avg.com ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
