473,381 Members | 1,602 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,381 software developers and data experts.

Problem with MSSQL SPRINTA 2000 JDBC Driver

Hi,
I have installed MQ SQL Server 2000 on my laptop and trying to use
SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I
wrote a sample Java app to test the connection and I get the following
error trace,

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
SQLException: SQLState(08S01)
{sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,
password=wasfe, host=US0211737-WP01}
getConnection failed: com.inet.tds.SQLException: Connection refused:
connect
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.inet.tds.TdsDriver.a(Unknown Source)
at com.inet.tds.TdsDriver.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

I tried searching the web and product doc. Nothing seems to help me.
Has anyone come across similiar problems? Any pointers will be
appreciated also.

Thanks,
Swami.
Jul 20 '05 #1
6 7242
Hi

you should print your code ,maybe you did anything wrong....

"Swami" <ch********@gmail.com> schrieb im Newsbeitrag
news:f9**************************@posting.google.c om...
Hi,
I have installed MQ SQL Server 2000 on my laptop and trying to use
SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I
wrote a sample Java app to test the connection and I get the following
error trace,

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
SQLException: SQLState(08S01)
{sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,
password=wasfe, host=US0211737-WP01}
getConnection failed: com.inet.tds.SQLException: Connection refused:
connect
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.inet.tds.TdsDriver.a(Unknown Source)
at com.inet.tds.TdsDriver.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

I tried searching the web and product doc. Nothing seems to help me.
Has anyone come across similiar problems? Any pointers will be
appreciated also.

Thanks,
Swami.

Jul 20 '05 #2
Hi

Have you checked that you are using the TCP/IP protocol and given port?
Check the client configuration and see if you can connect using Query
Analyser.

John

"Swami" <ch********@gmail.com> wrote in message
news:f9**************************@posting.google.c om...
Hi,
I have installed MQ SQL Server 2000 on my laptop and trying to use
SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I
wrote a sample Java app to test the connection and I get the following
error trace,

DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
SQLException: SQLState(08S01)
{sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,
password=wasfe, host=US0211737-WP01}
getConnection failed: com.inet.tds.SQLException: Connection refused:
connect
com.inet.tds.SQLException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.inet.tds.TdsDriver.a(Unknown Source)
at com.inet.tds.TdsDriver.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

I tried searching the web and product doc. Nothing seems to help me.
Has anyone come across similiar problems? Any pointers will be
appreciated also.

Thanks,
Swami.

Jul 20 '05 #3
John,
Good catch. I did try connecting using the client config. My server name
is US0211737-WP01. When I tried to specify that as my SQL server name,
it will not connect. But when I appended my instance name (PALYDB) like
US0211737-WP01\PLAYDB it connected. I tried the same thing in the JDBC
url, jdbc:inetdae:US0211737-WP01\\PLAYDB, I get the message,
java.net.UnknownHostException: US0211737-WP01\PLAYDB

Any help??

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #4
import java.sql.*; // JDBC package

public class PooledDriver
{

public static void main(String[] argv){
String url =
"jdbc:inetpool:inetdae7:US0211737-WP01:1433"; // use your hostname and
port number here
String login = "sa"; // use your login here
String password = "wasfe"; // use your password here

try {
DriverManager.setLogStream(System.out); // to create more info
// for technical support

Class.forName("com.inet.pool.PoolDriver").newInsta nce();
//or
//new com.inet.pool.PoolDriver();
//set a timeout for login and query
DriverManager.setLoginTimeout(10);
//open a connection to the database
Connection connection =
DriverManager.getConnection(url,login,password);

//to get the driver version
DatabaseMetaData conMD = connection.getMetaData();
System.out.println("Driver Name:\t" +
conMD.getDriverName());
System.out.println("Driver Version:\t" +
conMD.getDriverVersion());

//select a database
connection.setCatalog( "SBM_1_0" );

//create a statement
Statement st = connection.createStatement();

//execute a query
ResultSet rs = st.executeQuery("SELECT * FROM sysusers");

// read the data and put it to the console
while (rs.next()){
for(int j=1; j<=rs.getMetaData().getColumnCount(); j++){
System.out.print( rs.getObject(j)+"\t");
}
System.out.println();
}
//close the objects
st.close();
connection.close();

} catch(Exception e) {
e.printStackTrace();
}
}
}

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #5
The product doc on the inetsoftware web site indicates that a named instance
should be specified in the form 'hostname/instancename'. Note the forward
slash instead of the customary back slash.

If that doesn't work, you might try contacting the vendor.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Dallas Cowboy" <co*****@yahoo.com> wrote in message
news:40**********************@news.newsgroups.ws.. .
John,
Good catch. I did try connecting using the client config. My server name
is US0211737-WP01. When I tried to specify that as my SQL server name,
it will not connect. But when I appended my instance name (PALYDB) like
US0211737-WP01\PLAYDB it connected. I tried the same thing in the JDBC
url, jdbc:inetdae:US0211737-WP01\\PLAYDB, I get the message,
java.net.UnknownHostException: US0211737-WP01\PLAYDB

Any help??

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #6
Hi

If Dan's option doesn't work then creating an alias may work.

John

"Dallas Cowboy" <co*****@yahoo.com> wrote in message
news:40**********************@news.newsgroups.ws.. .
John,
Good catch. I did try connecting using the client config. My server name
is US0211737-WP01. When I tried to specify that as my SQL server name,
it will not connect. But when I appended my instance name (PALYDB) like
US0211737-WP01\PLAYDB it connected. I tried the same thing in the JDBC
url, jdbc:inetdae:US0211737-WP01\\PLAYDB, I get the message,
java.net.UnknownHostException: US0211737-WP01\PLAYDB

Any help??

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 20 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Swami | last post by:
Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPARTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I...
1
by: Prithpal | last post by:
Please help!!! We had a sql server 7 DB, with a char 8 field, in which some of the data was only 7 characters in length. Via a type 4 JDBC driver, we got back a NON space padded String. This...
4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We...
1
by: yongsing | last post by:
I have a Windows 2000 Server machine that runs DB2 UDB v7 fixpak 11. I also have a Java program that uses JDBC to insert data into the database. Sometimes, the program encounters SQL0302N error...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
1
by: tom.eeraerts | last post by:
Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i extracted a small piece of code and debugged the...
9
by: dunleav1 | last post by:
Does enabling/disabling Data Execution Prevention have a performance impact on SQL 2000 or SQL 2005? For SQL best performance - how should I configure for: Processor Scheduling: Programs or...
2
by: prasath03 | last post by:
Hi, I am using Microsoft SQL Server 2000 Driver for JDBC to connect to SQL Sever 2000. It is just a test application whether its connect or not. But I got the following errors: Error is:...
1
by: manjava | last post by:
Hello, i have a class java conncet to database mysql when i execute the classe alone so execute but when i want to execute this link on web...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.