Results 1 to 2 of 2

Thread: How to connect to a db on a LAN?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2001
    Location
    shiraz
    Posts
    163

    Question How to connect to a db on a LAN?

    Hi guys
    It’s my first time developing db application working on a LAN. I‘ve been using DAO before for past projects but now I need to develop an application which works on the LAN so I moved to ADO.NET but I don’t know how to access the db’s on the server form my application BTW I would better not use SQLserver because I want the application to be independent of SQLserver installed on the server or not.
    The case is:
    There’s a Server (Win2000 server) and a Win XP computer connected to it, on which my application will run, accessing an access db on the server.
    Now what is the connectionString? Or should I do something else? Can OLEDB drivers on the server serve a client on the other computer or using SQLserver is necessary for this type of project?
    Thanks a lot

  2. #2
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Just use the network path where you would normally put the local path in the connection string.

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ServerName\PathToDB\DB.mdb"

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