MySQL used with VB .NET 1.0

[Tom Shelton]

I'm now thinking I should ask my hosting service to move me over to a
Windows host. There seems to be little or no downside to that, other
than the local backup of the site they want me to do before they move
it over. One other minor problem is they tell me that MySQL doesn't
work as well under Windows as it does under Linux. My guess is

Not sure why they would say that... I've used MySQL from windows applications
with great success in the past (as long as you use the .net wrapper - the odbc
driver sucks).

Here's a link to the current connector for .net:
http://dev.mysql.com/doc/refman/5.0/en/connector-net.html

 

[Ed Sowell]

Thanks, Tom. I'll have a look.

In a rush to go back to Microsoft I thought I'd play with the code I'd used
earlier to connect with the .CSV file, hoping to then save it to a .mdb (or
whatever) Access file. Could find no SQL command like DUMP I read about for
MySQL. In my searches I discovered the rather startling information that
says one cannot create a .mdb file from within. It has to exist before one
even thinks about working with it from within. I also found some postings of
C++ programs that allow one to create .mdb files. Hard to get my mind around
this. Only thing I can think of is they view the process as ALWAYS starting
with an empty database, never importing an existing one.

Ed

 

[Ed]

Tom, Cor,

Actually, Excel can write out a workbook as XML. I'm not committed to
CSV. However, the Using DataStream... is not accepted in my version of
Visual Basic. Doing a Search in Help for DataStream in my version
turns up nothing.

Ed

 

[Cor Ligthert[MVP]]

Ed,

You can use for XML simply

dim ds as new Dataset

ds.ReadXML(ThePath)

writing is

ds.WriteXML

Cor