Recent content by peekay

Thanks David and dilettante, Four issues I need to pursue. 1. The link of dilettante is insightful and I will go through that process. Must I presume that the reference to 32 bit is to VB6 or to the database? 2. David gave and ADO solution which I will test. However, I need a DAO one. As far...

I have tested the ODBC DSN and it works but the following code statement fails with error: ODBC - call failed: Dim Conn As Connection Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DSN=IBSMSbloem;") What can be the problem? Thanks PK Odendaal

The code fails on this statement: Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DSN=IBSMSbloem;") Thanks PK Odendaal

Second attachment PK Odendaal https://files.engineering.com/getfile.aspx?folder=4b883159-b0f4-4444-8aa3-174526d31f5a&file=DSNbloemVB.jpg

I have created and tested a database with DSN - see attachment. When I try to open the connection in VB6 I get an error - see attachment (on next message). What can be the problem? Thanks PK Odendaal...

Thanks so much spamjim. PK Odendaal

First error PK Odendaal https://files.engineering.com/getfile.aspx?folder=469eb19a-c697-4ebd-8f53-f5fa9f3dbdba&file=Workbench_error.jpg

Thanks spamjim. 1. I have this error (screenshot attached) opening the Workbench. How can I fix that? 2. Workbench refers to MySql database engine and to Mariadb paths (screenshot attached). How do I know I use MariaDB and how do I change this configuration? 3. I used the following code on...

Maybe I should backtrack a little first. I am on windows 7 presently and developing with VB6. Access is becoming too small for my purposes. 1. Is MySql a database with all the necessary functions access has and does it have integrity for big data? 2. Why should I use MariaDB if I only need a...

Thank you all for your valuable contributions. One more question. Do I need to use phpmyadmin with MariaDB on windows 7 or the workbench? PK Odendaal

Thank you so much Chris. 1. I presume Linux Ubuntu is ok for the operating system. 2. Are the drivers for MySql and MariaDB the same? 3. Is it easy to port the database to another server should I wish to do so later? PK Odendaal

Reposting from VB6 I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access. 1. Can this be done and are the changes significant? 2. Do I need to use PHP or can I edit directly like I do now with DAO or even ADO. 3. What is the best...

I wish to change my VB6 program/s to read, write edit and delete data from a MySql database in stead of from MS Access. Can this be done and are the changes significant? Do I need to use PHP or can I edit directly like I do now with DAO or even ADO. Thanks PK PK Odendaal

chiph Thanks for the help - I will take this route, but I still need some assistance if you please. How do I set up the datatable ? Must I first set up a dataadapter and fill the dataset or can I directly do a sql query and fill the datatable. If you have some code I will appreciate. Thanks PK...

This is a VB.NET and Access question. ThatRickGuy - can you please elaborate on the SQL Thanks PK Odendaal