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!

External Development Forums - SalesLogix OLEDB Provider
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: SLXOLEDB.1 provider specified cast is not valid error

anna miller
Posts: 1

SLXOLEDB.1 provider specified cast is not valid error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 06 5:58 PM

My application has stopped working with the slxoledb.q provider only on one machine.
It works fine on my dev and test servers but on the production server I get this error when trying to open the connection with the provider:

[6/7/2006 3:08:09 PM] System.InvalidCastException: Specified cast is not valid.
at System.Data.OleDb.OleDbException..ctor(IErrorInfo errorInfo, Int32 errorCode, Exception inner)
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hResult, OleDbConnection connection, Object src)
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()

Any ideas?

thanks,
anna

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SLXOLEDB.1 provider specified cast is not valid error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 06 7:30 PM

The Specified Cast exception is one that is not correctly reported by the provider. The "invalid cast" is happening at the provider lever when attempting to pass the error details back to a .NET exception object. So you're not really seeing the *real* error.

Since the exceptions stack trace is going back to OleDbConnection.Open, the problem is most likely with the connection string. Focus there and see if something doesn't look right, also ensure the SLX server (and underlying database) is visible from the machine this is happening on (ie" no firewalls inbetween etc)

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: SLXOLEDB.1 provider specified cast is not valid error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 06 7:38 PM

I should mention that the problem with the "specified cast" thing has been fixed (i'm thinking it was SP3?)

[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/26/2024 4:13:37 AM