Results 1 to 7 of 7

Thread: PL/SQL with Access 2000

  1. Mar 20th, 2002, 08:40 AM #1
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479

    PL/SQL with Access 2000

    Can I implement PL/SQL with ADO to an Access 2000 database.
    If yes how?
    Reply With Quote Reply With Quote
  2. Mar 20th, 2002, 09:11 AM #2
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    PL/SQL is native to and only works against Oracle databases. So 'fraid not.
    The liver is bad. It must be punished.
    Reply With Quote Reply With Quote
  3. Mar 20th, 2002, 09:12 AM #3
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    Originally posted by RSINGH
    PL/SQL is native to and only works against Oracle databases. So 'fraid not.
    Is there anything similar I could use for Access or SQLServer?
    Reply With Quote Reply With Quote
  4. Mar 20th, 2002, 09:19 AM #4
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    In SQL Server, you would use Transact SQL which is used to create your stored procedures, views and program flow control. I've only used Access up to 97 and there is nothing comparable. Although I hear you can make stored procedures in Access 2000. You can then call these through an ADO command or connection object.
    The liver is bad. It must be punished.
    Reply With Quote Reply With Quote
  6. Mar 20th, 2002, 09:22 AM #5
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    God al-bloody-mighty I'm sick of learning new languages.
    Hope this is the last one.
    Reply With Quote Reply With Quote
  7. Mar 20th, 2002, 09:24 AM #6
    RSINGH
    RSINGH is offline
    Fanatic Member RSINGH's Avatar
    Join Date
    May 2001
    Location
    London
    Posts
    522
    T-SQL is pretty straight forward and not too diferent to PL/SQL. I suppose you can consider it as Microsoft's implementation. Good luck - if you need any help just shout.
    The liver is bad. It must be punished.
    Reply With Quote Reply With Quote
  8. Mar 20th, 2002, 09:29 AM #7
    GlenW
    GlenW is offline

    Thread Starter
    Hyperactive Member GlenW's Avatar
    Join Date
    Nov 2001
    Location
    Gateshead, England
    Posts
    479
    Good luck - if you need any help just shout.
    Cheers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width