I don't see what this has to do with CFC's, but... CFMX doesn't automatically recognize ODBC data sources the way CF5 and earlier did. You have to create the ODBC data source in Windows and also create an ODBC-JDBC Bridge datasource in CFAdmin.
HTH, Sam --------------------------------------------- B-Line Charting Components 2.0 now available http://www.blinex.com --------------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tyagi, Badal > Sent: Monday, June 09, 2003 8:49 AM > To: '[EMAIL PROTECTED]' > Subject: [CFCDev] Microsoft Excel DSN > > > Hi, > I'm unable to make dsn in CFMX of Microsoft Excel sheet. If I > do it through ODBC Datasource Administrator, then CF does not > recognise it and throws error "Data source 'import' could not > be found. " > > Actually I'm uploading an excel sheet from client's m/c > renaming it to my dsn file name and then thru <cfquery> tag I > read the records in it. The same thing I did it w/ <cfobject> > tag but till date I'm unable to resolve MX issues related to > COM objects(working fine in CF5.0), so I thought doing it ODBC way. > > regards, > badal Tyagi, ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
