Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    6

    Unanswered: Microsoft SQL Server 2005 JDBC Connection Error

    I am running Crystal Reports XI. I am trying to connect to a Microsoft SQL Server 2005 database via JDBC connection that is located in a named instance on another computer. I downloaded the Miscrosoft SQL Server JDBC Driver. I placed the sqljdbc.jar file in C:\Program Files\Common Files\Business Objects\3.0\java\lib\external. I added the following to the Classpath in CRConfig.xml :

    C:\Program Files\Common Files\Business Objects\3.0\java\lib\external\sqljdbc.jar;

    Then I tried to setup a new connection in Crystal Reports. I entered the following data:

    Connection URL: jdbc:microsoft:sqlserver://LSFM90:1433
    Database Classname: com.microsoft.jdbc.sqlserver.SQLServerDriver
    User ID: xxxx
    Password: xxxx

    When I click Finish, I get the following error message:

    Failed to open the connection. Details: JDBC driver not found.



    What am I doing wrong?? Also, where do I enter the instance name of the SQL Server database??-- normally I connect to server LSFM90\SSLSFM90.


    ANy help anyone has would be great

    Thanks

  2. #2
    Join Date
    Feb 2009
    Posts
    6
    Anyone have any help they can offer?? I really, really need to connect to a MSSQL 2005 db using Crystal Reports and it is not working.

    Thanks

Posting Permissions

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