|
Home > Archive > Sybase ADO .NET > December 2005 > Sybase 15 Developer Edition MSDTC & DTM
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sybase 15 Developer Edition MSDTC & DTM
|
|
| Carlos Alberto Costa Beppler 2005-11-28, 11:25 am |
| Hi, I´m doing some tests using Sybase 15 Developer Edition and MSDTC
managed transactions (via COM+ 1.5 ServiceConfig class), but I´m having
no success.
The problem is that it simply can´t connect to the server and this stack
strace is generated on client:
Unhandled Exception: Sybase.Data.AseClient.AseException: Failed to
create an XA helper object.
at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
Boolean forOpen)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
transaction)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
at
Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
at Sybase.Data.AseClient.AseConnection.Open()
at Transactions.TestAse.CreateID()
at Transactions.TestAse.List()
at Transactions.Program.Main(String[] args)
The server was configured using this commands:
XA support has been tested against Sybase version 12.5.1 and above.
sp_configure 'enable DTM',1
sp_configure 'enable xact coordination',1
grant role dtm_tm_role to USER_NAME
sp_configure 'lock scheme',0,datarows
Am I doing something wrong?
| |
| Carlos Alberto Costa Beppler 2005-11-28, 8:28 pm |
| To XA transactions work using MSDTC ans ASEConnection the following key
must be added to registry:
& #91;HKEY_LOCAL_MACHI
NE\SOFTWARE\Microsof
t\MSDTC\XADLL]
"sybdrvado115.dll"=" C:\\sybase\\DataAcce
ss\\ADONET\\dll\\syb
drvado115.dll"
After add that key and restart the MSDTC, a started to get an error
(Invalid transaction state) opening the second connection to the same
ASE on same transaction.
Reading the documentation o found that TightlyCoupled Transaction must
be 1 to enable tow or more connections to same ASE on one distributed
transaction.
Then using the following connection strings these erros occured:
Connection String:
Data
Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=XA
;TightlyCoupled
Transaction=1
Unhandled Exception: Sybase.Data.AseClient.AseException: Invalid
transaction state.
at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
Boolean forOpen)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
transaction)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
at
Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
at Sybase.Data.AseClient.AseConnection.Open()
at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
at Transactions.TestAse.List() in TestAse.cs:line 24
at Transactions.Program.Main(String[] args) in Program.cs:line 15
Connection String:
Data
Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupled
Transaction=1
Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
30002
at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
Boolean forOpen)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
transaction)
at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
at
Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
at Sybase.Data.AseClient.AseConnection.Open()
at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
at Transactions.TestAse.List() in TestAse.cs:line 24
at Transactions.Program.Main(String[] args) in Program.cs:line 15
Carlos Alberto Costa Beppler wrote:
> Hi, I´m doing some tests using Sybase 15 Developer Edition and MSDTC
> managed transactions (via COM+ 1.5 ServiceConfig class), but I´m having
> no success.
>
> The problem is that it simply can´t connect to the server and this stack
> strace is generated on client:
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Failed to
> create an XA helper object.
| |
| Carlos Alberto Costa Beppler 2005-11-29, 1:24 pm |
| I still have no success connecting Sybase using ADO.NET/MSDTC/DTM,
attached is the trace of one of my executions.
Can anyone help me?
Carlos Alberto Costa Beppler wrote:[color=darkred
]
>
> Connection String:
> Data
> Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
> 30002
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Carlos Alberto Costa Beppler wrote:
>
| |
| Carlos Alberto Costa Beppler 2005-11-30, 7:24 am |
| More information, the same test works if I use System.Data.Odbc instead
of Sybase.Data.AseClient.
Carlos Alberto Costa Beppler wrote:[color=darkred
]
> To XA transactions work using MSDTC ans ASEConnection the following key
> must be added to registry:
>
> & #91;HKEY_LOCAL_MACHI
NE\SOFTWARE\Microsof
t\MSDTC\XADLL]
> "sybdrvado115.dll"=" C:\\sybase\\DataAcce
ss\\ADONET\\dll\\syb
drvado115.dll"
>
> After add that key and restart the MSDTC, a started to get an error
> (Invalid transaction state) opening the second connection to the same
> ASE on same transaction.
>
> Reading the documentation o found that TightlyCoupled Transaction must
> be 1 to enable tow or more connections to same ASE on one distributed
> transaction.
>
> Then using the following connection strings these erros occured:
>
> Connection String:
> Data
> Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=XA
;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Invalid
> transaction state.
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Connection String:
> Data
> Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
> 30002
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Carlos Alberto Costa Beppler wrote:
>
| |
| Carlos Alberto Costa Beppler 2005-11-30, 7:24 am |
| It works if I use System.Data.Odbc instead of Sybase.Data.AseClient.
Carlos Alberto Costa Beppler wrote:[color=darkred
]
>
> Connection String:
> Data
> Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=XA
;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Invalid
> transaction state.
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Connection String:
> Data
> Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
> 30002
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransactio
n
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Carlos Alberto Costa Beppler wrote:
>
| |
|
| Hi Carlos,
I tried a quick connection test using 1.1.481.0 (to be released in 12.5.1
SDK ESD#11) and had no problems like this.
I will try the 15.0 version - what exact version do you have for
Sybase.Data.AseClient.dll?
< I do not have my app setup for XA yet, but the connection succeeded
without the error - I will need to setup something similar to your setup to
confirm>
-Paul
"Carlos Alberto Costa Beppler" <beppler@mpsinf.com.br> wrote in message
news:438b9e03$1@foru
ms-1-dub...
> To XA transactions work using MSDTC ans ASEConnection the following key
> must be added to registry:
>
> & #91;HKEY_LOCAL_MACHI
NE\SOFTWARE\Microsof
t\MSDTC\XADLL]
> "sybdrvado115.dll"=" C:\\sybase\\DataAcce
ss\\ADONET\\dll\\syb
drvado115.dll"
>
> After add that key and restart the MSDTC, a started to get an error
> (Invalid transaction state) opening the second connection to the same
> ASE on same transaction.
>
> Reading the documentation o found that TightlyCoupled Transaction must
> be 1 to enable tow or more connections to same ASE on one distributed
> transaction.
>
> Then using the following connection strings these erros occured:
>
> Connection String:
> Data
>
Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtoco
l=XA;TightlyCoupled[
color=darkred]
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Invalid
> transaction state.
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
>[/color]
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransa
ction
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Connection String:
> Data
>
Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtoco
l=OLE;TightlyCoupled
> Transaction=1
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
> 30002
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
> Boolean forOpen)
> at
>
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransa
ction[color=darkred]
> transaction)
> at
> Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at
> Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in TestAse.cs:line 57
> at Transactions.TestAse.List() in TestAse.cs:line 24
> at Transactions.Program.Main(String[] args) in Program.cs:line 15
>
> Carlos Alberto Costa Beppler wrote:
| |
|
| Hi Carlos,
I have no DTM app setup yet but this should work. I think you need to setup
a repro and log a Sybase Technical Support case so this can be looked at and
reported to Engineering if there is a problem. I can make a simple
connection with the parameters in place but I have not setup a COM+ object
yet to work with this.
What is the exact version of the Provider? Sybase.Data.AseClient.dll???
-Paul
"Carlos Alberto Costa Beppler" <beppler@mpsinf.com.br> wrote in message
news:438c9272@forums
-1-dub...
> I still have no success connecting Sybase using ADO.NET/MSDTC/DTM,
> attached is the trace of one of my executions.
>
> Can anyone help me?
>
>
>
> Carlos Alberto Costa Beppler wrote:
Source=larssen2003;P
ort=5000;Database=Te
ste;UID=test;PWD=tes
t2005;DTCProtoco
l=OLE;TightlyCoupled
[color=darkred]
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransa
ction[color=darkred]
conn)[color=darkred]
>
>
----------------------------------------------------------------------------
----
> Entering List
> Entering CreateID
> Entering Sybase.Data.AseClient.AseConnection Open
> DriverVersion = 1.15.50.0
> ConnectionString = Data
Source=larssen2003;P
ort=5000;Database=Te
ste;PacketSize=2048;
UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupledTran
saction=1
> Entering Sybase.Data.AseClient.AseConnection Get: State
> Exiting Sybase.Data.AseClient.AseConnection Get: State Closed
> Entering Sybase.Data.AseClient.AseConnection Get: Database
> Exiting Sybase.Data.AseClient.AseConnection Get: Database Teste
> Entering Sybase.Data.AseClient.AseConnection Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseConnection Get: NamedParameters
True
> Entering Sybase.Data.AseClient.AseCommand Set: Connection
> Sybase.Data.AseClient.AseConnection
> Exiting Sybase.Data.AseClient.AseCommand Set: Connection
> Entering Sybase.Data.AseClient.AseCommand AseCommand
> select 42
> Sybase.Data.AseClient.AseConnection
> Entering Sybase.Data.AseClient.AseCommand Set: CommandText
> select 42
> Exiting Sybase.Data.AseClient.AseCommand Set: CommandText
> Exiting Sybase.Data.AseClient.AseCommand AseCommand
> Entering Sybase.Data.AseClient.AseCommand ExecuteScalar
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseCommand Get: CommandText
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandText select
42
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseConnection Get: State
> Exiting Sybase.Data.AseClient.AseConnection Get: State Open
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseCommand Get: NamedParameters True
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: CommandType
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandType Text
> Entering Sybase.Data.AseClient.AseCommand Get: CommandText
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandText select
42
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseCommand Get: NamedParameters True
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseDataReader Read
> Entering Sybase.Data.AseClient.AseDataReader Get: IsClosed
> Exiting Sybase.Data.AseClient.AseDataReader Get: IsClosed False
> Exiting Sybase.Data.AseClient.AseDataReader Read True
> Entering Sybase.Data.AseClient.AseDataReader GetValue
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Entering Sybase.Data.AseClient.AseDataReader IsDBNull
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Entering Sybase.Data.AseClient.AseDataReader GetFieldType
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Exiting Sybase.Data.AseClient.AseDataReader GetFieldType
System. Int32
> Exiting Sybase.Data.AseClient.AseDataReader GetValue 42
> Entering Sybase.Data.AseClient.AseDataReader Close
> Entering Sybase.Data.AseClient.AseDataReader NextResult
> Exiting Sybase.Data.AseClient.AseDataReader NextResult False
> Exiting Sybase.Data.AseClient.AseDataReader Close
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Exiting Sybase.Data.AseClient.AseCommand ExecuteScalar 42
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Exiting Sybase.Data.AseClient.AseConnection Open
> Entering Sybase.Data.AseClient.AseConnection CreateCommand
> Entering Sybase.Data.AseClient.AseConnection Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseConnection Get: NamedParameters
True
> Entering Sybase.Data.AseClient.AseCommand Set: Connection
> Sybase.Data.AseClient.AseConnection
> Exiting Sybase.Data.AseClient.AseCommand Set: Connection
> Exiting Sybase.Data.AseClient.AseConnection CreateCommand
Sybase.Data.AseClient. AseCommand
> Entering Sybase.Data.AseClient.AseCommand Set: CommandText
> update Teste set Value = Value + 1 where Id = 1
> select Value from Teste where Id = 1
> Exiting Sybase.Data.AseClient.AseCommand Set: CommandText
> Entering Sybase.Data.AseClient.AseCommand ExecuteScalar
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseCommand Get: CommandText
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandText update
Teste set Value = Value + 1 where Id = 1
> select Value from Teste where Id = 1
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseConnection Get: State
> Exiting Sybase.Data.AseClient.AseConnection Get: State Open
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseCommand Get: NamedParameters True
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: CommandType
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandType Text
> Entering Sybase.Data.AseClient.AseCommand Get: CommandText
> Exiting Sybase.Data.AseClient.AseCommand Get: CommandText update
Teste set Value = Value + 1 where Id = 1
> select Value from Teste where Id = 1
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseCommand Get: NamedParameters
> Exiting Sybase.Data.AseClient.AseCommand Get: NamedParameters True
> Entering Sybase.Data.AseClient.AseCommand Get: Parameters
> Exiting Sybase.Data.AseClient.AseCommand Get: Parameters
Sybase.Data.AseClient. AseParameterCollecti
on
> Entering Sybase.Data.AseClient.AseDataReader Read
> Entering Sybase.Data.AseClient.AseDataReader Get: IsClosed
> Exiting Sybase.Data.AseClient.AseDataReader Get: IsClosed False
> Exiting Sybase.Data.AseClient.AseDataReader Read True
> Entering Sybase.Data.AseClient.AseDataReader GetValue
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Entering Sybase.Data.AseClient.AseDataReader IsDBNull
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Entering Sybase.Data.AseClient.AseDataReader GetFieldType
> 0
> Entering Sybase.Data.AseClient.AseDataReader Get: FieldCount
> Exiting Sybase.Data.AseClient.AseDataReader Get: FieldCount 1
> Exiting Sybase.Data.AseClient.AseDataReader GetFieldType
System. Int32
> Exiting Sybase.Data.AseClient.AseDataReader GetValue 1
> Entering Sybase.Data.AseClient.AseDataReader Close
> Entering Sybase.Data.AseClient.AseDataReader NextResult
> Exiting Sybase.Data.AseClient.AseDataReader NextResult False
> Exiting Sybase.Data.AseClient.AseDataReader Close
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Exiting Sybase.Data.AseClient.AseCommand ExecuteScalar 1
> Entering Sybase.Data.AseClient.AseConnection Close
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Exiting Sybase.Data.AseClient.AseConnection Close
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Entering Sybase.Data.AseClient.AseCommand Get: Connection
> Exiting Sybase.Data.AseClient.AseCommand Get: Connection
Sybase.Data.AseClient. AseConnection
> Exiting CreateID
> Entering ListData
> Entering Sybase.Data.AseClient.AseConnection Open
> DriverVersion = 1.15.50.0
> ConnectionString = Data
Source=larssen2003;P
ort=5000;Database=Te
ste;PacketSize=2048;
UID=test;PWD=tes
t2005;DTCProtocol=OL
E;TightlyCoupledTran
saction=1
> Entering Sybase.Data.AseClient.AseConnection Get: State
> Exiting Sybase.Data.AseClient.AseConnection Get: State Closed
>
> Unhandled Exception: Sybase.Data.AseClient.AseException: Internal Error:
30002
> at Sybase.Data.AseClient.AseConnectionImpl.CheckResult(Int32 res,
Boolean forOpen)
> at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction(ITransa
ction transaction)
> at
Sybase.Data.AseClient.AseConnectionImpl. EnlistDistributedTra
nsaction()
> at Sybase.Data.AseClient.AseConnectionPool. GetConnection(AseCon
nection
conn)
> at Sybase.Data.AseClient.AseConnection.Open()
> at Transactions.TestAse.ListData(Int32 id) in D:\beppler\DOCS\Visu
al
Studio 2005\Projects\Transa
ctions\Transactions\
TestAse.cs:line 72
> at Transactions.TestAse.List() in D:\beppler\DOCS\Visu
al Studio
2005\Projects\Transa
ctions\Transactions\
TestAse.cs:line 27
> at Transactions.Program.Main(String[] args) in D:\beppler\DOCS\Visu
al
Studio 2005\Projects\Transa
ctions\Transactions\
Program.cs:line 18
>
| |
| Carlos Alberto Costa Beppler 2005-12-02, 1:24 pm |
| The provider version is 1.15.50.0.
Paul wrote:
> Hi Carlos,
>
> I have no DTM app setup yet but this should work. I think you need to setup
> a repro and log a Sybase Technical Support case so this can be looked at and
> reported to Engineering if there is a problem. I can make a simple
> connection with the parameters in place but I have not setup a COM+ object
> yet to work with this.
>
> What is the exact version of the Provider? Sybase.Data.AseClient.dll???
>
> -Paul
>
| |
| Carlos Alberto Costa Beppler 2005-12-02, 8:25 pm |
| The provider version is 1.15.50.0.
As I said on earlier post, it is working if I use de ODBC driver and the
System.Data.OdbcConnection istead of Sybase.Data.AseConnection.
Paul wrote:
> Hi Carlos,
>
> I tried a quick connection test using 1.1.481.0 (to be released in 12.5.1
> SDK ESD#11) and had no problems like this.
>
> I will try the 15.0 version - what exact version do you have for
> Sybase.Data.AseClient.dll?
>
> < I do not have my app setup for XA yet, but the connection succeeded
> without the error - I will need to setup something similar to your setup to
> confirm>
>
> -Paul
>
| |
|
| Hi Carlos,.
You should report this to Sybase Technical Support. I have not gotten that
far but I would like to setup a COM+ object and see what happens. I am not
sure when I will getthis accomplished, but reporting to tech support would
be a good thing to do now.
-Paul
"Carlos Alberto Costa Beppler" <beppler@mpsinf.com.br> wrote in message
news:4390a160$1@foru
ms-1-dub...[color=darkred]
> The provider version is 1.15.50.0.
>
> As I said on earlier post, it is working if I use de ODBC driver and the
> System.Data.OdbcConnection istead of Sybase.Data.AseConnection.
>
>
> Paul wrote:
12.5.1[color=darkred]
to[color=darkred]
|
|
|
|
|