Re: MySQL used with VB .NET 1.0

Is this still the web site for the car club? If so, you should forget about using SQL. There is no point in putting that data into a database just so you can drag it out again to build the page. Go back to the CSV file you started with.

Whatever process you eventually develop for getting the data from an EXCEL spread*** on your machine into a database on your ISPs server will be much more complicated than a simple CSV export and FTP.

In fact, based on your first description, it would almost be simpler to manually build the pages each time they need updating and reload them to the server - a simple VB routine to create the variable portion of each page from the CSV file, insert it into the fixed portion, and you're done. Not elegant, but adequate.

The database solution is not worth the effort unless you have a need to learn the procedure, such as other projects coming up that require a database.

"Ed Sowell" <jag_man__REM0VE__653@xxxxxxxxxxxxx> wrote in message news:2BF43F87-6B49-41B6-BFD1-C050C5448253@xxxxxxxxxxxxxxxx
Ah, now I understand. But as you note, SqlServer is not an option on Linux servers. While I was investigating that, I revisited my hosting service and compared the available support on Linux vs. Windows servers. What I see there is discouraging, as it shows all the Windows stuff, e.g., ASP.Net 1.1 & 2.0 and .Net Framework as not supported on Linux. I'll ask them just to be sure but if that is as it seems my current little project is not going to work at all.

Ed


"Cor Ligthert[MVP]" <Notmyfirstname@xxxxxxxxx> wrote in message news:ON6$EeKwJHA.3832@xxxxxxxxxxxxxxxxxxxxxxx
Ed,

I don't think that much people here use MySql as SqlServer Express from Microsoft is freeware.
Therefore most people here uses the full versions of SqlServer or SqlServer Express

I have seen often issues with mySql from the point of view of the AdoNet newsgroup.
But as you have troubles with that, then that newsgroup can "maybe" help you.
I don't for the reason above not have experience with mySql

Cor




.