Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    66

    Unanswered: mysql and stored procedures

    I have a mysql with v5 and I want to write a stored procedure --
    if I write it on a mysql 5 can I access it from any other unix server (even a server that does not have mysql 5 on it)

  2. #2
    Join Date
    May 2006
    Location
    New York
    Posts
    15
    as long as it goes through ODBC, it is run on the server which has MySQL 5

  3. #3
    Join Date
    Mar 2004
    Posts
    370
    stored procedure is stored in your database engine (read it DBMS). you access your mysql from unix,win,... and database access the procedure and run it for you.
    So you could run it through any db independent mechanism such as ODBC,JDBC but not a OLEDB/ADO pair because there is no such a facility on *nix machines.
    -Good luck!

Posting Permissions

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