Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 29077 invoked from network); 28 Jun 2002 15:22:28 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by 209.66.108.5 with SMTP; 28 Jun 2002 15:22:28 -0000 Received: (qmail 7461 invoked by uid 97); 28 Jun 2002 15:22:11 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@jakarta.apache.org Received: (qmail 7238 invoked by uid 97); 28 Jun 2002 15:22:09 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 7150 invoked by uid 98); 28 Jun 2002 15:22:09 -0000 X-Antivirus: nagoya (v4198 created Apr 24 2002) Message-ID: From: "Douglas, Rory" To: 'Tomcat Users List' Subject: RE: weird connection problems Date: Fri, 28 Jun 2002 11:07:37 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/mixed; boundary="------------InterScan_NT_MIME_Boundary" X-Spam-Rating: 209.66.108.5 1.6.2 0/1000/N X-Spam-Rating: 209.66.108.5 1.6.2 0/1000/N --------------InterScan_NT_MIME_Boundary Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C21EB5.8A0989F0" ------_=_NextPart_001_01C21EB5.8A0989F0 Content-Type: text/plain; charset="iso-8859-1" Hi there If using the JDBC-ODBC bridge then the server executing the JDBC calls MUST have an ODBC datasource configured on it LOCALLY. On your own PC this is probably done. Have you done this on your remote Tomcat server?? The ODBC datasource would then have to point to whatever server your database is running on. Rory -----Original Message----- From: AMRAN121@aol.com [mailto:AMRAN121@aol.com] Sent: Friday, June 28, 2002 11: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: For additional commands, e-mail: ------_=_NextPart_001_01C21EB5.8A0989F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: weird connection problems

Hi there

If using the JDBC-ODBC bridge then the server = executing the JDBC calls MUST have an ODBC datasource configured on it = LOCALLY. On your own PC this is probably done. Have you done this on = your remote Tomcat server??

The ODBC datasource would then have to point to = whatever server your database is running on.

Rory

-----Original Message-----
From: AMRAN121@aol.com [mailto:AMRAN121@aol.com]
Sent: Friday, June 28, 2002 11: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:   <mailto:tomcat= -user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-h= elp@jakarta.apache.org>

------_=_NextPart_001_01C21EB5.8A0989F0-- --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=us-ascii -- To unsubscribe, e-mail: For additional commands, e-mail: --------------InterScan_NT_MIME_Boundary--