Message-Id: <4.3.1.0.20001123153208.00b15d98@mail.aquarius.com.au> Date: Thu, 23 Nov 2000 15:35:08 +1100 From: Glen Harvy <glen@aquarius.com.au> Subject: Re: [Emerald] Help SQL Errors
I am/was a newcomer to SQL and often had these problems. I wanted to use
iHTML - not SQL :-)
The best way of finding the problem is to open SQL Enterprise Manager and
running SQL Query. Copy the proposed iHTML-SQL query into that and SQL will
help you fix the problem. If it works in SQL then it will work in iHTML.
At 13:26 23/11/2000, you wrote:
>I'm not getting my accounting records inserted into my database. I have
>turned ODBC Debugging on and am seeing a lot of these two errors:
>
>Wed Nov 22 20:21:00 2000: ODBC Error:S1T00:0:
> [Microsoft][ODBC SQL Server Driver]Timeout expired
>
>Wed Nov 22 20:20:56 2000: ODBC Error:37000:170:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
>near 's'.
>
>More of the first one, but a lot of both.
>
>HELP!!!
>
>Brian Johnson
>Internet Operations Specialist
>Northern Valley Communications
>
>------------
>
>This is a user supported list. If you require assistance from IEA Software's
>Support Engineers, please check out our Support resources at
>http://www.iea-software.com/support.
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet needs
voice(02)9977-3788 fax(02)9977-3844
http://www.aquarius.com.au mailto:sales@aquarius.com.au
.