Database Connection Strings for Common Databases

Search: Go

	Winscripter
	WSH
	Forums
	Downloads
	Books
	Links
	Amazon

Home > WSH > Database

Database Connection Strings for Common Databases

Posted by Daren on Sunday, January 18, 2004 (PST)

ADO Connection Strings for various databases. Access, SQL, Paradox

Common Database Connection Strings

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

Notify me when a new comment is posted

Comments:

Database Connection Strings for Common Databases
By strevisol on Friday, March 10, 2006 (PST)

and for ibm db2 for example? sybase ase?

sergio

Reply to this Comment

Add Your Comment

New Articles

List installed COM objects and associated ProgIDs
Script: Lists all COM Objects and their associated ProgIDs (If available). Win32_ClassicCOMClassSetting

Script: File Rotator
Script: Rotate files where the most current file has the lowest number in the archive. When files exceed the retention period, they are deleted. Typically used for log files, backups, etc..

Script: Create IIS Website and DNS record
Script: Dan Casier sent me this script that will create a website and appropriate DNS record. The script is intended for Windows 2000 Server with local DNS and necessary DNS mof installed.