Re: [U2] UniODBC/UniOLEDB and Win2008? [ad]
Hi Kevin, [ad] (I thought I'd be honest and put this tag in here...) We can and do connect people to U2 data. We have customers doing some very interesting things with our products. And we support not just current U2, but PI/Open, mvEnterprise, mvBase, D3, and the list goes on... Our products were once known as Liberty ODBC but now our company is FusionWare Integration Corp. We have just recently gained control of the products for the first time since getting acquired by GA and the subsequent meltdown, so we are looking forward to doing a lot more in the community. Feel free to contact sa...@fwic.net for more information. :) [/ad] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, April 23, 2010 11:23 AM To: U2 Users List Subject: Re: [U2] UniODBC/UniOLEDB and Win2008? That's all unfortunate. I'm not sure if I'm more disillusioned by the hell that I've gone through with Microsoft in terms of Windows versions and SQL Server and linked servers and config and ... or with the overall state of affairs with the Rocket/U2 connectors. If we can't connect people to our data, then what hope of survival is there, really? ___ 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
Re: [U2] UniODBC/UniOLEDB and Win2008?
That's all unfortunate. I'm not sure if I'm more disillusioned by the hell that I've gone through with Microsoft in terms of Windows versions and SQL Server and linked servers and config and ... or with the overall state of affairs with the Rocket/U2 connectors. If we can't connect people to our data, then what hope of survival is there, really? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
Hi Kevin, 64 bit applications will not be able to directly access 32 bit drivers. There are some tricks for working around this, but they are NOT elegant. We're looking at what we need to do to enable our older ODBC drivers to work with 64-bit apps and we're unfortunately probably looking at retargeting, which means drivers, setup routines and all related components recompiled... :( We may not bother, as we do have an ADO.NET provider which doesn't need any such thing, we'd rather look at extending it to support linked tables... Decisions, decisions... :o -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, April 23, 2010 7:21 AM To: U2 Users List Subject: Re: [U2] UniODBC/UniOLEDB and Win2008? Thanks Robert, I see that now. But... how is one to actually use that data source, say, in a SQL Server linked server context? -K ___ 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
Re: [U2] UniODBC/UniOLEDB and Win2008?
Thanks Robert, I see that now. But... how is one to actually use that data source, say, in a SQL Server linked server context? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
Hi Kevin, On Windows 64 bit, there is a 64-bit odbcad32.exe (ODBC Administrator) and a 32-bit one. You have to run the 32-bit one to see 32-bit data sources like the UniODBC driver: C:\Windows>dir odbcad32.exe /s /p Volume in drive C is Preload Volume Serial Number is BCAB-EEE5 Directory of C:\Windows\System32 07/13/2009 06:39 PM90,112 odbcad32.exe 1 File(s) 90,112 bytes Directory of C:\Windows\SysWOW64 <--- This directory holds 32-bit versions of things 07/13/2009 06:14 PM86,016 odbcad32.exe 1 File(s) 86,016 bytes 32-bit versions have their own registry tree, so the 32-bit versions and 64-bit versions "see" different data sources. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 22, 2010 12:52 PM To: U2 Users List Subject: [U2] UniODBC/UniOLEDB and Win2008? I have a customer who has downloaded the most recent Unidata clients from the Rocket website and is trying to install them on Windows 2008/64-bit. The installation appears to go according to plan, there are no errors and no events logged, and yet after installing the ODBC driver, the Unidata ODBC driver is not listed in the list of ODBC data sources for the server. Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? -K ___ 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
Re: [U2] UniODBC/UniOLEDB and Win2008?
Phil's right. The thread at http://forums.techarena.in/operating-systems/1160164.htm gave me a little more info on that topic if you're curious as I was fighting with Windows Scripting Host 32/64 bit issues. Basically seems the first thing to try is running whatever you're wanting to run (cscript/wscript for me; odbcad32.exe for the ODBC manager) through the SysWOW64 folder first. %WINDIR%\System32\odbcad32.exe won't have UniData/UniVerse but %WINDIR%\SysWOW64\odbcad32.exe will have it for you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Thursday, April 22, 2010 4:11 PM To: U2 Users List Subject: Re: [U2] UniODBC/UniOLEDB and Win2008? You need to use the 32-bit odbc driver manager. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Friday, 23 April 2010 8:01 a.m. > To: U2 Users List > Subject: [U2] UniODBC/UniOLEDB and Win2008? > > I have a customer who has downloaded the most recent Unidata clients > from > the Rocket website and is trying to install them on Windows 2008/64- > bit. > The installation appears to go according to plan, there are no errors > and no > events logged, and yet after installing the ODBC driver, the Unidata > ODBC > driver is not listed in the list of ODBC data sources for the server. > > Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? > > -K > ___ > 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
How would a person do such a thing? Doesn't Windows have just this one ODBC connection store and when you use a connection you use whatever Windows is going to use? Forgive me for what must seem like stupid Windows questions. On Thu, Apr 22, 2010 at 2:10 PM, phil walker wrote: > You need to use the 32-bit odbc driver manager. > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Kevin King > > Sent: Friday, 23 April 2010 8:01 a.m. > > To: U2 Users List > > Subject: [U2] UniODBC/UniOLEDB and Win2008? > > > > I have a customer who has downloaded the most recent Unidata clients > > from > > the Rocket website and is trying to install them on Windows 2008/64- > > bit. > > The installation appears to go according to plan, there are no errors > > and no > > events logged, and yet after installing the ODBC driver, the Unidata > > ODBC > > driver is not listed in the list of ODBC data sources for the server. > > > > Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? > > > > -K > > ___ > > 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 > -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
You need to use the 32-bit odbc driver manager. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Kevin King > Sent: Friday, 23 April 2010 8:01 a.m. > To: U2 Users List > Subject: [U2] UniODBC/UniOLEDB and Win2008? > > I have a customer who has downloaded the most recent Unidata clients > from > the Rocket website and is trying to install them on Windows 2008/64- > bit. > The installation appears to go according to plan, there are no errors > and no > events logged, and yet after installing the ODBC driver, the Unidata > ODBC > driver is not listed in the list of ODBC data sources for the server. > > Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? > > -K > ___ > 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
[U2] UniODBC/UniOLEDB and Win2008?
I have a customer who has downloaded the most recent Unidata clients from the Rocket website and is trying to install them on Windows 2008/64-bit. The installation appears to go according to plan, there are no errors and no events logged, and yet after installing the ODBC driver, the Unidata ODBC driver is not listed in the list of ODBC data sources for the server. Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users