How to use MS SQL Server in your Delphi programs!

[@carloscrusca2]

Thanks for the video. One question, the Delphi Berlin have compatibility with SQL Server 2019 Standard?

[@delphiprogrammingtutorials2280]

Hi, Carlos, and thanks for your question. To the best of my knowledge, yes, they are compatible. However, that said, different sets of data access components (DAC) work a bit differently from one another. What DAC are you using to connect Delphi Berlin to SQL Server? Thank you so much for subscribing to my channel!

[@troyfrei2962]

Thank you very much!! Hey when you deploy the app you need to deploy part of the database with the app. How do you include the database and the app with the install? How does your app tell where the dir database is at after you install it on another computer?

[@delphiprogrammingtutorials2280]

Thanks for your comment, Troy! Yes, the end user must have the MS SQL Server on their machine to make use of the app. I think the best way is to generate the SQL script for the database and run that against the MS SQL Server to create the database. Then, as part of your application, create a start-up dialog where the end user can enter the pertinent connection string when launching for the first time. The MS SQL Server Express 2019 and the SQL Server Management Studio are free and distributable according to the Microsoft download link I posted in the description of this video tutorial. That gives you ample options to have when deploying to an end user. I hope this helps. I personally would remote connect to the end user and walk them through the entire setup the first time, if that's possibly. You can also search on the web as there are lots of installation programs that can handle something like this. If you have any other questions, just ask!

[@delphiprogrammingtutorials2280]

Let me also recommend the Inno Setup program you can get here: jrsoftware.org/isinfo.php. This program gives you lots of flexibility for installing everything you need to. Maybe you've used it or are using it. Once you get your installation script right, you can use it over and over to install everything. Let me know. Probably a good idea for another tutorial! 😉

[@delphiprogrammingtutorials2280]

While this is for an older version of MS SQL Server, it's still can get you started. stackoverflow.com/questions/454431/how-to-install-sql-server-2008-express-with-inno-setup

[@delphiprogrammingtutorials2280]

Have a look at this link, too. It's also free! www.kymoto.org/products/inno-script-studio

[@januszpodkoscielny348]

Thank you. I can connect with entering password. I cannot save password in my ADOCOnnetion. If I do that and turn off login prompt like you showed I allways get "Login failes for user SA" What is going on?

[@malaklafleur]

can you help me please !!! iI need your help please regarding creating an Android Delphi application and linking it with SQL

[@delphiprogrammingtutorials2280]

I honestly have never had any call for an Android or IOS app, what's more, connecting one to MS SQL. So very sorry. I'm sure if you Google it, you can find some help.