[Mono-list] Problem with a web serivce method.

[beniniva@csr.unibo.it]

Isql is an utility of unixODBC

---------------
[root@or2 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 <jns@gellyfish.com>:

> On Mon, 2004-08-23 at 13:43, beniniva@csr.unibo.it 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\
> 
>