Re: Problem with MSSQL SPRINTA 2000 JDBC Driver

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 07/11/04

  • Next message: Vasanth: "Accessing MS-Access from Solaris and AIX" 
    Date: Sun, 11 Jul 2004 21:39:16 GMT

    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.com...
    > 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.

  • Next message: Vasanth: "Accessing MS-Access from Solaris and AIX"

    Relevant Pages

    • RE: MBSA and MSs attempts at "security"
      ... >the port status of TCP and UDP ports on a computer you choose. ... you can also query an LDAP service. ... LDAP query and interpret an LDAP server's response to ...
      (Focus-Microsoft)
    • Re: Corstabquery or normal query
      ... You can create the crosstab similar to the suggestion by John. ... church, also church elders, we have many elders, only 1st elder is one person. ... I would first build a query to get the data ...
      (microsoft.public.access.reports)
    • Windows Service Project
      ... I've started my first practice windows service project in C#, ... there are three key moments which prevent me from programming such ... How do I make the service listen on any port? ... What is the event that is raised, when some query ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Creatinig a database to update in alphabetical order
      ... John M. it is like you are reading my mind, ... know I am a movie fanatic. ... > should not be routine) displayed as a query datasheet. ... > Keyword ...
      (microsoft.public.access.gettingstarted)
    • Re: Simply adding two fields
      ... Thank you, John. ... In an update query you update the field to the calculation. ... field before you add it to the master field you will have a problem. ... I'm reading a transaction file of widgets delivered and I want to update ...
      (microsoft.public.access.queries)