Re: Bug with instanceName property?
- From: "Angel Saenz-Badillos[MS]" <angelsa@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 16:59:18 -0800
The doc example is unfortunatelly wrong, it should use ";" instead of "/" to
separate instanceName and user. As far as the last connection string, the
first thing that stands out is that you are specifying a port number (1433).
When you specify a port it will take precedence over the instance name.
(Note, I am actually not sure of the behavior of the beta 2 driver here,
this will be true for the final version shipping this month).
Looking at the connection string another thing stands out. Due to customer
feedback we have decided to rename forwardReadOnlyMethod back to its
previous name, selectMethod. Apparently nobody has any idea of what the new
name meant. You will need to make sure to update this when moving your code
to the final driver. This is important because you _will not_ get an
exception for connection key value pairs that are not understood by the
driver. I am not a big fan of silently ignoring key value pairs but this
change was necesary for certification purposes.
--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/
"Wes Clark" <WesClark@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C247C15-D945-4D81-A646-B41F20C11F50@xxxxxxxxxxxxxxxx
>I can only get a connection to server with a non-default instance name
>using
> the
> jdbc:sqlserver://ITH\SQLSERVER2005:1433;forwardReadOnlyMethod=direct;databaseName=cc;user=sa;password=123
> syntax. This connection succeeds.
> If I try to use
> jdbc:sqlserver://ITH:1433;instanceName=SQLSERVER2005/user=sa;forwardReadOnlyMethod=direct;databaseName=cc;password=123
> following the example in the docs delivered with the Beta 2, I get
> com.microsoft.sqlserver.jdbc.SQLServerException: Failed
> Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for
> user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> If I use the syntax
> jdbc:sqlserver://ITH:1433;instanceName=SQLSERVER2005;user=sa;forwardReadOnlyMethod=direct;databaseName=cc;password=123
> I get
> com.microsoft.sqlserver.jdbc.SQLServerException: Failed
> Logon:com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open
> database
> requested in login 'cc'. Login fails.
>
> Any suggestions?
.
- Prev by Date: RE: can i use setString() for a text type column in the prepareStateme
- Next by Date: Re: Encrypted JDBC between JAVA Middletier and MSSQL Server
- Previous by thread: RE: can i use setString() for a text type column in the prepareStateme
- Next by thread: Re: Bug with instanceName property?
- Index(es):
Relevant Pages
|
