after i done the replication from sql server 7.0(pub/dist) with sql server
2000(subscription) there will promt out the error like below :
Agents Last Action
Snapshot No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
Log Reader No such interface supported.NOTE:The step was retried
the
requested number of times(10)without succeeding.
The step failed.
202.168.xx:XXXXX No such interface supported.NOTE:The step was retried the
requested number of times(10)without succeeding.
The step failed.
ALL ERROR!!!!!
Please help...
thanks a lot
Sam,
are you doing merge replication by any chance - this configuration is not
supported.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It sounds like your com components did not get registered. Did you apply an
sp recently? If so you should reapply it.
If not, is this relevant?
http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/6252b9649b296145
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sam@.discussions.microsoft.com> wrote in message
news:F09CBB95-050E-4704-AEB0-4C8B0AE77809@.microsoft.com...
> after i done the replication from sql server 7.0(pub/dist) with sql server
> 2000(subscription) there will promt out the error like below :
> Agents Last Action
> Snapshot No such interface supported.NOTE:The step was
> retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> Log Reader No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> 202.168.xx:XXXXX No such interface supported.NOTE:The step was retried
> the
> requested number of times(10)without succeeding.
> The step failed.
> ALL ERROR!!!!!
> Please help...
> thanks a lot
>
|||I doing transactional replication.
Thanks for your replied.
"Paul Ibison" wrote:
> Sam,
> are you doing merge replication by any chance - this configuration is not
> supported.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||OK - please see if this applies:
[url]http://groups.google.co.uk/group/microsoft.public.sqlserver.replication/browse_thread/thread/bdd1dfac50797c18/190e2af45971b1cb?lnk=st&q=No+such+interface+suppor ted+sql+server+replication&rnum=1&hl=en#190e2af459 71b1cb[/url]
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Showing posts with label urgent. Show all posts
Showing posts with label urgent. Show all posts
Monday, March 12, 2012
Friday, March 9, 2012
HELP - urgent situation
Hey all
I've got a DTS package with a script that does this:
Set xlApp = CreateObject("Excel.Application")
This fails though. Do I have to install MS Office on the machine the SQL Server is on? Or can I simply copy a few DLLs over and register them??
Thanks! I gotta get this solved within 5 hrs :(I am by no means an expert on this particular situation, but I would think that your 'best' (meaning most likely to work the first time) solution would be to install MS Office (just the Excel portion of it) on the server.
Regards,
hmscott|||Our in-house IT guy won't install Excel/Office on the server that our SQL Server is on.. something about opening up for potential problems and/or security issues.
It seems to me that if you CreateObject("Excel.Application"), that there's some kind of ActiveX .dll that could be registered on the server to allow the creation of these Excel COM objects. Anyone know which files they are??|||Where is the Package called from?
If client side app I would suggest installing Excel would work,
If a VB app adding the Excel distributables in the compile should work.
Create a reference to the Excel Object in your VB app.
mine is at
C:\Program Files\Microsoft Office 2000\Office\EXCEL9.OLB
When installed the required registry entries should follow.
Good Luck|||It's an ActiveX script within a DTS package on the server. I'd LIKE to have Office installed, but IT won't allow it.
Is there some way I could place the EXCEL9.OLB file on the server, and reference it somehow in my VBScript??|||All DTS Packages are run on the client unless scheduled by SQL Server regardless of where the code resides.
Your users will need Excel on their PC to use the output anyway, as well as DTS dlls (read SQL Server Client).
Is XML an option? or a structured text file which they can import into Excel. If so you could use the fileScripting object in Active script.|||Well.. actually this is a web page executing the DTS package.. so all the proper DTS dlls are installed on the web server now. And the DTS package has an ActiveX script that tries to create an instance of Excel.Application..but can't do so because Office is not installed on the web server (and will never be).
Nope.. XML is not an option. They gave us an Excel workbook they want populated.. there's no room to budge on this, unfortunately.|||If all you are doing is a data migration into a template try to map to the Excel spreadheet and se a dtsDataPump|||What if you pumped the data to a Comma Separated Value file (.csv), and let Excel convert it from wherever the client happens to open it from?|||OK here's the solution we went with.. MS Office Web Components.
Problem is, I can't find any thorough documentation on it. I want to know if it's possible to open an Excel file with it.
Set objOWC = CreateObject("OWC10.Spreadsheet")
That's how it's created. I have a few examples that tell you how to create a new Excel file from scratch and save it. But not how to open an existing one, modify it, then save to a new file.
Does anyone know, or can point me to some documentation? Thanks!
I've got a DTS package with a script that does this:
Set xlApp = CreateObject("Excel.Application")
This fails though. Do I have to install MS Office on the machine the SQL Server is on? Or can I simply copy a few DLLs over and register them??
Thanks! I gotta get this solved within 5 hrs :(I am by no means an expert on this particular situation, but I would think that your 'best' (meaning most likely to work the first time) solution would be to install MS Office (just the Excel portion of it) on the server.
Regards,
hmscott|||Our in-house IT guy won't install Excel/Office on the server that our SQL Server is on.. something about opening up for potential problems and/or security issues.
It seems to me that if you CreateObject("Excel.Application"), that there's some kind of ActiveX .dll that could be registered on the server to allow the creation of these Excel COM objects. Anyone know which files they are??|||Where is the Package called from?
If client side app I would suggest installing Excel would work,
If a VB app adding the Excel distributables in the compile should work.
Create a reference to the Excel Object in your VB app.
mine is at
C:\Program Files\Microsoft Office 2000\Office\EXCEL9.OLB
When installed the required registry entries should follow.
Good Luck|||It's an ActiveX script within a DTS package on the server. I'd LIKE to have Office installed, but IT won't allow it.
Is there some way I could place the EXCEL9.OLB file on the server, and reference it somehow in my VBScript??|||All DTS Packages are run on the client unless scheduled by SQL Server regardless of where the code resides.
Your users will need Excel on their PC to use the output anyway, as well as DTS dlls (read SQL Server Client).
Is XML an option? or a structured text file which they can import into Excel. If so you could use the fileScripting object in Active script.|||Well.. actually this is a web page executing the DTS package.. so all the proper DTS dlls are installed on the web server now. And the DTS package has an ActiveX script that tries to create an instance of Excel.Application..but can't do so because Office is not installed on the web server (and will never be).
Nope.. XML is not an option. They gave us an Excel workbook they want populated.. there's no room to budge on this, unfortunately.|||If all you are doing is a data migration into a template try to map to the Excel spreadheet and se a dtsDataPump|||What if you pumped the data to a Comma Separated Value file (.csv), and let Excel convert it from wherever the client happens to open it from?|||OK here's the solution we went with.. MS Office Web Components.
Problem is, I can't find any thorough documentation on it. I want to know if it's possible to open an Excel file with it.
Set objOWC = CreateObject("OWC10.Spreadsheet")
That's how it's created. I have a few examples that tell you how to create a new Excel file from scratch and save it. But not how to open an existing one, modify it, then save to a new file.
Does anyone know, or can point me to some documentation? Thanks!
Monday, February 27, 2012
HELP-- execution dts in transaction -- URGENT
please I need to know what is required to properly execute a dts with steps joined to transactions in it.
i know MSDTC must be running on server but it must be running in local machine too?
user running dts must be sysadmin? is it required ?
any other requirements needed?
please write down a full list of required items or a BOL reference to look forMaybe if you tell us what you're trying to do?|||what i want is to know what are the requirements to execute a dts with steps joined to transactions in it. I talk about requirements related to services, user privileges and so on
I want to know this info that applied for a general problem (that is how to execute a transactional dts).
Anyway i will tell you what is my specific problem related to it. I have a DTS who loops over files in a directory processing each file (that is inserting rows in several tables of a sql server database) in a way that all files must be processed or if one is not processed due to an error (logged to a log table) then all previous files must be deprocessed (changes made to database must be 'rollback'ed). Thus transacctions are needed into the DTS for some steps (those who change database) while others mustn't (those who perform tests and just write to log table)
This is so easy to do in a DTS but i have experienced several problems due to transacctions. first, with MSDTC service running in server machine (where SQLServer is running) I cannot execute successfully the dts unless MSDTC also running in my local machine. Also is not possible for my user to execute DTS from dts editor unless my user being sysadmin in SQLServer server machine. So i want to know what is exactly necessary to execute such kind of DTS (transactional DTS) in terms of services, security, user profiles and roles, etc
i know MSDTC must be running on server but it must be running in local machine too?
user running dts must be sysadmin? is it required ?
any other requirements needed?
please write down a full list of required items or a BOL reference to look forMaybe if you tell us what you're trying to do?|||what i want is to know what are the requirements to execute a dts with steps joined to transactions in it. I talk about requirements related to services, user privileges and so on
I want to know this info that applied for a general problem (that is how to execute a transactional dts).
Anyway i will tell you what is my specific problem related to it. I have a DTS who loops over files in a directory processing each file (that is inserting rows in several tables of a sql server database) in a way that all files must be processed or if one is not processed due to an error (logged to a log table) then all previous files must be deprocessed (changes made to database must be 'rollback'ed). Thus transacctions are needed into the DTS for some steps (those who change database) while others mustn't (those who perform tests and just write to log table)
This is so easy to do in a DTS but i have experienced several problems due to transacctions. first, with MSDTC service running in server machine (where SQLServer is running) I cannot execute successfully the dts unless MSDTC also running in my local machine. Also is not possible for my user to execute DTS from dts editor unless my user being sysadmin in SQLServer server machine. So i want to know what is exactly necessary to execute such kind of DTS (transactional DTS) in terms of services, security, user profiles and roles, etc
Subscribe to:
Posts (Atom)