Re: Using ODBC

On Fri, 27 Jun 2003 13:29:33 -0500, "Beebs" <ABieberitz_at_2tacweb.com> wrote:

>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
>

What data is it you want your users to access without it being on a server? The data that's in the database? Or the data necessay to make the connection to a database, regardless of where that database is?

If you don't wan't the data in the database to be on a server . . . well, I just hope I misunderstood your question, because if this *is* what you mean, then you obviously have to have Oracle server and a copy of the database on each user's PC. Surely this isn't what you mean??????

If,by " access this data without it residing on a server" you mean the data necessary to connect to a database (which presumably *is* on a server!). . you have to install the Oracle client and configure the client's tnsnames file and (since you're using ODBC) the odbc dsn. Received on Fri Jun 27 2003 - 15:07:31 CDT