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]>
msg40060/bin00000.bin
Description: application/ms-tnef
-- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
