October 18, 2004 at 10:31 am
Please help!!!
I need programmatically to load data from Access 2000 database to SQL server 2000 (populate tables in SQL Server).
I have user Admin with password ‘aaaa’ in Access.
I wanted to use linked server:
sp_addlinkedserver 'oct_18', 'Access 2000', 'Microsoft.Jet.OLEDB.4.0', 'c:\aaa\My.mdb'
sp_addlinkedsrvlogin 'oct_18', false, 'sa', 'Admin', 'aaaa'
After this I am getting error “OLEDB provider reported error. Authentication failed.”
The same error I am getting if I create the Linked Server manually with option
“be made using the security context: sa
password ”
How can I get it working programmatically?
What wrong with my statements? Should I use ‘sa’ as a local login?
If I go to Access and remove manually password then I can create linked server and load data. But I have to do it programmatically on user’s machines where Access has password.
October 19, 2004 at 12:24 am
Are you loading the data using Access or SQL
October 19, 2004 at 7:37 am
I am creating Linked server on SQL Server. I would like to load data from Access database to SQL server tables.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply