You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Anders Högqvist <ho...@hotmail.com> on 2001/04/02 10:23:51 UTC
ESQL and MS Access
Hello again!
I'm sorry to write this again but I really need an answer! I've tried to use an Access database with ESQL but it doesn't work. First I tried to do it manualy with a logicsheet with some java code. I used jdbc.odbc.JdbcOdbcDriver and it worked. But when I try to do it in ESQL with the same driver I get an "Error loading driver" message. Is there something I have to do before using ESQL? The documentation on this is not so good so I hope there is someone out there that can answer this.
/Anders Högqvist
Re: Re[2]: ESQL and MS Access (code)
Posted by simone cecchini <si...@kiosco.org>.
At 12:48 4/2/01 +0200, you wrote:
>Hello simone,
>
>sc> <esql:query>SELECT CategoryName FROM Categories ORDER BY CategoryID;</esql:query>
>sc> (i think the semicolon is required ??)
>i think not.
>
i should have stessed the <esql:query> tag, to be put instead of <query>.
please, forgive! :-)
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re[2]: ESQL and MS Access (code)
Posted by Bartlomiej Pater <no...@poland.com>.
Hello simone,
sc> <esql:query>SELECT CategoryName FROM Categories ORDER BY CategoryID;</esql:query>
sc> (i think the semicolon is required ??)
i think not.
--
Best regards,
Bartlomiej mailto:nostah@poland.com
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: ESQL and MS Access (code)
Posted by simone cecchini <si...@kiosco.org>.
you should try putting
<esql:query>SELECT CategoryName FROM Categories ORDER BY CategoryID;</esql:query>
instead of
<query>SELECT CategoryName FROM Categories ORDER BY CategoryID</query>
(i think the semicolon is required ??)
bye,
simone
At 11:27 4/2/01 +0200, you wrote:
>Hello!
>
>Ok, here is the esql I try to get working (attached as .txt). I also added
>the logicsheet I told you about that worked just fine.
>
>Thank you for your time
>Anders Högqvist
>
>
>----- Original Message -----
>From: "Bartlomiej Pater" <no...@poland.com>
>To: "Anders Högqvist" <co...@xml.apache.org>
>Sent: Monday, April 02, 2001 10:57 AM
>Subject: Re: ESQL and MS Access
>
>
>> Hello Anders,
>>
>> Monday, April 02, 2001, 10:23:51 AM, you wrote:
>>
>> AH> Hello again!
>>
>> AH> I'm sorry to write this again but I really need an answer! I've tried
>to use an Access database with ESQL but it doesn't work. First I tried to do
>it manualy with a logicsheet with some java
>> AH> code. I used jdbc.odbc.JdbcOdbcDriver and it worked. But when I try to
>do it in ESQL with the same driver I get an "Error loading driver" message.
>Is there something I have to do before using
>> AH> ESQL? The documentation on this is not so good so I hope there is
>someone out there that can answer this.
>>
>> maybe you could post a code sniplet?
>>
>> --
>> Best regards,
>> Bartlomiej mailto:nostah@poland.com
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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: <co...@xml.apache.org>
>> For additional commands, e-mail: <co...@xml.apache.org>
>>
>>
>
>Attachment Converted: "F:\Data\~Simon\MailBoxes\simone@kiosco.org\Attach\kod.txt"
>---------------------------------------------------------------------
>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: <co...@xml.apache.org>
>For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: ESQL and MS Access (code)
Posted by Anders Högqvist <ho...@hotmail.com>.
Hello!
Ok, here is the esql I try to get working (attached as .txt). I also added
the logicsheet I told you about that worked just fine.
Thank you for your time
Anders Högqvist
----- Original Message -----
From: "Bartlomiej Pater" <no...@poland.com>
To: "Anders Högqvist" <co...@xml.apache.org>
Sent: Monday, April 02, 2001 10:57 AM
Subject: Re: ESQL and MS Access
> Hello Anders,
>
> Monday, April 02, 2001, 10:23:51 AM, you wrote:
>
> AH> Hello again!
>
> AH> I'm sorry to write this again but I really need an answer! I've tried
to use an Access database with ESQL but it doesn't work. First I tried to do
it manualy with a logicsheet with some java
> AH> code. I used jdbc.odbc.JdbcOdbcDriver and it worked. But when I try to
do it in ESQL with the same driver I get an "Error loading driver" message.
Is there something I have to do before using
> AH> ESQL? The documentation on this is not so good so I hope there is
someone out there that can answer this.
>
> maybe you could post a code sniplet?
>
> --
> Best regards,
> Bartlomiej mailto:nostah@poland.com
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
Re: ESQL and MS Access
Posted by Bartlomiej Pater <no...@poland.com>.
Hello Anders,
Monday, April 02, 2001, 10:23:51 AM, you wrote:
AH> Hello again!
AH> I'm sorry to write this again but I really need an answer! I've tried to use an Access database with ESQL but it doesn't work. First I tried to do it manualy with a logicsheet with some java
AH> code. I used jdbc.odbc.JdbcOdbcDriver and it worked. But when I try to do it in ESQL with the same driver I get an "Error loading driver" message. Is there something I have to do before using
AH> ESQL? The documentation on this is not so good so I hope there is someone out there that can answer this.
maybe you could post a code sniplet?
--
Best regards,
Bartlomiej mailto:nostah@poland.com
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>