Re: [Mono-list] POSGRESQL / NPGSQL / MONO / DATASET

Tue, 08 Jun 2004 06:47:52 -0700 

ok, im a noob, i have found alon,e looollll
just forgot a Npgsql. :D
please find attached the log file if u dont want to see it here


here is the log:
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlConnection.NpgsqlConnection(Server=126.10.0.1;Port=5432;User 
Id=Pasquet;Database=Marrot;Password=kiorky)
08/06/2004 15:39:49     8830    Debug   Get NpgsqlClosedState.Instance
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlConnection.ParseConnectionString()
08/06/2004 15:39:49     8830    Debug   Connection string option: SERVER = 126.10.0.1
08/06/2004 15:39:49     8830    Debug   Connection string option: PORT = 5432
08/06/2004 15:39:49     8830    Debug   Connection string option: USER ID = Pasquet
08/06/2004 15:39:49     8830    Debug   Connection string option: DATABASE = Marrot
08/06/2004 15:39:49     8830    Debug   Connection string option: PASSWORD = kiorky
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.NpgsqlCommand()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlParameterCollection.NpgsqlParameterCollection()
08/06/2004 15:39:49     8830    Debug   Set NpgsqlCommand.Transaction = 
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataAdapter.NpgsqlDataAdapter()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlCommand.Connection
08/06/2004 15:39:49     8830    Debug   Get NpgsqlCommand.Connection
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlConnection.Open()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlClosedState.Instance
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlClosedState.Open()
08/06/2004 15:39:49     8830    Normal  Connected to: 126.10.0.1:5432.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlStartupPacket.NpgsqlStartupPacket()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlStartupPacket.WriteToStream()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlStartupPacket.WriteToStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ProcessBackendResponses()
08/06/2004 15:39:49     8830    Debug   AuthenticationRequest message received from 
server.
08/06/2004 15:39:49     8830    Debug   Server requested cleartext password 
authentication.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlStartupState.Authenticate()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlPasswordPacket.NpgsqlPasswordPacket()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlPasswordPacket.WriteToStream()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   AuthenticationRequest message received from 
server.
08/06/2004 15:39:49     8830    Debug   AuthenticationOK received.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: client_encoding.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: SQL_ASCII.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message from Server: Param = 
client_encoding, Value = SQL_ASCII
08/06/2004 15:39:49     8830    Debug   ParameterStatus message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: DateStyle.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: ISO, MDY.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message from Server: Param = 
DateStyle, Value = ISO, MDY
08/06/2004 15:39:49     8830    Debug   ParameterStatus message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: is_superuser.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: off.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message from Server: Param = 
is_superuser, Value = off
08/06/2004 15:39:49     8830    Debug   ParameterStatus message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: server_version.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: 7.4.1.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message from Server: Param = 
server_version, Value = 7.4.1
08/06/2004 15:39:49     8830    Debug   ParameterStatus message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: session_authorization.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: Pasquet.
08/06/2004 15:39:49     8830    Debug   ParameterStatus message from Server: Param = 
session_authorization, Value = Pasquet
08/06/2004 15:39:49     8830    Debug   BackendKeyData message received from server.
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlBackEndKeyData.NpgsqlBackEndKeyData()
08/06/2004 15:39:49     8830    Debug   ReadyForQuery message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: I.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlConnection.ProcessServerVersion()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.LoadTypesMapping()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.NpgsqlCommand()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlParameterCollection.NpgsqlParameterCollection()
08/06/2004 15:39:49     8830    Debug   Set NpgsqlCommand.Transaction = 
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.ExecuteReader()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.ExecuteReader(Default)
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.CheckConnectionState()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlReadyState.Query()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.GetCommandText()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlCommand.GetClearCommandText()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlParameterCollection.Count
08/06/2004 15:39:49     8830    Debug   Query sent: select oid, typname from pg_type 
where typname in ('bool', 'bytea', 'date', 'float4', 'float8', 'int2', 'int4', 'int8', 
'numeric', 'text', 'time', 'timestamp', 'timestamptz', 'timetz');.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ProcessBackendResponses()
08/06/2004 15:39:49     8830    Debug   RowDescription message received from server.
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlRowDescription.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: oid.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: typname.
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   DataRow message received from server.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: SELECT.
08/06/2004 15:39:49     8830    Debug   CompletedResponse message from Server: SELECT.
08/06/2004 15:39:49     8830    Debug   ReadyForQuery message received from server.
08/06/2004 15:39:49     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:49     8830    Debug   String read: I.
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:49     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:49     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:49     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlCommand.IDbCommand.ExecuteReader(CloseConnection)
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlCommand.ExecuteReader(CloseConnection)
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlCommand.CheckConnectionState()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlReadyState.Query()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlCommand.GetCommandText()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlCommand.GetClearCommandText()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlParameterCollection.Count
08/06/2004 15:39:50     8830    Debug   Query sent: delete from popo;insert into 
popo(sssss,xdsd)values('59','aaaaa');insert into 
popo(sssss,xdsd)values('519','aaaaa');insert into 
popo(sssss,xdsd)values('529','aaaaa');insert into 
popo(sssss,xdsd)values('359','aaaaa');insert into 
popo(sssss,xdsd)values('459','aaaaa');SELECT *  FROM popo.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.WriteString()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlState.ProcessBackendResponses()
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: DELETE 5.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: DELETE 
5.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: INSERT 0 1.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: INSERT 
0 1.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: INSERT 0 1.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: INSERT 
0 1.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: INSERT 0 1.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: INSERT 
0 1.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: INSERT 0 1.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: INSERT 
0 1.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: INSERT 0 1.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: INSERT 
0 1.
08/06/2004 15:39:50     8830    Debug   RowDescription message received from server.
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlRowDescription.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: sssss.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: xdsd.
08/06/2004 15:39:50     8830    Debug   DataRow message received from server.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   DataRow message received from server.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   DataRow message received from server.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   DataRow message received from server.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   DataRow message received from server.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.NpgsqlAsciiRow()
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlAsciiRow.ReadFromStream_Ver_3()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering 
NpgsqlDataReader.ConvertBackendStringToSystemType()
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: SELECT.
08/06/2004 15:39:50     8830    Debug   CompletedResponse message from Server: SELECT.
08/06/2004 15:39:50     8830    Debug   ReadyForQuery message received from server.
08/06/2004 15:39:50     8830    Debug   Entering PGUtil.ReadString()
08/06/2004 15:39:50     8830    Debug   String read: I.
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlState.ChangeState()
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.FieldCount
08/06/2004 15:39:50     8830    Debug   Get NpgsqlDataReader.FieldCount
08/06/2004 15:39:50     8830    Debug   Entering NpgsqlConnection.Dispose(True)


