weird connection problems

[AM...@aol.com]

Hi all
 I currently have MS Access as my backend database and Tomcat as server. When 
I try to connect to a datasource over the network with the jsp (presentation 
purpose) and java bean (business logic (where I establish connection to 
Access database)) setup, i get an error. If I use the same jsp and java bean 
to retrieve information from a database which is on my local pc then it is 
able to do it ok. 

Why is this happening? I am using a jdbc:odbc driver (the one that comes free 
with jdk1.4 (TYPE 1)). I thought it may be the driver but the funny thing is 
if I write a jsp (presentation and business logic mixed) to retrieve the data 
from over the network then it works!!! Has anyone else had this problem? Does 
anyone know what I could be doing wrong? Any suggestions?

Kind Regards
Amran


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

RE: weird connection problems

[Jim Rueschhoff <jr...@imsurenetwork.com>]

Did you set up the ODBC DSN info to define the network connection using the
ODBC reg tool in the console?  You need to configure the ODBC info before
making the ODBC connection over a network.

In a related matter:  You understand that MS Access is not a suitable
database for a real production web app, right?  Also the jdbc:odbc bridge is
intended to be used only in a development environment.  It is NOT thread
safe and therefore is not safe to use in a production setting where you may
have more than one user processing at a time.  However, neither of these
problems has anything to do with problem you stated.  Both will work on a
site so small that there is no chance of having multiple users on at once.

-----Original Message-----
From: AMRAN121@aol.com [mailto:AMRAN121@aol.com]
Sent: Friday, June 28, 2002 8:00 AM
To: tomcat-user@jakarta.apache.org
Subject: weird connection problems


Hi all
 I currently have MS Access as my backend database and Tomcat as server.
When
I try to connect to a datasource over the network with the jsp (presentation
purpose) and java bean (business logic (where I establish connection to
Access database)) setup, i get an error. If I use the same jsp and java bean
to retrieve information from a database which is on my local pc then it is
able to do it ok.

Why is this happening? I am using a jdbc:odbc driver (the one that comes
free
with jdk1.4 (TYPE 1)). I thought it may be the driver but the funny thing is
if I write a jsp (presentation and business logic mixed) to retrieve the
data
from over the network then it works!!! Has anyone else had this problem?
Does
anyone know what I could be doing wrong? Any suggestions?

Kind Regards
Amran


--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>