jSQLConnect is good. Check www.j-netdirect.com
Jack Lee
-Original Message-
From: ³¯¬Ó¤å [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 25, 2001 12:40 AM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
There is a JDBC driver for MS-SQL in IBM WebSphere. Maybe
tired of this kind of argument.
get a life!!!
-Original Message-
From: Darth Darknerd [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 24, 2001 3:29 PM
To: Tomcat Users List
Subject: Re: [Offtopic] RE: JDBC Driver for MS SQL Server
I wouldn't know about extensive QA process
I wouldn't know about extensive QA process or the terrorist thing.
Microsoft ships with thousands of known bugs, and even QA still misses
some huge bugs, and also security type issues are just not addressed in QA.
(This coming from previous experience working for QA at Microsoft in
I have a question...
Isn't there some TDS driver out there. I remember someone was working on
a generic TDB-ODBC driver to Sybase/MS-SQL using an open source TDS
library, and I vaguely remember coming across info about a JDBC-TDS
library.
Anybody can point me in the right direction, it be
There is a JDBC driver for MS-SQL in IBM WebSphere. Maybe you counld try
it.
Good Luck.
-Original Message-
From: Darth Darknerd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 25, 2001 6:32 AM
To: Tomcat Users List
Subject: Re: JDBC Driver for MS SQL Server
I have
Users List [EMAIL PROTECTED]
Sent: Tuesday, December 25, 2001 4:02 AM
Subject: Re: JDBC Driver for MS SQL Server
I have a question...
Isn't there some TDS driver out there. I remember someone was working on
a generic TDB-ODBC driver to Sybase/MS-SQL using an open source TDS
library, and I
TOMCAT_HOME/lib
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:30 AM
To: '[EMAIL PROTECTED]'
Subject: JDBC Driver for MS SQL Server
Hi,
I am using Tomcat 3.2.1. I downloaded the JDBC Driver for MS and Installed
it. But I got error:
My suggestion: DUMP the ms driver!!!
Another good one is from www.j-netdirect.com
They have a complete JDBC 2.0 complaint jdbc-odbc driver. This will allow you to work
with SQL Server or access from linux, solaris or windows.
Driver is called JDataConnect. We use that here. Very flexible,
You can find out the best driver but the location is $TOMCAT_HOME/lib
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:35 AM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
My suggestion: DUMP the ms driver
e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
thanks for your help
Jack
-Original Message-
From: Guido Medina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10:31 AM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS
driver from www.j-netdirect.com rocks.
- John
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 9:35 AM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
My suggestion: DUMP the ms driver!!!
Another good one is from
They have a complete JDBC 2.0 complaint jdbc-odbc driver.
This will allow you to work
with SQL Server or access from linux, solaris or windows.
Be aware that the jdbc-odbc bridge is serialised (cos odbc is
single-threaded). So if you want multiple concurrent accesses then that
isn't an
now.
Your welcome (you said thank you),
Guido.
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 12:12 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
After I put the three jar files in TOMCAT_HOME/lib. The classes were
Hi,
Now, After I put three jar files in tomcat/lib, program is able to locate
the classes. But I have another error:
[Microsoft][SQLServer JDBC Driver]Error establishing socket.
What is it?
Here is the progrm:
String m_Class = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector =
Also try another driver, it could be true, microsoft's programmer and java
are not good friends, maybe the driver is bad done.
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 12:12 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL
I certainly agree on this opinion! I got bloody knuckles from the MS
driver (really just OEM'd from Merant before they spun off). bigint
didn't work at all right out of the gate. How many other bugs are
lurking if such an obvious one made it through the extensive QA
process?
According to
'
Subject: RE: JDBC Driver for MS SQL Server
Hi,
Now, After I put three jar files in tomcat/lib, program is
able to locate
the classes. But I have another error:
[Microsoft][SQLServer JDBC Driver]Error establishing socket.
What is it?
Here is the progrm:
String m_Class
:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:53 AM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Certain versions of SQL Server (6.5 I know, others maybe) don't
enable TCP/IP access by default. Contact your DBA for more assistance.
Randy
: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 12:44 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Hmmm, this might be getting off topic, but, yes, they have gone back and
forth between named pipes and TCP/IP (with 2k) as
default. Do you
-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:48 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
Hi,
The default port is 1433. Now I got the connection to SQL Server. However, there are
several databases in SQL Server. prodserver is one
Users List'
Subject: RE: JDBC Driver for MS SQL Server
Hi,
The default port is 1433. Now I got the connection to SQL Server. However,
there are several databases in SQL Server. prodserver is one of the
databases. When I query a table, it says it is invalid object name. How to
access a table
in your sql server, you can set your default DB if you want
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:48 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
Hi,
The default port is 1433. Now I got the connection
Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:48 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
Hi,
The default port is 1433. Now I got the connection to SQL Server. However,
there are several databases in SQL Server. prodserver
by the company.
-Original Message-
From: Jack Li [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:01 AM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
Thanks for quick reply. But I still get the error:
[MERANT][SQLServer JDBC Driver][SQLServer
endorsed by the company.
-Original Message-
From: Jack Li [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 5:01 AM
To: 'Tomcat Users List'
Subject: RE: JDBC Driver for MS SQL Server
Thanks for quick reply. But I still get the error:
[MERANT][SQLServer JDBC Driver
AM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
or
prodserver.dbo.pe_orders
where dbo is the owner of the database. if dbo is not the owner then
specify who the owner is there.
-Original Message-
From: Artigas, Ricardo Y. [mailto:[EMAIL PROTECTED
26 matches
Mail list logo