RE: Can't see connections
"Jerry Schwartz" <[email protected]> Fri, 17 Dec 2010 14:47:25 -0500
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Organization | Global Information Inc. |
| Message-ID | <[email protected]> |
I couldn't find any bug reports on this issue, so I opened Bug #59010. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: [email protected] Web site: www.the-infoshop.com >-----Original Message----- >From: Jerry Schwartz [mailto:[email protected]] >Sent: Friday, December 17, 2010 1:35 PM >To: 'Jerry Schwartz'; [email protected] >Subject: RE: Can't see connections > >Well, I did some manual work on the files and registry entries, but to no >avail. > >- I uninstalled MyODBC v. 5 >- I deleted the myodbc* files from \windows\system32 >- I manually edited the paths in the keys for my existing DSNs. > >That all worked just fine. > >Unfortunately, it didn't fix my problem: the MyODBC setup will not (or >cannot) >write the necessary entries into the system registry. > >I wound up building the necessary keys by hand: > >[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MainTable_USA (local test)] >"Driver"="C:\\Program Files\\MySQL\\Connector ODBC 5.1\\myodbc5.dll" >"SERVER"="localhost" >"UID"="access" >"PWD"="xxxxxx" >"DATABASE"="maintable_usa" >"PORT"="3306" >[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SubTable_USA (local test)] >"Driver"="C:\\Program Files\\MySQL\\Connector ODBC 5.1\\myodbc5.dll" >"SERVER"="localhost" >"UID"="access" >"PWD"="xxxxxx" >"DATABASE"="subtable_usa" >"PORT"="3306" > >I hope this helps somebody. > >Since I have to deploy this on several systems, this might actually work out >easier for me. > >Regards, > >Jerry Schwartz >Global Information Incorporated >195 Farmington Ave. >Farmington, CT 06032 > >860.674.8796 / FAX: 860.674.8341 >E-mail: [email protected] >Web site: www.the-infoshop.com > > >>-----Original Message----- >>From: Jerry Schwartz [mailto:[email protected]] >>Sent: Friday, December 17, 2010 10:23 AM >>To: [email protected] >>Subject: Can't see connections >> >>I know this has been talked about before, but now it is biting me big time. >> >> >> >>I deleted my existing connections and tried to create new ones, and they >>don't >>show up. I tried making them System DSNs and I tried making them User DSNs, >>without any luck. >> >> >> >>The creation process seems to work fine, and I tested each connection before >>hitting OK. >> >> >> >>Some of my other, older connections still show. >> >> >> >>I'm running Win32 Vista, and just installed mysql-connector-odbc-5.1.8- >>win32.msi. >> >> >> >>Regards, >> >> >> >>Jerry Schwartz >> >>Global Information Incorporated >> >>195 Farmington Ave. >> >>Farmington, CT 06032 >> >> >> >>860.674.8796 / FAX: 860.674.8341 >> >>E-mail: <mailto:[email protected]> [email protected] >> >>Web site: <http://www.the-infoshop.com/> www.the-infoshop.com >> >> > > > > > >-- >MySQL ODBC Mailing List >For list archives: http://lists.mysql.com/myodbc >To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]