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.

Hi

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

"Swami" <chamuramya@gmail.com> schrieb im Newsbeitrag
news:f9704653.0407110508.1c2b7e3e@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.

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" <chamuramya@gmail.com> wrote in message
news:f9704653.0407110508.1c2b7e3e@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.

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!

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!

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" <coowboy@yahoo.com> wrote in message
news:40f1eaf8$0$16455$c397aba@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!

Hi

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

John

"Dallas Cowboy" <coowboy@yahoo.com> wrote in message
news:40f1eaf8$0$16455$c397aba@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!