Results 1 to 5 of 5

Thread: VB SQL error message

  1. Jul 11th, 2001, 06:26 PM #1
    yakilov
    yakilov is offline

    Thread Starter
    New Member
    Join Date
    May 2001
    Posts
    7

    VB SQL error message

    If anybody knows, what does that error message means, please, tell.
    I run vb program, which use a Command object to run a SP and I am getting an error message:

    "Invalid character for cast specification"
    Reply With Quote Reply With Quote
  2. Jul 11th, 2001, 06:40 PM #2
    chrisjk
    chrisjk is offline
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    what's the SQL?
    Reply With Quote Reply With Quote
  3. Jul 11th, 2001, 06:44 PM #3
    chrisjk
    chrisjk is offline
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    This may be of interest http://support.microsoft.com/support...SRCH&SPR=MSALL
    Reply With Quote Reply With Quote
  4. Jul 11th, 2001, 06:49 PM #4
    Mongo
    Mongo is offline
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482
    It's difficult to say specifically what's causing your error from
    what info you've supplied, but you can safely assume either
    an input or output parameter to your SP is defined as the
    incorrect datatype.

    Also, FWIW, in SQLServer v7 without SP2 installed, a negative
    zero (-0) result will cause this error.
    Reply With Quote Reply With Quote
  6. Jul 12th, 2001, 08:04 AM #5
    Gary Juleff
    Gary Juleff is offline
    Junior Member
    Join Date
    Oct 2000
    Location
    High Wycombe, UK
    Posts
    25
    Its a syntax problem. Try placing quotes around your variable

    Regards....

    Gaz
    Ciao.........Gary

    VB6, SQL Server 7, Access 97
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width