ลงชื่อเข้าใช้
 
หน้าหลักLibraryเรียนรู้ดาวน์โหลดการแก้ไขปัญหาชุมชนฟอรัม
ทรัพยากรสำหรับผู้เชี่ยวชาญด้าน IT >
> 
> 
SQL service installation at client end

Answered SQL service installation at client end

  • 5 มีนาคม 2555 4:35
     
     
    ลงชื่อเข้าใช้เพื่อโหวต
    0

    hello,

    i have a project which i have to install at the client end. it is done in VB.net and SQL 2008R2(SQLEXPRESS). My problem is when i make a setup file including All the necessary files (.mdf, .ldf, etc) and try to install at the clients end. the installation is complete, but when i try to run, it gives an error of SQL, coz the client machine does not have SQL, i do not want to install the whole SQL server coz it is a very small project, what are the alternatives for it please

    thanks and regards

    HV

    • ย้ายโดย Bob BeaucheminMVP 6 มีนาคม 2555 6:14 Moving to a more relevent forum for better results (From:.NET Framework inside SQL Server)
    •  
     

ตอบทั้งหมด

  • 5 มีนาคม 2555 15:16
     
     คำตอบที่เสนอ
    ลงชื่อเข้าใช้เพื่อโหวต
    0

    hi,

    If you would like to use your database made in SQL Express, you need to install it on your client's machine. If you do not want to install it, you may look for another data store, like xml or SQL CE. The latter is just a bunch of DLL files afaik.

    Another option is to install another editon than express on a central server and connect the app for that instance from every machine.

    I hope it helps.

    Janos

    There are 10 type of people. Those who understand binary and those who do not.
    My Blog

    • เสนอเป็นคำตอบโดย Zoltán Horváth 9 มีนาคม 2555 14:56
    •  
     
  • 5 มีนาคม 2555 16:41
     
     
    ลงชื่อเข้าใช้เพื่อโหวต
    0
    hello,

    thanks for your input, but how can i make an inventory control system work with XML or SQL CE. is it feasible.
    If yes then i will do my research. but kindly let me know if it is feasible or not
    thanks for your advice

    rgds

    HV

     
  • 7 มีนาคม 2555 7:04
    ผู้ดูแล
     
     คำตอบ
    ลงชื่อเข้าใช้เพื่อโหวต
    0

    Hi Hari vaag,

    For SQL Server compact you can refer to this reference: http://support.microsoft.com/kb/920700/en-us

    I suggest you to use SQL Server localDB, LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines. Moreover, if the simplicity (and limitations) of LocalDB fit the needs of the target application environment, developers can continue using it in production, as LocalDB makes a pretty good embedded database too.

    You can refer to: http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx 

    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • ทำเครื่องหมายเป็นคำตอบโดย Hari Vaag 7 มีนาคม 2555 12:18
    •