JDBC connections for clusterd SQL 2000 instances
Mon, 27 Aug 2007 22:06:44 -0400
Hello,
We have a Third party application that uses JDBC to connect to a database hosted on a SQL 2000 database server. No problem when we connect to a standalone database server. However, recently we copied our Production database to a Pilot db server which happens to be on a clustered SQL server that uses named ins ...
|
Authorization Error Using 1.2 CTP Driver
Mon, 27 Aug 2007 11:06:06 -0700
I've switched to using the new 1.2 CTP driver when I run locally. When
starting Tomcat, I"m getting
10:55:17,859 INFO JDBC Driver:
com.microsoft.sqlserver.jdbc.SQLServerDriver, major version: 1, minor
version: 2
Aug 27, 2007 10:55:18 AM com.microsoft.sqlserver.jdbc.AuthenticationJNI
<clinit>
WARNI ...
|
Connection Reset Error with SQLState() = 08S01
Thu, 23 Aug 2007 14:46:01 -0700
The stack trace is
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.flush(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSWriter.endRequest(Unkn ...
|
Odd JDBC behavior with LIKE ... ESCAPE query...
Fri, 17 Aug 2007 14:35:41 -0700
Hi all. I am not sure this is a JDBC problem or not...
I will attach a self-contained JDBC program that shows
the issue.
I want to find data that has a backslash followed by
an underscore, but not data that simply has a backslash.
I have data with and without, but my query with
LIKE ... ESCAPE '\' doesn' ...
|
driver fails to retrieve data via prepared statement
Wed, 15 Aug 2007 14:29:17 -0700
Hi all.
Here's a program that creates a temp table,
inserts a row, selects the data out successfully
with a plain statement, but can't select the
data out via a PrepredStatement:
Output:
C:\new_ms_driver>java foo
Driver version is 1.1.1320.0
DBMS version is 8.00.818
ran first query
Did I get my data? tru ...
|
instjdbc.sql and sqljdbc.dll
Wed, 14 Mar 2007 13:12:05 -0700
Does anyone know where one can find specific, detailed documentation on the
xp_ extended stored procedures from the instjdbc.sql file for SQL Server 2000?
Thanks! ...
|
re:Cant_find_a_driver_this_site_will_Ask_MDREPAIRS
Tue, 13 Mar 2007 00:06:28 GMT
Cant_find_a_driver_this_site_will_Email_Mark
http://www.mdrepairs.com
...
|
|
|
2005 JDBC driver / SQL Server 2000 / "sleeping" user db connection
Mon, 12 Mar 2007 12:03:05 -0700
Our Web application uses Tomcat 5.5 with the 2005 JDBC driver and SQL Server
2000 on the backend. We have had problems with the database connection being
lost (between database and web servers) and having to restart Tomcat (and
Apache). We have also noticed in SQL Server 2000 in the Current Activity -
Pr ...
|
Codepage 850 and MS SQL 2005 JDBC 1.1 Driver
Thu, 8 Mar 2007 16:08:18 -0800
This apparently is not supported in 1.1 (using JDK 1.4):
(com.microsoft.sqlserver.jdbc.SQLServerException)
com.microsoft.sqlserver.jdbc.SQLServerException: Codepage 850 is not
supported by the Java environment.
Our datatbase is required to use this collation, so we can't change it.
Any ideas/workaroun ...
|
i will find drivers for you
Wed, 7 Mar 2007 15:03:20 +0000
i will find drivers for you at mdrepairs
...
|
