|
|
 | | From: | DavidM | | Subject: | Re: VB6 Users | | Date: | Sat, 18 Dec 2004 17:53:54 -0600 |
|
|
 | My problem is -- I have a SQL Server application that I want the ability of
SETUP to update the database during install. Can Inno handle this?
Should I create another standalone DB application that users must run to
update the database schema, indexes, tables, etc?
Whats the norm?
"David M. Camp" wrote in message
news:cpc2so$a1s$1@news.jrsoftware.org...
>I use Inno for all my setup programs.
>
> I program using VB6, Crystal Report 9, MS-Access(2000).
>
> All of my programs will use an Access database, The reports will use CR9.
>
> I have wrote setup programs that will install my software on Windows/98,
> Windows/2000, Windows/XP, Windows/NT4.
>
> I love Inno Setup!!!!!!
> David M. Camp
>
>
|
|
| | From: | Kevin Puetz | | Subject: | Re: VB6 Users | | Date: | Sun, 19 Dec 2004 13:08:20 -0600 |
|
|
| DavidM wrote:
> My problem is -- I have a SQL Server application that I want the ability
> of
> SETUP to update the database during install. Can Inno handle this?
>
> Should I create another standalone DB application that users must run to
> update the database schema, indexes, tables, etc?
>
> Whats the norm?
>
>
> "David M. Camp" wrote in message
> news:cpc2so$a1s$1@news.jrsoftware.org...
>>I use Inno for all my setup programs.
>>
>> I program using VB6, Crystal Report 9, MS-Access(2000).
>>
>> All of my programs will use an Access database, The reports will use CR9.
>>
>> I have wrote setup programs that will install my software on Windows/98,
>> Windows/2000, Windows/XP, Windows/NT4.
>>
>> I love Inno Setup!!!!!!
>> David M. Camp
>>
>>
It certainly seems like it should be possible - Inno's scripting language
can talk to stdcall DLL interfaces, and to COM objects, so it would seem
possible to use DAO/ADO/etc and set things up. I've never done anything
quite that fancy, but I don't see why it wouldn't work...
Depending on how complex your setup is (and how familiar you want to get
with pascal script), another approach would be to write the setup code as
part of the application, and run when it's needed. Of course, to do this,
you have to be able to detect this - I have a table of version data as part
of my schema, so I know. Alternatively, you could put it in your app under
a special /setup commandline switch, which you could call from Inno at the
end of installation.
|
|
| | From: | Sven Axelsson | | Subject: | Re: VB6 Users | | Date: | Sun, 19 Dec 2004 22:37:20 +0100 |
|
|
| On Sat, 18 Dec 2004 17:53:54 -0600, DavidM wrote:
> My problem is -- I have a SQL Server application that I want the ability of
> SETUP to update the database during install. Can Inno handle this?
>
> Should I create another standalone DB application that users must run to
> update the database schema, indexes, tables, etc?
>
> Whats the norm?
>
>
> "David M. Camp" wrote in message
> news:cpc2so$a1s$1@news.jrsoftware.org...
>>I use Inno for all my setup programs.
>>
>> I program using VB6, Crystal Report 9, MS-Access(2000).
>>
>> All of my programs will use an Access database, The reports will use CR9.
>>
>> I have wrote setup programs that will install my software on Windows/98,
>> Windows/2000, Windows/XP, Windows/NT4.
>>
>> I love Inno Setup!!!!!!
>> David M. Camp
The norm is to just call osql with a SQL file that contains whatever you
need to do to set up the environment. Something like this:
osql /U username /P password /i doit.sql /o result.txt
--
Sven Axelsson, Sweden
|
|
| | From: | DavidM | | Subject: | Re: VB6 Users | | Date: | Sun, 19 Dec 2004 21:23:56 -0600 |
|
|
| Can Inno Setup be customized to prompt the user for a valid SQL Server
login/password and server name?
"Sven Axelsson" wrote in message
news:1uuwj289xgwno.rl32zqlgzskq.dlg@40tude.net...
> On Sat, 18 Dec 2004 17:53:54 -0600, DavidM wrote:
>
>> My problem is -- I have a SQL Server application that I want the ability
>> of
>> SETUP to update the database during install. Can Inno handle this?
>>
>> Should I create another standalone DB application that users must run to
>> update the database schema, indexes, tables, etc?
>>
>> Whats the norm?
>>
>>
>> "David M. Camp" wrote in message
>> news:cpc2so$a1s$1@news.jrsoftware.org...
>>>I use Inno for all my setup programs.
>>>
>>> I program using VB6, Crystal Report 9, MS-Access(2000).
>>>
>>> All of my programs will use an Access database, The reports will use
>>> CR9.
>>>
>>> I have wrote setup programs that will install my software on Windows/98,
>>> Windows/2000, Windows/XP, Windows/NT4.
>>>
>>> I love Inno Setup!!!!!!
>>> David M. Camp
>
> The norm is to just call osql with a SQL file that contains whatever you
> need to do to set up the environment. Something like this:
>
> osql /U username /P password /i doit.sql /o result.txt
>
> --
> Sven Axelsson, Sweden
|
|
| | From: | Anton | | Subject: | Re: VB6 Users | | Date: | Tue, 21 Dec 2004 16:35:37 +0000 (UTC) |
|
|
| DavidM wrote:
> Can Inno Setup be customized to prompt the user for a valid SQL Server
> login/password and server name?
Yes. It has [code] section. There you can add your custom forms.
|
|
| | From: | DavidM | | Subject: | Re: VB6 Users | | Date: | Tue, 21 Dec 2004 13:08:35 -0600 |
|
|
| Does someone have some samples of doing this?
If I prompt for login information to SQL, will it allow me to run an EXE
that is within the SETUP? Just trying to figure out how this all works.
"Anton" wrote in message
news:9c68e9acc5f9b45859b20776100f5762$1@news.jrsoftware.org...
> DavidM wrote:
>
>> Can Inno Setup be customized to prompt the user for a valid SQL Server
>> login/password and server name?
>
> Yes. It has [code] section. There you can add your custom forms.
>
>
|
|
|
