Home > Archive > Visual Basic > January 2006 > Suggestion for DB Connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Suggestion for DB Connection
|
|
|
| Hi
I am using Visual Basic 6.0 and Oracle 8 as database for my project.
My project is going to be an Multiuser software. The database should be
accessible from other computers also. which is the best method to
connect to the database using Visual basic 6.0 is it ODBC connection or
is there any other method to connect to the central database.
Thanks in advance
| |
| Michael Cole 2006-01-27, 3:55 am |
| Joe wrote:
> Hi
>
>
> I am using Visual Basic 6.0 and Oracle 8 as database for my project.
> My project is going to be an Multiuser software. The database should
> be
>
> accessible from other computers also. which is the best method to
> connect to the database using Visual basic 6.0 is it ODBC connection
> or is there any other method to connect to the central database.
I would go with ODBC. Its reasonably widespread and stable, and it doesn't
limit your options nor does it require a great deal of work to get up and
running.
Note that the "C" in ODBC stands for "Connectivity", thus saying "ODBC
connection" is slightly redundant. Bit like saying "PIN Number", "ATM
Machine" or "EFT Transfer"
--
Regards,
Michael Cole
| |
|
|
"Michael Cole" <noone@hansen.com> wrote in message
news:uhRrJVwIGHA.3944@tk2msftngp13.phx.gbl...
> Joe wrote:
>
> I would go with ODBC. Its reasonably widespread and stable, and it
> doesn't
> limit your options nor does it require a great deal of work to get up and
> running.
>
I don't think I can agree with that recommendation. I would avoid ODBC at
most all costs. Why would ODBC be better than ADO and the OLEDB Provider for
Oracle?
--
Mike
Microsoft MVP Visual Basic
| |
| Michael Cole 2006-01-29, 3:55 am |
| MikeD wrote:
> "Michael Cole" <noone@hansen.com> wrote in message
> news:uhRrJVwIGHA.3944@tk2msftngp13.phx.gbl...
>
>
> I don't think I can agree with that recommendation. I would avoid
> ODBC at most all costs. Why would ODBC be better than ADO and the
> OLEDB Provider for Oracle?
Correct me here if I am wrong, but ADO isn't, strictly speaking, an
alternative to ODBC. OLEDB is; but ADO, like DAO, RDO whatever, is a set of
data objects, not a method of connection.
As for ODBC vs OLEDB, I really can't comment, as I've never really played
around with OLEDB that much.
--
Regards,
Michael Cole
|
|
|
|
|