Thanks
With my statement
SELECT * FROM OPENDATASOURCE ('Microsoft.jet.OLEDB.4.0',
'Data Source=h:\Shopinfo\shopdetail.mdb')...ShopDetail WHERE SHOP_PFCNTR =
$Shop Number$
The error I get is the following
ARERR [552] Failure during SQL operation to the database : ORA-00933: SQL
command not properly ended
The MDB does not have a passowrd. I think I'm missing a quote somewhere.
A question I had is, do I need to setup a System Data source on the server
to this Microsoft access db or can that be done on the client?
"Ashton, Jim (JUS)" <[email protected]>
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
04/17/2009 10:34 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: SQL statement
**
The following works for SQL Server in a similar situation. Not sure what
the corollary to "OPENDATASOURCE" is for Oracle.
SELECT X.* FROM OPENDATASOURCE('Microsoft.jet.OLEDB.4.0',
'Data Source=\\usranfb\transfer\Shopinfo\shopdetail.mdb;
Jet OLEDB:Database Password=<password>;')...<table name> X
WHERE SHOP_PFCNTR = $Shop number$
<password> is an optional database level password - if there is no
database password on the .mdb file I think you can omit the entire "Jet
OLEDB:Database Password=<password>;" phrase.
<table name> is the name of the table containing the SHOP_PFCNTR field in
your Access database.
Hope this helps,
Jim.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_
*************************************************************
This e-mail message, including any attachments, is for the sole use of the
addressee(s) to whom it has been sent, and may contain information that is
confidential or legally protected. If you are not the intended recipient or
have received this message in error, you are not authorized to copy,
distribute, or otherwise use this message or its attachments. Please notify
the sender immediately by return e-mail and permanently delete this message and
any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is
error or virus free.
