Alternate Solutions to Consider
Database Type |
Connection String Examples |
SQL Server 2000 or earlier |
"Provider=sqloledb;Data Source=serverName;Initial Catalog=pubs;User Id=sa;Password=assssd;" |
SQL Server 2005 & 2008 |
Server=serverName;Database=pubs;UID=sa;PWD=asssd; |
MS Access |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=; |
Paradox |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myDb;Extended Properties=Paradox 5.x; |
Excel |
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"
Example select statement: SELECT * FROM [sheet1$] (worksheet name followed by a "$" and wrapped in "[" "]" brackets.)
|
Text
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended Properties="text;HDR=Yes;FMT=Delimited"
|
DBF/FoxPRo
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=
|