Re: Suggestion for DB Connection

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


.

Relevant Pages

  • ODBC setup
    ... I'm trying to setup linked tables through ODBC connection to an Oracle ... I checked my tnsnames entry and used the correct server name, ... tnsnames entry for that particular database, but it is in the format: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Mail merge process is printing out extra records
    ... FWIW I can easily replicate this problem here with some simple test data. ... when it connects to a Jet database by specifying properties in a .odc (or ... is to use an ODBC connection instead of an OLEDB one (check Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Passing parameter to a select query
    ... ' need to wait while the first query refreshes ... it works fine for external linking of the database within Access. ... you have an ODBC connection for your database? ...
    (microsoft.public.excel.programming)
  • Re: creating replication and not using default database name
    ... the datawh and has the db name in the ODBC connection. ... that when I've started replication before. ... > of the subscriber database name is. ... I am going to break and recreate replication to our datawarehouse. ...
    (microsoft.public.sqlserver.replication)
  • Re: Insert database problem
    ... In my experience, the Database field works fine as long as you ... Assuming all machines have the required Oracle ODBC driver installed, ... be able to force the ODBC connection by going directly over MS Query (from the ...
    (microsoft.public.word.tables)
Quantcast