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!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: Type mismatch error when trying to open connection via ColdFusion

Charlie Arnold
Posts: 1

Type mismatch error when trying to open connection via ColdFusion Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Dec 06 3:28 PM

I'm trying to create an OLEDB connection to SalesLogix from ColdFusion via ADO, like so:

connStr='Provider=SLXOLEDB.1

assword=xxxx

ersist Security Info=True;User ID=Admin;Initial Catalog=SALESLOGIX;Data Source=xxxx;Extended Properties="PORT=1706;LOG=ON"';
objDataConn = CreateObject("COM", "ADODB.Connection");
objDataConn.Open(connStr);

I get this error: 0x80020005 - Type mismatch. in 'Provider'.

I've tested the connection interactively using Ryan's connection builder and it succeeds.

The error seems to indicate a datatype issue with the value of the 'provider' key in the connection string. Anyone have any insight?

[Reply][Quote]

Steve Meyers
Posts: 11

Re: Type mismatch error when trying to open connection via ColdFusion Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Dec 06 9:15 AM

Do you have ANY SalesLogix components installed on the machine you are executing the above code? I realize this may be a silly question but, the connection will not work unless you have the SalesLogix OLEDB Provider installed on the machine.

[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 11:11:41 AM