Here's how I got it to work:

<jdbc name="access">
<pool-controller min="2" max="20" />
<dburl>jdbc:odbc:DEMODATABASE</dburl>
<user />
<password />
</jdbc>

where DEMODATABASE is the name of my database. Make sure you have this name set in your system DSN (ODBC DataSources)

In my web.xml file, I have the following driver

sun.jdbc.odbc.JdbcOdbcDriver

Works fine for me. Good luck

Sushil

From: "Antonio Gallardo" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Fw: MDB Access
Date: Thu, 19 Dec 2002 07:33:43 -0600 (CST)

Check this:

http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection

Antonio

marco scotoni dijo:
>
> ----- Original Message -----
> From: "marco scotoni" <[EMAIL PROTECTED]>
> To: "Upayavira" <[EMAIL PROTECTED]>
> Sent: Thursday, December 19, 2002 2:05 PM
> Subject: Re: MDB Access
>
>
>> OK,
>>
>> i'm able to connect with this string in local way:
>> <dburl>jdbc:odbc:Driver={Microsoft Access Driver
>> (*.mdb)};DBQ=c:\test\test.mdb;</dburl>
>>
>> But when the file is located on intranet like \\test\test\test.mdb i'm
>> not able to send the username and password of net to access to file...
>>
>> not able to connect in net way:
>>
>> <dburl>jdbc:odbc:Driver={Microsoft Access Driver
>> (*.mdb)};DBQ=\\test\test\test.mdb;</dburl>
>>
>> thx
>>
>> Marco
>>
>> ----- Original Message -----
>> From: "Upayavira" <[EMAIL PROTECTED]>
>> To: "marco scotoni" <[EMAIL PROTECTED]>
>> Sent: Thursday, December 19, 2002 1:59 PM
>> Subject: Re: MDB Access
>>
>>
>> > > There's anyone who could send me string connection to a MDB File
> please?
>> >
>> > I can't give you an exact string to do this - I haven't done it
>> myself.
>> >
>> > However, to connect to databases from Cocoon, you use JDBC. To
>> connect
> to
>> Access
>> > databases, you often use ODBC. Therefore, you could probably get
>> away
> with
>> using the
>> > JDBC-ODBC bridge, which I believe comes with some versions of the
>> JDK.
>> >
>> > Search on the net for JDBC-ODBC bridge, or maybe someone else on the
> list
>> can
>> > explain how to use it.
>> >
>> > Regards, Upayavira
>>
>
>
> ---------------------------------------------------------------------
> Please check that your question  has not already been answered in the
> FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
> For additional commands, e-mail:   <[EMAIL PROTECTED]>




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

-----------------------------
15 Chester Circle
Apt. 1B
New Brunswick, NJ 08901

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 3 months FREE*. http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&SU= http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_virusprotection_3mf


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to