1、卸载sql,如果没有卸载选项那直接删除sql的安装目录,2、删除注册表里 一切和sql server 有关的项 ,重启计算机。3、重新安装mssql。
不行的话把下列内容复制到文本文件后改后缀为reg 然后执行 安装mssql,或执行后重启计算机再安装mssql
Windows Registry Editor Version 500
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\LocalServer]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\ODBC Data Sources]
"LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (mdb)"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\TrioMotors\Engines]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINI\TrioMotors\Engines\Jet]
"ImplicitCommitSync"="Yes"
"MaxBufferSize"=dword:00000200
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver da Microsoft para arquivos texto (txt; csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"=",asc,csv,tab,txt,csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Access (mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="2"
"FileExtns"="mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft dBase (dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,ndx,mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Excel(xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver do Microsoft Paradox (db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Driver para o Microsoft Visual FoxPro]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,cdx,idx,fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Access Driver (mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="2"
"FileExtns"="mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Access-Treiber (mdb)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odbcjt32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="2"
"FileExtns"="mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase Driver (dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,ndx,mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase VFP Driver (dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,cdx,idx,fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft dBase-Treiber (dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\oddbse32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,ndx,mdx"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Excel Driver (xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Excel-Treiber (xls)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odexl32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft FoxPro VFP Driver (dbf)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,cdx,idx,fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft ODBC for Oracle]
"UsageCount"=dword:00000001
"Driver"="C:\\WINDOWS\\system32\\msorcl32dll"
"Setup"="C:\\WINDOWS\\system32\\msorcl32dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="0250"
"ConnectFunctions"="YYY"
"APILevel"="1"
"CpTimeout"="120"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Paradox Driver (db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Paradox-Treiber (db )]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odpdx32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="db"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Text Driver (txt; csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"=",asc,csv,tab,txt,csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Text-Treiber (txt; csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\odbcjt32dll"
"Setup"="C:\\WINDOWS\\system32\\odtext32dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"=",asc,csv,tab,txt,csv"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Visual FoxPro Driver]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,cdx,idx,fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\Microsoft Visual FoxPro-Treiber]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\vfpodbcdll"
"Setup"="C:\\WINDOWS\\system32\\vfpodbcdll"
"APILevel"="0"
"ConnectFunctions"="YYN"
"DriverODBCVer"="0250"
"FileUsage"="1"
"FileExtns"="dbf,cdx,idx,fpt"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\MS Code Page Translator]
"Translator"="C:\\WINDOWS\\system32\\MSCPXL32dll"
"Setup"="C:\\WINDOWS\\system32\\MSCPXL32dll"
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\ODBC Core]
"UsageCount"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\ODBC Drivers]
"SQL Server"="Installed"
"Microsoft Access Driver (mdb)"="Installed"
"Microsoft Text Driver (txt; csv)"="Installed"
"Microsoft Excel Driver (xls)"="Installed"
"Microsoft dBase Driver (dbf)"="Installed"
"Microsoft Paradox Driver (db )"="Installed"
"Microsoft Visual FoxPro Driver"="Installed"
"Microsoft FoxPro VFP Driver (dbf)"="Installed"
"Microsoft dBase VFP Driver (dbf)"="Installed"
"Microsoft Access-Treiber (mdb)"="Installed"
"Microsoft Text-Treiber (txt; csv)"="Installed"
"Microsoft Excel-Treiber (xls)"="Installed"
"Microsoft dBase-Treiber (dbf)"="Installed"
"Microsoft Paradox-Treiber (db )"="Installed"
"Microsoft Visual FoxPro-Treiber"="Installed"
"Driver do Microsoft Access (mdb)"="Installed"
"Driver da Microsoft para arquivos texto (txt; csv)"="Installed"
"Driver do Microsoft Excel(xls)"="Installed"
"Driver do Microsoft dBase (dbf)"="Installed"
"Driver do Microsoft Paradox (db )"="Installed"
"Driver para o Microsoft Visual FoxPro"="Installed"
"Microsoft ODBC for Oracle"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\ODBC Translators]
"MS Code Page Translator"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINSTINI\SQL Server]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32dll"
"Setup"="C:\\WINDOWS\\system32\\sqlsrv32dll"
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="0350"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"
使用逆向思维来解决这个问题:
感觉你的这个问题可以使用sql中的变量来实现,
drop database @dataname
然后就是声明这个dataname了
declare @dataname varchar(10)
但是现在问题就是如何给变量@dataname赋值,你的意思是想象从控制台接收一个参数吧,然后实现删除数据库的效果吧
但是感觉数据库好像没有这样的功能,如果你有变成语言的基础,可以把数据库和变成语言结合起来的话,要实现这个效果的话,就非常的简单啦
我会java、c#不知道这两个语言你会不 如果你同意我的建议 你还是不会的话 你可以再联系我
但愿可以帮助你 谢谢
以上就是关于sql程序安装配置服务器失败全部的内容,包括:sql程序安装配置服务器失败、使用批处理命令,删除、分离指定SQL数据库的方法。、等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)