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