RE: Connecting to ms sql

2001-04-05 Thread Warren Crossing
hey, go to java.sun.com/products go to the jdbc site. they have a list of jdbc drivers. you might be better of using a jdbc odbc bridge from sun. l8r. -Original Message- From: Bahl, ankur [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 April 2001 4:09 PM To: '[EMAIL PROTECTED]' Subject:

RE: connecting to MS-SQL

2001-02-14 Thread Richard Downey
At what point does it raise that message ? Have you connected OK to the Database ? got a Recordset etc. ? The JDBC-ODBC in SDK 1.3 certainly works with SQL 7 and is very Quick. -Original Message- From: David Treves [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 13:38 To: mailing list

Re: connecting to MS-SQL

2001-02-14 Thread David Treves
l Message - From: "Richard Downey" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 3:59 PM Subject: RE: connecting to MS-SQL At what point does it raise that message ? Have you connected OK to the Database ? got a Recordset etc. ? The JDBC-ODBC in SDK 1

RE: connecting to MS-SQL

2001-02-14 Thread Richard Downey
To: [EMAIL PROTECTED] Subject: Re: connecting to MS-SQL I managed to create the connection, statement and the resultset, the problem is when I try to get the data: try { Connection con = broker.getConnection(); //using the DBConnectionBroker pool Statement stmt = con.createStatement

Re: connecting to MS-SQL

2001-02-14 Thread Frank Mau
Hi, I think you should try this code-snippet: ... Connection con = null; try { // get data from database con = DriverManager.getConnection( ... ); // replace with your DB-connector Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery( "put your SQL-Statement here"