>
> Date: Mon, 17 Apr 2000 10:27:16 +0200
> From: "Siddhartha Chandurkar (EHPT)" <[EMAIL PROTECTED]>
> Subject: Entity Bean deployment in J@EE
> MIME-Version: 1.0
> Content-Type: multipart/alternative;
> boundary="----_=_NextPart_001_01BFA847.C2BD9714"
> <Environment>
> Win NT 4.0, J2sdkee, JDK 1.2.2, MS Access
> </Environment>
> Hi Everybody,
> I want to use Access as my Databse for an Entity bean in J2EE. I am not being
> able to do that. Can you please tell me the procedure to use Access as the
> database
You can configure the J2SDK to use Sun's JDBC-ODBC bridge as the
JDBC driver, and then use ODBC to connect to Access. However, I tried
this once (can't remember if it was with J2SDK or some commercial
product) and it didn't work properly. The ODBC driver was pitching out
error messages. The combination of EJB and the JDBC-bridge was
asking ODBC to do things it can't - not surprising, since Access doesn't
have any native SQL support at all.
If you need something quick and dirty the Cloudscape Java database that
comes with the SDK is a much better choice, IMO.
--Jon
-------------------------------------------------------------------
Jon Dart [EMAIL PROTECTED]
TIBCO Software Inc. 650-846-5099
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
