Error 7399 Informix
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: error 7399 with a linked server (informix) SQL Server > Getting started with SQL Server Question 0 Sign in to vote Here’s the booboo. Client Side: O/S Vista Business 64 bit Informix SDK 3.50 64 bit SQL Server 2008 64 bit with service pack 1. Server Side: Informix IDS 9.40.UC8 O/S Red Hat Linux 2.4.21 Coledbp.sql ran on Informix sysmaster database. Regsvr32.exe ran for ifxoledbc.dll Situation: I am trying to make a linked server on the SQL Server 2008 pointing to the Informix server on Linux. The linked server is created correctly. I can test the connection correctly. But I have the following error when I try to query on the database schema. The Informix ODBC works fine. The OLDE DB provider
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » T-SQL » Linking an Informix server -> Error 7399 Linking an Informix server -> Error 7399 Rate Topic Display Mode Topic Options Author Message Jean-Pierre LACOSTEJean-Pierre LACOSTE Posted Thursday, May 26, 2005 11:07 AM Grasshopper Group: General Forum Members Last Login: Thursday, April 21, 2011 2:15 PM Points: 14, Visits: 15 In a procedure, I want to link an Informix server https://social.msdn.microsoft.com/Forums/sqlserver/en-US/80c94f01-05fb-4363-883d-f0bcc8b79696/error-7399-with-a-linked-server-informix?forum=sqlgetstarted :EXEC sp_addlinkedserver@server = '24sunix_se', -- name of the informix server@provider = 'MSDASQL',@datasrc = 'certif', -- name of the odbc connection@srvproduct = 'Informix 3.33 32 bit'EXEC sp_addlinkedsrvlogin@rmtsrvname = '24sunix_se',@userself = 'false',@locallogin = 'sa',@rmtuser = 'smc',@rmtpassword = 'toto'The server appear in the list of the linked server (in Security/Linked server), but I can't access to the tables :Error 7399 : Data source name not found http://www.sqlservercentral.com/Forums/Topic185478-8-1.aspx and no default driver specified.[OLE/DB Provider MSDASQL 'IDVInitialize::Initialize returned 0x80004005I don't understand the error message, the odbc connection works fine. And I can build an connection with a udl file usingthe connection string :MSDQSQL.1;Security Info =false; User ID = smc; Data source = certifWhat's wrong in my process ?Thank's you for your help !Jean-Pierre Post #185478 evorstenboschevorstenbosch Posted Thursday, May 26, 2005 11:55 PM SSC Rookie Group: General Forum Members Last Login: Wednesday, November 26, 2014 12:53 AM Points: 43, Visits: 11 Did you check the following:Is the ODBC source a System DSN, not an User DSN? Is the ODBC source on the server machine?Hope this helps.Erik Post #185579 Jean-Pierre LACOSTEJean-Pierre LACOSTE Posted Friday, May 27, 2005 12:58 AM Grasshopper Group: General Forum Members Last Login: Thursday, April 21, 2011 2:15 PM Points: 14, Visits: 15 The ODBC source is a User DNS and the ODBC source is on the server machine with SQLServer.Thank's for the reply Post #185590 Ste_PSte_P Posted Friday, May 27, 2005 3:14 AM SSC Veteran Group: General Forum Members Last Login: Wednesday, September 30, 2015 5:17 PM Points: 214, Visits: 102 Hi,Have yo
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo http://www.tek-tips.com/viewthread.cfm?qid=1231008 Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your https://groups.google.com/d/topic/microsoft.public.sqlserver.connect/ONZUlpBarYU Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! error 7399 Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Setup and Administration Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Setup and Administration Forum Informix Linked server thread962-1231008 Forum Search FAQs Links MVPs Informix Linked server Informix Linked server thendrickson (Programmer) error 7399 informix (OP) 16 May 06 11:21 I am attempting to create a linked server (Informix)I use the following to create the linked server.use masterexec sp_addlinkedserver@Server = 'traintcpTest',@srvProduct = 'IBM Informix 3.82 32 bit',@Provider='MSDASQL',@provstr = 'Driver={IBM Informix 3.82 32 bit};Database=jlk_stage;UID=me;PWD=something;PROTOCOL=onsotcp;HOSTNAME=\\devserver;SERVICE=1527;SERVER=traintcp;'Although I have changed the UID and PWD to a generic value for this post, the rest of the values are exactly what the values are for a user dsn that works properlyAs soon as I click on the created linked server and click tables, I receive an error 7399 OLE DB Provider 'MSDASQL' reported an errorDriver's SQLSetConnectAttr failed],Driver's SQLSetConnectAttr failed],Invalid SQLHostsfile format.]etc. etc.I am using SQL Server 2000.I am doing a google search of course, but not finding the fix. from what I am finding, I seem to be "doing it right" so I suspect I am just plain missing the obvious.Any ideas? RE: Informix Linked server thendrickson (Programmer) (OP) 16 May 06 15:46 I found a typo in the provider string. Additionally I found some other information.Currently i am trying to executeexec sp_addlinkedserver@Server = 'traintcpTest1',@srvProduct = 'ifxoledbc',@Provider='MSDASQL',@provstr = 'Driver={IBM Informix OLE DB Provider};Database=jlk_stage;UID=me;PWD=something;PROTOCOL=onsoctcp;HOSTNAME=devserv;Service=1527;SERVER=t
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen