Dropping database connection 
Author Message
 Dropping database connection

Hi all,

I have seen this problem posted in various places before but no
soloution. Can anyone help?

I am trying to connect a Java client to my progress 9.1b database
using the jdbc drivers shipped with that version.

I can load the drivers fine and connect to the database but the
connection is dropped right away, or at least I think so because when
I try to execute a statement I ge the follwoing error:

Failed to connect to DB
[JDBC Progress Driver]:Table/View/Synonym not found (7519)

I connect to the same db using the progress client and everything is
fine.

Help anyone???

Code snippet:

-----<snip>

//load the database driver
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver") ;

//set up a connection to the database
DriverManager.getConnection("jdbc:JdbcProgress:T:localhost:8222:CHRIS_TEST",
"user", "pass");

PreparedStatement ps = myConn.prepareStatement("SELECT * FROM
test.people") ;

ResultSet myResultSet = ps.executeQuery() ;

-----<end snip>



Tue, 04 May 2004 16:10:41 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Vendor EAI product drops database connection

2. ** DROP DATABASE and active connections question **

3. Dropping database regardless of connections

4. Database object won't drop Sybase connection

5. SQL DBNETLIB drops connection on 28800 connections.

6. Dropping file system files after dropping database devices on SQL 6.5

7. Restoring Dropped DataBase Devices and Databases

8. dropping databases and cross database references

9. VB ODBC to SQL connection dropping

10. VB to SQL ODBC connection dropping

11. Dropping SQL Server Connections

12. SQL7 Constant Connection drops


 
Powered by phpBB® Forum Software