I just got the ODBC to work on my 64-bit machine. I used Glenn's advice and downloaded the 11.x UniVerse client and then installed the ODBC driver along with the UCI editor. We're using UniVerse 10.3 for the record, a couple notes from my install are as follows below:
Installing ODBC client: - install ODBC driver (from UniVerse client disk or zip). - install UCI editor. - open UCI editor, right-click on 'ODBC Data Sources'. + click Add, name can be anything, source is ELCODB2. + Save. - open Rocket U2-> UniVerse ODBC Driver-> ODBC Admins. + click Add. + select UniVerse ODBC (last item). + choose server from dropdown (that you added in UCI editor). + enter the UniVerse account name, USER, PW, then do 'test connection'. - Open Excel and choose Data-> From Other Sources-> Microsoft Query + select the name that you called your host in the UCI editor from the dropdown and make sure the name/pw are entered. + select the tables/fields you want in your spreadsheet. It was really straight forward and worked like a charm. The one thing to remember is to ADD the server to the UCI editor under ODBC data sources so that it appears in the dropdown menu when setting the ODBC driver up. Hope this helps. Chris > Date: Tue, 13 Sep 2011 19:44:25 -0400 > From: [email protected] > To: [email protected] > Subject: Re: [U2] 64-bit ODBC driver for win 7 > > If you are running Universe 10, I doubt the version 11 driver will > work. Let me know as I am in the same boat. I have not had time to > try it. > > On 9/13/11, Chris Austin <[email protected]> wrote: > > > > Thanks Glenn, I will give this a try in the morning! > > > > Chris > > > >> Date: Tue, 13 Sep 2011 23:48:26 +0200 > >> From: [email protected] > >> To: [email protected] > >> Subject: Re: [U2] 64-bit ODBC driver for win 7 > >> > >> Hi Chris, > >> > >> I suggest you download the latest client software package from the > >> Rocket site. The latest release is 11.1A which should be 64 bit windows > >> compatible. > >> > >> https://u2tc.rocketsoftware.com/u2bcesdinternal.asp?pid=100000037293&product=UVCLIENT > >> > >> <https://u2tc.rocketsoftware.com/u2bcesdinternal.asp?pid=100000037293&product=UVCLIENT> > >> > >> Kind regards > >> Glenn Sallis > >> > >> Am 13.09.2011 23:17, schrieb Chris Austin: > >> > I'm running a 64-bit version of Windows 7 and trying to install the ODBC > >> > driver that came with the UniVerse 10.1 client disk but > >> > I keep getting a message when I run the INSTALL application. The error > >> > states: > >> > > >> > 'The version of this file is not compatible with the version of windows > >> > you're running. Check your computers system information to see > >> > whether you need a 32-bit or 64-bit version of the program' > >> > > >> > Where can I download the 64-bit version of the UniVerse ODBC drivers? > >> > > >> > Thanks, > >> > > >> > Chris > >> > > >> > > >> > _______________________________________________ > >> > U2-Users mailing list > >> > [email protected] > >> > http://listserver.u2ug.org/mailman/listinfo/u2-users > >> > >> _______________________________________________ > >> U2-Users mailing list > >> [email protected] > >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > -- > Sent from my mobile device > > John Thompson > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
