dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 11 of 11

Thread: how can vb6 share mssql database on a network

  1. #1
    Join Date
    Nov 2011
    Posts
    6

    how can vb6 share mssql database on a network

    i want to know how can i share my mssql database on network, i have to create a program that can access database through a network

  2. #2
    Join Date
    Jun 2005
    Location
    JHB South Africa
    Posts
    3,772

    Re: how can vb6 share mssql database on a network

    Sure you can ...

    It's easy ...

    Use the correct connection string...

    Data Source=Server/instance;Initial Catalog=dbname;user id=user;password=password;connection timeout=180
    Articles VB6 : Break the 2G limit - Animation 1, 2 VB.NET : 2005/8 : Moving Images , Animation 1 , 2 , 3 , User Controls
    WPF Articles : 3D Animation 1 , 2 , 3
    Code snips: VB6 Hex Edit, IP Chat, Copy Prot., Crop, Zoom : .NET IP Chat (V4), Adv. ContextMenus, click Hotspot, Scroll Controls
    Find me in ASP.NET., VB6., VB.NET , Writing Articles, My Genealogy, Forum
    All VS.NET: posts refer to VS.NET 2008 (Pro) unless otherwise stated.

  3. #3
    Join Date
    Nov 2011
    Posts
    6

    Re: how can vb6 share mssql database on a network

    how can i access the mssql server from 1 computer to another computer in vb6?

  4. #4
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,321

    Re: how can vb6 share mssql database on a network

    As stated in post #2 use the correct connection string [assuming of course the pcs are networked together]
    Always use [code][/code] tags when posting code.

  5. #5
    Join Date
    Nov 2011
    Posts
    6

    Re: how can vb6 share mssql database on a network

    i will just make a network between the pcs and the code will work? is there anything else to configure or setup? thanks for the help

  6. #6
    Join Date
    Nov 2011
    Posts
    6

    Re: how can vb6 share mssql database on a network

    pleaseee!!!!!! help me my time is running out please im begging all of you please help me

  7. #7
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,321

    Re: how can vb6 share mssql database on a network

    You must use a connection string,
    http://www.connectionstrings.com/
    Always use [code][/code] tags when posting code.

  8. #8
    Join Date
    Nov 2011
    Posts
    6

    Re: how can vb6 share mssql database on a network

    there to many connection string what connection string will i use? please help and thank you

  9. #9
    Join Date
    Nov 2011
    Posts
    6

    Re: how can vb6 share mssql database on a network

    please help me

  10. #10
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,321

    Re: how can vb6 share mssql database on a network

    You need to use the right one, different databases use different strings, sometimes there are several that will work with a given database depending on what you need to do. First look up the database you are using then look at the connection strings for that database then try one making sure to put your server info and any required userid and password info in. Test and see if it works and if not then try another.

    We do not have enough info to create the string for you and this is something you should do yourself so you will know how to do it in the future. The link I posted before should have all the info you need.
    Always use [code][/code] tags when posting code.

  11. #11
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: how can vb6 share mssql database on a network

    Not to mention that NOBODY should know the credentials to any DB from a forum
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)