KiOrKY <[EMAIL PROTECTED]> a �crit :

> ggrrrrrrrr,,,,,
> [EMAIL PROTECTED]:~/npg$ mcs select_mono.cs -r:System.Data -r:Npgsql
> select_mono.cs(38) error CS0103: The name `LogLevel.Debug' could not be found
> in `ado.generique.requete.select.adapterposgresql2.Appli'
> Compilation failed: 1 error(s), 0 warnings
> [EMAIL PROTECTED]:~/npg$ 
> 
> help ;)
> the code is
> /*
>  * mpasquet le 21/04/2004 a 14h30
>  * 
>  *  premier programme d'acces aux donnees
>  * 
>  **/
> 
> namespace ado
> {
>       namespace generique
>       {
>                       namespace requete
>                       {
>                               namespace select
>                               {
>                                       namespace adapterposgresql2
>                                       {       
>                                               /**     INCLUDES NECCESSAIRES  **/
>                                               using System;
>                                               using ado.generique; // acces generique
>                                               using System.Data;                     
>                  
>                                       
>                                               /**              ALIAS        **/
>                                               using cout=System.Console;
>                                               /** DEBUT CODE **/
>                                               class Appli     
>                                               {
>                                                       public static void 
> Main(string[] args)
>                                                       {
>                                                               
> cout.WriteLine(&quot;-----------------------------------------\n&quot;);
>                                                               cout.WriteLine(&quot; 
> Salut   ----&gt; DEBUT 
> requete_select_adapter)\n&quot;);
>                                                               cout.WriteLine(&quot;  
>        attente touche ...\n&quot;);
>                                                               
> cout.WriteLine(&quot;-----------------------------------------\n&quot;);             
>                                                            
>                                                               /****/
>                                                               try
>                                                               {               
>                                                                       // Enable 
> logging.
>                                                                       
> Npgsql.NpgsqlEventLog.Level = LogLevel.Debug;
>                                                                       
> Npgsql.NpgsqlEventLog.LogName = &quot;NpgsqlTests.LogFile&quot;;
>                                                                       //modOutils 
> mnoutil = new
> modOutils();//System.IO.File.Copy(mnoutil.renvoipathfichiercfg(),@&quot;ADO.exe.config&quot;,true);
>                                                                       string srequet 
> =@&quot;delete from popo;&quot;;
>                                                                       
> srequet+=@&quot;insert into popo(sssss,xdsd)&quot;;
>                                                                       
> srequet+=@&quot;values('59','aaaaa');&quot;;
>                                                                       
> srequet+=@&quot;insert into popo(sssss,xdsd)&quot;;
>                                                                       
> srequet+=@&quot;values('519','aaaaa');&quot;;
>                                                                       
> srequet+=@&quot;insert into popo(sssss,xdsd)&quot;;
>                                                                       
> srequet+=@&quot;values('529','aaaaa');&quot;;
>                                                                       
> srequet+=@&quot;insert into popo(sssss,xdsd)&quot;;
>                                                                       
> srequet+=@&quot;values('359','aaaaa');&quot;;
>                                                                       
> srequet+=@&quot;insert into popo(sssss,xdsd)&quot;;
>                                                                       
> srequet+=@&quot;values('459','aaaaa');&quot;;   
>                                                                       
> srequet+=@&quot;SELECT *  FROM popo&quot;;                                           
>                    
>                                                                       string 
> scnxtring=@&quot;Server=126.10.0.1;Port=5432;User
> Id=Pasquet;Database=&quot;;
>                                                                       
> scnxtring+=@&quot;Marrot;Password=kiorky&quot;;
>                                                                       
> Npgsql.NpgsqlConnection toto = new
> Npgsql.NpgsqlConnection(scnxtring);
>                                                                       
> Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(srequet,toto);
>                                                                       
> Npgsql.NpgsqlDataAdapter DaAd = new
> Npgsql.NpgsqlDataAdapter(cmd);                                                       
>                  
>                                                                       DataSet Dsdset 
> = new DataSet();                                                 
>                                                                       
> DaAd.Fill(Dsdset);
>                                                                       
> Dsdset.AcceptChanges();                                                              
>    
>                                                                       
> DataTableCollection dtccol = Dsdset.Tables;
>                                                                       
> foreach(DataTable dtta in dtccol)
>                                                                       {
>                                                                               
>                                                                               
> cout.WriteLine( dtta.TableName);
>                                                                               
> foreach(DataRow drro in dtta.Rows)
>                                                                               {
>                                                                                      
>  cout.WriteLine(&quot;c1: {0} &lt;-&gt; c2: {1} &lt;-&gt;
> \n&quot;,(Int32)drro.ItemArray[0],drro.ItemArray[1]);                         
>                                                                               }
>                                                                       }
>                                                                       toto.Close();  
>  
>                                                               }
>                                                               catch(System.Exception 
> e)
>                                                               {
>                                                                       
> cout.WriteLine(&quot;Exception  lev�e: &quot;+ e.Message);
>                                                               }
>                                                               /****/
>                                                               
> cout.WriteLine(&quot;-----------------------------------------\n&quot;);
>                                                               cout.WriteLine(&quot; 
> Bye   ----&gt; FIN 
> requete_select_adapter\n&quot;);
>                                                               cout.WriteLine(&quot;  
>        attente touche ...\n&quot;);
>                                                               
> cout.WriteLine(&quot;-----------------------------------------\n&quot;);             
>    
>                                                               cout.ReadLine();
>                                                       }
>                                               }// fin classe APPLI
>                                       }
>                               }
>               
>               }
>       }
> }
> 
> 
> Francisco Figueiredo Jr. &lt;[EMAIL PROTECTED]&gt;
> a �crit :
> 
> &gt; KiOrKY wrote:
> &gt; 
> &gt; &amp;gt;In fact dont help, the goal is to migrate entirely an windows
> application
> &gt; into mono environnment and the base opf this application is to
> &gt; &amp;gt;dataadpter.fill(dataset)
> &gt; &amp;gt;
> &gt; &amp;gt;in anyway, i have tested datareader which work fine !
> &gt; &amp;gt;
> &gt; &amp;gt;just a litlle precision :)
> &gt; &amp;gt;
> &gt; &amp;gt;mono is a dream, its the last error i have at the moment !
> &gt; &amp;gt;
> &gt; &amp;gt;all the classses we need at enterprise are working well !
> &gt; &amp;gt;
> &gt; &amp;gt;  
> &gt; &amp;gt;
> &gt; 
> &gt; Hi Kiorky!
> &gt; 
> &gt; Wow! Very nice to know you are heading you development environment to
> Mono!
> &gt; 
> &gt; I hope I can help you in this last error you are getting! :)
> &gt; 
> &gt; While I'm setting up my devel environment, could you try add the 
> &gt; following lines and send me (can be in private) the log you get?
> &gt; 
> &gt; Thanks in advance.
> &gt; 
> &gt; // Enable logging.
> &gt; NpgsqlEventLog.Level = LogLevel.Debug;
> &gt; NpgsqlEventLog.LogName = &amp;quot;NpgsqlTests.LogFile&amp;quot;;
> &gt; 
> &gt; 
> &gt; Regards,
> &gt; 
> &gt; Francisco Figueiredo Jr.
> 
> -- 
> ----------------------------
>     I{ i () r |{ Y
>     Debian User
> ---------------------------------------------
> -- Mathieu PASQUET     
> -- Testeur Debian SID
> -- irc: #debian-fr / irc.freenode.net port: 6667 
> -- Site: www.fr.debian.org 
> ---------------------------------------------
> 
> 
> _______________________________________________
> Mono-list maillist  -  [EMAIL PROTECTED]
> http://lists.ximian.com/mailman/listinfo/mono-list

-- 
----------------------------
    I{ i () r |{ Y
    Debian User
---------------------------------------------
-- Mathieu PASQUET     
-- Testeur Debian SID
-- irc: #debian-fr / irc.freenode.net port: 6667 
-- Site: www.fr.debian.org 
---------------------------------------------

Attachment: NpgsqlTests.LogFile.tar.bz2
Description: Binary data

Reply via email to