| Author |
Topic |
|
Dayvson
Starting Member
14 Posts |
 Posted - 2002-12-09 : 16:01:48
|
| Hello people, I would like to link an access database to a Sql Server using a StoredProcedure ( " sp_addlinkedserver " ), But , for some reasons that I don`t know what...I am not getting it! I would like someone could help me, `cos I need it urgently!Note: The Access database it protected by a password ( just to protect the database ). |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-09 : 16:28:20
|
| Try this.EXEC sp_addlinkedserver 'AccessSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\MyDatabase.mdb', 'Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\MyDatabase.mdb;Jet OLEDB:System database=c:\MyMDW.mdw;User Id=Me;Password=MyPWD;', 'Jet 4.0' |
 |
|
|
Dayvson
Starting Member
14 Posts |
Posted - 2002-12-10 : 08:03:01
|
| Dear ValterBorges, I think U very much for your efforts, but it didn`t work out...It`s appear a message of authentication failure.I would like you could explain me every parameters individually...I had executing this at the "Query Analyzer", but when I try to access the "Access DataBase", It`s appear a message of error. Well, I don`t know what I should do to solve it...I hope someone may help me... |
|
|
|
Dayvson
Starting Member
14 Posts |
Posted - 2002-12-10 : 08:09:42
|
| I don`t want be boring...but, it`s only because I am driving crazy about it...But, I`d like someone could explain me about it too: >> 'Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\MyDatabase.mdb;Jet OLEDB:System database=c:\MyMDW.mdw;User Id=Me;Password=MyPWD;', << Mainly, the "System database" |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-12-10 : 08:37:08
|
| If you're new to MSSQL try to do such tasks in Enterprise Manager. It's easier and it doesn't require an in depth knowledge of T-SQL. |
|
|
|
Dayvson
Starting Member
14 Posts |
Posted - 2002-12-10 : 09:12:08
|
| Rihardh, It`s not my real problem...Because, when I try to access the "database Access's tables", I do it at the Enterprise Manager...I know it`s easier friend. I like work at the Query Analyzer. I can`t see any problems about it! |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-10 : 09:38:32
|
| EXEC sp_addlinkedserver 'AccessSource', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:\MyDatabase.mdb', 'Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\MyDatabase.mdb;Jet OLEDB:System database=c:\MyMDW.mdw;User Id=Me;Password=MyPWD;', 'Jet 4.0' sp_addlinkedserver [ @server = ] 'server' [ , [ @srvproduct = ] 'product_name' ] [ , [ @provider = ] 'provider_name' ] [ , [ @datasrc = ] 'data_source' ] [ , [ @location = ] 'location' ] [ , [ @provstr = ] 'provider_string' ] [ , [ @catalog = ] 'catalog' ] Check out BOL for indepth discussion.As far as 'Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\MyDatabase.mdb;Jet OLEDB:System database=c:\MyMDW.mdw;User Id=Me;Password=MyPWD;', That's a provider string or connection string.Provider is the driver,Persist Security Info see belowhttp://support.microsoft.com/default.aspx?scid=KB;en-us;193135&Data Source is your access databaseSystem database is you mdw access group security file if you have one.User Id and password is to grant access to the group or database.This might also helphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_6a44.aspEdited by - ValterBorges on 12/10/2002 09:39:41 |
|
|
|
Dayvson
Starting Member
14 Posts |
Posted - 2002-12-12 : 13:31:25
|
| Thanks All!!! I am going still trying it... anything else, I back here! Cya! |
|
|
|
|
Linked Servers