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

KiOrKY KiOrKY <kiorky@goddess-gate.com>
Tue, 8 Jun 2004 16:33:45 +0200 

is iot whe you
do

dataapdter.fill( dataset) ; because its there i have problems !

Carlos Guzmán Álvarez <carlosga@telefonica.net> a écrit :

> Hello:
> 
> &gt;In fact dont help, the goal is to migrate entirely an windows application
> into mono environnment and the base opf this application is to
> &gt;dataadpter.fill(dataset)
> &gt;
> Huummmmm .... not sure if it will be the same problem
> but a user of the Firebird .NET provider is having problems
> with datasets  using mono beta 2 .... and the same problem he
> is having works fine in .NET ....
> 
> 
> 
> 
> 
> --
> Best regards
> 
> Carlos Guzmán Álvarez
> Vigo-Spain

[Mono-list] POSGRESQL / NPGSQL / MONO / DATASET
KiOrKY KiOrKY <kiorky@goddess-gate.com>
Tue, 8 Jun 2004 15:46:31 +0200

    * Previous message: [Mono-list] ADODB.dll
    * Next message: [Mono-list] monodoc Mono Handbook not found?
    * Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This is a MIME encoded message.

--NextParte99434ab1507e57e42cef1cf58921f2e
Content-Type: text/plain;
	charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

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=098830=09Debug=09Entering NpgsqlConnection.NpgsqlConnec=
tion(Server=3D126.10.0.1;Port=3D5432;User Id=3DPasquet;Database=3DMarrot;Pa=
ssword=3Dkiorky)
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlClosedState.Instance
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlConnection.ParseConnect=
ionString()
08/06/2004 15:39:49=098830=09Debug=09Connection string option: SERVER =3D 1=
26.10.0.1
08/06/2004 15:39:49=098830=09Debug=09Connection string option: PORT =3D 543=
2
08/06/2004 15:39:49=098830=09Debug=09Connection string option: USER ID =3D =
Pasquet
08/06/2004 15:39:49=098830=09Debug=09Connection string option: DATABASE =3D=
 Marrot
08/06/2004 15:39:49=098830=09Debug=09Connection string option: PASSWORD =3D=
 kiorky
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.NpgsqlCommand()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlParameterCollection.Npg=
sqlParameterCollection()
08/06/2004 15:39:49=098830=09Debug=09Set NpgsqlCommand.Transaction =3D=20
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataAdapter.NpgsqlDataA=
dapter()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlCommand.Connection
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlCommand.Connection
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlConnection.Open()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlClosedState.Instance
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlClosedState.Open()
08/06/2004 15:39:49=098830=09Normal=09Connected to: 126.10.0.1:5432.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlStartupPacket.NpgsqlSta=
rtupPacket()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlStartupPacket.WriteToSt=
ream()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlStartupPacket.WriteToSt=
ream_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ProcessBackendRes=
ponses()
08/06/2004 15:39:49=098830=09Debug=09AuthenticationRequest message received=
 from server.
08/06/2004 15:39:49=098830=09Debug=09Server requested cleartext password au=
thentication.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlStartupState.Authentica=
te()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlPasswordPacket.NpgsqlPa=
sswordPacket()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlPasswordPacket.WriteToS=
tream()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09AuthenticationRequest message received=
 from server.
