MGZ NetArt

Software Development and Support

Home
Design Patterns
C# Tips
AsyncCallback
Asynchronous Form.ShowDia
BackgroundWorker
Connection String
CopyTo() vs Clone()
Convert Color To String
Dispose vs Finalize
Debug mode
Delete Duplicate in SQL
Drag&Drop for TreeView
Edit Full Path Property
Hiding And Overriding
Polimorphism
How to use Resources
Run Time DLL
Simple Threading
Singleton Connection
Save Win Form as JPG File
Save Object in Registry
Soap Serialization
Sort and CompareTo
Working With List<>
Examples & Videos
MRDS Examples
Resume
Contact Us
Database connection strings
 

With visual Studio it is very easy to figure out the connection string to the database. In case that you don’t have Visual Studio, then here is the code:


 
SQL
"Persist Security Info=False;User ID=UserID;password =yourpassword; Initial Catalog=yourdatabasename Data Source=yourservername; Packet Size=4096"
"provider=Sybase.ASEOLEDBProvider;Server Name=yourservername;Initial Catalog=yourdatabasename;max pool size=5;Pooling=true;User Id=yourID;Password=yourpassword;Server Port Address=5000"
 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Documents and Settings\My Documents\MyAccessDB.mdb;User ID=yourname"