Re: Accessing MS Access and SQL Server from VB 6

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/07/04 

Date: Thu, 6 May 2004 22:07:38 -0400

Hi,

I think this way would add extra pain in your development. As I know there
is no simple way to support multiple type of the databases any way. But you
decide to go the way of changing syntax, it could add very big amount of
time for testing 

-- 
Val Mazur
Microsoft MVP
"sherilw" <anonymous@discussions.microsoft.com> wrote in message 
news:A5FDA17D-4238-4142-946C-45C82720A5FD@microsoft.com...
> The program is quite large and uses hundreds of date and string specific 
> client side SQL statements.   I would like to port some of my statements 
> over to stored procedures, but I'm not sure of the rules regarding which 
> ones to transfer.
> I thought that if I had a couple of small procedures that would change the 
> syntax for an access date to the syntax for a SQL server date.
> What do you think, is this the way to go?  What are the rules regarding 
> stored procedures?
> Thanks

Relevant Pages

  • Re: Query based on Excel link
    ... John Vinson wrote ... ... > stored procedures. ... clause or a parameter query to create SQL statements that use ... another syntax you can use is the new CREATE PROCEDURE ...
    (microsoft.public.access.queries)
  • Re: Query based on Excel link
    ... John Vinson wrote ... ... > stored procedures. ... clause or a parameter query to create SQL statements that use ... another syntax you can use is the new CREATE PROCEDURE ...
    (microsoft.public.access.queries)
  • Re: Query based on Excel link
    ... John Vinson wrote ... ... > stored procedures. ... clause or a parameter query to create SQL statements that use ... another syntax you can use is the new CREATE PROCEDURE ...
    (microsoft.public.access.queries)
  • Re: Query based on Excel link
    ... John Vinson wrote ... ... > stored procedures. ... clause or a parameter query to create SQL statements that use ... another syntax you can use is the new CREATE PROCEDURE ...
    (microsoft.public.access.queries)
  • Re: "Select" & "Order By" OK- WHERE Doesnt Work !
    ... >> Unless you have register globals on you need to code the above as ... > their syntax. ... >> It's always useful to display your sql statements especially when you ... select * from table where song='cherish' and 1 order by somename ...
    (comp.lang.php)