lundi 20 août 2012
ASP: database connection strings (basic)
Do you like this story?
After a few days of deserved rest, here we get back to work! No that I want to, but I'm sure you are all waiting for new posts ... ... ... or not?
In the following short article I would like to list all possible database connection strings, just in case you need them in your projects. We will see just the basic way of connecting to data sources, so keep in mind that specific additional security parameters may be used, in case you need them.
Ready? Then please follow me...
Here is the list! I divided it into different sections, so that it might be easier to find what needed.
SQL Server
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Access 2007 (OLEDB 12.0)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\Access2007File.accdb;Persist Security Info=False;
Access
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myDB.mdb
Exchange
ExOLEDB.DataSource
We need to specify the "store" in the connection open command. An example:conn.open "http://ServerName/PublicStoreName"
System DSN
DSN=myDsn;Uid=myUsername;Pwd=;
File DSN
FILEDSN=c:\myDsnFile.dsn;Uid=myUsername;Pwd=;
Excel
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcelFile.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
Excel 2007
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\MyExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";
"HDR=Yes;" indicates that the first row contains column names, and not data. "HDR=No;" obviously indicates tha there are no column names.Ok, that's all for today. If you need to add something, please use the comments section below.
This post was written by: Franklin Manuel
Franklin Manuel is a professional blogger, web designer and front end web developer. Follow him on Twitter
Inscription à :
Publier les commentaires (Atom)
0 Responses to “ASP: database connection strings (basic)”
Enregistrer un commentaire