Re: SQL Licencing Headaches.



garyusenet@xxxxxxxxx wrote:
can I use something like mysql? i've heard of it but thats about all.

Yes. From what I understand, MySQL is free for personal and commercial use, but if you want any support, you pay for that. There is a .NET library you can use to connect to MySQL called the MySQL Connector/NET.

PostgreSQL is another option, as is the afore-mentioned Firebird.

My application is a simple lead management program. Im looking for a
database solution that doesn't incur any licencing fees.

Then MySQL/PostgreSQL/Firebird is probably what you would be best using.

So far my app is one windows form, with controls databound to a sql
database i've created by 'new connection' and just typing the name of
the sql database i wanted.

None of the free database I've mentioned offer connectivity that is that simple, but connecting to those database servers isn't any harder than SQL if you do the connection entirely in code. It will be a learning experience, and its not very hard at all.

my only db experience is with access, and you simply wrote the
database, and paid per client for access. Thus my jaded logic says my
interface i've written (i.e. the windows form app) so there's no client
licence to pay now... so why should I pay to have the file sit on a
server and have data written to and from it? it seems crazy.

Any licensing scheme that is based on client connections, is goofy, in my opinion.

jeremiah
.



Relevant Pages

  • Re: hitting the limits
    ... relatively straight forward MySql database. ... 10K visitors a month and an 80Mb database are nothing. ... heavily loaded server. ... But the connection will hang around until the garbage ...
    (comp.lang.php)
  • Re: VFP8 & MySQL
    ... > VFP functions like NVL to a MySQL one, definitely it made the switch very ... > About your connection problem, I have mine setup as default for 100 ... As for the server, we left it ... The server crashed and corrupted the database. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP8 & MySQL
    ... Main Location and 3 branches (these are remotely accessing MySQL at the main ... About your connection problem, I have mine setup as default for 100 ... As for the server, we left it alone. ... The server crashed and corrupted the database. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Java and MySql program example ?
    ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
    (comp.lang.java.programmer)
  • Re: OdbcDataReader
    ... I did as you told and i find out that the connection to the MySql ... database closes and if i go to the MySql mamager i not able to open it ... >> While the odbccommand is reading the Access table I open the other ...
    (microsoft.public.dotnet.languages.csharp)