SQL Express

behi_ · 16th February 2006, 15:59

Hi everyone.

I am new at this forum and i had to join it becouse i have problem that i am solving it for 4 day.

I have app and i want to create installer for it. Including MS SQL Server Express. I have allready made installer that check for .net framework 2.0 and then installs WindowsInstaller and .net framework 2.0 if needed. Then installs MS SQL Server Express and it's working and runs SQL script for creating database and tables.

Now the big problem is MS SQL Server Express i have to check if there is MS SQL Server Express allready installed and then if there is i have to check if an instance (that is selected in advance for my app) allready installed and ask user for 'as' pasword. I did the checking of instance now i have to test if i can connect to it with pass that user gave.

I connect trough OSQL.exe and i am asking how can i read the sentence from comsole (detail window) if connection fail? So that i could ask user once more for pass.

kichik · 19th February 2006, 18:27

See How can I get input from the user?

behi_ · 20th February 2006, 10:53

I saw this already.

I am wondering how could i check, if i can login with that pass, that user gave me.

kichik · 21st February 2006, 18:22

Ah, then use nsExec. See Examples\nsExec\test.nsi for a working example. To search for a string use StrStr or another more advanced function.

16th February 2006, 15:59	#1
behi_ Junior Member Join Date: Feb 2006 Location: Slovenia Posts: 2	SQL Express Hi everyone. I am new at this forum and i had to join it becouse i have problem that i am solving it for 4 day. I have app and i want to create installer for it. Including MS SQL Server Express. I have allready made installer that check for .net framework 2.0 and then installs WindowsInstaller and .net framework 2.0 if needed. Then installs MS SQL Server Express and it's working and runs SQL script for creating database and tables. Now the big problem is MS SQL Server Express i have to check if there is MS SQL Server Express allready installed and then if there is i have to check if an instance (that is selected in advance for my app) allready installed and ask user for 'as' pasword. I did the checking of instance now i have to test if i can connect to it with pass that user gave. I connect trough OSQL.exe and i am asking how can i read the sentence from comsole (detail window) if connection fail? So that i could ask user once more for pass.

19th February 2006, 18:27	#2
kichik M.I.A. [NSIS Dev, Mod] Join Date: Oct 2001 Location: Israel Posts: 11,343	See How can I get input from the user? NSIS FAQ \| NSIS Home Page \| Donate $ "I hear and I forget. I see and I remember. I do and I understand." -- Confucius

21st February 2006, 18:22	#4
kichik M.I.A. [NSIS Dev, Mod] Join Date: Oct 2001 Location: Israel Posts: 11,343	Ah, then use nsExec. See Examples\nsExec\test.nsi for a working example. To search for a string use StrStr or another more advanced function. NSIS FAQ \| NSIS Home Page \| Donate $ "I hear and I forget. I see and I remember. I do and I understand." -- Confucius

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

20th February 2006, 10:53	#3
behi_ Junior Member Join Date: Feb 2006 Location: Slovenia Posts: 2	I saw this already. I am wondering how could i check, if i can login with that pass, that user gave me.