请问在installshield中能自动执行建库建表的sql命令吗？

[lurry]

如果我想在安装asp文件时自动执行sql命令，该如何去做？谢谢！！

[ttt2]

发过去了

[szqed]

我也想要一份源程序。因为我也需要做发布程序。
我的邮箱[e-mail]

[lurry]

谢谢您，我先看一下。

[lurry]

我是installshield 5.1，无法打开源程序，哪里有6.1或6.2的下载？

[playmud]

可以，也可以用asp文件创建表
例子如下：
<%
On Error Resume Next
set con=server.createobject("adodb.connection")
con.open "server=(local);driver=sql server;database=redriver;uid=sa;pwd="
'Catalog
'con.execute "drop table Catalog"
sql="create table Catalog( CatalogID int NOT NULL ,"&_
"CatalogName nvarchar(40) Not Null,"&_
"FatherID int not null)"
con.execute sql
'con.execute "drop table Product"
sql="create table Product( ProductID int identity(1,1) NOT NULL ,"&_
"ProductName nvarchar(100) Not Null,"&_
"ProductNumber nvarchar(40) Not Null,"&_
"StopFlag bit not null,"&_
"Bitmap nvarchar(50) Null,"&_
"Notes ntext null,"&_
"Discount real null,"&_
"Price real null,"&_
"FatherID int not null)"
con.execute sql
Response.Write Err.Description
%>

[ttt2]

能sqlserve导出sql语名
然后用installshield执行
我有成功的源程序

[lurry]

能贴出来吗？或者给我发一份，好吗？[e-mail]
非常感谢！一定给分。

[liao_yy]

我也想要一份:[e-mail]

[qimz]

能给我一份吗？[e-mail]

[PerfectCK]

用Osql.exe执行SQL脚本！

[cuizhiyong]

给我一份吧。谢谢：）
[e-mail]

[julyclyde]

没用过SQL SERVER啊？
OSQL.EXE就是SQL SERVER里边的

[softwareforjava]

给我一份吧:
[e-mail]

[Jaron]

要了解更多的关于InstallShield的资料,请访问http://www.jiangdu.net/bbs

usage: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted Identifiers]
[-L list servers] [-c cmdend]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary]