Connection Strings (OLE/ODBC.Net)

By Kevin Schreiner

December 30, 2008

Open Web Studio provides the ability to use external connections from standard .Net ODBC supported databases via the Connection property of the Rendering, Action:Execute and Sub queries. The provided list below is a breakdown of example Connection Strings from well known Database Management Systems.



Access


Default
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\path\dabasename.mdb;User Id=admin;Password=;

Password Protected
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\path\dabasename.mdb;Jet OLEDB:Database Password=passwordValue;

Active Directory


Provider=ADSDSOObject;User Id=Username;Password=PasswordValue;

AS/400 (iSeries)


PROVIDER=IBMDA400; DATA SOURCE=SOURCE_SYSTEM;USER ID=Username;PASSWORD=PasswordValue;

DBF / FoxPro


Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\path;Extended Properties=dBASE IV;User ID=Admin;Password=OptionalPasswordValue;

DSN


Default
DNS=DsnName;Uid=Username;Pwd=OptionalPasswordValue;

File DSN


FILEDSN=C:\Path\File.dsn;Uid=Username;Pwd=OptionalPasswordValue;

Excel


Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Path\FileName.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1

Firebird


User=Username;Password=PasswordValue;Database=DatabaseFileName.fdb;DataSource=ServerName;Port=3050;Dialect=3;Charset=NONE;Role=;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;

IBM DB2


Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=IP ADDRESS;Initial Catalog=SourceCatalog;Package Collection=SourceCollection;Default Schema=Schema;User ID=Username;Password=OptionalPasswordValue;

Informix


Provider=Ifxoledbc.2;password=OptionalPasswordValue;User ID=Username;Data Source=DatabaserName@Server_Name;Persist Security Info=true;

Ingres


Provider=MSDASQL.1;DRIVER=Ingres;SRVR=SERVER;DB=DATABASE;Persist Security Info=False; uid=UserName; pwd=OptionalPasswordValue; SELECTLOOPS=N; Extended Properties="SERVER=SERVERNAME; DATABASE=DATABASENAME; SERVERTYPE=INGRES"

Interbase


provider=sibprovider;location=server:;data source=c:\path\dabasename.gdb;user id=UserName;password=OptionalPasswordValue

MySQL


Provider=MySQLProv;Data Source=DatabaseName;User Id=Username;Password=OptionalPasswordValue;

Oracle


Default (Microsoft)
Provider=msdaora;Data Source=OracelDatabaseName;User Id=Username; Password=OptionalPasswordValue;

Default (Oracle)
Provider=OraOLEDB.Oracle;Data Source=OracelDatabaseName;User Id=Username; Password=OptionalPasswordValue;

Trusted Connection
Provider=OraOLEDB.Oracle;Data Source=OracelDatabaseName;OSAuthent=1;

Paradox


 Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DatabaseName;Extended Properties=Paradox 5.x;

Pervasive


Provider=PervasiveOLEDB;Data Source=C:\Path

SQL Server


Provider=sqloledb;Data Source=DataSourceName;Initial Catalog=DatabaseName;User Id=Username;Password=OptionalPasswordValue;
Provider=sqloledb;Data Source=IPADDRESS,1433;Network Library=DBMSSOCN; Initial Catalog=DATABASENAME; User ID=Username; Password=OptionalPasswordValue;

Sybase


Adaptive Server Anywhere (ASA)
Provider=ASAProv;Data source=ASADataSourceName

Adaptive Server Enterprise (ASE)
Provider=Sybase.ASEOLEDBProvider;Srvr=SERVERNAME,5000; Catalog=DATABASENAME;User Id=Username; Password=OptionalPasswordValue

Text


Delimited Columns
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Path\;Extended Properties="text; HDR=Yes; FMT=Delimited”

Fixed Columns
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Path\;Extended Properties="text; HDR=Yes; FMT=Fixed"

Visual FoxPro


Database
Provider=vfpoledb.1;Data Source=C:\Path\FileName.dbc;Collating Sequence=machine

Table Directory
Provider=vfpoledb.1;Data Source=C:\Path\;Collating Sequence=general

ODBC DSN
Provider=vfpoledb.1;DSN=DSNNAME

Average (1 Ratings):
 
Want to help out?
 
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share