
Using VB to connect to DB without using ODBC
OLE DB is the wave of the future, but it solves nothing for the issues you
seem to be trying to deal with (i.e., not having to do an install on each
client.
ADO together with IE is probably your best answer given the criteria you've
listed. ADO still requires ODBC, but you build a middle teir by using ASP
and escape 95% of it. Basically, most everything would be server side. If
you really still wanted to put some of the horse power at the client, you
could add in the RDS, which would give you fairly robust record handling at
the client end - amount other things, you can download a recordset, save it
to disk, mess around with it, and upload changes (handling update collisions
of course).
If you want more information on this, I'd suggest searching the MS site
looking for ADO, RDS, and "ADO Disconnected Recordsets".
Rob
Quote:
>Hi, I am looking for information on the best way to use VB to connect to
>Oracle and AS400 databases without putting an ODBC connection on every
>desktop. The company I work for has many sites worldwide and every PC is
>connected to the company Intranet. I would therefor like to use a TCP/IP
>connection to a middle tier, which would solve a lot of support problems.
>I have looked at OLE DB/ADO but am unsure if this solves the problem.
>Should I consider MTS and Cobra?. Should I write a server app to run on the
>database server myself. The amount of data is not vast. Any suggestions?
>Regards, Alistair Sincalair
>Team Leader