You are all a great bunch I am sure. How is it used with an ADO connection object? I am not an expert on DB, but I do know the security can be a hassle and easily messed up. You should see the list of tables in the right pane. You can’t delete your own topics. Thanks, Have a great day! I will be facing similar task in a few days and I never worked with AS

Uploader: Faezshura
Date Added: 3 May 2011
File Size: 35.27 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 48320
Price: Free* [*Free Regsitration Required]

IBM Configuring an OLE DB Provider on an SQL Server – United States

I’m not sure what you mean by IIS as the data sources would not be controlled there. Last post Dec 15, Thanks in advance all. Thread “WorkThread0” has exited with error code 0xC I agree to my information being processed by TechTarget and ibmdw400 Partners to contact me via phone, email, or other means regarding information relevant to my professional interests.

I think there must have been some registry corruption somewhere that prevented it from working before. I’m sure you have a reason, but I have to ask. Daily SQL Articles by email:. I may unsubscribe at any time. You can’t post new topics.


Unconfigured Ad Widget

What are the settings on the Security Tab of the linked server properties? This occurs when the number of errors reaches the number specified in MaximumErrorCount. Friday, January 19, 3: Here is the error when trying to execute a query using my login: I have not tried it, but it really describes the problem. When I try to run my program on the CA Express machines using the second example I can login to the AS but when I try to retrieve the recordset the VB program crashes and gives me and illegal operation error.

The same error exists in the command window of package execution utility. Wednesday, January 24, 2: This is the name of your IBM System i server. You can’t edit your own posts. There seems to be two types of drivers you can use but I’ve used the one that is supposedly backwards compatible.

Thread “SourceThread0” has exited with error code 0xC The Execution method succeeded, but the number of errors ibmds400 5 reached the maximum allowed 1 ; resulting in failure.

IBMDA Provider & SQL select statement issue – IT Answers

Thursday, February 15, 5: As we are behind loading PTF’s on our system, maybe with this post someone will beat me to it and can let us know if it really works.


Luckily or unluckily there is no dump file is being generated. Monday, October 25, 5: What can be wrong? Post reply Like Add to Briefcase.

You can’t post topic replies. You can’t post HTML code. Have you had any success resolving this issue? As for the steps, there are none except using the above connstr in place of your normal connstr to you sql, for example. Wednesday, October 31, ibmds400 I will look into the link you sent to see if I can seea nything there. The article explains that it is necessary to apply a “hotfix”on the operating system of as