CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    390

    How to connect to SQL Server data without using SQL Server Management Studio in C# ?

    ask: is it possible to connect SQL Server data according to file connection type, just like in microsoft access data connection
    public static string sConnectionString = @ "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + @ "| DataDirectory | \ data.mdb" + "; Persist Security Info = False; Jet OLEDB: Database Password = 123";

    How do you convert the above access connection into sql server connection ?

  2. #2
    VictorN's Avatar
    VictorN is online now Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,085

    Re: How to connect to SQL Server data without using SQL Server Management Studio in C

    Victor Nijegorodov

  3. #3
    VictorN's Avatar
    VictorN is online now Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,085

    Re: How to connect to SQL Server data without using SQL Server Management Studio in C

    Quote Originally Posted by Zikkarro View Post
    Did you solve it?
    If you asked me then yes. I did solve this "problem" many years ago wenn I began to use SQL Server.
    Victor Nijegorodov

  4. #4
    Join Date
    Jun 2021
    Posts
    10

    Thumbs up Re: How to connect to SQL Server data without using SQL Server Management Studio in C

    I have the same problem that you have, then I research and I find a solution to this website
    https://www.guru99.com/c-sharp-access-database.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured