Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a linked server to a .MDB file using JET 4.0

Status
Not open for further replies.
load3d

load3d

Programmer
Feb 27, 2008
117
US
Hello,
I'm trying to create a linked server to an unecrypted, no security Access database. I have tried many different variations. I keep getting an "Unspecified error" SQL ERROR: 7303 when trying to connect. Has anyone ever come across this?



EXEC sp_addlinkedserver
@server = 'MP2',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = '',
@datasrc = 'F:\MP2\MP2.MDB'
GO



EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'MP2',
@useself='False',


@rmtuser='admin',
@rmtpassword='password'
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
343
Swi
Swi
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
530
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
634
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
650
lameid
lameid
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
882
combo
combo

Part and Inventory Search

Sponsor

Back
Top