Good day! May i ask?

This is the scenario:
The main purpose of daily activity report is to monitor the library transactions and to find out borrowers who are overdue. The report should be generated at the end of each business day and should contain the following data items: for each overdue borrowed item, report the name and address of the borrower, the return date, the title and the ID of the item; for each new library item, print all the related information.

How can i do this in vb using a mysql connection?
I am planning to create a database for borrowers who have penalties due to overdue. This database will gather or receive those overdue automatically from a database of borrower's record..Every transaction will capture the exact date and time by the system..A penalty will be considered if the borrower failed to return the book after 3 days...
Can u give me an idea?
Hope you will reply soon...thank you! God bless!

7 Years
Discussion Span
Last Post by reyborn

You can use ADODB to establish connection from VB6 to MySQL. But first, you must activate ADODB component by going to Project Menu -> Preferences ->Microsoft Data Object 2.8 Lib.
After activating the component, you may use the following code:
connectionObject.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=SERVER;Database=DATABASENAME; User=USERNAME;Password=PASSWORD;Option=3;"
You can download MySQL ODBC Connector here http://dev.mysql.com/downloads/connector/odbc/3.51.html

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.