Programmers on board? SQL help any one ??

n2_neon

Member
Oct 27, 2008
2
0
0
Colombo
i have a MDF sql file!! and i need a source code for reading it without accessing sql server ! cause the application which is to be devoloped is an home use application so client shouldnt have to worry about installing sql server for function to be excecuted so if there is a source (if java most prefered) pls share the knowldege with me

thanks!!
:nerd: :confused:
 

magicman

Member
Feb 8, 2008
327
5
0
In the magic world
n2_neon said:
i have a MDF sql file!! and i need a source code for reading it without accessing sql server ! cause the application which is to be devoloped is an home use application so client shouldnt have to worry about installing sql server for function to be excecuted so if there is a source (if java most prefered) pls share the knowldege with me

thanks!!
:nerd: :confused:


Google it man.. ;)

cheers !!!
 

kosandpol

Well-known member
  • Jun 10, 2008
    45,329
    1,492
    113
    There's no such thing. Trying to access the SQL database directly means you're trying to code an SQL server.
    Use SQL Desktop Engine or SQL Express which you can re distribute with your package so that when the client installs your software it automatically installs the SQL server as well.
     

    n2_neon

    Member
    Oct 27, 2008
    2
    0
    0
    Colombo
    installing the sql server on the client machine is not only just grabbing a service and running on the client i guess !! to do take the sql server to the client how do i do it ! ?? ok or is there a better solution my databse contain 2.3 million records
     

    kosandpol

    Well-known member
  • Jun 10, 2008
    45,329
    1,492
    113
    Use MS SQL DESKTOP ENGINE or MS SQL EXPRESS which you can redistribute with your application. Both of them supports unattended installation so the client wouldnt know that it was installed.
    Else you can use MySQL or MySQLi database which can be redistributed as well.
    Or if its static data, use a MS ACCESS database to store the data.