Choosing SQL database ...

[Rimantas]

It seems that we talking about different things ...

That it's a waste of time ...

I don't think so. If you can't do the test I propose just say "I can't do it".

EMG

It seems that I wasn't right ... Enrico , I was talking about the time from "click" button to open mdichild with folder and 2 browses . The browses are very complex , they are related to others dbfs , I'm using own relation function in codeblock . Something like that : { || myfind( "MACHINES", OPERS->MACH_ID, "SHORT_MACH", nIndexForSearch ) } , which return "SHORT_MACH" field value from "MACHINES" dbf and other many things . Because are many records , it seems that browse something is stopping ... Open of DBFs it's fast . Excuse me , I was wrong . So I was misleading this discusion ... Sorry ... I did something like James test and then all clear ups ...

Regards !

[Enrico Maria Giordano]

No problem, Rimantas.

EMG

[Adolfo]

Also security is relative. In SQL you have one file if this is corrupt then all your data is lost. You can delete with on click a whole SQL server.
I had much work to keep the server always going. But as I say it depends on the purpose.
Programming is always at the end 0 or 1 and SQL has a good marketing.
Best regards,
Otto

Otto.
Security IS NOT relative. SQL is MUCH MORE secure than dbf's in all ways.
For DBF's you need an shared directory, seen by any PC on the net, that's enough for having any or all dbf's, cdx's erased.. or opened with any DBF utility, even Excel. ( ADS is the exception )
SQL is not. You need administrative rigths to enter any server. Second you never give administrative rigths to the aplication, you create a special user to have access thru the aplication with only the rigths you need to have.
SQL is not only ONE file ( depends on the DB), but is much more resistant to corruption than DBF's, BECAUSE IS A SERVER, you can also get changes back whenever you wanted, erase a whole day of data and have it like it was yesterday ( for example ), you have server logs to determine which changes were made. On the other hand...there's plenty of discussions on SQL speeds in the web, the worst are by far, those based on WINDOWS.
I uploaded my MYSQL server 2 years ago in my LINUX FEDORA CORE 7 server... and there it is.. running.. and running... and running.. no worms, DOS attacks, virus, trojans etc. Imagine, it is also the firewall for my Windows 2003 server, because WIN can't be facing the NET without checking it at least every 2 days... that's a routine I don't have with LINUX.

From Chile
Adolfo

[Otto]

Adolfo,

Be honest
>you can also get changes back whenever you wanted
If you say “you” you mean a specialist an administrator.

If there is a problem with a dbase file I say please open the explorer and copy file A from the backup folder to your data folder.

I did much work with SQL SERVER and VB.NET. But I am glad to have FIVEWIN and dBase.
I don’t know what kind of software you produce. The database depends on that.
What kind of software do you develop?

In my case most of the customers have 2 WS and one file server. There is no need for a database server in this case.


>For DBF's you need an shared directory, seen by any PC on the net, that's enough for having any or all dbf's, cdx's erased.. or opened with any DBF utility, even Excel. ( ADS is the exception )

You can work with your password on your tables on a SQL Server. In practice it is the same as with your dbf-files in a folder.

Maybe you are save as long as you install all the service packs and the setup of the server is correct. Administrator is a profession. But not every SQL server is setup by a professional. This is much work. As always after every SP you have to change the setup etc. .

The Lifetime Cost - a total of all costs you have for a software product like ours would be much higher if I would use SQL.

Please google:
Hacking an SQL Server Ergebnisse 1 - 10 von ungefähr 3.030.000 für Hacking an SQL Server.
sql server down Ergebnisse 1 - 10 von ungefähr 15.000.000 für sql server down
sql server Troubleshooting
sql server Performance Problems Ergebnisse 1 - 10 von ungefähr 8.990.000 für sql server Performance Problems
etc.

I don’t understand why there are so many pages full with performance problems, server down, troubleshooting?

Best regards,
Otto

[Adolfo]

>you can also get changes back whenever you wanted
If you say “you” you mean a specialist an administrator.

YES...me. If I Use SQL .. I have to know how to do this... If you work with DBF, at least you should know how to use DBU. Don't you?

