Re: [Emerald] Help SQL Errors

New Message Reply Date view Thread view Subject view Author view
Glen Harvy (glen@aquarius.com.au)
Thu, 23 Nov 2000 15:55:51 +1100



Message-Id: <4.3.1.0.20001123155518.00b15d98@mail.aquarius.com.au>
Date: Thu, 23 Nov 2000 15:55:51 +1100
From: Glen Harvy <glen@aquarius.com.au>
Subject: Re: [Emerald] Help SQL Errors

Sorry - I thought I was in another listserve!!!!

Good luck ..

At 15:35 23/11/2000, you wrote:

>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
>------------
>
>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

.



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