VS 2010 Database Technology Question-VBForums
Results 1 to 7 of 7

Thread: Database Technology Question

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2010
    Posts
    178

    Question Database Technology Question

    I'm wondering if there is a better technology than Access. I know the answer is yes, but I'm meaning in situation.

    Where I work I have to use what is given to me or use something that doesn't need to be installed.

    Access is a given. Been doing some research as well as reading on here. Access is just plain slow and would like something faster. My program shouldn't used by more than 1 at a time, so I don't need anything heavy duty.

    I read about SQL Server CE and that it doesn't need to be installed, but it needs DLL files. I would rather not have to put them on the server. I would only like my exe and the database file (if any) to be in the directory on the server. Basically would it be possible to put the DLL files into my exe and use it from there or there any other technology that I can use that is better than Access?

  2. #2
    PowerPoster
    Join Date
    Mar 2002
    Location
    UK
    Posts
    4,592

    Re: Database Technology Question

    When you install your app, what is the issue with installing a couple of other files to the same directory? It is no more complex than a copy paste of 1 folder instead of copy and paste of 1 file for CE, nothing is registered, just copied (read private install part). In order to use access you need a driver, which with odbc/access already installed makes your job easier, but it still had to be there, the same as the sql engine has to be there the same as oracle, the same as SQL CE. Trying to avoid the problem will not make it go away, to connect to a database, you need the right database drivers/software installed.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Oct 2010
    Posts
    178

    Re: Database Technology Question

    I'm not installing my application. I'm just copying the exe file. I don't have admin privileges. The least amount of files, the better. The files are stored on the network, so multiple users have access to it, and they would quesiton me as to why I needed so many DLL files (7 of them from SQL CE).

    Things in common: Office 2007, .Net 3.5.

  4. #4
    Lively Member S0LARIS's Avatar
    Join Date
    Apr 2011
    Posts
    121

    Re: Database Technology Question

    Use *.dbf file as database.
    And there will be no need to include any other files,except your exe file and *.dbf(database) file and maybe maximum just one dll/ocx file.

    Or you can firstly install ADO control on that machine(s) and only after deploy exe file, that's it.

    And here is link,how to read from dbf using ADO:
    http://www.developerfusion.com/threa...ing-ado-howto/
    If my post was helpful to you, then express your gratitude using Rate this Post.
    To understand recursion, you must first understand recursion.

  5. #5
    PowerPoster
    Join Date
    Mar 2002
    Location
    UK
    Posts
    4,592

    Re: Database Technology Question

    Quote Originally Posted by TrickyNick View Post
    I'm not installing my application. I'm just copying the exe file. I don't have admin privileges.
    Did you read the link?

    Private file–based deployment refers to the process of including the required SQL Server Compact 3.5 DLLs as files in the project (as opposed to a reference to DLLs already on the target computer). If you include the necessary DLLs with the application, the requirement to install SQL Server Compact 3.5 is removed. Therefore, the administrative credentials are no longer needed.

  6. #6
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    15,754

    Re: Database Technology Question

    SQL CE is really much less powerful than ACCESS - in the way you can write queries and such. It's meant more to be more of a data storage vehicle.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  7. #7

    Thread Starter
    Addicted Member
    Join Date
    Oct 2010
    Posts
    178

    Re: Database Technology Question

    Taking SQL CE out, are there any databases that would be better than Access, be quicker & faster that wouldn't need to be installed?

    And to answer Grimfort: No didn't read the link I actually missed it when i first saw your post, I appologize, going to read it now. To the 2nd part of your post, yes, but they say to copy the files to the directory which I'd not like to do and have to answer why I had to have so many DLLs. Would rather those DLLs be stored inside my exe.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.