Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Writing Stored Procedures in MS Access 97

Reply
Thread Tools

Writing Stored Procedures in MS Access 97

 
 
Manoj S. P.
Guest
Posts: n/a
 
      07-07-2003
Hi folks,

Is it possible to write stored procedures in MS Access 97?
If yes, how can I call one from my Java program?
Will it be a normal call through a Cllable Statement?
Thanks in advance for the help.

Regards,
Manoj S. P.
 
Reply With Quote
 
 
 
 
Andy Flowers
Guest
Posts: n/a
 
      07-07-2003
Stored procedures (or the MS Access version of them)_ have only been
available since Access 2000.

Even with the correct versions stored procedures are little more than
queries, so no procedural code allowed. The syntax was introduced to support
MSDE (and SQL Server ) better I believe.

If you want to use a simple Windows based database then take a look at MSDE.

"Manoj S. P." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) om...
> Hi folks,
>
> Is it possible to write stored procedures in MS Access 97?
> If yes, how can I call one from my Java program?
> Will it be a normal call through a Cllable Statement?
> Thanks in advance for the help.
>
> Regards,
> Manoj S. P.



 
Reply With Quote
 
 
 
 
Manoj S. P.
Guest
Posts: n/a
 
      07-09-2003
Thanks for the reply, Andy.
Atleast you helped me from going into a ghost chase for stored
procedures or equivalent in MS Access 97.
I will be obliged if you could provide me with more information on how
to improve transaction speed when using MS Acces 97 from your Java
program.

Regards,
Manoj S. Panicker

"Andy Flowers" <(E-Mail Removed)> wrote in message news:<FdiOa.5904$(E-Mail Removed)>...
> Stored procedures (or the MS Access version of them)_ have only been
> available since Access 2000.
>
> Even with the correct versions stored procedures are little more than
> queries, so no procedural code allowed. The syntax was introduced to support
> MSDE (and SQL Server ) better I believe.
>
> If you want to use a simple Windows based database then take a look at MSDE.
>
> "Manoj S. P." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed) om...
> > Hi folks,
> >
> > Is it possible to write stored procedures in MS Access 97?
> > If yes, how can I call one from my Java program?
> > Will it be a normal call through a Cllable Statement?
> > Thanks in advance for the help.
> >
> > Regards,
> > Manoj S. P.

 
Reply With Quote
 
Andy Flowers
Guest
Posts: n/a
 
      07-09-2003
Improving speed ?

I have never used Access 97 from Java/JDBC due to the sheer number of layers
that any calls must go through,
JDBC->JDBC/ODBC Bridge->ODBC->Access DLL.

Given that the JDBC/ODBC Bridge is a piece of 'sample', non-production level
code that Sun provide to allow test connections to databases on WIN32 it's
speed is generally not all that hot.

Do you have to use Access 97, or can you use one of the other Java
databases, HSQL et. all, as mentioned throughout the Java newsgroups.

This is probably not a very good answer, but if you ask the question on the
MS Access newsgroups there may be expertise there that may be able to help
with optimising you SQL, operations and database for throughput.

"Manoj S. P." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed) om...
> Thanks for the reply, Andy.
> Atleast you helped me from going into a ghost chase for stored
> procedures or equivalent in MS Access 97.
> I will be obliged if you could provide me with more information on how
> to improve transaction speed when using MS Acces 97 from your Java
> program.
>
> Regards,
> Manoj S. Panicker
>
> "Andy Flowers" <(E-Mail Removed)> wrote in message

news:<FdiOa.5904$(E-Mail Removed)>...
> > Stored procedures (or the MS Access version of them)_ have only been
> > available since Access 2000.
> >
> > Even with the correct versions stored procedures are little more than
> > queries, so no procedural code allowed. The syntax was introduced to

support
> > MSDE (and SQL Server ) better I believe.
> >
> > If you want to use a simple Windows based database then take a look at

MSDE.
> >
> > "Manoj S. P." <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed) om...
> > > Hi folks,
> > >
> > > Is it possible to write stored procedures in MS Access 97?
> > > If yes, how can I call one from my Java program?
> > > Will it be a normal call through a Cllable Statement?
> > > Thanks in advance for the help.
> > >
> > > Regards,
> > > Manoj S. P.



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Debugging SQL Server 2000 Stored Procedures. lhak ASP .Net 1 10-23-2004 03:30 PM
Putting stored procedures in a dll Soumitra Banerjee ASP .Net 1 02-27-2004 01:46 AM
VB.NET Retrieving Identity form MSSQL2000 without using stored procedures Taras ASP .Net 2 10-05-2003 05:35 AM
Waiting on Stored Procedures Matt ASP .Net 2 07-18-2003 12:46 PM
Re: Your opinion about stored procedures mono ASP .Net 1 07-04-2003 07:55 PM



Advertisments