08/06/2004 15:39:49=098830=09Debug=09AuthenticationOK received.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message received from =
server.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: client_encoding.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: SQL_ASCII.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message from Server: P=
aram =3D client_encoding, Value =3D SQL_ASCII
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message received from =
server.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: DateStyle.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: ISO, MDY.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message from Server: P=
aram =3D DateStyle, Value =3D ISO, MDY
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message received from =
server.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: is_superuser.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: off.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message from Server: P=
aram =3D is_superuser, Value =3D off
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message received from =
server.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: server_version.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: 7.4.1.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message from Server: P=
aram =3D server_version, Value =3D 7.4.1
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message received from =
server.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: session_authorization.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: Pasquet.
08/06/2004 15:39:49=098830=09Debug=09ParameterStatus message from Server: P=
aram =3D session_authorization, Value =3D Pasquet
08/06/2004 15:39:49=098830=09Debug=09BackendKeyData message received from s=
erver.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlBackEndKeyData.NpgsqlBa=
ckEndKeyData()
08/06/2004 15:39:49=098830=09Debug=09ReadyForQuery message received from se=
rver.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: I.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlConnection.ProcessServe=
rVersion()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.LoadTypesMap=
ping()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.NpgsqlCommand()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlParameterCollection.Npg=
sqlParameterCollection()
08/06/2004 15:39:49=098830=09Debug=09Set NpgsqlCommand.Transaction =3D=20
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.ExecuteReader()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.ExecuteReader(D=
efault)
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.CheckConnection=
State()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlReadyState.Query()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.GetCommandText(=
)
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlCommand.GetClearCommand=
Text()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlParameterCollection.Count
08/06/2004 15:39:49=098830=09Debug=09Query sent: select oid, typname from p=
g_type where typname in ('bool', 'bytea', 'date', 'float4', 'float8', 'int2=
', 'int4', 'int8', 'numeric', 'text', 'time', 'timestamp', 'timestamptz', '=
timetz');.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ProcessBackendRes=
ponses()
08/06/2004 15:39:49=098830=09Debug=09RowDescription message received from s=
erver.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlRowDescription.ReadFrom=
Stream_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: oid.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: typname.
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: SELECT.
08/06/2004 15:39:49=098830=09Debug=09CompletedResponse message from Server:=
 SELECT.
08/06/2004 15:39:49=098830=09Debug=09ReadyForQuery message received from se=
rver.
08/06/2004 15:39:49=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:49=098830=09Debug=09String read: I.
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlState.ChangeState()
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:49=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:49=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[1]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[1]
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.GetValue()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlAsciiRow.this[0]
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.Read()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlCommand.IDbCommand.Exec=
uteReader(CloseConnection)
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlCommand.ExecuteReader(C=
loseConnection)
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlCommand.CheckConnection=
State()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlReadyState.Query()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlCommand.GetCommandText(=
)
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlCommand.GetClearCommand=
Text()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlParameterCollection.Count
08/06/2004 15:39:50=098830=09Debug=09Query sent: delete from popo;insert in=
to popo(sssss,xdsd)values('59','aaaaa');insert into popo(sssss,xdsd)values(=
'519','aaaaa');insert into popo(sssss,xdsd)values('529','aaaaa');insert int=
o popo(sssss,xdsd)values('359','aaaaa');insert into popo(sssss,xdsd)values(=
'459','aaaaa');SELECT *  FROM popo.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.WriteString()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlState.ProcessBackendRes=
ponses()
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: DELETE 5.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 DELETE 5.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 INSERT 0 1.
08/06/2004 15:39:50=098830=09Debug=09RowDescription message received from s=
erver.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlRowDescription.ReadFrom=
Stream_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: sssss.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: xdsd.
08/06/2004 15:39:50=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09DataRow message received from server.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.NpgsqlAsciiRow=
()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlAsciiRow.ReadFromStream=
_Ver_3()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlDataReader.ConvertBacke=
ndStringToSystemType()
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: SELECT.
08/06/2004 15:39:50=098830=09Debug=09CompletedResponse message from Server:=
 SELECT.
08/06/2004 15:39:50=098830=09Debug=09ReadyForQuery message received from se=
rver.
08/06/2004 15:39:50=098830=09Debug=09Entering PGUtil.ReadString()
08/06/2004 15:39:50=098830=09Debug=09String read: I.
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlState.ChangeState()
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.FieldCount
08/06/2004 15:39:50=098830=09Debug=09Get NpgsqlDataReader.FieldCount
08/06/2004 15:39:50=098830=09Debug=09Entering NpgsqlConnection.Dispose(True=
)


KiOrKY <kiorky@goddess-gate.com> a =E9crit :

> ggrrrrrrrr,,,,,
> kiorky@doldit100:~/npg$ mcs select_mono.cs -r:System.Data -r:Npgsql
> select_mono.cs(38) error CS0103: The name `LogLevel.Debug' could not be f=
ound
> in `ado.generique.requete.select.adapterposgresql2.Appli'
> Compilation failed: 1 error(s), 0 warnings
> kiorky@doldit100:~/npg$=20
>=20
> help ;)
> the code is
> /*
>  * mpasquet le 21/04/2004 a 14h30
>  *=20
>  *  premier programme d'acces aux donnees
>  *=20
>  **/
>=20
> namespace ado
> {
> =09namespace generique
> =09{
> =09=09=09namespace requete
> =09=09=09{
> =09=09=09=09namespace select
> =09=09=09=09{
> =09=09=09=09=09namespace adapterposgresql2
> =09=09=09=09=09{=09
> =09=09=09=09=09=09/**     INCLUDES NECCESSAIRES  **/
> =09=09=09=09=09=09using System;
> =09=09=09=09=09=09using ado.generique; // acces generique
> =09=09=09=09=09=09using System.Data;=09=09=09=09=09
> =09=09=09=09=09
> =09=09=09=09=09=09/**              ALIAS        **/
> =09=09=09=09=09=09using cout=3DSystem.Console;
> =09=09=09=09=09=09/** DEBUT CODE **/
> =09=09=09=09=09=09class Appli=09
> =09=09=09=09=09=09{
> =09=09=09=09=09=09=09public static void Main(string[] args)
> =09=09=09=09=09=09=09{
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;----------------------------=
-------------\n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot; Salut   ----&gt; DEBUT=20
> requete_select_adapter)\n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;         attente touche ...\=
n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;----------------------------=
-------------\n&quot;);=09=09=09=09=09=09=09=09=09
> =09=09=09=09=09=09=09=09/****/
> =09=09=09=09=09=09=09=09try
> =09=09=09=09=09=09=09=09{=09=09
> =09=09=09=09=09=09=09=09=09// Enable logging.
> =09=09=09=09=09=09=09=09=09Npgsql.NpgsqlEventLog.Level =3D LogLevel.Debug=
;
> =09=09=09=09=09=09=09=09=09Npgsql.NpgsqlEventLog.LogName =3D &quot;Npgsql=
Tests.LogFile&quot;;
> =09=09=09=09=09=09=09=09=09//modOutils mnoutil =3D new
> modOutils();//System.IO.File.Copy(mnoutil.renvoipathfichiercfg(),@&quot;A=
DO.exe.config&quot;,true);
> =09=09=09=09=09=09=09=09=09string srequet =3D@&quot;delete from popo;&quo=
t;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;insert into popo(sssss,xdsd)=
&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;values('59','aaaaa');&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;insert into popo(sssss,xdsd)=
&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;values('519','aaaaa');&quot;=
;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;insert into popo(sssss,xdsd)=
&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;values('529','aaaaa');&quot;=
;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;insert into popo(sssss,xdsd)=
&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;values('359','aaaaa');&quot;=
;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;insert into popo(sssss,xdsd)=
&quot;;
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;values('459','aaaaa');&quot;=
;=09
> =09=09=09=09=09=09=09=09=09srequet+=3D@&quot;SELECT *  FROM popo&quot;;=
=09=09=09=09=09=09=09=09
> =09=09=09=09=09=09=09=09=09string scnxtring=3D@&quot;Server=3D126.10.0.1;=
Port=3D5432;User
> Id=3DPasquet;Database=3D&quot;;
> =09=09=09=09=09=09=09=09=09scnxtring+=3D@&quot;Marrot;Password=3Dkiorky&q=
uot;;
> =09=09=09=09=09=09=09=09=09Npgsql.NpgsqlConnection toto =3D new
> Npgsql.NpgsqlConnection(scnxtring);
> =09=09=09=09=09=09=09=09=09Npgsql.NpgsqlCommand cmd =3D new Npgsql.Npgsql=
Command(srequet,toto);
> =09=09=09=09=09=09=09=09=09Npgsql.NpgsqlDataAdapter DaAd =3D new
> Npgsql.NpgsqlDataAdapter(cmd);=09=09=09=09=09=09=09=09=09
> =09=09=09=09=09=09=09=09=09DataSet Dsdset =3D new DataSet();=09=09=09=09=
=09=09=09
> =09=09=09=09=09=09=09=09=09DaAd.Fill(Dsdset);
> =09=09=09=09=09=09=09=09=09Dsdset.AcceptChanges();=09=09=09=09=09=09=09=
=09=09
> =09=09=09=09=09=09=09=09=09DataTableCollection dtccol =3D Dsdset.Tables;
> =09=09=09=09=09=09=09=09=09foreach(DataTable dtta in dtccol)
> =09=09=09=09=09=09=09=09=09{
> =09=09=09=09=09=09=09=09=09=09
> =09=09=09=09=09=09=09=09=09=09cout.WriteLine( dtta.TableName);
> =09=09=09=09=09=09=09=09=09=09foreach(DataRow drro in dtta.Rows)
> =09=09=09=09=09=09=09=09=09=09{
> =09=09=09=09=09=09=09=09=09=09=09cout.WriteLine(&quot;c1: {0} &lt;-&gt; c=
2: {1} &lt;-&gt;
> \n&quot;,(Int32)drro.ItemArray[0],drro.ItemArray[1]);=09=09=09=09
> =09=09=09=09=09=09=09=09=09=09}
> =09=09=09=09=09=09=09=09=09}
> =09=09=09=09=09=09=09=09=09toto.Close();=09
> =09=09=09=09=09=09=09=09}
> =09=09=09=09=09=09=09=09catch(System.Exception e)
> =09=09=09=09=09=09=09=09{
> =09=09=09=09=09=09=09=09=09cout.WriteLine(&quot;Exception  lev=E9e: &quot=
;+ e.Message);
> =09=09=09=09=09=09=09=09}
> =09=09=09=09=09=09=09=09/****/
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;----------------------------=
-------------\n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot; Bye   ----&gt; FIN=20
> requete_select_adapter\n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;         attente touche ...\=
n&quot;);
> =09=09=09=09=09=09=09=09cout.WriteLine(&quot;----------------------------=
-------------\n&quot;);=09=09
> =09=09=09=09=09=09=09=09cout.ReadLine();
> =09=09=09=09=09=09=09}
> =09=09=09=09=09=09}// fin classe APPLI
> =09=09=09=09=09}
> =09=09=09=09}
> =09=09
> =09=09}
> =09}
> }
>=20
>=20
> Francisco Figueiredo Jr. &lt;fxjrlists@yahoo.com.br&gt;
> a =E9crit :
>=20
> &gt; KiOrKY wrote:
> &gt;=20
> &gt; &amp;gt;In fact dont help, the goal is to migrate entirely an window=
s
> 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; =20
> &gt; &amp;gt;
> &gt;=20
> &gt; Hi Kiorky!
> &gt;=20
> &gt; Wow! Very nice to know you are heading you development environment t=
o
> Mono!
> &gt;=20
> &gt; I hope I can help you in this last error you are getting! :)
> &gt;=20
> &gt; While I'm setting up my devel environment, could you try add the=20
> &gt; following lines and send me (can be in private) the log you get?
> &gt;=20
> &gt; Thanks in advance.
> &gt;=20
> &gt; // Enable logging.
> &gt; NpgsqlEventLog.Level =3D LogLevel.Debug;
> &gt; NpgsqlEventLog.LogName =3D &amp;quot;NpgsqlTests.LogFile&amp;quot;;
> &gt;=20
> &gt;=20
> &gt; Regards,
> &gt;=20
> &gt; Francisco Figueiredo Jr.
>=20
> --=20
>
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list

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

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