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]