Solved

Problem connecting to SQL Server 2005 developer edtion from JRun 3.1

Posted on 2007-03-29
9
293 Views
Last Modified: 2013-12-02
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
Comment
Question by:sriniram
  • 4
  • 4
9 Comments
 
LVL 16

Expert Comment

by:rboyd56
ID: 18816984
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
 
LVL 30

Expert Comment

by:Mayank S
ID: 18818599
>> 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
 
LVL 30

Expert Comment

by:Mayank S
ID: 18818607
>> 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
 

Author Comment

by:sriniram
ID: 18823430
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:sriniram
ID: 18824416
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
 
LVL 30

Expert Comment

by:Mayank S
ID: 18827672
>> 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
 
LVL 30

Expert Comment

by:Mayank S
ID: 18827676
>> I created the JDBC driver but still the connectivity is not taking place.

Did you add it to JRun's classpath?
0
 

Author Comment

by:sriniram
ID: 19100783
I reinstalled everything and it is working fine.

Thanks for the support.
Sri
0
 

Accepted Solution

by:
sriniram earned 0 total points
ID: 19779910
This problem is being solved by re-installing the sql server.

I request the moderator to close this item.

Thanks
Sri
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now