5/14/2024 11:30:47 PM
|
| |
| 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!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
OleDb Provider error and ASP.NET 2.0 site
Posted: 05 Aug 08 4:41 AM
|
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!
|
|
|
| |
| |
|
Re: OleDb Provider error and ASP.NET 2.0 site
Posted: 05 Aug 08 6:44 AM
|
Hi Sara,
Are you disposing your objects in your code?
"The using statement allows the programmer to specify when objects that use resources should release them. The object provided to the using statement must implement the IDisposable interface. This interface provides the Dispose method, which should release the object's resources."
Cheers,
Steve
|
|
|
| |
|
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!
|
|
|
|
|
|
|
|