function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dan HuranDan Huran 

forceAMP

just installed the 2.2 version of DBAmp, as the old one stopped working.
Got everything kind og working now - but sf_replicate returns null and leaves me with empty tables. Any ideas?
qmanqman
The SF_Replicate proc has changed with each version. When you upgrade, be sure to rerun the Create SF_Replicate proc using the latest version in the DBAmp program directory. Then fire up the DBAmp configuration pgm (from the Start menu) and make sure that the credentials are good. While you are checking the credentials, click the Test Connection button and make sure you have a good connection.

Finally, restart the SQL Server to flush out any dll's that may be cached.

Then try the SF_Replicate again.

Bill

Message Edited by qman on 11-14-2005 02:33 PM
Dan HuranDan Huran
FIX: Debuged SF_Replicate in SQl Server Query Analyzer.
The sp was shelling out to the command prompt to run the DBAmpReplicate.exe, but
failed to build the correct command parameter as the following returned null:

select @location = (select location from master.dbo.sysservers where srvname=@table_server)


I commented out :

--set @Command = @Command + ' "' + @location + '" '

on line 102 and it seems to be working again.

Strange.

Daniel
qmanqman
Thanks Daniel!

DBAmp'ers: if you make Dan's change it will work but kill the ability to use Test Instances.

I'll try to post a more comprehensive fix in the next release of DBAmp.

Thanks,

Bill