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

[john]

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

[David Satz]

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
>
>