当前位置：首页 -> 技术开发 -> ASP专区 -> 谢谢版主对我的回答，但用ADOX中的CREATE只能建ACCESS库，我找了个建SQL SERVER

谢谢版主对我的回答，但用ADOX中的CREATE只能建ACCESS库，我找了个建SQL SERVER

时间： 2021-07-31 作者：daque

<%'*********************************这是本领一dim oconn dim sdatabasename sdatabasename = "test1"set oconn=server.createobject ("adodb.connection")oconn.open "provider=sqloledb;data source=you_server;user id=sa;password=you_sa_password;"oconn.execute "create database " & sdatabasenameoconn.close set oconn=nothing'*********************************本领一中断'*********************************这是本领二dim osqlserver dim odatabase dim odbfiledata dim ologfiledim sdatabasenamedim sdatapathsdatabasename = "test1"'底下改成你的sql server数据目次sdatapath = "c:\program files\microsoft sql server\mssql\data"' create a new sql server object and connectset osqlserver = server.createobject ("sqldmo.sqlserver")'osqlserver.loginsecure = true ' use integrated security'osqlserver.connect "(local)"osqlserver.connect "you_server", "sa", "you_sa_passwrod" ' use standard security' create a server.createobject (" database objectset odatabase = server.createobject ("sqldmo.database")odatabase.name = sdatabasename' create a server.createobject (" db file objectset odbfiledata = server.createobject ("sqldmo.dbfile")with odbfiledata.name = sdatabasename & "_data".physicalname = sdatapath & "\" & sdatabasename & "_data.mdf".primaryfile = true.filegrowthtype = sqldmogrowth_mb.filegrowth = 1end with' create a server.createobject (" logfile objectset ologfile = server.createobject ("sqldmo.logfile")with ologfile.name = sdatabasename & "_log".physicalname = sdatapath & "\" & sdatabasename & "_log.ldf"end with' add the db file and log file to the database objectodatabase.filegroups("primary").dbfiles.add odbfiledataodatabase.transactionlog.logfiles.add ologfile' add the database to sql server (create the database)osqlserver.databases.add odatabase' close the connectionosqlserver.close' clean upset ologfile = nothingset odbfiledata = nothingset odatabase = nothingset osqlserver = nothing'**************************************本领二中断%>

谢谢版主对我的回答，但用ADOX中的CREATE只能建ACCESS库，我找了个建SQL SERVER

相关推荐

推荐下载

热门阅览

最新排行