John: 1. There are some third-party ODBC tools available. 2. I do something like this now with Adobe's ColdFusion... a free developer version of CF is available for download from Adobe. 3. Rocket has some tech manuals that cover this area. 4. When I was troubleshooting this with CF, I wrote a little Java connection string test program.
--Bill -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John J. Wahl Sent: Monday, April 23, 2012 5:44 PM To: U2 Users List Subject: [U2] [UV] UniOLEDB driver 64-bit windows and installers (take 50 or something) Greetings all, I've been parsing through the posts I've seen in the group and online, and I'd love to get to a point where there's a conflict, but no such luck for me I'm afraid. Our issue seems a little different and I'm hoping someone has seen this recently. I have a single UniVerse server (10.1) it's running Windows Server 2008, and had (as of this weekend) SQL Server 2008 on it as well; both were setup as 32-bit. This weekend I tried to move all my SQL Server to a new box which is still SQL Server 2008, but the Server itself is 64-bit and Windows Server 2008 R2. To make a medium story shorter I cannot get IBM.UniOLE to show up as a "Provider" in SQL Server, I had it working pretty darn well on my old box and was quite happy. Unfortunately no matter what I do with installs (I have tried older, newer, 32-bit and 64-bit drivers) I just cannot get it to work. So during my debugging and disassembling of this poor process I've made, I noticed that the Registry says the following: Key: HKEY_CLASSES_ROOT Wow6432Node\CLSID\{DB14F292-CA54-11D1-BEB8-0060973B624E}\InprocServer32 ValueName: (Default) Value: C:\Windows\SysWow64\UniOLEDB.dll I have no such file, I've looked w/ /a etc, so it's not just hidden. In fact, a quick search revealed no file w/ that name ANYWHERE on the HD. Now I was able to determine that the .msi package has a nested structure and the file " _3C788511D64D4D17B7955EB0B3E14A56" really is the DLL in question, but... I would rather do this the correct way and no brute force something into place. Could there be something I'm missing or do not understand about the UniOLEDB 64-bit installer? Thank you everyone, ------------------------------- John J. Wahl Employee Owner Programmer / Analyst Tel: (888) 465-6737 Ext. 120 Fax: (330) 342-3896 Email: jw...@joseph.com <-- farm me I dare you ;) Web: http://www.Joseph.com/ _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users