slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - ASP/ASP.NET/Web Services/Other
Forum to discuss building external web applications for SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ASP/ASP.NET/Web Services/Other | New Thread

View: Search:

Author

Thread: Errors with OleDb Provider

Sara
Posts: 10

Errors with OleDb Provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Aug 08 10:43 PM

Please excuse me for cross-posting, but perhaps it was more appropriate on this section...

The error I get appears after a second or third connection happens to the site. If I only have one connection it works just fine, obviously this is useless. I run the page, it works, then run the page again (different tab or even different browser), it sometimes runs but most of the times it fails and I get the following error:

OleDbException 0x80004005 Failed to execute internal SalesLogix procedure

System.Data.OledDb.oleDbCommand.ExecuteCommandTextForSInfleResult(tagDBPARAMS dbParams, Object& executeResult)

The only thing I can imagine is that the connection is either kept open or something with the provider remains locked. If I restart IIS or wait until the site times out, I can run the page without the error again.
Also, the page redirects me to another page, and all the work that I do works correctly. It's just when trying to run my login screen several times that causes the error. Particularly after getting the server and alias lists.
And I use Ryan's code for getting the server and alias lists. My code is in C# and all the connections are done in a using statement.

Has this happened to anybody else? What's the fix?
I appreciate any help you can give me as I've been dealing with this issue for days now and can't get a handle on it.

Thanks!

[Reply][Quote]

Harendra Sinha
Posts: 66

Re: Errors with OleDb Provider Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Aug 08 12:53 PM

Be sure thet u r disposing the object related with connection in finally block or something like that after each operation .
-Harendra

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 10:35:17 AM