RE: XLS as a DSNless Connection

2001-12-13 Thread Duane Boudreau
Is there a way in CF4.5? Duane -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 4:33 PM To: CF-Talk Subject: RE: XLS as a DSNless Connection If you are running CFAS 5.0: cfquery name= q dbtype=dynamic connectstring=DRIVER={SQL

RE: XLS as a DSNless Connection

2001-12-12 Thread Dan Phillips
I don't believe CF supports DSNless connections. -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 4:17 PM To: CF-Talk Subject: XLS as a DSNless Connection Hi All, Does anyone have a code snippet that shows how to connect to an excel

RE: XLS as a DSNless Connection

2001-12-12 Thread Carlisle, Eric
DSNless queries are supported in CF5. Here's a good starting point... http://www.cfm-resources.com/tutorials.cfm?Include=dsnless.txt EC -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 4:16 PM To: CF-Talk Subject: RE: XLS

RE: XLS as a DSNless Connection

2001-12-12 Thread Joseph DeVore
If you are running CFAS 5.0: cfquery name= q dbtype=dynamic connectstring=DRIVER={SQL SERVER};SERVER=;UID=;PWD=;DATABASE= blockfactor=100 ... /cfquery FYI: Connect string properties are specific to the database you are connecting to HTH, Joseph DeVore VeloxWeb Technologies

RE: XLS as a DSNless Connection

2001-12-12 Thread Kurt Ward
Source=c:\somepath\myExcelSpreadsheet.xls; Extended Properties=Excel 8.0;HDR=Yes;; -Original Message- From: Joseph DeVore [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 4:33 PM To: CF-Talk Subject: RE: XLS as a DSNless Connection If you are running CFAS

RE: XLS as a DSNless Connection

2001-12-12 Thread Joseph DeVore
, 2001 1:35 PM To: CF-Talk Subject: RE: XLS as a DSNless Connection Excel ODBC: ConnectionString=Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=c:\somepath\mySpreadsheet.xls; DefaultDir=c:\somepath; Excel OLEDB via MS Jet