com.microsoft.sqlserver.jdbc.SQLServerException: Invalid O..

we are trying to fetch records using the select statement from the SQL Server
2005 Server using the jdbc driver 1.2 . but when the batch is executed,
getting the error ".com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
object name".
connection url we are using is
DB_URL=jdbc:sqlserver://172.23.51.182\\devenv:1253.


Earlier we are using SQL Server 2000 and the batch is running fine.
the connection url is
DB_URL=jdbc:microsoft:sqlserver://172.23.51.47:1433

would like to know whether there is any difference with the connection url.

any help in this regard would be appreciable.

Regards,
Murthy.

The connection url that you have seems to be correct, but for testing purpose
can you try the following :

jdbc:sqlserver://172.23.51.182;instanceName=devenv;portNumber=1253;

Also your 2000 connection string does not seem to have an instance . So is
devenv your instance name ?

--
Bindesh Vijayan[MSFT]


"Murthy" wrote:

> we are trying to fetch records using the select statement from the SQL Server
> 2005 Server using the jdbc driver 1.2 . but when the batch is executed,
> getting the error ".com.microsoft.sqlserver.jdbc.SQLServerException: Invalid
> object name".
> connection url we are using is
> DB_URL=jdbc:sqlserver://172.23.51.182\\devenv:1253.
>
>
> Earlier we are using SQL Server 2000 and the batch is running fine.
> the connection url is
> DB_URL=jdbc:microsoft:sqlserver://172.23.51.47:1433
>
> would like to know whether there is any difference with the connection url.
>
> any help in this regard would be appreciable.
>
> Regards,
> Murthy.