I never saw this come across so i'm trying again. thanks for any help. ---------- 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
