Professional Web Applications Themes

Pulling in data from system ODBC - MySQL

WHAT I NEED: Help with determining the best 'light weight' way to pull data into my mySQL database from an external ODBC data source. MY SITUATION: I have a server that allows very restricted ODBC access to its databases through a license restricted driver. For years I have been using M$ Access to pull the data I need out of that server over to my file server and into an ACCESS database, daily. I run reports and application against the access databases. Now the size restrictions of access, among other things, are getting in my way and I would like ...

  1. #1

    Default Pulling in data from system ODBC

    WHAT I NEED: Help with determining the best 'light weight' way to
    pull data into my mySQL database from an external ODBC data source.

    MY SITUATION: I have a server that allows very restricted ODBC access
    to its databases through a license restricted driver. For years I
    have been using M$ Access to pull the data I need out of that server
    over to my file server and into an ACCESS database, daily. I run
    reports and application against the access databases. Now the size
    restrictions of access, among other things, are getting in my way and
    I would like to move to MySQL.

    THE PROBLEM: I am a beginner with MySQL. I was hoping that I could
    somehow use the mySQL command line client to pull data from an ODBC
    connection into my SQL server but that doesn't seem possible. My
    hardware is rather old so I'm looking for a 'light weight' method of
    creating and updating tables on my mySQL server based on queries run
    again ODBC database tables.

    Can this be done without the aid of an expensive database manipulation
    app like ACCESS?

    Thanks for your help.

    Rusty Guest

  2. #2

    Default Re: Pulling in data from system ODBC

    Rusty Robot wrote: 
    yes, it can! look up sqlyog!

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  3. #3

    Default Re: Pulling in data from system ODBC

    On May 18, 9:20 am, lark <net> wrote: 




    >
    > yes, it can! look up sqlyog!
    >
    > --
    > lark -- net
    > To reply to me directly, delete "despam".[/ref]

    Interesting. Downloading now. Thanks allot, I post back with my
    results.

    Rusty Guest

Similar Threads

  1. Pulling data across domains
    By CreativeStride in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: September 23rd, 04:50 AM
  2. Pulling in data from another http:// site??
    By Steve in forum Macromedia ColdFusion
    Replies: 3
    Last Post: September 1st, 07:05 PM
  3. pulling data frm disconnected system.
    By anil kumar.m in forum ASP.NET Web Services
    Replies: 3
    Last Post: October 16th, 04:43 PM
  4. Problem pulling data from oracle
    By Bobby Singh in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: January 10th, 12:35 AM

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