From: Mark A. Sam on
Hello,

I want to link Oracles tables to an Access DB but can't see them from a
workstation. I can see folders on the server but the Oracle tables on a D:\
Drive. I can only see them if I logon to the server or through Remote
Desktop. The Server is

\\ASams3

The Files are on D:\FamousDB\Database

I can login as Admin on the server. Is there a special syntax or does the
server need to be configured to allow this? I need to set up a DSN.

Thank you for you help and God Bless,

Mark A. Sam


From: Dave Patrick on
Links need to be established through oracle db engine running on server, not
a direct file sharing access. Talk to your oracle DB admin about setting up
a DSN


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Mark A. Sam" wrote:
> Hello,
>
> I want to link Oracles tables to an Access DB but can't see them from a
> workstation. I can see folders on the server but the Oracle tables on a
> D:\ Drive. I can only see them if I logon to the server or through Remote
> Desktop. The Server is
>
> \\ASams3
>
> The Files are on D:\FamousDB\Database
>
> I can login as Admin on the server. Is there a special syntax or does the
> server need to be configured to allow this? I need to set up a DSN.
>
> Thank you for you help and God Bless,
>
> Mark A. Sam
>

From: Mark A. Sam on
Thanks Dave. We don't have an Oracle Admin. Oracle came with the
accounting software which configured the Database. But you gave me the
direction I need.


"Dave Patrick" <DSPatrick(a)nospam.gmail.com> wrote in message
news:uSieuA2zKHA.3884(a)TK2MSFTNGP06.phx.gbl...
> Links need to be established through oracle db engine running on server,
> not a direct file sharing access. Talk to your oracle DB admin about
> setting up a DSN
>
>
> --
>
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
>
> "Mark A. Sam" wrote:
>> Hello,
>>
>> I want to link Oracles tables to an Access DB but can't see them from a
>> workstation. I can see folders on the server but the Oracle tables on a
>> D:\ Drive. I can only see them if I logon to the server or through
>> Remote Desktop. The Server is
>>
>> \\ASams3
>>
>> The Files are on D:\FamousDB\Database
>>
>> I can login as Admin on the server. Is there a special syntax or does
>> the server need to be configured to allow this? I need to set up a DSN.
>>
>> Thank you for you help and God Bless,
>>
>> Mark A. Sam
>>
>