Re: calls table in ODBC

Dale E. Reed Jr. ( (no email) )
Sun, 11 Jan 1998 10:22:43 -0800

Mokrosh Pietro wrote:
>
> i have some problem with Calls table in ODBC mode:
>
> the table is obviously not updated as it should, altough sometime some
> records are appended...

Can you give some more details of this? Do you see any
problems in -x15 mode? Any errors?

> but this is what i see with SQL Trace from time to time:
>
> -- 11.1.1998 16:51:57,100 RPC (ID=46, SPID=13, User=sa(GNS\pietro),
> App='', Host=''(147) )
> sp_columns "Calls", NULL, NULL, NULL, "Calls", NULL, NULL, NULL
> go

This isn't a big deal. Its the way RadiusNT 2.2 checked to see if
the connection was still alive and working correctly.

> i run this query (sp_collumns....) but it will eventually end with:
> Msg 257, Level 16, State 1
> Implicit conversion from datatype 'varchar' to 'int' is not allowed.
> Use the CONVERT function to run this query.

This doesn't sound right. sp_columns is just a system stored procedure
that gives you information back on the columns in a table.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com