Re: Micro$oft SQL Server 2005 (64 bit version) to IDS 9.40 Linked server

Sorry, I forgot to mention that I currently have this running just fine in our production environment with CSDK 3.00.FC3 on Windows 2003 x64 with SQL Server 9.0.3215, connecting to IDS 10.00.TC6 running on another server (Win2003 32 bit). But only after a lot of hair pulling. Jim On Wed, Mar 19, 2008 at 12:16 PM, Jim Tranny <jimtranny@gmail.com> wrote: > DL, you're getting hit by the 64bit CSDK install bug. The Windows > 64bit CSDK does come with the 64 bit driver. I've reported the issue > to IBM during the open beta of the Windows 64bity port but I think > it's still present. > > The problem is with the installer and how it creates its registry > entries. It creates the entries under the Wow6432Node when it should > not. I can send you the files I wrote to correct this. > > Jim > > > > On Wed, Mar 19, 2008 at 12:03 PM, DL Redden <redden96@yahoo.com> wrote: > > > > We have not gotten linked servers to Informix to work with 64-bit MSSQL. I > > believe the reason is that the OLEDB driver that comes with the 64-bit > > Informix client is still a 32-bit driver. Since MSSQL is 64-bit it cannot > > utilize a 32-bit OLEDB driver. It's very frustrating and I've spent a > > considerable amount of time trying everything that I could think of or find. > > I have not tried support, either IBM or Microsoft. > > > > > > > > > > ----- Original Message ---- > > From: Everett Mills <eemills@nationalbeef.com> > > To: Informix-List (E-Mail) <informix-list@iiug.org> > > Sent: Wednesday, March 19, 2008 10:03:34 AM > > Subject: Micro$oft SQL Server 2005 (64 bit version) to IDS 9.40 Linked > > server > > > > Guys- > > We have a new SQueaL Server 2005 64 bit install which need to > > read some data from our IDS 9.40.UC8 instances running on HP-UX 11.11. > > This has been no problem for grabbing data with the 32 bit version of > > SQueaL: create a DSN for the IDS instance and use ODBC for the linked > > server. The 64 bit SqueaL doesn't support ODBC, which has left us > > floundering. The server with SqueaL has CSDK 3.0.FC3 installed and the > > IDS server has had the most recent version of coledbp.sql run on it. > > The IDS server has been set up in SetNet 32. > > Has anyone gotten this type of configuration to work? > > > > Here is a sample of what we've tried from the SQueaL side: > > > > > > EXEC master.dbo.sp_dropserver @server=N'dcbeef', > > @droplogins='droplogins' > > > > EXEC sp_addlinkedserver > > @server = 'my_new_linked_server', -- defined in SetNet32 on tab 'Server > > information', > > -- field 'Informix Server' > > @provider = 'ifxoledbc', -- DO NOT CHANGE ! > > @datasrc = 'database_name@ids_server_name', -- name of the connection > > defined in your system. (you must configure this.) > > @srvproduct = 'Informix', > > @catalog = 'database_name' > > --@provstr = > > 'Host=my_ids_host;Server=ids_server_name;Service=sqlexec;Protocol=onsoct > > cp;Database=database_name;UID=valid_user;PWD=password_here' > > ---- > > sp_testlinkedserver my_new_linked_server > > --****THIS SUCCEEDS**** > > go > > select * from> > [my_new_linked_server].database_name.informix.valid_table_name > > > > > > OLE DB provider "ifxoledbc" for linked server "my_new_linked_server" > > returned message "EIX000: (-674) Routine (oledbcollen) can not be > > resolved. ". > > Msg 7311, Level 16, State 2, Line 1 > > Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider > > "ifxoledbc" for linked server " my_new_linked_server ". The provider > > supports the interface, but returns a failure code when it is used. > > > > We've tried dozens of different variation on this theme. Any suggestion > > as to what we're doing wrong? Or does the 64 bit SQueaL just not work > > for this? > > > > Thanks in advance, EEM > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > > > > >