No, you aren't wrong.
That's the right way to work with (any) ODBC you want
You first need to define your Data Source in:
Start => Settings => Control Panel => ODBC Data Sources
then you can use your "pointer" as your dbURL as describe below.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 05:55 AM
Subject: AW: MS Access with struts
> Hi,
>
> it could be made with the Access Database configured as a
> Systemdatasource (ODBC-Administration-Tool in the Control panel), where
> you define a name for your datasource.
> Then you give the url as jdbc:odbc:yourdatabasename.
> I can't imagine that Access is a Databse server which you can access by
> "jdbc:odbc:localhost:8080/pcd/User.mdb". Mybe Im wrong.
>
> Dimitris
>
> >> -----Urspr�ngliche Nachricht-----
> >> Von: Roland Berger [SMTP:[EMAIL PROTECTED]]
> >> Gesendet am: Donnerstag, 30. August 2001 10:05
> >> An: [EMAIL PROTECTED]
> >> Betreff: MS Access with struts
> >>
> >> Hi all
> >>
> >> I try to access an MSAccess DB out of struts and I work with JBuilder
> >5.0.
> >> But when running the application I get the following error from
> >JBuilder:
> >>
> >> cannot load servlet name: action2001-08-30 09:39:47 - path="/pcd"
> >:action:
> >> Initializing application data source
> >org.apache.struts.action.DATA_SOURCE
> >> 2001-08-30 09:39:47 - path="/pcd" :action: Exception initializing
> >> application data source org.apache.struts.action.DATA_SOURCE -
> >> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Der
> >Datenquellenname
> >> wurde nicht gefunden, und es wurde kein Standardtreiber angegeben.
> >>
> >>
> >> The struts-config.xml looks like this:
> >>
> >> snippted...
> >>
> >> <data-sources>
> >> <data-source
> >> description="Example Data Source Description"
> >> driverClass="sun.jdbc.odbc.JdbcOdbcDriver"
> >> url="jdbc:odbc:localhost:8080/pcd/User.mdb"/>
> >> </data-sources>
> >>
> >>
> >> Thakns for any help
> >> Roland
>
>
