Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error 8525. Distributed transaction completed. Either enlist this se
Hi I get this error (8525) when I try to commit a distributed transaction. The transaction is executed by a proc calling a remote proc through a linked server. Both servers run SQL 2k enterprise and are contained in the same cluster. I tried SQL server 2k sp3a as a solution but no luck. The...- PieterM
- Post #3
- Forum: Microsoft: COM+
-
Is it possible to insert multiple records with ONE insert?
Where do you get the data for the INSERT. If it is from another SQL database you can use a SELECT statements else create a DTS Package. I do recommend that you create a DTS package anyway and maybe schedule it to run when your server is not busy: eg. 24h00- PieterM
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Error "Server has not yet been opened"
EUREKA!! I changed my driver from "p2sodbc.dll" to "pdssql.dll" , installed SQL Client on the machines and copied ntwdblib.dll to the system32 folder.- PieterM
- Post #10
- Forum: Business Objects: Crystal Reports 3 Integrate
-
Error "Server has not yet been opened"
HELP!!!!!! I have tried numerous examples and even tried my own variation, but no luck. I keep on getting the same old tiring message: "Server has not yet been opened.' Here is some of my code: Dim rdApp As CRAXDRT.Application Dim rptSource As CRAXDRT.Report Dim crpParamDefs As...- PieterM
- Post #7
- Forum: Business Objects: Crystal Reports 3 Integrate
