RE: JDBC Driver for MS SQL Server
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 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 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 much appreciated. - jm -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: [Offtopic] RE: JDBC Driver for MS SQL Server
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 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 Cupertino). What's really scary is that Microsoft deviates from the basic concept around web technologies where the client SHOULD NOT ACCESS the hard drive or the local client period!!! Exception being these cookies, which have been exploited previously. Just a week or so ago, my machine was infected by the MINDA virus, and all I did was browse the net, albeit with IE and going to an infected IIS server. There motto should be... ... Microsoft: Making it Easier (for Terrorists and Virus Writers!!) Hat's off to open source!!! Open Source community is concerned for security, while Microsoft's priorities are obviously not. On Tuesday, December 18, 2001, at 08:59 AM, Justin Rowles wrote: 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 the current /. [slashdot.org] front page, a member of Al-Qaeda is claiming that MS was infiltrated and that there are deliberate bugs and trapdoors in XP. Microsoft says that the their extensive QA process hasn't picked up anything. Open source is safer for your critical applications. Apache, Tomcat, GNU et al are great. J. This message was brought to you by Fear, Uncertainty and Dubya. -- You're only jealous cos the little penguins are talking to me. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: [Offtopic] RE: JDBC Driver for MS SQL Server
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 Cupertino). What's really scary is that Microsoft deviates from the basic concept around web technologies where the client SHOULD NOT ACCESS the hard drive or the local client period!!! Exception being these cookies, which have been exploited previously. Just a week or so ago, my machine was infected by the MINDA virus, and all I did was browse the net, albeit with IE and going to an infected IIS server. There motto should be... ... Microsoft: Making it Easier (for Terrorists and Virus Writers!!) Hat's off to open source!!! Open Source community is concerned for security, while Microsoft's priorities are obviously not. On Tuesday, December 18, 2001, at 08:59 AM, Justin Rowles wrote: 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 the current /. [slashdot.org] front page, a member of Al-Qaeda is claiming that MS was infiltrated and that there are deliberate bugs and trapdoors in XP. Microsoft says that the their extensive QA process hasn't picked up anything. Open source is safer for your critical applications. Apache, Tomcat, GNU et al are great. J. This message was brought to you by Fear, Uncertainty and Dubya. -- You're only jealous cos the little penguins are talking to me. *** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *** -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
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 vaguely remember coming across info about a JDBC-TDS library. Anybody can point me in the right direction, it be much appreciated. - jm -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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 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 much appreciated. - jm
Re: JDBC Driver for MS SQL Server
Hi, Its being developed by freetds.org. They are developing JDBC drivers for MS SQL Server and Sybase based on TDS protocol under opensource. you can find more details here http://www.freetds.org Regards, Sri K Ganjam - Original Message - From: Darth Darknerd [EMAIL PROTECTED] To: Tomcat 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 vaguely remember coming across info about a JDBC-TDS library. Anybody can point me in the right direction, it be much appreciated. - jm -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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: Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where to put the three jar files? Also, are there other drivers available and good? I am using jdbc-odbc to connect SQL Server now. My application freezes very oftenly. Any sugguestions? Thanks, Jack -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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, minor limitations (on field size). And no errors so far. Chris -Original Message- From: Jack Li [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 10: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: Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where to put the three jar files? Also, are there other drivers available and good? I am using jdbc-odbc to connect SQL Server now. My application freezes very oftenly. Any sugguestions? Thanks, Jack -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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!!! 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, minor limitations (on field size). And no errors so far. Chris -Original Message- From: Jack Li [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 10: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: Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where to put the three jar files? Also, are there other drivers available and good? I am using jdbc-odbc to connect SQL Server now. My application freezes very oftenly. Any sugguestions? Thanks, Jack -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
After I put the three jar files in TOMCAT_HOME/lib. The classes were found.
But I got new error: No suitable driver . What is the TCP/IP port for SQL
Server? Here is my program:
String m_Class = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft.sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException 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 SQL Server
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:
Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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? The JSQLConnect 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 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, minor limitations (on field size). And no errors so far. Chris -Original Message- From: Jack Li [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 10: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: Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where to put the three jar files? Also, are there other drivers available and good? I am using jdbc-odbc to connect SQL Server now. My application freezes very oftenly. Any sugguestions? Thanks, Jack -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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 option. Justin. -- You're only jealous cos the little penguins are talking to me. *** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *** -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
Try now checking the name of the driver, very detail checking, the case of
the letters, the dots and son for example, maybe instead of
com.microsoft.jdbc.sqlserver.SQLServerDriver is
com.microsoft.jdbc.sqlserver.SQLServer.Driver, try navigating the jar files
of the driver, and check the folders, you have to see
com/microsoft/jdbc/sqlserver...etc etc, check every detail, if you don't
find any error try e.printStackTrace() to see what is happenning instead of
e.getMessage(), the first is more detail, check the user, normally could be
admin and empty passwd, etc etc, that's all I can tell you 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 found.
But I got new error: No suitable driver . What is the TCP/IP port for SQL
Server? Here is my program:
String m_Class = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft.sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException 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 SQL Server
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:
Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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 Server
After I put the three jar files in TOMCAT_HOME/lib. The classes were found.
But I got new error: No suitable driver . What is the TCP/IP port for SQL
Server? Here is my program:
String m_Class = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft.sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException 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 SQL Server
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:
Unable to load class com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
[Offtopic] RE: JDBC Driver for MS SQL Server
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 the current /. [slashdot.org] front page, a member of Al-Qaeda is claiming that MS was infiltrated and that there are deliberate bugs and trapdoors in XP. Microsoft says that the their extensive QA process hasn't picked up anything. Open source is safer for your critical applications. Apache, Tomcat, GNU et al are great. J. This message was brought to you by Fear, Uncertainty and Dubya. -- You're only jealous cos the little penguins are talking to me. *** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *** -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
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 have a firewall in the way? Say your servlet is on the DMZ and the
dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
msg40042/bin0.bin
Description: application/ms-tnef
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
Way off topic. If you are getting invalid object then it is because it doesn't
understand your statement. You likely have to qualify your statement better.
instead of SELECT * from table_name
you need SELECT * FROM dbo.table_name
post this to SQL people though
-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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ and the
dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
http://java.sun.com/docs/books/tutorial/jdbc/index.html
You are too far from our problems, read the tutorial there, it is quite
simple, short and useful.
Greetings,
Guido.
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 4: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 of the
databases. When I query a table, it says it is invalid object name. How to
access a table in a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
RE: JDBC Driver for MS SQL Server
Thanks for quick reply. But I still get the error:
[MERANT][SQLServer JDBC Driver][SQLServer]Invalid object name
'prodserver.pe_orders'.
Here is thre program
String m_Class = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:merant:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username, m_Password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(Select * from
prodserver.pe_orders);
if(rs.next()){
out.println(rs.getString(Order_No));
}
rs.close();
if(st!=null)st.close();
if(con!=null)con.close();
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
What's I missed?
Thanks,
Jack
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:51 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Way off topic. If you are getting invalid object then it is because it
doesn't understand your statement. You likely have to qualify your statement
better.
instead of SELECT * from table_name
you need SELECT * FROM dbo.table_name
post this to SQL people though
-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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10: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:
Unable to load class
com.microsoft.jdbc.sqlserver.SQLServerDriver. Where
to put the three jar files?
Also, are there other drivers available and good? I am using
jdbc-odbc to
connect SQL Server now. My application freezes very oftenly. Any
sugguestions?
Thanks,
Jack
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED
RE: JDBC Driver for MS SQL Server
Assuming prodserver is the database name and pe_orders is the table name,
try prodserver..pe_orders instead of prodserver.pe_orders.
HTH.
:~)
Ricky Y. Artigas
Database Administrator /
Analyst/Programmer
Information Technology Division
Easycall Communications Phils., Inc.
---
IMPORTANT NOTICE:
This message (and any attachment hereto) may contain privileged and/or
confidential information specific to EasyCall. If you are not the intended
addressee indicated in this message, you may not copy or disseminate this
message (or any attachment hereto) to anyone. Instead, please destroy this
message (and any attachment hereto), and kindly notify the sender by reply
email. Any information in this message (and any attachment thereto) that
do not relate to the official business of EasyCall shall be understood as
neither given nor 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][SQLServer]Invalid object name
'prodserver.pe_orders'.
Here is thre program
String m_Class = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:merant:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username,
m_Password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(Select * from
prodserver.pe_orders);
if(rs.next()){
out.println(rs.getString(Order_No));
}
rs.close();
if(st!=null)st.close();
if(con!=null)con.close();
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
What's I missed?
Thanks,
Jack
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:51 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Way off topic. If you are getting invalid object then it is because it
doesn't understand your statement. You likely have to qualify your
statement better.
instead of SELECT * from table_name
you need SELECT * FROM dbo.table_name
post this to SQL people though
-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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
Thanks,
Jack
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December
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]]
Sent: Tuesday, December 18, 2001 5:42 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Assuming prodserver is the database name and pe_orders is the table name,
try prodserver..pe_orders instead of prodserver.pe_orders.
HTH.
:~)
Ricky Y. Artigas
Database Administrator /
Analyst/Programmer
Information Technology Division
Easycall Communications Phils., Inc.
---
IMPORTANT NOTICE:
This message (and any attachment hereto) may contain privileged and/or
confidential information specific to EasyCall. If you are not the intended
addressee indicated in this message, you may not copy or disseminate this
message (or any attachment hereto) to anyone. Instead, please destroy this
message (and any attachment hereto), and kindly notify the sender by reply
email. Any information in this message (and any attachment thereto) that
do not relate to the official business of EasyCall shall be understood as
neither given nor 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][SQLServer]Invalid object name
'prodserver.pe_orders'.
Here is thre program
String m_Class = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:merant:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username,
m_Password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(Select * from
prodserver.pe_orders);
if(rs.next()){
out.println(rs.getString(Order_No));
}
rs.close();
if(st!=null)st.close();
if(con!=null)con.close();
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
What's I missed?
Thanks,
Jack
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:51 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Way off topic. If you are getting invalid object then it is because it
doesn't understand your statement. You likely have to qualify your
statement better.
instead of SELECT * from table_name
you need SELECT * FROM dbo.table_name
post this to SQL people though
-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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[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
-Original Message-
From: Jack Li [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 11:24 AM
To: 'Tomcat Users List'
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 = com.microsoft.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:microsoft:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector,
m_Username, m_Password);
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage
RE: JDBC Driver for MS SQL Server
correct!
:~)
Ricky Y. Artigas
Database Administrator /
Analyst/Programmer
Information Technology Division
Easycall Communications Phils., Inc.
---
IMPORTANT NOTICE:
This message (and any attachment hereto) may contain privileged and/or
confidential information specific to EasyCall. If you are not the intended
addressee indicated in this message, you may not copy or disseminate this
message (or any attachment hereto) to anyone. Instead, please destroy this
message (and any attachment hereto), and kindly notify the sender by reply
email. Any information in this message (and any attachment thereto) that
do not relate to the official business of EasyCall shall be understood as
neither given nor endorsed by the company.
-Original Message-
From: Scott Hodson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 10:07 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]]
Sent: Tuesday, December 18, 2001 5:42 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Assuming prodserver is the database name and pe_orders is the table name,
try prodserver..pe_orders instead of prodserver.pe_orders.
HTH.
:~)
Ricky Y. Artigas
Database Administrator /
Analyst/Programmer
Information Technology Division
Easycall Communications Phils., Inc.
---
IMPORTANT NOTICE:
This message (and any attachment hereto) may contain privileged and/or
confidential information specific to EasyCall. If you are not the
intended
addressee indicated in this message, you may not copy or disseminate
this
message (or any attachment hereto) to anyone. Instead, please destroy
this
message (and any attachment hereto), and kindly notify the sender by
reply
email. Any information in this message (and any attachment thereto) that
do not relate to the official business of EasyCall shall be understood
as
neither given nor 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][SQLServer]Invalid object name
'prodserver.pe_orders'.
Here is thre program
String m_Class = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver;
String m_Connector = jdbc:merant:sqlserver://prodserver:1433;
String m_Username = ;
String m_Password = ;
Connection con = null;
try{
Class.forName(m_Class);
con = DriverManager.getConnection(m_Connector, m_Username,
m_Password);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(Select * from
prodserver.pe_orders);
if(rs.next()){
out.println(rs.getString(Order_No));
}
rs.close();
if(st!=null)st.close();
if(con!=null)con.close();
}catch(ClassNotFoundException e){
out.println(class not found: + e.getMessage());
}catch(SQLException e){
out.println(e.getMessage());
}catch(Exception e){
out.println(e.getMessage());
}
What's I missed?
Thanks,
Jack
-Original Message-
From: Bongiorno.Christian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 3:51 PM
To: Tomcat Users List
Subject: RE: JDBC Driver for MS SQL Server
Way off topic. If you are getting invalid object then it is because it
doesn't understand your statement. You likely have to qualify your
statement better.
instead of SELECT * from table_name
you need SELECT * FROM dbo.table_name
post this to SQL people though
-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 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 a database?
Thanks
Jack
-Original Message-
From: 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 have a firewall in the way? Say your servlet is on the
DMZ
and the dbase is on the private (I hope!)
-Original Message-
From: Randy Layman [mailto:[EMAIL PROTECTED
