Skip to Content
avatar image
Former Member

Problem with Creating a scenario using MSSQL Server 2000.

Hello,

I want to create a scenario from JDBC to FILE where i am using the database as MS SQL Server 2000.

I want the appropriate URL and Driver parameters in order to run the scenario in my local machine.

Thanks,

Soorya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 07, 2008 at 10:12 AM

    Hi,

    First you need to deploy the appropriate DataBase drivers on system.But be sure that in SQL Server Athuneticatin mode is set to "mixed mode" Right click you DBMS server Eterprise Manager Tool and select "properties >Securtiy ->Choose "SQL Server windows" authenticaion.

    Please let me know if you have any queries..

    Regards,

    Chandu.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I was able to get through that problem of URL and JDBC Driver.

      But now i am facing new problem,

      like,

      Database-level error reported by JDBC driver while executing statement 'SELECT * FROM EXAMPLE WHERE PROCESSED = 'NO''. The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'EXAMPLE'.'. For details, contact your database server vendor.

      Can you please help me out in this regard.

      Thanks,

      Soorya