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 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]> <<
> File: ATT32464.txt >>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
