|
Templates, Tools and Utilities
for Clarion Developers
|
 |
 |
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
SQL Related Articles: Create a MSDE database from Clarion
2003-01-20 -- Greg Berthume
Newsgroups: comp.lang.clarion
Code to process SQL file via PowerRUN:
!'c:\mssql7\binn\osql.exe -S' & GLO:ServerName & ' -Usa -P -i ' & GLO:SQLFile
Greg Berthume
Berthume Software
www.berthume.com
Coming Soon: cpTracker 2003 (Software Project Management System)
"Greg Berthume" wrote in message
news:3e2c0f47$1@news.softvelocity.com...
> I used PowerRUN to execute the following after MSDE is installed:
>
> !Button Code
> BEEP(BEEP:SystemExclamation) ; YIELD()
> Btn#=MESSAGE('WARNING: MS SQL Server 7 or MSDE must first be running on
'&|
> ' the PC.'&|
> '||Do you really want to Create the Database and User Logins?', |
> 'Create SQL Database and User Logins', ICON:Exclamation, |
> BUTTON:Yes+BUTTON:No, BUTTON:Yes, 0)
> IF Btn# = BUTTON:Yes
> GetServer ! Prompt for Server Name
> IF GLO:ServerName
> CreateDB
> .
> .
>
> !CreateDB Procedure's PowerRUN Extension setting
> !'c:\mssql7\binn\osql.exe -S' & GLO:ServerName & ' -Usa -P -i qde30.sql'
>
> I embedded the following code to install MSDE:
>
> ! Button Code
> BEEP(BEEP:SystemQuestion) ; YIELD()
> Btn#=MESSAGE('Do you really want to install MSDE?', |
> 'MS Data Engine Installation', ICON:Question, |
> BUTTON:Yes+BUTTON:No, BUTTON:Yes, 0)
> IF Btn# = BUTTON:Yes
> BEEP(BEEP:SystemAsterisk) ; YIELD()
> MESSAGE('A status bar is displayed during part of the installation, but
> '&|
> 'the setup will continue for several minutes after the status
bar
> '&|
> 'is no longer displayed.'&|
> '||To verify MSDE has been completely installed, \MSSQL7 should
> have '&|
> 'been created, there should be a new group on the
Start\Programs
> menu '&|
> 'called MSDE and \windows\setup.log should contain a ResultCode
> setting '&|
> 'of 0 and a Completed Status of 1 indicating a successfull
> installation.'&|
> '||Please reboot the computer after the installation is
complete
> so '&|
> 'that the \MSSQL7 folder is added to the PATH.', |
> 'MS Data Engine Installation Message', ICON:Asterisk)
> TIPath=path()
> P#=LEN(TIPath)
> IF P#>3
> IPath=TIPath & '\'
> ELSE
> IPath=TIPath
> .
> LOC:MSDECMD = 'msdex86.exe -a -f1 "' & IPath & 'unattend.iss"' !
> prefix -s for silent install
> RUN(LOC:MSDECMD)
> .
>
> Here's some code for "SQL Server Client Connectivity":
>
> BEEP(BEEP:SystemQuestion) ; YIELD()
> Btn#=MESSAGE('Do you wish to install silently (no interface) ?', |
> 'MS SQL Server 7 Client Connectivity Installation', ICON:Question, |
> BUTTON:Yes+BUTTON:No+BUTTON:Cancel, BUTTON:Yes, 0)
> IF Btn# = BUTTON:Yes
> BEEP(BEEP:SystemAsterisk) ; YIELD()
> MESSAGE('Please wait while the installation occurs.', |
> 'MS SQL Client Install', ICON:Asterisk)
> SETCURSOR(CURSOR:Wait)
> RUN('mdac_typ.exe /q:a /c:"setup.exe /qt"',1)
> SETCURSOR()
> BEEP(BEEP:SystemAsterisk) ; YIELD()
> MESSAGE('Installation Completed!', |
> 'MS SQL Client Install', ICON:Asterisk)
> ELSIF Btn# = BUTTON:No
> ?Window{PROP:Hide}=True
> RUN('mdac_typ.exe')
> ?Window{PROP:Hide}=False
> ELSIF Btn# = BUTTON:Cancel
> .
>
>
> Greg Berthume
> Berthume Software
> www.berthume.com
>
> Coming Soon: cpTracker 2003 (Software Project Management System)
>
> "KEVIN PLUMMER" wrote in message
> news:3e2b5101@news.softvelocity.com...
> > Hi,
> >
> > I'm looking to move a TPS application across to SQL. Most of my users
are
> > less than 5 users so I thought MSDE was a good option with bigger users
> able
> > to scale up using MSSQL2000.
> >
> > It is easy enough to create a MSDE installation disk, but how do I
create
> a
> > database from an install disk ? Even using FM3 you have to create the
> > Database first which is easy if you have the tools installed on your
> machine
> > but I don't want my users to have to do anything - just install and
start
> > using like TPS installation.
> >
> > Has anyone had any experience with this ?
> >
> > Cheers,
> >
> > Kevin
> >
> >
> >
> >
> >
>
>
Today is April 27, 2024, 12:10 pm
This article has been viewed 35114 times.
Google search
has resulted in 161 hits on this article since January 25, 2004.
Back to article list
Search Articles
Add Comment
Printer friendly
|
|
|
