linked server to jet database

Hi,
I have a problem using an jet database as a linked server.
when there is no database password on the mdb database everything is working
fine.
When I put a password an the mdb database I receive the error:
Msg 7399, Level 16, State 1, Line 1The OLE DB provider "MSDASQL" for linked
server "ExpertM" reported an error. The provider did not give any informatio
n
about the error.Msg 7303, Level 16, State 1, Line 1Cannot initialize the dat
a
source object of OLE DB provider "MSDASQL" for linked server "ExpertM".
The database password is correct because when I enter a fault password I
receive the expected error that the password is incorrect.
Any idea?
Thanks
BartHello Bart,
I reproduce this issue.
My suggestion is that you could create a DSN for the access mdb database
and use the Microsoft OLEDB Provider for ODBC Drivers to link this DSN in
the SQL Server as a workaround.
Please let me know if this is OK for you.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.