Home > Archive > MS SQL Server > November 2006 > error 3146









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 error 3146
BrianMultilLanguage

2006-11-07, 7:12 pm


Only one user has the problem.
I have given them a new copy of the switchboard but same startup error.
Thank you for your help.

>
> IOSDSQL 664-964 ENTER SQLSetStmtOption
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C
>
> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
> (SQL_SUCCESS)
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C (BADMEM)
>
> IOSDSQL 664-964 ENTER SQLExecDirect
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
>
> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
> (SQL_ERROR)
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
>
> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax near '.'. (170)
>



Dan Guzman

2006-11-07, 7:12 pm

Check to make sure QUOTED_IDENTIFIER is ON.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"BrianMultilLanguage" <brian@clilang.com> wrote in message
news:12kv1p37855g42@
corp.supernews.com...
>
> Only one user has the problem.
> I have given them a new copy of the switchboard but same startup error.
> Thank you for your help.
>
>
>


BrianMultilLanguage

2006-11-08, 7:12 pm

BINGO~!

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:59C18CE9-04B5-49E1-87AB- 4EA2DAD4E977@microso
ft.com...
> Check to make sure QUOTED_IDENTIFIER is ON.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "BrianMultilLanguage" <brian@clilang.com> wrote in message
> news:12kv1p37855g42@
corp.supernews.com...
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com