Re: [Emerald] Help SQL Errors

New Message Reply Date view Thread view Subject view Author view
Glen Harvy (
Thu, 23 Nov 2000 15:35:08 +1100

Message-Id: <>
Date: Thu, 23 Nov 2000 15:35:08 +1100
From: Glen Harvy <>
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.
>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
>For more information about this list (including removal) go to:

AQUARIUS Communications for all your Internet needs
voice(02)9977-3788 fax(02)9977-3844


New Message Reply Date view Thread view Subject view Author view
This archive was generated on Wed Nov 22 2000 - 20:23:46 Pacific Standard Time