Winscripter
  WSH
  Forums
  Downloads
  Books
  Links
  Amazon




Login
Register

© winscripter.com
1998-2004







Database Connection Strings for Common Databases

Posted by 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

 


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

Panasonic Camera Reviews
By Panasonic Camera Reviews on Sunday, August 21, 2011 (PST)
I just added this feed to my bookmarks. I have to say, I very much enjoy reading your blogs. Thanks! Canon Camera Reviews

Reply to this Comment

www.winscripter.com is super
By farmville-secrets on Wednesday, October 12, 2011 (PST)
I love 2 read www.winscripter.com ! farmville hack

Reply to this Comment

perioada de gratie cosmote

By Jackiewicz6169 on Sunday, October 30, 2011 (PST)
cosmote reincarcare online|

Reply to this Comment

www.winscripter.com rocks!!!
By playstation-giveaway on Saturday, November 05, 2011 (PST)
You put a lot of work in www.winscripter.com , i like it! playstation 3 giveaway

Reply to this Comment

incarcare cartela online

By Konowal8980 on Tuesday, November 08, 2011 (PST)
{{reincarcare cartele|reincarcare vodafonecartela}|

Reply to this Comment

www.winscripter.com is full of interesting info
By samsung-epic-4g on Wednesday, November 16, 2011 (PST)
I read www.winscripter.com everyday Samsung Epic 4G

Reply to this Comment

www.winscripter.com is full of interesting content
By htc-thunderbolt on Thursday, November 17, 2011 (PST)
I love to read www.winscripter.com everyday htc thunderbolt

Reply to this Comment

www.winscripter.com is my fav site
By making-money on Tuesday, December 13, 2011 (PST)
i love to read www.winscripter.com !!!! making money from home

Reply to this Comment

www.winscripter.com is unbeliveable !
By gift-card on Saturday, December 17, 2011 (PST)
www.winscripter.com is awsome, my nr one site now free sears gift card

Reply to this Comment

www.winscripter.com rocks dude !
By bet-at-home on Monday, December 19, 2011 (PST)
www.winscripter.com is sweet ! bet at home italia

Reply to this Comment

Hi boys, i think that www.winscripter.com rocks !!!
By CPA-network on Sunday, December 25, 2011 (PST)
I come back to www.winscripter.com every single day!! Highest paying affiliate

Reply to this Comment

Add Your Comment



WSH and ADSI Administrative Scripting

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.


  • Winscripter   |  WSH   |  Forums   |  Downloads   |  Books   |  Links   |  Amazon