Re: Suggestion for DB Connection

MikeD wrote:
> "Michael Cole" <noone@xxxxxxxxxx> wrote in message
> news:uhRrJVwIGHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
>> 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.
>>
>
>
> 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


.

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... ODBC was superseded thirteen years ago by OleDb: ... In this particular case, my program will conect to an Oracle database, but ... There does not seem to be a .NET provider for MS Access, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Set up an ODBC connection Programmatically?
    ... the correct DSNless connection string for Oracle? ... Doug Steele, Microsoft Access MVP ... Other people can use this database, ... they have their system ODBC drive set up exactly as mine was when I ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO connection with VBS to locally stored MS-Access database
    ... Even using of the OLEDB Jet provider is better, I do not see any confusion ... You could use ODBC or OLEDB syntax but in this case ADO will using ... > I am trying to connect to a local Access database via ADO and VB Script. ...
    (microsoft.public.data.ado)
  • Re: Please Reply . Its Urgent.
    ... But i'm still not able to connect to Oracle Database either through ODBC ... Oracle in Ora9i and testing the connection) as follows:(recent error ...
    (microsoft.public.vb.database.ado)
  • Re: Problem with numeric blank fields
    ... Oracle 8i and ASA 8.03. ... I checked the ODBC log to find out what ODBC types they were bound to. ... which type of database? ... thing I can think off is to modify the SQL directly in MS Query (i.e. ...
    (microsoft.public.word.mailmerge.fields)
Loading