Sunday, February 26, 2012

error 3146

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)
>
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.
>
>
|||BINGO~!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:59C18CE9-04B5-49E1-87AB-4EA2DAD4E977@.microsoft.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...
>

No comments:

Post a Comment