Professional Web Applications Themes

how to return data from another SQL server? - MySQL

Can anybody help me on this "how to?" I hava an application that communicates with MySQL server. For one query, i need the data from another sql server (Microsoft SQL Server) in the network. Is there any way to make MySQL server do a query on that other server and return it to the user again? If so, how to do this trick? TIA! Jacco....

  1. #1

    Default how to return data from another SQL server?

    Can anybody help me on this "how to?"

    I hava an application that communicates with MySQL server. For one query, i
    need the data from another sql server (Microsoft SQL Server) in the network.

    Is there any way to make MySQL server do a query on that other server and
    return it to the user again? If so, how to do this trick?

    TIA!

    Jacco.


    Jacco Guest

  2. #2

    Default Re: how to return data from another SQL server?

    Jacco wrote:
    > Can anybody help me on this "how to?"
    >
    > I hava an application that communicates with MySQL server. For one query, i
    > need the data from another sql server (Microsoft SQL Server) in the network.
    >
    > Is there any way to make MySQL server do a query on that other server and
    > return it to the user again? If so, how to do this trick?
    >
    > TIA!
    >
    > Jacco.
    >
    >
    Not to my knowledge. You're application will need to make the query.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    [email]jstucklexattglobal.net[/email]
    ==================
    Jerry Stuckle Guest

  3. #3

    Default Re: how to return data from another SQL server?

    I'm a relatively newbie, but wouldn't you use odbc
    ([url]http://www.roth.net/perl/odbc/faq/[/url]) or java's jdbc
    ([url]http://java.sun.com/products/jdbc/faq.html)?[/url]

    -John


    "Jacco" <JaccogDONT_SPAM_MEhotmail.com> wrote in message
    news:44782732$0$39829$dbd45001news.wanadoo.nl...
    > Can anybody help me on this "how to?"
    >
    > I hava an application that communicates with MySQL server. For one query,
    i
    > need the data from another sql server (Microsoft SQL Server) in the
    network.
    >
    > Is there any way to make MySQL server do a query on that other server and
    > return it to the user again? If so, how to do this trick?
    >
    > TIA!
    >
    > Jacco.
    >
    >

    The Ewings Guest

Similar Threads

  1. XMLReader Class ++ no data is been return
    By 60s in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: May 21st, 07:10 PM
  2. search and return Yahoo stock data
    By wbeartop in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: February 1st, 11:53 PM
  3. return data on a table from a text box
    By Gm3512 in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 7th, 07:16 PM
  4. WS parameters & return values data integrity
    By Strider in forum ASP.NET Web Services
    Replies: 0
    Last Post: April 26th, 10:01 AM
  5. Problems using services which return data using xsi:nil
    By Stan Yamane in forum ASP.NET Web Services
    Replies: 1
    Last Post: July 15th, 05:56 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139