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]]
> > 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]>
>
>
>
> --
> 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]>
