DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: ** How to do direct connection to server

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    ** How to do direct connection to server

    [Originally posted by Happy Cat]

    I have database in server. I dunno the provider name of the database. it's not SQL or DB2, it's called OpenIngres.

    Does anyone have any other suggestion for me to do direct connection to this database. Or any tips that may help?

    I can use ODBC to connect, but i have to use direct connection rather than ODBC.

    Please give me, any related information, any possible solutions...any.....


    Thank you very much.

    my email : LShannen@yahoo.com

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:** How to do direct connection to server

    [Originally posted by Andon K.]

    In VB, there are no hundred ways to connect to a database. If you don't have the right OLE DB provider for the database, your have three other options:

    1. Attaching the database to an Access database (not applicable in your case).

    2. Using the ODBC OLE DB provider (which you can't or don't want).

    3. Using a custom database engine that is compatible with VB and your database (which is probably not applicable in your case).

    I don't see any other possibility.


  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:** How to do direct connection to server

    [Originally posted by Happy Cat]

    Then, do you know how or where to get the OLE DB name for this OpenIngres Database??

    Any way to search for it??? This database is on Unix environment, and NT also.


    Thank you..

  4. #4
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Re:** How to do direct connection to server

    [Originally posted by Andon K.]

    You should check with the vendor of the your database if they have a custom OLE DB provider available. If they don't, your only alternative is the ODBC OLE DB provider which is sort of a "universal" provider. I am sure that Ingres supports ODBC connections as most "normal" database engines do.

    Your VB aplications will work, maybe a bit slower, and probably you won't have access to some of the advanced features of your database that the ODBC standard doesn't support. That's the price of universality ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center