I'm using code from CFComet to generate an excel spread sheet from a sql
query but i'm having trouble getting the ado connection to open. I think
perhaps the problem is that i'm replacing "MyDSN" (CFSET Datasource =
"MyDSN") with the wrong value. I'm using the name of the datasource that i
specified in the CF administrator, but when i talked to some microsoft guys
here, they told me that they didn't think CF would translate that to the
proper values for an ADO connection. Has anyone used this code before and if
so, can you tell me what it is i'm doing wrong. Thanks for any help.
d
>> the line below generates the error
CFSET oConn.Open(Datasource, UserName, Password, -1)
>> the error:
Error Diagnostic Information
Arguments expected by object does not match arguments specified in the tag.
Error building an argument list for: OPEN
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
