1. Important Notice: ALWAYS login to your account using Board4all.biz - we do not own or run any other websites so please make sure you are connected to our official domain, and that you see the secure connection padlock before entering your login details.

Source Code LookDB - Automatic Generator View & Edit DataBase on MySQL or other db

Discussion in 'VB6/ActiveX' started by petbang, Nov 2, 2017.

  1. petbang

    petbang Registered User

    Joined:
    Nov 2, 2017
    Messages:
    7
    Likes Received:
    107
    Hello, I am new to the forum. I hope you like this application, it is very useful for all those interested in connecting with a database in mysql or similar. It works very fast and is highly configurable from the file 'config.ini'. You only have to change the following data:

    Code:
    [SERVIDOR] #SERVICIO DE DATOS -----------------
    IP=192.168.0.11
    USUARIO=demo
    PASSWORD=demo
    PUERTO=3306
    Contains activeX (I have your source code, I'll upload them if you like the app):
    -MetroBoton.ocx (Generates more visual buttons)
    -PrintRecordset.dll (Prints quickly and easily)
    -xFrame_v1.ocx (An improved frame design)

    The code is commented in English / Spanish, I'm doing another version that opens all the tables (detected automatically from the source) in the same program or window. It also creates the form automatically just like this but detects each field (combo, items, data, etc).

    If you like to upload the program and others I have facts.

    Thank you! Enjoy!

    [PetBANG]

    Preview:
    https://i.imgur.com/X1EIbd0.gifv

    Download:
    Hidden Content:
    [HIDDEN CONTENT]
    Hidden Content:
    [HIDDEN CONTENT]
    *add new link to download.
     
    Last edited: Jan 23, 2018
    Tagaroe, aalba, annabil23 and 31 others like this.
  2. zu

    zuhriahamed Registered User

    Joined:
    Nov 22, 2007
    Messages:
    65
    Likes Received:
    1,037
    Hello friend... seems to be nice try. I would like to know, is this can be used with SQLCE file, coz I need to use SQLCE for Client/Server software development. Please tell me if its possible, where i have to change the code...
     
  3. petbang

    petbang Registered User

    Joined:
    Nov 2, 2017
    Messages:
    7
    Likes Received:
    107
    1. Type 'odbcad32' in command pront o from the taskbar.
    2. Make sure you have the engine installed and correctly configured as user's DNS.
    3. Inside the file 'data.ini' substitute the string for your engine:

    [SYSTEM] #CONFIGURATION OF THE SYSTEM -----------------
    DRIVER = MySQL ODBC 5.1 Driver

    You can change the entire line to the correct one from the ConfiguratorINI module. Search and change for your connection string:

    Example:
    ConnectionString = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Persist Security Info=False;Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\Northwind.sdf"

    More help:
    https://social.msdn.microsoft.com/F...9a71ef34e1f5/sql-compact-with-vb6?forum=sqlce

    *LookDB is only demostration, there is still a lot of work, I hope it helps.
     
    Last edited: Nov 21, 2017
    Tagaroe, duclt2002 and Mario guerra like this.

Share This Page