• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Problem connecting to SQL Server 2005 developer edtion from JRun 3.1

Environment:

IIS 6.0 as Web Server
ASP
JRUN 3.1 as App Server
SQL Server 2005

We are using an ASP application for the authentication and Java / JRUN 3.1 for reporting application.

I have a problem in connecting to the SQL Server 2005 from the Java (XSLT) code. This works fine when I use SQL Server 2005 standard edition (a copy of production). But when I try with the developer edition of SQL Server 2005, on my local machine (which I will be using temporarily), it is not connecting to the database. The error I am getting is "<message><![CDATA[Opening DB Connection develsql Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver URL: jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME]]></message>".

Using the database parameters like server name, database name, user name and password, in Microsoft SQL Server Management Studio, I am able to connect.

The developer edition should be same as enterprise edition and it should have all the features of the standard edition.

Can someone suggest what I need to look into or whether I need to install any JDBC drivers?

Thanks
Sri.
0
sriniram
Asked:
sriniram
  • 4
  • 4
1 Solution
 
rboyd56Commented:
You are right there is not difference between the Standard Edition and Developer in this respect.

This is just a shot in the dark but have you enabled TCP/IP and named pipes, using the SQL Server Configuration Tool, on the developer instance?
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> This is just a shot in the dark but have you enabled TCP/IP

That's could be missing is what is my guess too
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> whether I need to install any JDBC drivers?

Not if you are using this one:

http://www.microsoft.com/downloads/details.aspx?familyid=6d483869-816a-44cb-9787-a866235efc7c&displaylang=en
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
sriniramAuthor Commented:
Generally I will not install any JDBC driver separately. It works when I use the standard edition (copy of productiion).

I have the productiion environments with standard edition and developer edition. How I can check whether the JDBC driver is installed?

I think I have enabled the TCP/IP and names pipes. When I configure theh ODBC data source, I can see both of these enabled. Is there any other way I can check these?

Thanks
Sri
0
 
sriniramAuthor Commented:
Using the the link you gave, I created the JDBC driver but still the connectivity is not taking place. I removed the developer edition  and installed the standard edition of SQL Server 2005 and it works fine even without the JDBC driver.

Then again i reverted back tot developer edition of SQL Server 2005, I am getting the same problem.

The error is:

<message><![CDATA[Opening DB Connection develsql Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver URL: jdbc:microsoft:sqlserver://ServerName:1433;DatabaseName=dbName]]></message>
</entry><entry><date>30 Mar 2007 10:51:19,906</date><priority>ERROR</priority><ndc></ndc><thread>jcp-0</thread><category>com.JLT.embryo.embryoSql</category><location>com. JLT. embryo.embryoSql.buildDOMfromSQL (embryoSql.java:202)</location>
<message><![CDATA[A SQL Exception occurred ([Microsoft][SQLServer JDBC Driver]Error establishing socket.), the SQL was getReportList 'P123456', '8%0A'  ]]></message>
</entry><entry><date>30 Mar 2007 10:51:19,906</date><priority>ERROR</priority><ndc></ndc><thread>jcp-0</thread><category>com.JLT.embryo.embryoSql</category><location>com.JLT.embryo.embryoSql.buildDOMfromSQL (embryoSql.java:203)</location>
<message><![CDATA[Stack Trace: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.

Any suggestions plesae?

Thanks
Sri
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> I will not install any JDBC driver separately

You need to install the correct JDBC driver for the database.

>> it works fine even without the JDBC driver.

Then JRun already has a JDBC driver.

>> Any suggestions plesae?

Did you check if TCP/ IP is enabled on the DB?
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> I created the JDBC driver but still the connectivity is not taking place.

Did you add it to JRun's classpath?
0
 
sriniramAuthor Commented:
I reinstalled everything and it is working fine.

Thanks for the support.
Sri
0
 
sriniramAuthor Commented:
This problem is being solved by re-installing the sql server.

I request the moderator to close this item.

Thanks
Sri
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now