You can work with your password on your tables on a SQL Server. In practice it is the same as with your dbf-files in a folder.

IMPOSSIBLE....As a good ADMINISTRATOR and DEVELOPER.... never work with the administrator user , create a work user without all privileges... or you log into a linux box as ROOT?... In DBF case... your son playing in you PC can erase the folder with no problems at all..... "In practice it is the same as with your dbf-files folder "

Maybe you are save as long as you install all the service packs and the setup of the server is correct. Administrator is a profession. But not every SQL server is setup by a professional. This is much work. As always after every SP you have to change the setup etc. .

I've never installed a service pack in LINUX....( always use final releases ) there the problem is not SQL... is the SO... maybe MICRO$OFT.

When you have a hosting....you do nothing of these. Just uploaded my DB, and use it from all my customers locations.

The Lifetime Cost - a total of all costs you have for a software product like ours would be much higher if I would use SQL.

Yes. SQL is not for all kind of software.

I don’t understand why there are so many pages full with performance problems, server down, troubleshooting?

Mainly because is so widely used by so many kind of users (from students, to IT pro )... now if you seek within these pages most of them are related to MICRO$OFT products and SO. Also remember that there at least 7 main brands of sql servers... MS, Mysql, Oracle, Postgress, Sybase, DB2, SQLITE (wich is more used than you think since is a embeded SQL engine )... so the number of actual users and developers is HUGE....

Finally... XHB,FWH and Mysql is a very good combination.

From Chile
Adolfo

[Otto]

Hello Adolfo,
are you kidding.
I know that you are capable of.
I mean “you” in the sense of John Doe.

Her all the systems I know have WINDOWS installed. Therefore I can’t say anything about
LINUX.
Best regards,
Otto

[Adolfo]

Hello Adolfo,
are you kidding.
I know that you are capable of.
I mean “you” in the sense of John Doe.

Her all the systems I know have WINDOWS installed. Therefore I can’t say anything about
LINUX.
Best regards,
Otto

YEP...LINUX Rocks

Sincerely.. I tried twice to have a decent SERVER with Windows... there were so many problems..... we have to put it after a Linux Firewall to work with it. And the machine was a monster (for that times a P4, 1 GB RAM, 2 SCSI HD, HP ) with 2003 Server and MS Sql Server, It was used for a big ERP solution. But once you put it to the web, it was a turtle, heavy and slow, all local processes became slow. The software was a mix of VB, JAVA and .NET, VB for local work, JAVA for WEB access and .Net for conectivity and services. In the meantime we have to download 3 SP and patches. The developer of the ERP asked us to put more RAM on the server, and have more bandwith available. I decided to put it inside the net, after a Linux Firewall and Proxy. There were no more problems with it. It's still working, but once or twice a week I have to check its logs looking for problems.

On the other hand. I think that a great solution is to have an external HOST with MYSQL or whatever SQL solutions you'll find. Here in CHILE for a 10 GB disk Space, NO traffic Limit, 25 MYSQL db's, 500 mail accounts, auto backup, and some "extras" for only U$ 25 monthly... a server, administration, backup, web access, 24/7 support, 99.999 uptime monthly.
Licences included.

I think is a solution for those who don't know how to administrate a Server, or doesn't have money to have his own with at least a T1 connection.

There you only ask your client to have a decent ADSL conection, and they can work from their homes, other locations, or while travelling etc. etc.

From Chile
Adolfo

[James Bott]

Adolfo,

A hosted server sounds like a very good idea for most small businesses. I will keep it in mind. Thanks for the info.

Regards,
James

[alvaro533]

Hi, I know it is an old post, but how can I install the ODBC driver in silent mode? I am using this one, and the switch /s does not work

http://www.ch-werner.de/sqliteodbc/

Thank you very much.
Alvaro

Dear Mr.Adolfo,

My intention is that when I run my FWH app, the FWH application should be able to check whether the ODBC driver is installed or not. If not installed then it will install the ODBC driver in Silent mode

Regards
Anser

[Rimantas]

Hi, I know it is an old post, but how can I install the ODBC driver in silent mode? I am using this one, and the switch /s does not work

http://www.ch-werner.de/sqliteodbc/

