Connection Strings

.Net, ASP Add comments

Access File:
 “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Work\Tools\myaccessdb.mdb;”

SQL Server:
“user id=SqlLoginName;password=SqlPW;initial catalog=yourDBname;data source=YourServerName;Connect Timeout=30”

SQL – OLE DB:
 Data Source=ServerIP; User ID=SqlLoginName;password=SqlPW;initial catalog=yourDBname

CSV File:
 “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”c:\tool\myfile.csv”;Extended Properties=””text;HDR=No;FMT=Delimited”””

ODBC link:
 “DSN=myDB;UID=John;PWD=123;”

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in