|
Home > Archive > MS SQL Server > March 2006 > Re: The text, ntext, and image data types cannot be compared or so
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: The text, ntext, and image data types cannot be compared or so
|
|
| John Bell 2006-03-05, 8:24 pm |
| Hi Nathon
Without knowing the SQL that they are sending to the database, it is a bit
of a black box. A simple insert statement should not be a problem, therefore
it looks like they may be doing other things in their code that is causing
the problem. You can use SQL profiler to show what statements are being sent
and this may help when they you do eventually get through to their support.
John
"Nathon Jones" wrote:
> I'll be honest with you John, I am using a Dreamweaver Extension (WA_eCart)
> to handle the INSERT to database, and I don't have a great knowledge of
> MSSQL so I'm unable to truthfully answer your question.
>
> The extension takes form data from a page on a different server, and then is
> supposed to INSERT that data into our MSSQL database.
>
> We don't understand the error and there are no mentions of this in the
> extension support networks - oh, and they don't work Saturday's!
>
> Thanks for trying to help. What exactly does this error mean though? That
> we are trying to insert the wrong type of data into a field? We've double
> checked that, and most of our fields are nvarchar.
>
> Thanks.
> Nath.
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:78FBC94B-F802-4ED3-9C67- 781787E394A3@microso
ft.com...
>
>
>
| |
| Nathon Jones 2006-03-05, 8:24 pm |
| John, would it help if I posted our ASP/VB code? (I assume the SQL is in
there?)
Is SQL profiler part of Enterprise Manager?
Thanks
Nath.
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:6CAF27E5-2BE7-4EC0-8997- 3529C3E3A6F6@microso
ft.com...[color=darkred]
> Hi Nathon
>
> Without knowing the SQL that they are sending to the database, it is a bit
> of a black box. A simple insert statement should not be a problem,
> therefore
> it looks like they may be doing other things in their code that is causing
> the problem. You can use SQL profiler to show what statements are being
> sent
> and this may help when they you do eventually get through to their
> support.
>
> John
>
> "Nathon Jones" wrote:
>
| |
| John Bell 2006-03-06, 7:23 am |
| Hi Nathon
I don't think the code would help in this instance as I assume that all the
SQL is called from your third party add in.
SQL profiler is a tool that comes with SQL Server, it is not part of EM but
it can be accessed from the tools menu. You should also find it in the SQL
Server program group off the start menu.
As an introduction you may want to look at Tony's webcast at
http://www.sqlserverfaq.com/control...br />
50420.wmv
John
"Nathon Jones" wrote:
> John, would it help if I posted our ASP/VB code? (I assume the SQL is in
> there?)
>
> Is SQL profiler part of Enterprise Manager?
>
> Thanks
> Nath.
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:6CAF27E5-2BE7-4EC0-8997- 3529C3E3A6F6@microso
ft.com...
>
>
>
|
|
|
|
|