SPONSORS:






User Tag List

Results 1 to 3 of 3

Thread: SQL Server

  1. #1
    bjc
    bjc is offline
    Member
    Join Date
    Jan 2000
    Location
    CT
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server

    I am using a SQL Server 7.0 Data Base to store the results of a script. If the results conform to my check constraints and or triggers in SQL Server, the data is written to the table without any problems. When data does not conform to these rules, I raise a user defined error message.

    When this situation occurs, I do not receive the error message in Silk. I get a message that states the following:
    *** Error: (HY007) [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared
    If I perform the query through SQL Server, I get the correct message.

    Is this a SQL Server 7.0 issue or is it a SilkTest issue? Any suggestions would be appreciated.

  2. #2
    Member
    Join Date
    Oct 2000
    Location
    South San Francisco, CA, USA
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Server

    I don't know if this is relevant to the error you are getting but I just discovered that there are some data exchange problems between Silk and ODBC/SQL7. I received a "cursor state" error when I passed a stored procedure command from Silk to SQL 7 via ODBC. I had no problem when the string was translated into a pure SQL select statement. Your error may have something to do with incompatible datatypes between the two environments...just a guess though.

    Good luck.

  3. #3
    Senior Member
    Join Date
    Jul 1999
    Location
    Burlingame CA 94010
    Posts
    502
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Server

    Why not check the data for your rules in SilkTest before sending it to the DB?

    ------------------
    John W Green
    jwgreen@automationexpertise.com
    http://www.automationexpertise.com

 

 

Posting Permissions

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

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 12:18 PM.

Copyright BetaSoft Inc.