Hi. I would recommend you to change to MySQL or PostgreSQl if you can. There are some utilities to migrate the database. I used MS Access before, but now I am using PostgreSQL and I can say that the change was a big step forward.
Regards, Antonio Gallardo Sushil Bhattarai dijo: > 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]> --------------------------------------------------------------------- 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]>
