Re: Creating Linked database connections to Informix 9 from SQL
> Thanks for that Darren, unfortunately we're stuck with linked servers. > (Hey, I'm only the System/DB Admin, why would anyone from the development > team ask me about my environment.) We have however traced the cause of the > problem to a conflict with a previously used ODBC driver (SCO > SQL-Retriever). Removing this stopped the problem and it all know works > fine. > > Regards > > Simon > > -----Original Message----- > From: DarrenJacobs@carmax.com [mailto:DarrenJacobs@carmax.com] > Sent: 30 January 2003 15:07 > To: Simon.Coyne@dla.com > Subject: Re: Creating Linked database connections to Informix 9 from SQL > [175] > > > > Link server sucks!! It should not be that difficult to configure but you > have to remember it is microsoft! Poorly documented, no good examples, > etc.... I would think IBM would have a better relationship with Bill. We > also have issues with link server and sybase. It just doesn't work as > easily as it should. > > Not sure if I saw the error you encountered but I used 2.80 to make > connections to informix 9.21. Try this guy at informix if you need help. > Mathew .... mmenefee@us.ibm.com. He is the one that recommended me using > 2.80. He was a great help and maybe by now there is even more > documentation by informix. By the way, I believe my case no, was 321713. > > Below is my configuration. I hope it helps. Good Luck! > > My config: > > (Embedded image moved to file: pic01360.pcx) > > > (Embedded image moved to file: pic03884.pcx) > > (Embedded image moved to file: pic02499.pcx) > > > > > "Coyne, Simon" > > <Simon.Coyne@dla To: ids@iiug.org > > .com> cc: > > Sent by: Subject: Creating Linked > database connections to Informix 9 from SQL [175] > forum.subscriber > > @iiug.org > > > > > > 01/30/03 04:57 > > AM > > > > > > > > > > Informix Friends > > We are currently in the process of migrating to Informix version 9. At the > moment we are doing a number of tests around our bespoke applications. One > of these involves transferring a large amount of data from our Informix 9 > server through a SQL Server linked database ODBC connection. We have > installed Informix CSDK 2.7 on our SQL-Server environment (NT4 SP6, > S/Server7 SP3) and now we are experiencing a couple of problems > > 1. From a PC workstation, if we connect to the database we can find no way > to turn off ANSI padding. Is this feasible? > > 2. From a SQL-Server server, we cannot get it to connect properly. We > create > a linked database and although we can see the table list, no SQL will run > against it. The error returned at the SQL Server end is > > "Server: Msg 7370, Level 16, State 2, Line 1 > One or more properties could not be set on the query for OLE DB provider > 'MSDASQL'. The provider could not support a required property. > [OLE/DB provider returned message: Multiple-step OLE DB operation > generated > errors. Check each OLE DB status value, if available. No work was done.]" > > The only reference I can find to this error is that regcopy has not been > run, but it has and the log reports success. > > > I cannot believe that I am the first person to try this and wondered if > anyone had any advice to offer. > > Many Thanks > > Simon Coyne > Infrastructure Support > DLA > > email: simon.coyne@nospam.dla.com > > You know what to remove to get a proper email address. > > > > > The contents of this email are confidential to the intended recipient at > the email address to which it has been addressed. It may not be disclosed > to or used by anyone other than this addressee, nor may it be copied in > any > way. If received in error, please contact DLA, a UK law firm, ( > http://www.dla.com/) on +44 (0) 8700 111111 quoting the name of the sender > and the addressee and then delete it from your system. > > Please note that neither DLA nor the sender accepts any responsibility for > viruses and it is your responsibility to scan the email and attachments > (if > any). No contracts may be concluded on behalf of DLA by means of email > communications. > > A list of the names of the partners of DLA (who are either solicitors or > registered foreign lawyers) and their qualifications is available for > inspection at 3 Noble Street, London, EC2V 7EE, UK. > > Regulated by the Law Society. > > > > > > > > > > The contents of this email are confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to or used by anyone other than this addressee, nor may it be copied in any way. If received in error, please contact DLA, a UK law firm, (http://www.dla.com/) on +44 (0) 8700 111111 quoting the name of the sender and the addressee and then delete it from your system. Please note that neither DLA nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of DLA by means of email communications. A list of the names of the partners of DLA (who are either solicitors or registered foreign lawyers) and their qualifications is available for inspection at 3 Noble Street, London, EC2V 7EE, UK. Regulated by the Law Society.