Re: MS Access Driver!!!
Faulkner, Perry wrote: Muhammad, Your original post was that you had jdbc:odbc: - not jdbc.odbc., so your missing more than just sun. in the web.xml! It is a java package and class reference. In coccon.xconf you should have something similar to: jdbc name=mydb auto-commitfalse/auto-commit dburljdbc:odbc:mydatabase/dburl user/user passwordp/password /jdbc Note: that this needs the : and is NOT a class reference! Rewrite that to: jdbc name=mydb auto-commitfalse/auto-commit !-- may fail with some drivers -- driversun.jdbc.odbc.JdbcOdbcDriver/driver dburljdbc:odbc:mydatabase/dburl !-- username/password is not necessary with MS Access -- /jdbc Ladies in gentlemen, I provided this so you can see the proper markup for the jdbc entry. I do not advocate the use of the Jdbc/Odbc bridge driver at all--esp. in regards to MS Access. You can install MySQL on windows for a real database that does not cost any money for development. -- They that give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. - Benjamin Franklin - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: MS Access Driver!!!
And to add - combine mySQL with the wonderful dbTools package import your m$access files in one swift swoop - then delete them!!) and you have all you need ! See: http://www.dbtools.com.br/ [EMAIL PROTECTED] 16/04/2002 02:54:17 Faulkner, Perry wrote: Muhammad, Your original post was that you had jdbc:odbc: - not jdbc.odbc., so your missing more than just sun. in the web.xml! It is a java package and class reference. In coccon.xconf you should have something similar to: jdbc name=mydb auto-commitfalse/auto-commit dburljdbc:odbc:mydatabase/dburl user/user passwordp/password /jdbc Note: that this needs the : and is NOT a class reference! Rewrite that to: jdbc name=mydb auto-commitfalse/auto-commit !-- may fail with some drivers -- driversun.jdbc.odbc.JdbcOdbcDriver/driver dburljdbc:odbc:mydatabase/dburl !-- username/password is not necessary with MS Access -- /jdbc Ladies in gentlemen, I provided this so you can see the proper markup for the jdbc entry. I do not advocate the use of the Jdbc/Odbc bridge driver at all--esp. in regards to MS Access. You can install MySQL on windows for a real database that does not cost any money for development. -- They that give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. - Benjamin Franklin - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
MS Access Driver!!!
Dear All, Does any one knows the name os MS Access driver and where it is located?? I have inserted jdbc:odbc:JdbcOdbcDriver within the WEB_INF/web.xml file but getting exceptions... Thanking you for your kind help. Irfan. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: MS Access Driver!!!
Thanks Perry, but I just forgotten to mention sun. before the jdbc.odbc.JdbcOdbcDriver. If the driver is correct, then I may be doing something wrong in the cocoon.xconf file datasources... Any further help please... Thanking you. From: Faulkner, Perry [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: MS Access Driver!!! Date: Tue, 16 Apr 2002 08:08:59 +1000 Hi Muhammad, That should be: sun.jdbc.odbc.JdbcOdbcDriver Perry -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 16 April 2002 8:03 To: [EMAIL PROTECTED] Subject: MS Access Driver!!! Dear All, Does any one knows the name os MS Access driver and where it is located?? I have inserted jdbc:odbc:JdbcOdbcDriver within the WEB_INF/web.xml file but getting exceptions... Thanking you for your kind help. Irfan. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: MS Access Driver!!!
show the exceptions. maybe u didn't configure ODBC data source. -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 6:17 PM To: [EMAIL PROTECTED] Subject: RE: MS Access Driver!!! Thanks Perry, but I just forgotten to mention sun. before the jdbc.odbc.JdbcOdbcDriver. If the driver is correct, then I may be doing something wrong in the cocoon.xconf file datasources... Any further help please... Thanking you. From: Faulkner, Perry [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: MS Access Driver!!! Date: Tue, 16 Apr 2002 08:08:59 +1000 Hi Muhammad, That should be: sun.jdbc.odbc.JdbcOdbcDriver Perry -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 16 April 2002 8:03 To: [EMAIL PROTECTED] Subject: MS Access Driver!!! Dear All, Does any one knows the name os MS Access driver and where it is located?? I have inserted jdbc:odbc:JdbcOdbcDriver within the WEB_INF/web.xml file but getting exceptions... Thanking you for your kind help. Irfan. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: MS Access Driver!!!
Muhammad, Your original post was that you had jdbc:odbc: - not jdbc.odbc., so your missing more than just sun. in the web.xml! It is a java package and class reference. In coccon.xconf you should have something similar to: jdbc name=mydb auto-commitfalse/auto-commit dburljdbc:odbc:mydatabase/dburl user/user passwordp/password /jdbc Note: that this needs the : and is NOT a class reference! HTH Perry -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 16 April 2002 8:17 To: [EMAIL PROTECTED] Subject: RE: MS Access Driver!!! Thanks Perry, but I just forgotten to mention sun. before the jdbc.odbc.JdbcOdbcDriver. If the driver is correct, then I may be doing something wrong in the cocoon.xconf file datasources... Any further help please... Thanking you. From: Faulkner, Perry [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: MS Access Driver!!! Date: Tue, 16 Apr 2002 08:08:59 +1000 Hi Muhammad, That should be: sun.jdbc.odbc.JdbcOdbcDriver Perry -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 16 April 2002 8:03 To: [EMAIL PROTECTED] Subject: MS Access Driver!!! Dear All, Does any one knows the name os MS Access driver and where it is located?? I have inserted jdbc:odbc:JdbcOdbcDriver within the WEB_INF/web.xml file but getting exceptions... Thanking you for your kind help. Irfan. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.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/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]