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

Have you run the coledbp.sql file from the CSDK folder on your IDS server? If not do this first. If you have, you may have an issues that I've also encountered. I've had to first run doledbp.sql, then check sysmaster for any table or stored procedure beginning with "ole" that may not have been deleted. I had at least one remain, drop it. Once you are sure your sysmaster is 'clean', then rerun coledbp.sql. Also you may want to try sp_addlinkedserver without the @catalog argument. We use: EXEC master.dbo.sp_addlinkedserver @server = N'INFORMIX', @srvproduct=N'IBM', @provider=N'Ifxoledbc', @datasrc=N'mydb@idsserver', @provstr=N'decasr8=R8;DB_LOCALE=en_US.819' Jim On Wed, Mar 19, 2008 at 11:03 AM, Everett Mills <eemills@nationalbeef.com> wrote: > 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 >