Isql is an utility of unixODBC --------------- [EMAIL PROTECTED] root]# isql tdmio root rootpwd +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select * from sessione; +---------------+---------+-------+-----+-------+ | CodiceSessione| Problema| Stato | Nome| Utente| +---------------+---------+-------+-----+-------+ | 1 | 1 | chiusa| Null| U1 | | 2 | 1 | chiusa| Null| U1 | | 3 | 1 | chiusa| Null| U1 | | 4 | 1 | chiusa| Null| U4 | | 5 | 1 | chiusa| Null| U1 | | 6 | 1 | chiusa| Null| U4 | | 7 | 1 | chiusa| Null| U5 | | 8 | 1 | chiusa| Null| U4 | | 9 | 1 | chiusa| Null| U1 | | 10 | 1 | chiusa| Null| U1 | | 11 | 1 | chiusa| Null| U1 | | 12 | 1 | Attiva| Null| U1 | +---------------+---------+-------+-----+-------+ SQLRowCount returns 12 12 rows fetched
SQL> select * from sessione where Utente = 'U1' and Stato='Attiva'; +---------------+---------+-------+-----+-------+ | CodiceSessione| Problema| Stato | Nome| Utente| +---------------+---------+-------+-----+-------+ | 12 | 1 | Attiva| Null| U1 | +---------------+---------+-------+-----+-------+ SQLRowCount returns 1 1 rows fetched SQL> -------------- In the code the value of "Utente" is passed by a session var "(string)Session["Utente"]" but the query is the same. Valentina. >Scrive Jonathan Stowe <[EMAIL PROTECTED]>: > On Mon, 2004-08-23 at 13:43, [EMAIL PROTECTED] wrote: > > > > > "The remote server returned an error: (500) Internal Server Error. > > Unable to retreive error information from ODBC driver manager" > > > > What it means? > > > > There is a problem with your ODBC configuration, can you make a small > console example that just attempts to do the same connection to the > database? > > /J\ > > _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
