DevHeads.net

Can't see connections

By Jerry Schwartz at 12/17/2010 - 11:23

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: ... at gii dot co.jp> <a href="mailto: ... at gii dot co.jp"> ... at gii dot co.jp</a>

Web site: <http://www.the-infoshop.com/> <a href="http://www.the-infoshop.com" title="www.the-infoshop.com">www.the-infoshop.com</a>

Comments

RE: Can't see connections

By Jerry Schwartz at 12/17/2010 - 14:34

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: <a href="mailto: ... at gii dot co.jp"> ... at gii dot co.jp</a>
Web site: <a href="http://www.the-infoshop.com" title="www.the-infoshop.com">www.the-infoshop.com</a>

RE: Can't see connections

By Jerry Schwartz at 12/17/2010 - 15:47

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: <a href="mailto: ... at gii dot co.jp"> ... at gii dot co.jp</a>
Web site: <a href="http://www.the-infoshop.com" title="www.the-infoshop.com">www.the-infoshop.com</a>