DB Script ADO Connection *.dbf file

[lexd]

http://www.codeproject.com/Articles/...on-Strings#OLE DB SqlServer

talk about connection strings or scripts, one script makes a tcp/ip Localhost to ADO connection
I do not get what type of script or how to use the script.

some software uses *.dbf files to make a ADO connection that I would like to make

I have MySQL Server 5.7 that is at the moment With a schema called foo.co.nz containing a table named 'users' that I will add more tables too, that I want a ADO Connection to.

How do I make a this foo.dbf file to do this and how do I install it like Delphi does with their demos.

I found
http://phplens.com/lens/adodb/tute.htm but I do not know how to run it ether

[dilettante]

.DBF files are normally dBase or xBase tables.

There are a couple of ways to use these with Microsoft software either standard in Windows or downloadable/installable. I have no idea what MySQL or Delphi have to do with them at all. Where any "script" fits in here is a total mystery to me.

You mention a lot of stuff, but is normal VB involved? Or even VB.Net which belongs in another forum here? Perhaps your question belongs over in the database forum?

I can't decipher what you are after. Maybe you can rephrase the question?

[DataMiser]

Assuming that you are using VB6 and ADO and want to talk to MySQL then maybe this will help
https://dev.mysql.com/doc/connector-...ng-vb-ado.html

[DataMiser]

As for the ADO connection. You use a connection string which is just a string of text. If you would have checked your other thread instead of starting a new one you would have saw an example.

VB can work with MySQL using ADO without and issue.

As far as completely setup I have no idea what you really mean by that.

[dilettante]

Most cheap/free MySQL hosts do not allow database connections through their firewalls anyway for security purposes. Some will offer "white listing" of one or a few IP addresses but that's useless if you don't have a fixed IP address.

[lexd]

DataMiser Thank you very much, and thanks all you other gays for trying, its how to register into the ADO that's the last link I have to understand. I believe I must end up with a ActiveX result in the end some how

[DataMiser]

What do you mean by how to register into the ADO?

If you are coding in VB you have to add a reference to Microsoft ActiveX data objects to your project.
You must have the MySql connector installed on your PC
You must use the proper connection string

From there it is like any other ADO project.