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

MSSQL -> MySQL Questions

forums › forums › SQLyog › Using SQLyog › MSSQL -> MySQL Questions

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • October 10, 2004 at 5:12 am #16362
      Ritesh
      Member

      Currently, SQLyog's ODBC Import Tool only supports importing of Table Structures and Data.

      We plan to add options for importing other objects like Indexes, PKs, FKs in the next version i.e. 4.1.

    • October 20, 2010 at 3:30 pm #16363
      ajanamills
      Member

      I am trying out the import feature on the evaluation edition too. I have set up a ODBC connection with the MSSQL 2005 server, tested it with the password and it connects. Only when I go to connect using SQLyog it gives a “could not connect error”

      ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bac'.

      ERROR: Import aborted…

      Any idea what could be wrong?

    • October 20, 2010 at 3:30 pm #16364
      ajanamills
      Member

      I am trying out the import feature on the evaluation edition too. I have set up a ODBC connection with the MSSQL 2005 server, tested it with the password and it connects. Only when I go to connect using SQLyog it gives a “could not connect error”

      ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'bac'.

      ERROR: Import aborted…

      Any idea what could be wrong?

    • October 20, 2010 at 5:01 pm #16365
      peterlaursen
      Participant

      hmmm .. no idea at the moment really.

      1)

      Could you try if you are able to import to Excel using same DSN settings?

      (Excel menu. .. Data .. Import external Data .. import Data .. select ODBC DSN in the dropdown in Excel 2003)

      2)

      Check if some firewall or similar type of program is the problem?

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