Running SQL Server 2005 SP2 and using named instances. I have an
application which uses JDBC to connect to my SQL server. Connectivity using
ODBC works just fine as I can test it successfully using a UDL file.
However, this application fails to connect to my server every time and I am
not sure what troubleshooting tool I can use to narrow the problem. To
clarify, I can connect remotely to my SQL server using a UDL file by any
combination of name or IP, named pipes or TCP/IP, SQL or Windows
Authentication. In sum, I cannot connect to my SQL 2005 server using JDBC -
can any diagnostic tool tell me what the problem is?
Re: sendStringParameterAsUnicode: How to insert unicode data corre ... After checking with Microsoft it turns out that transmitting Unicode... requires a change in the data format sent to the JDBC Receiver channel.... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ... (microsoft.public.sqlserver.jdbcdriver)
RE: BUG: JDBC connection disconnected, cant reconnect ... we've replaced the MS JDBC driver with jTDS JDBC driver, ... There is really nothing the driver can do that will take down SQL Server.... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database... (microsoft.public.sqlserver.jdbcdriver)
RE: SQL Server SP3a via JDBC SP2 ... | Subject: RE: SQL Server SP3a via JDBC SP2... | Content-Type: text/plain; ... | Carb Simien, thanks for your reply, but the query... (microsoft.public.sqlserver.jdbcdriver)
RE: Installing SS 2005 JDBC Driver 1.1 ... SQL Server 2005 JDBC Driver\sqljdbc_1.1) ... I see the .jar file but I have no idea how/where I am to define the ... Panel that a SQL Server JDBC is installed. ... How do I install this? ... (microsoft.public.sqlserver.jdbcdriver)
RE: JDBC - Cant get unicode with ResultSet.getString() ... The data is correct in Sql Server - I viewed it there. ... And it is the jdbc getString() that returns it wrong, ... So for somereason the Microsoft Sql Server JDBC driver is not returning ... (microsoft.public.sqlserver.odbc)
