| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2005-02-01 : 02:17:28
|
| hi,i am working on replication from access to SQL server and reffering the article.http://www.sqlteam.com/item.asp?ItemID=14443When i try to add publication getting following error message.Server: Msg 14013, Level 16, State 1, Procedure sp_addpublication, Line 143This database is not enabled for publication.i have only one table in access with three fields. can u guide me why i m getting this error message and what's wrong with it.thanks in advance. |
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 02:35:29
|
| The article that u are reffering to creates a publication in sql server which would be copied to access.So could u please write in detail what u wanna do here..To enable ur sql server for publication and avoid this error just select your sql server name under "sql server group" category from enterprise manager ... go to tools menu ... third option there is replication...in replication select configure publishing , subscribers, distributors...a interactive wizard will come up which will guide you to enable ur server for publication and distribution .RegardsRishi |
 |
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 02:57:35
|
| Hey...imughaldid it worked for u or not??? |
|
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 02:57:40
|
| Hey...imughaldid it worked for u or not??? |
|
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 02:57:46
|
| Hey...imughaldid it worked for u or not??? |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2005-02-01 : 03:52:13
|
| i m trying and will get back to in few minutes |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2005-02-01 : 04:00:28
|
| when i followed the instruction it is showing just three databse mydatabase, northwind and pub. i have to synchronize data from access database. My master databas eis access and slave is sql server.Replicate data from access into sql server.when i execute following sql getting error message.sp_addpublication @publication = 'GPPatient', @sync_method = 'character', @repl_freq = 'snapshot', @status = 'active', @allow_push = 'true', @allow_pull = 'true', @allow_anonymous = 'false', @independent_agent = 'false', @immediate_sync = 'false', @allow_sync_tran = 'false', @autogen_sync_procs = 'false', @retention = 336, @allow_queued_tran = 'false', @snapshot_in_defaultfolder = 'true', @compress_snapshot = 'false', @allow_dts = 'false', @allow_subscription_copy = 'false', @add_to_active_directory = 'false'Server: Msg 14013, Level 16, State 1, Procedure sp_addpublication, Line 143This database is not enabled for publication.kidnly help me out |
|
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 04:43:50
|
| As I earlier told u this atricle is for publication through sql server to access.Not vice versa.Looking at ur requirement Link tables from Access to SQL Server is best option 4 u.Just go for help in Access for Linked Tables...its simple man...You cannot Publish from access to sql server as far as my knowledge goes. (Not sure but probably its not there) |
|
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-01 : 23:54:37
|
| One thing u can do out here is use merge replication over heterogeneous source i.e access in this case and configure push subscription to access from SQL Server itself. After doing this any changes made to ur access Database would be reflected to sql server and vice-versa.But for this initially u need to have all ur access Data imported to ur SQL server using DTS or BCP which further can be used as a publisher for access Database.RegardsRishi |
|
|
|
|
Add publication