Invalid URL

Invalid URL

Post by truc » Tue, 27 Nov 2001 16:13:25



Hi all,

when I used JDBC Driver sqlserver to connect to my Project
runing on Windowns2000 with dadabase SQL Server7.0 and
I have URL and Driver:

- URL :
jdbc:microsoft:sqlserver://192.168.1.113:1433/SALTECH
- Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

I have received a massage:

[Microsoft][SQLServer JDBC Driver] Unable to connect.
Invalue URL.

But If I use one Driver of the Weblogic for mssqlserver to
connect to my Project before and I connected to my
Project. after that
I have just used again with Driver mssqlServer(above) it
work look good. I don't understand this. the first I can't
connect to project by this Driver.

Thank for your instruction,
Truc

 
 
 

Invalid URL

Post by Usha » Tue, 27 Nov 2001 16:41:55


I am using an App Server and in my standalone class i get the same
connection as used by the AppServer.When there is any error at the
client,the SQLException thrown is :

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.setFetchSize(Unknown Source)

Could someone suggest why is this occuring.The connection is cloned in
the AppServer.
Thank u
Usha

 
 
 

Invalid URL

Post by Pan Chieh-Yin » Thu, 13 Dec 2001 18:03:21


Hi :

maybe you can try the URL :
jdbc:microsoft:sqlserver://192.168.1.113:1433;DatabaseName=SALTECH
instead of
jdbc:microsoft:sqlserver://192.168.1.113:1433/SALTECH

Best Reguards,
Pan



Quote:> Hi all,

> when I used JDBC Driver sqlserver to connect to my Project
> runing on Windowns2000 with dadabase SQL Server7.0 and
> I have URL and Driver:

> - URL :
> jdbc:microsoft:sqlserver://192.168.1.113:1433/SALTECH
> - Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

> I have received a massage:

> [Microsoft][SQLServer JDBC Driver] Unable to connect.
> Invalue URL.

> But If I use one Driver of the Weblogic for mssqlserver to
> connect to my Project before and I connected to my
> Project. after that
> I have just used again with Driver mssqlServer(above) it
> work look good. I don't understand this. the first I can't
> connect to project by this Driver.

> Thank for your instruction,
> Truc

 
 
 

1. JDBC getConnection invalid Oracle-URL

Hello,
I am trying to get this sample code running but I keep getting an Invalid
Oracle-URL Exception???

         Connection conn =

                                        "scott", "tiger");


there? I have tried the tnsnames.ora entry.

Alternately I have tried this sample code:
      Connection conn =


myhost)(protocol=tcp)(port=1521))            (connect_data=(sid=orcl)))",
"scott", "tiger");

With the same Exception occuring. What am I to put as "myhost" and what as
"orcl". I tried myhost = servername and orcl = tnsnames.ora-entry . This
doesn't seem consistent to me, as the servername is part of tnsnames.ora an
thus unnecessary. What would be the correct term to put there?

Are there any other possibilities for what may have caused this invalid
Oracle_url exception?

Answering any of the three questions would be most welcome.
Best regards and thank you for your patience, yours J?rn Propach.

P.S.
the relevant part of tnsnames.ora is
sa.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = wisou2.wiso.uni-goettingen.de)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = wisou2.wiso.uni-goettingen.de)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = pl)
    )
  )

2. Manual Batch Update...

3. [connectionopen(invalid instance()).]invalid connection

4. Regarding MCDBA Papers

5. invalid - invalid character error

6. Question concering Database synchronization (using CRecordset)

7. [ConnectionOpen (Invalid Instance()).]Invalid connection.

8. How make a given field "current"?

9. ejb deploy "service URL is invalid" problem

10. Using ADO.Recordset to OPEN a URL/How to "post" info to the url?

11. What is the best way to URL access ?

12. Request.QueryString in Stored Procedure (URL parameter) with asp