Thank you very much.
Alvaro

Alvaro ,

At first this ODBC you must to install as a package in user PC . So you must to check PC system DSN names , if not exist , then you must run installation of this ODBC as driver . After installation you will create ODBC connection from your application ...

[alvaro533]

Thank you for your answer, Rimantas,

I have the app working fine with the driver installed. Now I have to send the program to my customers. I would like to be able to install the OBDC driver in silent mode, since some of my customers don't speak English and the driver instalation is in English. The parameter /S does not work. In this topic, someone said that it could be installed in silent mode, but I don't know how to do it. The driver I am refering to is this one:

http://www.ch-werner.de/sqliteodbc/

Thank you,

Alvaro

[Rimantas]

Thank you for your answer, Rimantas,

I have the app working fine with the driver installed. Now I have to send the program to my customers. I would like to be able to install the OBDC driver in silent mode, since some of my customers don't speak English and the driver instalation is in English. The parameter /S does not work. In this topic, someone said that it could be installed in silent mode, but I don't know how to do it. The driver I am refering to is this one:

http://www.ch-werner.de/sqliteodbc/

Thank you,

Alvaro

Alvaro ,
I'm using the same SqLite odbc driver . It seems that you don't understand me ... . As I mentioned , the problem is that the user must install ODBC driver . You must to send to user own program and instalation package of this ODBC driver . The parameter /S is for creating DSN name of ODBC driver from your FWH program . This isn't the same . Let talk about Access dobc driver . The Access odbc in all win systems alreday exist . So you can with FWH programm create new DSN ( data source name ) of ODBC with all parameters . This can be done with /S parameter . But mentioned SqLite ODBC driver didn't exist in windows system . You must to run installation of this driver .
The best way is to get remote connection to user PC and install ODBC driver .

[reinaldocrespo]

Hi.

Going back to the comparison between dbfs and sql; I think it is hard to appreciate the magnitud of the advantages offered by an SQL server side engine (ADS, MySql, MSSql, ASE, iAnywhere, ...) that are simply impossible to reproduce with plain dbfs. For example:

1. Server side triggers. Yes -this is huge.
2. Server enforced referential integrity rules (i.e no orphan records). -Peace of mind.
3. Transactions. More peace of mind.
4. SERIOUSLY Reduced network traffic.
5. zero table corruption. You'll love it when you no longer have to restore a table or try to fix it.
6. Data security -tables do not need to be placed on a "shared" directory where a malicious user could do as he pleases.
7. Server Notifications to clients.
8. Replication.
9. Remote http access (via php, Java, ... clients)
10. Much more advanced field types

ISAM has its beauty and I have always thought that most people on the SQL community undervalue its worth. With ADS you have SQL + ISAM. I don't think any other SQL engine does the same + zero maintenance.

Reinaldo.

[Rimantas]

Hi.

Going back to the comparison between dbfs and sql; I think it is hard to appreciate the magnitud of the advantages offered by an SQL server side engine (ADS, MySql, MSSql, ASE, iAnywhere, ...) that are simply impossible to reproduce with plain dbfs. For example:

1. Server side triggers. Yes -this is huge.
2. Server enforced referential integrity rules (i.e no orphan records). -Peace of mind.

ISAM has its beauty and I have always thought that most people on the SQL community undervalue its worth. With ADS you have SQL + ISAM. I don't think any other SQL engine does the same + zero maintenance.

Reinaldo.

Why I'm migrating to SQL ? I'm thinking that good project must have 2 parts - database and application . And database must have business logic in triggers and UDF's . Application can be from FWH, RIA with javascript and etc . When user in applications data grid change values , then database triggers & udf's are doing needfuls actions . The application only must to do a way to needfulls datas . Then you can to separate more forces for a good solutions how to browse , present this datas . With DBF's all business logics is in application . If I change something related data to remain of stock , I must to do some other changes in other DBF's tables with application . This isn't a good way . If to change application , from FWh to Visual Basic ( as for sample ) then programmer must to do the business logics with other language .

Maybe alreday exist something similar with and with DBF's ( excluding ADS ) . The DBF's with own simplity have charm . For a simply projects they are irrepleaceble ...

With best regards !