I found what is my error from. In selected command I try to read Octet Field. I changed to VarChar and It works.
Thanks Paul. |-----Original Message----- |From: [EMAIL PROTECTED] [mailto:firebird- |[EMAIL PROTECTED] On Behalf Of Paul Mercea |Sent: Monday, May 29, 2006 8:19 PM |To: firebird-net-provider@lists.sourceforge.net |Subject: RE: [Firebird-net-provider] Error code -303 | |So... |Using VS 2005 |Provider FB.Net 2.0 RC4 |.Net Framework 2 |FBServer 2.0 RC 1 on Windows and RC 2 in Linux | |Sample code look like |String test=""; |FbCommand fbc = new FbCommand("select passwd from sys_user where |[EMAIL PROTECTED]", fbConnInv); |fbc.Parameters.Add("@pLOGIN",FbDbType.VarChar).Value = "paul"; |test = (string)fbc.ExecuteScalar(); | |Thanks, |Paul | ||-----Original Message----- ||From: [EMAIL PROTECTED] [mailto:firebird- ||[EMAIL PROTECTED] On Behalf Of Carlos Guzmán ||Álvarez ||Sent: Monday, May 29, 2006 8:04 PM ||To: firebird-net-provider@lists.sourceforge.net ||Subject: Re: [Firebird-net-provider] Error code -303 || ||Hello: ||> ||> Hi ||> ||> Im running a simple fbcommand (select ) and executed scalar. ||> ||> I get error Dynamic sql error SQL error code = -303 internal error ||> ||Please send a sample of the SQL command you are trying to execute, if ||not if will be really hard to give you any help. || ||And plase let us know what version of the provider, .net framework and ||firebird server are you using. ||> || || ||-- ||Carlos Guzmán Álvarez ||Vigo-Spain || ||http://carlosga.blogspot.com/ || ||No hay un solo rey que no descienda de un esclavo, ||ni un esclavo que no haya tenido reyes en su familia. || || || ||------------------------------------------------------- ||All the advantages of Linux Managed Hosting--Without the Cost and Risk! ||Fully trained technicians. The highest number of Red Hat certifications in ||the hosting industry. Fanatical Support. Click to learn more ||http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642 ||_______________________________________________ ||Firebird-net-provider mailing list ||Firebird-net-provider@lists.sourceforge.net ||https://lists.sourceforge.net/lists/listinfo/firebird-net-provider | | | |------------------------------------------------------- |All the advantages of Linux Managed Hosting--Without the Cost and Risk! |Fully trained technicians. The highest number of Red Hat certifications in |the hosting industry. Fanatical Support. Click to learn more |http://sel.as- |us.falkag.net/sel?cmd_______________________________________________ |Firebird-net-provider mailing list |Firebird-net-provider@lists.sourceforge.net |https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=lnk&kid7521&bid$8729&dat1642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
