What I need to install to interact with remote Database??


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: What I need to install to interact with remote Database??

  1. #1
    john Guest

    What I need to install to interact with remote Database??



    Hi!

    I wonder if someone can tell me what I need to install on a client computer
    (that DOESN'T have any SQL server software installed) to be able to interact
    with a SQL database with SQL statements.

    I hope it's neccesary with installing SQL ODBC drivers, is this correct ??
    And, if that is all I need to install, how can I install the drivers. Do
    I get them only by installing MDAC 2.X ???

    What I in the end want to be able t do is to use a Visual Basic application
    on the client computer that interact with a remote SQL database via ODBC.

    Very greatful if someone could tell me what I need to install on the client
    machine

    ****PLEASE RESPOND TO THE GROUP ************

    Best Regards
    /John



  2. #2
    David Satz Guest

    Re: What I need to install to interact with remote Database??

    AFAIK - since I am no longer a VB guy - If you are going to use ODBC, then
    the client needs ODBC and MDAC. If you are going to use OLEDB, you can get
    away with only MDAC.
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions
    { SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------
    "john" <john7006@yahoo.com> wrote in message
    news:3c385e8b@147.208.176.211...
    >
    >
    > Hi!
    >
    > I wonder if someone can tell me what I need to install on a client

    computer
    > (that DOESN'T have any SQL server software installed) to be able to

    interact
    > with a SQL database with SQL statements.
    >
    > I hope it's neccesary with installing SQL ODBC drivers, is this correct ??
    > And, if that is all I need to install, how can I install the drivers. Do
    > I get them only by installing MDAC 2.X ???
    >
    > What I in the end want to be able t do is to use a Visual Basic

    application
    > on the client computer that interact with a remote SQL database via ODBC.
    >
    > Very greatful if someone could tell me what I need to install on the

    client
    > machine
    >
    > ****PLEASE RESPOND TO THE GROUP ************
    >
    > Best Regards
    > /John
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center