473,326 Members | 2,173 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,326 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 7239
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 meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.