SQL connectionstring parameters

Hot Topic

Dynamic Columns & Dynamic Grouping ???
Login failed for user "David". Reason: Not associated with a trusted SQL Server connection.
Query VS Stored Procedure problem
ssis will not display package
Previos period YTD for closed periods only
Inserting image file into Image column in DB
Grandtotal row diff between analytic and regular aggregate functions?
Question transport-level error
Suppressing text messages
Simple Question - Control Flow Related

SQL Server

Stored Proc for creating and inserting into a table
User-defined types (UDT) in Typed Dataset
Connection String Encryption for SQL Server Mobile
Unrecognized Oracle Functions in SMAA for Oracle
How would you interpret this Error Message
Problem with Context Switching feature in SQL 2005
Scheduled Jobs
Problem installing server instance on windows xp sp2
SQL 2005 DW and BI Features comparison to SQL server 2000
Issues with MOM reports after SQL2k5 install

SQL connectionstring parameters

Hi, does anyone knows where can i find all the values that support the connectionstring since the connectionstring uses the "server=local;database=nortwind;UID=me...."

etc. are there more parameteres to specify which one of them is not REALLY important , where can i find a list or something about it

Thank you, i hope i made my point clear



Answer this question

SQL connectionstring parameters

  • Captain Baz

    Try these links on MSDN. They provide the properties (values) that make up each of the different connection strings. Which ones are really important It all depends on what you're using the connection for

    SQLConnectionStringBuilder

    OleDbConnectionStringBuilder

    ODBCConnectionStringBuilder

    OracleConnectionStringBuilder

    SqlCeConnection



  • sennekeennes

    Ohh, that's great, i actually made a "test app" to see how Clickonce works, and is just what i was looking for, now i only need to add code for saving new records on tables, update and all that.

    Thank you


  • ahmedilyas

    Yes. The whole idea of SQL Server Express is that you can distribute it like an Access Database, but with the added benefit of being a SQL Server Database.



  • starbukk

    so, if i deploy my app with my databases working, using ClickOnce for SQL Express, it's gonna keep working fine on the location (let's say another PC) i deployed it even if that location doesn't have SQL installed

  • someguy65

    A set of ready connection strings can be found on www.connectionstrings.com

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Fahd

    Thank you for your posts, they are really helpful to me , by the way, another question just came to my mind, the thing is my app connects to a sql server in my computer, so i can manage some databases and stuff like that, but my pc it's not gonna be the one that uses it, i need my app to run in another pc, but i don't know whats gonna happen because on the login i connect to my local server, from where i manage my databases,logins,triggers,etc.... does the other computer needs the sql client , should i need to create the same databases that i'm working with in that PC it's there a way just to add the mdf file to my app folder like the MOffice Access databases (i guess not, but i'm not sure)

    Or any tips about it

    Thank you


  • James. L.

    You could use SQL Server Express to host your DB and then distribute it with your application.

     

    Have a read of http://msdn.microsoft.com/vstudio/express/sql/



  • SQL connectionstring parameters
Answer this question