:)
Access
Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\temp\sample.mdb
dBASE III
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=21
dBASE IV
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=277
dBASE 5.0
Driver={Microsoft dBASE Driver (*.dbf)};DBQ=c:\temp; DriverID=533
Excel 3.0/4.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp; DriverID=278
Excel 5.0/7.0
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=22
Excel 97
Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\temp\sample.xls;DriverID=790
Oracle
Driver={Microsoft ODBC Driver for
Oracle};Server=OracleServer.world;Uid=demo;Pwd=demo
Paradox 3.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=26
Paradox 4.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=282
Paradox 5.X
Driver={Microsoft Paradox Driver (*.db )};DBQ=c:\temp;DriverID=538
SQL Server
Driver={SQL Server};Server=myserver;Database=pubs;Uid=sa;Pwd=
Text/CSV
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=c:\temp
Thank you,
Joseph DeVore
VeloxWeb Technologies
-----Original Message-----
From: Kurt Ward [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 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
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data 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 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
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 1: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 spread
sheet as a dnsless connection?
Thanks,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
