Geek Answers Handbook

Delphi 2010, SQL Server 2008, dbExpress. How to distribute the end user

I am using Delphi, but I am starting with databases.

I installed MSSQLServer 2008 Express on my computer, started developing ... I used TSQLConnection, made a registration form [hostname, database_name, username, password], and everything works fine on my PC.

But it does not work on my client PC. I do not know what to do with my exe to make it portable.

1) Error 1: Login failed, "dbxmss.dll is missing." I found the dll in my Delphi \ bin and told my client to put it in the exe folder. Q1) Is this a suitable place for dll?

2) Error 2: After that, he received: login failed, a catastrophic failure. I read tons of forum posts, it looks like I have to send it "SQL Server Native Client 10" for installation. Q2) Does this problem solve? I do not want to emphasize that my client is having a different setback. Q3) If yes, can I just pick up the dll (s) that SQL NC 10 installs and distributes the dll (s) instead of fully installing SQL NC 10?

Q4) Is there anyway to tell Delphi "pack me everything I need except exe"?

Thank you in advance

+4
source share
2 answers

To simulate the end-user environment on your computer, I recommend using a virtual machine (such as VirtualBox) and testing the installation steps. Using the snapshot function, you can return to the old images of the virtual machine, for example, before installing the database server or client software. This will allow you to prepare and test the software installation program for your application, without disturbing end users, on as many targeted OSs as you need to support.

+3
source

Q1: application folder is a great place to install dbExpress dll driver

Q2: Yes, the client needs to install its own SQL client.

Q3: No, you probably just can't capture the DLL and work. Driver components must be registered for OleDB and ODBC to work.

Q4: Not especially when you rely on third-party components.

Additionally, the mjn response of using VirtualBox to simulate your final user environment helps to avoid this kind of event in the future.

+1
source

More articles:


All Articles