OPENROWSET error / OLE DB Provider error 1

[flaniganmj]

Howdy,

How do I find out what OLE DB provider I have in Access? I am trying to use the OPENROWSET function on a very small table in Access 2002. Looks like this:
************************
SELECT
tst.*

FROM
OPENROWSET
(
'Microsoft.Jet.OLEDB.4.0',
'\\path\path\stores.mdb';'un';'pw',
'SELECT store_number
FROM store;'
) tst

************************

Getting errors-
7312: Unspecified
7399: OLE Provider 'Microsoft.Jet.OLEDB.4.0' reported an error

Any help would be greatly appriciated.

Thanks,

flan

 

[cmmrfrds]

On the Server test your OLE-DB connection with the udl wizard.

Here is how you invoke the udl wizard. Do this on the server desktop.

1. create a blank notepad file.
2. save the file.
3. rename the file by adding a new extention of .udl
make sure you save as all files not txt or some other
file type.
4. the icon for the file should change from notepad to a
little computer - it has now become the wizard.
5. double click on the file and it will bring up a dialog
box with multiple tabs.
6. use the microsoft Access provider – this will be Jet 4.0 for Access 2000 or Jet 3.51 for Access 97.
7. look under the ALL tab and there will be parameter settings which you can change if necessary. There is a test button, press to test the connection.
8. close the file.
9. open the file from notepad instead of double clicking the icon. You will see the connection string which you can copy and paste into your program.

 

[flaniganmj]

Thank you!