8/22/2025 10:27:37 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 ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.
|
|
|
|
Type mismatch error when trying to open connection via ColdFusion
Posted: 21 Dec 06 3:28 PM
|
fiogf49gjkf0d I'm trying to create an OLEDB connection to SalesLogix from ColdFusion via ADO, like so:
connStr='Provider=SLXOLEDB.1 assword=xxxxersist 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? |
|
|
|
Re: Type mismatch error when trying to open connection via ColdFusion
Posted: 22 Dec 06 9:15 AM
|
fiogf49gjkf0d 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. |
|
|
|
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!
|
|
|
|
|
|
|
|