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