MS Access with MyODBC

[I have three PCs running Win7 32-bit that do not exhibit this problem.]

- I have a PC running Win7 64-bit.

- I installed MS Office 2007 (which is 32-bit).

- I installed the 64-bit version of MyODBC (latest GA). (If the exact version
matters, I'll get it on Monday when I get back to the office.)

- Using the normally-accessible ODBC administration applet, I created and
tested a System DSN.

- I am unable to see the System DSN from MS Access or any other Office
program.

- I created and tested a User DSN.

- MS Access can see and use the User DSN.

Other than proceeding with a User DSN, are there any suggestions out there?

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MS Access with MyODBC

>-----Original Message-----
>From: Ludwig, Sven [mailto:Sven.Ludwig@LudwigIT.de]
>Sent: Sunday, July 25, 2010 5:05 AM
>To: Jerry Schwartz
>Subject: AW: MS Access with MyODBC
>
>Hi Jerry,
>
>this is a know Problem because there are two Versions oft he ODBC-Admin-Tool
>on
>64bit-Systems.
>
>You could find the solution on the Microsoft-Website:
>http://support.microsoft.com/?scid=kb%3Ben-us%3B942976&x=11 &y=3
>
>You simply have to use the other ODBC-Admin-Tool.
>
[JS] I'm pretty sure I tried that. Here's the fly in the ointment:

"The SQLDataSources function that is called in a 32-bit application returns
only system DSNs for 32-bit drivers but returns user DSNs for both 32-bit
drivers and 64-bit drivers."

In this case, I have a 32-bit application (MS Office) that needs to see the
MySQL ODBC driver. Because the OS is 64-bit, only the 64-bit MySQL ODBC will
install. Since the driver is 64-bit, I am creating a system DSN for a 64-bit
driver. As quoted above, a 32-bit application cannot see a 64-bit DSN.

The only workaround is to create a user DSN. Fortunately for me, most of our
PCs have only one user.

And, of course,

"To maintain backward compatibility, no resolution for this problem is
currently available."

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com




>Greetings,
>Sven
>
>
>-----Ursprüngliche Nachricht-----
>Von: Jerry Schwartz [mailto:jerry@gii.co.jp]
>Gesendet: Sonntag, 25. Juli 2010 04:01
>An: myodbc@lists.mysql.com
>Betreff: MS Access with MyODBC
>
>[I have three PCs running Win7 32-bit that do not exhibit this problem.]
>
>- I have a PC running Win7 64-bit.
>
>- I installed MS Office 2007 (which is 32-bit).
>
>- I installed the 64-bit version of MyODBC (latest GA). (If the exact version
>matters, I'll get it on Monday when I get back to the office.)
>
>- Using the normally-accessible ODBC administration applet, I created and
>tested a System DSN.
>
>- I am unable to see the System DSN from MS Access or any other Office
>program.
>
>- I created and tested a User DSN.
>
>- MS Access can see and use the User DSN.
>
>Other than proceeding with a User DSN, are there any suggestions out there?
>
>Regards,
>
>Jerry Schwartz
>Global Information Incorporated
>195 Farmington Ave.
>Farmington, CT 06032
>
>860.674.8796 / FAX: 860.674.8341
>E-mail: jerry@gii.co.jp
>Web site: www.the-infoshop.com
>
>
>
>
>
>--
>MySQL ODBC Mailing List
>For list archives: http://lists.mysql.com/myodbc
>To unsubscribe:
>http://lists.mysql.com/myodbc?unsub=sven.ludwig@ludwigit.de
>
>
>
>





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org