Solved

Problem connecting to SQL Server 2005 developer edtion from JRun 3.1

Posted on 2007-03-29
9
294 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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
 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

831 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