Debugging Query Analyzer & dates

Two of the sprocs input parameters are datetime. When I try to debug the
sproc SQL Server errors with
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
I've tried everything (except of course what might actually work).
Help!!!
regards
Frank Ashley
Try any of the ODBC styles, as defined in:
http://msdn.microsoft.com/library/en...on_03_04l0.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Frank Ashley" <fashley_NO_SPAM@.clusterseven.com> wrote in message
news:uG9xu73gEHA.632@.TK2MSFTNGP12.phx.gbl...
> Two of the sprocs input parameters are datetime. When I try to debug the
> sproc SQL Server errors with
>
> [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
> specification
>
> I've tried everything (except of course what might actually work).
>
> Help!!!
> regards
> Frank Ashley
>
|||That worked first time.
Thanks
Frank Ashley
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OZ0mPj4gEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Try any of the ODBC styles, as defined in:
> http://msdn.microsoft.com/library/en...on_03_04l0.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Frank Ashley" <fashley_NO_SPAM@.clusterseven.com> wrote in message
> news:uG9xu73gEHA.632@.TK2MSFTNGP12.phx.gbl...
>

Debug stored procedure in query analyzer

Trying to use Debug feature in query analyzer -- on some systems I get the
message
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
There's nothing wrong with the stored procedure. If I have this problem, it
happens with all stored procedures except those that have no parameters. If
there are no parameters, the message doesn't show, but debug still doesn't
work properly.
Carole
You may have to specify date parameter values in a specific format. For
example, see:
http://groups-beta.google.com/group/...f1164645c4a4f9
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CDuttlinger" <h2oPower@.newsgroup.nospam> wrote in message
news:6E2C1A97-A747-4BC6-979B-CE090C67B6A4@.microsoft.com...
> Trying to use Debug feature in query analyzer -- on some systems I get the
> message
> [Microsoft][ODBC SQL Server Driver]Invalid character value for cast
> specification
> There's nothing wrong with the stored procedure. If I have this problem,
> it
> happens with all stored procedures except those that have no parameters.
> If
> there are no parameters, the message doesn't show, but debug still doesn't
> work properly.
> --
> Carole
|||That doesn't explain why debug works on some computers and not others, with
the same stored procedures.
Carole
"Narayana Vyas Kondreddi" wrote:

> You may have to specify date parameter values in a specific format. For
> example, see:
> http://groups-beta.google.com/group/...f1164645c4a4f9
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CDuttlinger" <h2oPower@.newsgroup.nospam> wrote in message
> news:6E2C1A97-A747-4BC6-979B-CE090C67B6A4@.microsoft.com...
>
>
|||Perhaps the debugger does something to the input, where what it does is dependent on Regional
Settings in windows?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"CDuttlinger" <h2oPower@.newsgroup.nospam> wrote in message
news:ED00A9CE-A366-4F9D-B60A-7DE5F090302E@.microsoft.com...[vbcol=seagreen]
> That doesn't explain why debug works on some computers and not others, with
> the same stored procedures.
> --
> Carole
>
> "Narayana Vyas Kondreddi" wrote: