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

VB and SQLyog

forums › forums › VB and SQLyog

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 28, 2004 at 10:44 pm #8671
      MIkeMechanic
      Member

      Hi!

      Wondering if somebody could help me on how to connect a Visual Basic Application to a SQLyog DataBase.

      Thanks in advance.

      MIkeMechanic

    • November 29, 2004 at 1:10 pm #16607
      Shadow
      Member

      There is no SQLyog database. SQLyog is a front-end for MySql databases. There are two ways for connecting to a MySql db from VB. The hard way is to export the header of each function in libmysql.dll and write your own client software. The easy way is to download MySql's ODBC driver (MyODBC) from dev.mysql.com and use ADO to connect to MySql. A connectionstring example: “Driver=MySQL ODBC 3.51 Driver;DATABASE=my_db;SERVER=localhost;UID=my_user;PASSWORD=my_password;PORT=330

      ;OPTION=3″. Always set the “do not optimize column width” option at the ODBC settings!

    • November 30, 2004 at 11:05 am #16608
      MIkeMechanic
      Member

      Thanks!!!

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