pat_m_brown@yahoo.com
|
| Posted: 03/07/2002, 10:02 PM |
|
When working with JSP code and Access databases, I am having a problem
getting connected to the access database. In the file common.asp
there is the following lines
//Database connection string
static final String DBDriver ="";
static final String strConn ="";
static final String DBusername="";
static final String DBpassword="";
Lets consider I have a access database called jspdb.mdb
in c:\data
How would I set the connection string for that using the above lines?
Do I need to setup a DSN for this?
-- Pat Brown --
-- Pat Brown--
|
|
|
 |
Nicole
|
| Posted: 03/11/2002, 2:32 AM |
|
Pat,
try to use ODBC connection to Access db. Make sure that IDBC driver is installed on your machine. Create DSN to db. Then connection staring and db driver would be:
Connection String: jdbc:odbc:DSN_name
Database Driver: sun.jdbc.odbc.JdbcOdbcDriver
|
|
|
|
lost 1
|
| Posted: 06/13/2002, 8:20 AM |
|
Where can I get the IDBC driver? I am running W2K w/iis 5
|
|
|
|
|
