Viewing 15 posts - 1 through 15 (of 50 total)
Thanks Koen, that makes a lot of sense -
After posting this yesterday, we were able to revert to a similar Sybase driver version 12.5 (someone was sure that we...
January 9, 2013 at 5:02 am
opc.three (1/8/2013)
Relevant?
Saw that article - talks about the same kind of problem and solution we used but still does not explain why making the buffer...
January 9, 2013 at 4:54 am
Here is the generated script I used.
Take a look at it and replace the server, db names - login etc... accordingly.
It only has 1 table involved in the replication but...
September 21, 2012 at 6:08 am
The central Server can pull the data out of the subscriber. As long it uses an account with the proper permissions, everything will merge.
I don`t have access to the script...
September 19, 2012 at 8:39 am
You have many ways:
Initiallly, you can run the Import Data wizard in SQL which will build and run an SSIS package to import the Access data into SQL, in the...
September 19, 2012 at 7:45 am
You can still download SQL Express 2008, you don`t have to use 2012 version.
Of course, SQL Express would be one more thing running on the PC but it is not...
September 19, 2012 at 7:06 am
You can definitely use Merge Replication if you have SQL Express on your local touch station replicate data back to the central DB. I`ve done it in the past for...
September 19, 2012 at 5:31 am
How about just keeping the front-end part of the Foxpro application and have all the data in SQL Server? Lose the Foxpro database part? This would require pointing the Foxpro...
September 7, 2012 at 8:50 am
Looks like you invested lots of time in writing up this great script.
Thanks for sharing it...
:satisfied:
July 20, 2011 at 3:42 pm
da-zero (11/16/2010)
Do the following roles have execute permission on that stored procedure:db_ssisadmin, db_ssisoperator, db_ssisltduser
I assumed they did, since it out-of-the-box roles, but it is a good practive to check. Thanks.
And...
November 16, 2010 at 11:51 am
The only update I applied from the download was the NativeClient.
I was then able to import the dtsx successfully.
I am sceptical that it solved the issue...maybe it is just a...
November 12, 2010 at 4:48 pm
I am currently downloading the Cumulative Update 3 and will apply it on my test server.
Let you know how it goes...
November 12, 2010 at 12:58 pm
Some more info...
Was able to replicate error on another server; Here is what I found out as permissions needed.
As indicated in BOL, the windows account used as the Snapshot Agent...
November 17, 2009 at 6:46 pm
I was able to make it work when setting the Snapshot Agent running under the SQL Server Agent account (right now, Local System).
We'll keep it like this for now, will...
November 17, 2009 at 7:45 am
The security context is using the Windows account indicated in the error message.
sa account is enabled
November 17, 2009 at 5:24 am
Viewing 15 posts - 1 through 15 (of 50 total)