ODBC - Complete Beginner
Neilo
I have absolutely no experience or knowledge of ODBC so could do with some
help and advice.
We have a linux server running some software that basically runs our
business. We are going to be investing in some new software for our Accounts
dept, which is designed to pull the data from our server and allows users to
compile all kinds of reports etc. Will be great when its working.
However, I need to organise the link between the two systems but dont have a
clue where to start. I know I have to install an ODBC driver onto the main
server, but thats it really. What else do I need to do for the new software
to work? Due to our current infrastructure I am unable to install this new
software onto the main server. Does ODBC comes as part of Server 2003? Or
can I get it up and running on a PC?
Your help would be appreciated, and no doubt raise more questions.
Thanks in advance.
Ralph
"Neilo" <Ne...@discussions.microsoft.com> wrote in message
news:C39A336A-F451-4726...@microsoft.com...
Not nearly enough information.
I assume the workstations are using Windows and you are programming in
Classic VB (VB6 or lower). If this is incorrect then you need to post to
another newsgroup.
ODBC is only one of several mechanisms for providing 'data connectivity'
between an Application and a data server. It works by providing an "ODBC
driver" which needs to be compatible with both the client data access
library and the database server.
We need to know what database server is running on the Linix box. For
example, if you are using Oracle then you can use Oracle client software,
other RDBMS have similar libraries available. There is 3rd party software
available. Or you may be able to use to ODBC drivers already installed (or
available separately) with the various Windows platforms.
-ralph