Re: Using ODBC

Beebs <ABieberitz_at_2tacweb.com> schreef in berichtnieuws vfp33le45cr65c_at_corp.supernews.com...
| Peter,
|
| Thanks for the help, but it was actually an error on my part. This whole
| time I had been using the Oracle Names Server I had set up, rather than
the
| Service Name of the database itself. Once I checked this in SQL Plus and
| verified I could connect up, I linked to a table in another application
and
| it worked without any errors.
|
| My next question is what do I need to distribute with my application so my
| user's can access this data without it residing on a server, or is that
| impossible. If so, and they need it on a server, what drivers and dlls,
| etc...need to be on each client's computer?
|
| Thanks,
| Aaron
|
| > Start by running the following command on the same box:
| > sqlplus system/manager_at_your_service_name
|

If you want to use ODBC on a client PC to connect to a database on another host, you must install Oracle Net on each client. Further you need to configure Net. In your current solution you included a service definition in a local tnsnames.ora file, defining where to find the database ("go to host X using protocol TCP/IP on port N and request there a connection to db with sid S (or service name T)").
You can keep doing this but depending on the number of clients it can be difficult to maintain this file it the database moves. A Oracle Names Server can be easier, but again, you need to modify sqlnet.ora on each host when host/port of the ONS changes. Best solution could be to have a special hostname "ons.yourdomain" or so defined in DNS and change the DNS entry if it should move. The ONS could run on the same host as the db.
On the databaser server a listener must be configured and started that listens for connection requests for the database. Received on Fri Jun 27 2003 - 14:39:52 CDT