Problem with Win XP Service Pack 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
I got a problem when I installed the SP2 for Win XP. I use Visual
Studio. net 2003 to develop a C# client and a using a SQL Server 2000 on the
server. Before the upgrade it worked fine and if I uninstall SP2 on the
client it will work fine. But with SP2, I got the following exception...

"System.ArgumentException: The parameter is incorrect.\r\n at
System.Data.Common.ITransactionExportFactory.Create(UInt32 DTCLength, Byte[]
DTCAddr, ITransactionExport& export)\r\n at
System.Data.SqlClient.Transaction.CreateTransactionExport(Byte[] dtcAddr,
UInt32 dtcLength, ITransaction transaction, ITransactionExport&
transactionExport)\r\n at
System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransaction(ITransaction
transaction)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()\r\n
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)\r\n at System.Data.SqlClient.SqlConnection.Open()\r\n at
Hind.Data.StoredProced
ure..ctor(String sStoredProcedure, SqlParameter[] objSqlParameters) in
C:\\Projekt\\Hind\\Source\\HindData\\StoredProcedure.cs:line 36" "The
parameter is incorrect."

....when I trying to run a stored procedure on the database server.

Is there anyone who had the same problem?? Any solutions??

Thanks!
Andreas
 
Andreas Fredriksson said:
Hi!
I got a problem when I installed the SP2 for Win XP. I use Visual
Studio. net 2003 to develop a C# client and a using a SQL Server 2000 on
the
server. Before the upgrade it worked fine and if I uninstall SP2 on the
client it will work fine. But with SP2, I got the following exception...

"System.ArgumentException: The parameter is incorrect.\r\n at
System.Data.Common.ITransactionExportFactory.Create(UInt32 DTCLength,
Byte[]
DTCAddr, ITransactionExport& export)\r\n at
System.Data.SqlClient.Transaction.CreateTransactionExport(Byte[] dtcAddr,
UInt32 dtcLength, ITransaction transaction, ITransactionExport&
transactionExport)\r\n at
System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransaction(ITransaction
transaction)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()\r\n
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)\r\n at System.Data.SqlClient.SqlConnection.Open()\r\n
at
Hind.Data.StoredProced
ure..ctor(String sStoredProcedure, SqlParameter[] objSqlParameters) in
C:\\Projekt\\Hind\\Source\\HindData\\StoredProcedure.cs:line 36" "The
parameter is incorrect."

...when I trying to run a stored procedure on the database server.

Is there anyone who had the same problem?? Any solutions??

Thanks!
Andreas
Click to expand...

Guess you have installed SP2 with the firewall enabled (default).

Check following to solve your issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;841249

Other "must read" for devs.

http://download.microsoft.com/download/6/8/a/68a81446-cd73-4a61-8665-8a67781ac4e8/WF_XPSP2.doc

http://support.microsoft.com/default.aspx?scid=fh;ln;xpsp2swhw

Willy.
 
Instal the SQL Client again. I had the same problem with
Oracle after loading XP SP2. The ODBC layer seems to get
messed up with SP2, but a quick install of the client
fixes it again.
-----Original Message-----
Hi!
I got a problem when I installed the SP2 for Win XP. I use Visual
Studio. net 2003 to develop a C# client and a using a SQL Server 2000 on the
server. Before the upgrade it worked fine and if I uninstall SP2 on the
client it will work fine. But with SP2, I got the following exception...

