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
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
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
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
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
, 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
6 matches
Mail list logo