Computing.Net > Forums > Programming > ODBC Connection

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

ODBC Connection

Reply to Message Icon

Name: Praveen Mittal (by call_sonu2002)
Date: September 11, 2007 at 04:20:06 Pacific
OS: Win 2003
CPU/Ram: 256 MB
Product: HP Brio
Comment:

Friend

I have a application, which displays the ODBC connection created in Windows and I check whether the Connection is valid or not.

The Same-way, if i provide a UNIX BOX machine to the application, It should display the ODBC Configured in the UNIX Box. Is it possible.

Can a Windows based application can access the list of ODBC Connections created on UNIX BOX.

Please provide with your valuable answers.
Regards

Praveen



Sponsored Link
Ads by Google

Response Number 1
Name: OrionCA
Date: September 12, 2007 at 11:24:31 Pacific
Reply:

Not exactly. ODBC is a stand-alone "bridge program" between two different system, which can have different O/Ss, hardware, database engines, etc. It's the proverbial "Brunette between two Blondes" translator. You write a command in some language (Access, SQL, Paradox, etc.) on your machine, your ODBC driver wraps this in a packet and sends it to the ODBC connection on the other box, that ODBC sends the command on to the O/S, which processes it and returns a result. The result is sent by the ODBC connection to your machine and received by the ODBC driver, which translates it into something your application can understand.

If you set up an ODBC connection on a UNIX box any machine with a compatible ODBC driver that can network with the UNIX box can talk to the ODBC connection if it has its network address. It can't really "detect" the ODBC connection except by running through the entire list of available network addresses and testing each one of these in sequence. If you have 4-5 ODBC connections set up on your UNIX box each has to have its own unique address and there's no way for a remote computer to "find" all of these except by being told or somehow scanning all available addresses for them.


0
Reply to Message Icon

Related Posts

See More


How to lock folder. how to control access to ...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: ODBC Connection

ODBC connection www.computing.net/answers/programming/odbc-connection/13636.html

How to use the ODBC connect in the VB6 ? www.computing.net/answers/programming/how-to-use-the-odbc-connect-in-the-vb6-/2483.html

c++ Informix ODBC connection www.computing.net/answers/programming/c-informix-odbc-connection/5654.html