"System.ArgumentException: The parameter is incorrect.\r\n at
System.Data.Common.ITransactionExportFactory.Create (UInt32 DTCLength, Byte[]
DTCAddr, ITransactionExport& export)\r\n at
System.Data.SqlClient.Transaction.CreateTransactionExport (Byte[] dtcAddr,
UInt32 dtcLength, ITransaction transaction, ITransactionExport&
transactionExport)\r\n at
System.Data.SqlClient.Transaction.GetTransactionCookie (Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNull DistributedTransaction(ITransaction
transaction)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistrib utedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistrib utedTransaction()\r\n
at System.Data.SqlClient.SqlInternalConnection.Activate (Boolean
isInTransaction)\r\n at
Click to expand...
System.Data.SqlClient.SqlConnection.Open()\r\n at
Hind.Data.StoredProced
ure..ctor(String sStoredProcedure, SqlParameter[] objSqlParameters) in
C:\\Projekt\\Hind\\Source\\HindData\\StoredProcedure.cs:l ine 36" "The
parameter is incorrect."

....when I trying to run a stored procedure on the database server.

Is there anyone who had the same problem?? Any solutions??

Thanks!
Andreas
Click to expand...
 
Andreas,

I've just come across this problem today after installing SP2. Did you find
a solution?

Stuart.


Andreas Fredriksson said:
Thanks for all the help but it haven't solve the problem...yet...
(positive
thinking)

I tried to do the reinstall of SQL Client but nothing changed... I have
also
read thoose documents and made a lot of changes in the new firewall but it
still not woorking. I'm not sure that the firewall is the problem, I tried
to
turn off the firewall but the problem is still showing up.

Do anybody have any other ideas???

// Andreas

Andreas Fredriksson said:
Hi!
I got a problem when I installed the SP2 for Win XP. I use Visual
Studio. net 2003 to develop a C# client and a using a SQL Server 2000 on
the
server. Before the upgrade it worked fine and if I uninstall SP2 on the
client it will work fine. But with SP2, I got the following exception...

"System.ArgumentException: The parameter is incorrect.\r\n at
System.Data.Common.ITransactionExportFactory.Create(UInt32 DTCLength,
Byte[]
DTCAddr, ITransactionExport& export)\r\n at
System.Data.SqlClient.Transaction.CreateTransactionExport(Byte[] dtcAddr,
UInt32 dtcLength, ITransaction transaction, ITransactionExport&
transactionExport)\r\n at
System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransaction(ITransaction
transaction)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()\r\n
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)\r\n at System.Data.SqlClient.SqlConnection.Open()\r\n
at
Hind.Data.StoredProced
ure..ctor(String sStoredProcedure, SqlParameter[] objSqlParameters) in
C:\\Projekt\\Hind\\Source\\HindData\\StoredProcedure.cs:line 36" "The
parameter is incorrect."

...when I trying to run a stored procedure on the database server.

Is there anyone who had the same problem?? Any solutions??

Thanks!
Andreas
Click to expand...
Click to expand...
 
I'm sorry but I din't...:(

After a couple of days trying to find out what the problem could be, I
uninstalled SP2 and so I could work with more "important" stuff. I hope
somebody else who is smarter then me can solve the problem... :)

I will be very happy if you reply to me if you find a solution.

// Andreas

Stuart Whiteford said:
Andreas,

I've just come across this problem today after installing SP2. Did you find
a solution?

Stuart.


Andreas Fredriksson said:
Thanks for all the help but it haven't solve the problem...yet...
(positive
thinking)

I tried to do the reinstall of SQL Client but nothing changed... I have
also
read thoose documents and made a lot of changes in the new firewall but it
still not woorking. I'm not sure that the firewall is the problem, I tried
to
turn off the firewall but the problem is still showing up.

Do anybody have any other ideas???

// Andreas

Andreas Fredriksson said:
Hi!
I got a problem when I installed the SP2 for Win XP. I use Visual
Studio. net 2003 to develop a C# client and a using a SQL Server 2000 on
the
server. Before the upgrade it worked fine and if I uninstall SP2 on the
client it will work fine. But with SP2, I got the following exception...

"System.ArgumentException: The parameter is incorrect.\r\n at
System.Data.Common.ITransactionExportFactory.Create(UInt32 DTCLength,
Byte[]
DTCAddr, ITransactionExport& export)\r\n at
System.Data.SqlClient.Transaction.CreateTransactionExport(Byte[] dtcAddr,
UInt32 dtcLength, ITransaction transaction, ITransactionExport&
transactionExport)\r\n at
System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransaction(ITransaction
transaction)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)\r\n at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()\r\n
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)\r\n at System.Data.SqlClient.SqlConnection.Open()\r\n
at
Hind.Data.StoredProced
ure..ctor(String sStoredProcedure, SqlParameter[] objSqlParameters) in
C:\\Projekt\\Hind\\Source\\HindData\\StoredProcedure.cs:line 36" "The
parameter is incorrect."

...when I trying to run a stored procedure on the database server.

Is there anyone who had the same problem?? Any solutions??

Thanks!
Andreas
Click to expand...
Click to expand...
Click to expand...
 
Back
Top