Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Import from other MySQL Source

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Import from other MySQL Source

  • This topic is empty.
Viewing 8 reply threads
  • Author
    Posts
    • January 8, 2005 at 1:10 pm #16779
      seo
      Member

      it seems i can connect with MySQL ODBC 3.51 Driver but not

      Microsoft SQL Server ODBC Driver Version 03.70.0961

      Running connectivity tests…

      Attempting connection

      [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

      TESTS FAILED!

      how does this part work???

      thanks in advance…besides this this software should be a breeze….i love it…

    • January 8, 2005 at 9:56 pm #16780
      peterlaursen
      Participant

      To connect to a MYSQL database you must use one of the connection tools provided by MYSQL !! Primarly the Mysql ODBC-driver or Mysql JDBC-driver! A driver for MS-SQL-Server won't work with MYSQL!

      You can however also connect from programming languages like php, perl, c etc.

    • January 10, 2005 at 9:30 pm #16781
      seo
      Member

      Hi,

      thank you for your prompt response…I can connect to mysql…with no problems…however, i can't import with my ODBC import wizard…my 3.51 ODBC driver works and connects…but i think the import requires the SQL Server ODBC driver (which can't connect when i configure it for PUBS)….i connected mysql with php no problem…i just need the SQL Server to connect to import my insert documents…please…any ideas…

      I guess the problem is importing insert documents for my tables….and i can't do that with the sqlyog enterprise….edition…thanks in advance…

    • January 10, 2005 at 9:45 pm #16782
      peterlaursen
      Participant

      You must explain more in detail what you are trying to do !! We can't read thoughts 🙂

      Do you want to import TO MYsql FROM MS-SQL-Server ?? If yes, then you of course need to configure an MS-SQL-ODBC instance for the MS-SQL DB using Windows' “administrative tools” and give it a name. From the “ODBC import wizard” in sqlyog choose that name to import from.

      I don't have access to a MS-SQL server, so if there is any specific problem in that I can't help, but those are the basic principles. Sqlyog does not use an ODBC driver to access (neither read or write) a MySQL database (it uses the “native” C -interface/API built into MySQL Server executables).

    • January 10, 2005 at 10:48 pm #16783
      seo
      Member

      lets put it this way….i need to import from a text file to mysql table called employees_data ….how do you do this with SQLyog enterprise edition? The help files don't seem to help….thanks….

    • January 10, 2005 at 11:37 pm #16784
      peterlaursen
      Participant

      To import to MySQL with sqlyog from a text file you don't use ODBC all all.

      From Table .. export/import .. import table data .. import from CSV.

      A .csv is basically a semicolon-delimitted text-file.

      This is a sample generated with MS Excel (four cells with string content (first row) “d”,”d” (second row)”a” and “s”

      (start)

      d;d

      a;s

      (end)

    • January 13, 2005 at 4:53 am #16785
      seo
      Member

      hello, all is well….i used the odbc 3.51 driver to import a text file (not csv this time…) the only thing i have trouble with is starting the sqlyog…i click on the exe link and the server info prompts then i log in but no screen….what gives….

    • January 13, 2005 at 5:00 am #16786
      seo
      Member

      NO Problem starting (i just change the target window to maximum)…i love this software!!!!!!!! i also appreciate the fast responses….everything about this company rocks!!!!!!!!!!!!!!!!!!

    • January 13, 2005 at 5:03 am #16787
      Ritesh
      Member

      😀

  • Author
    Posts
Viewing 8 reply threads
  • You must be logged in to reply to this topic.