操作系统为WINDOWS SERVER2003 + ORACLE 8.1.7 此时在控制面板中点击数据源ODBC 点添加这时 数据源驱动都有  接下来我按装 SQL2000 企业版SP2 安装过程中提示错误 退出安装后 这时再点击ODBC数据源 点添加 这里的数据源驱动都没有了 。
问题 1:如何让丢失的ODBC驱动都回来? 

解决方案 »

  1.   

    在网上找到了
    Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC][HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI][HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer]
    "Description"=""
    "Server"="(Local)"
    "Trusted_connection"=""
    "UseProcForPrepare"="Yes"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "LocalServer"="SQL Server"
    "TrioMotors"="Microsoft Access Driver (*.mdb)"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
    "DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TrioMotors\Engines][HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TrioMotors\Engines\Jet]
    "ImplicitCommitSync"="Yes"
    "MaxBufferSize"=dword:00000200
    "PageTimeout"=dword:00000005
    "Threads"=dword:00000003
    "UserCommitSync"="Yes"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver da Microsoft para arquivos texto (*.txt; *.csv)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Access (*.mdb)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="2"
    "FileExtns"="*.mdb"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft dBase (*.dbf)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.ndx,*.mdx"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Excel(*.xls)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.xls"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Paradox (*.db )]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.db"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver para o Microsoft Visual FoxPro]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "APILevel"="0"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="2"
    "FileExtns"="*.mdb"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access-Treiber (*.mdb)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="2"
    "FileExtns"="*.mdb"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase Driver (*.dbf)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.ndx,*.mdx"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase VFP Driver (*.dbf)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "APILevel"="0"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft dBase-Treiber (*.dbf)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\oddbse32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.ndx,*.mdx"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Excel Driver (*.xls)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.xls"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Excel-Treiber (*.xls)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odexl32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.xls"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft FoxPro VFP Driver (*.dbf)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "APILevel"="0"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft ODBC for Oracle]
    "UsageCount"=dword:00000001
    "Driver"="C:\\WINDOWS\\system32\\msorcl32.dll"
    "Setup"="C:\\WINDOWS\\system32\\msorcl32.dll"
    "SQLLevel"="1"
    "FileUsage"="0"
    "DriverODBCVer"="02.50"
    "ConnectFunctions"="YYY"
    "APILevel"="1"
    "CpTimeout"="120"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Paradox Driver (*.db )]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.db"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Paradox-Treiber (*.db )]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odpdx32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.db"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Text Driver (*.txt; *.csv)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Text-Treiber (*.txt; *.csv)]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll"
    "Setup"="C:\\WINDOWS\\system32\\odtext32.dll"
    "APILevel"="1"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Visual FoxPro Driver]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "APILevel"="0"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Visual FoxPro-Treiber]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "Setup"="C:\\WINDOWS\\system32\\vfpodbc.dll"
    "APILevel"="0"
    "ConnectFunctions"="YYN"
    "DriverODBCVer"="02.50"
    "FileUsage"="1"
    "FileExtns"="*.dbf,*.cdx,*.idx,*.fpt"
    "SQLLevel"="0"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MS Code Page Translator]
    "Translator"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
    "Setup"="C:\\WINDOWS\\system32\\MSCPXL32.dll"
    "UsageCount"=dword:00000002
    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core]
    "UsageCount"=dword:00000002[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\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 Drver"="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\ODBCINST.INI\ODBC Translators]
    "MS Code Page Translator"="Installed"[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
    "UsageCount"=dword:00000002
    "Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
    "Setup"="C:\\WINDOWS\\system32\\sqlsrv32.dll"
    "SQLLevel"="1"
    "FileUsage"="0"
    "DriverODBCVer"="03.50"
    "ConnectFunctions"="YYY"
    "APILevel"="2"
    "CPTimeout"="60" 这种方法 修复之后可以安装SQL2000了  可是里面少了 原来有的ORACLE FOR ODBC这项数据源驱动。如何把它也恢复啊  特别着急 不能重做系统 因为系统上还有一个使用ORACLE数据库的软件 我们都不会安装。
      

  2.   

    这个驱动只要安装oracle 就有了