XL: ????? ??????? ??? DSNs ???????? ??? DSN

?????? ????????? ?????? ?????????
???? ???????: 165866 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ??????? ????? ????? ?????? ??? ???? ?????? (????? ????? ??? DSN) ??????? ????? ?????? ????? ?? Microsoft Excel? ??? ????? ????????? ???????? ??????? ????? ?????? ????? ?? ???? ??? ?????? ????? ?? ??? ???? ????????. Microsoft Query 97 ?????????? ?????? ? Microsoft Excel 97 ? ???? ??? ??????? ??? ????? ?? ??????? ??? DSN; ?? ????????? ??????? ?? Microsoft Query ? Microsoft Excel.

??????? ????

????? ??????? ??? DSN ???

?? ????????? ??????? ?? Microsoft Excel ??????? ???????? ???????? ????? ????? ???? ??????. ??? ???? ???????? ?????????? ?????? ???????? ??????? ???????? ????? ?? ??????? ??????? ?? ???? ?????. ????? ??? ?????? ???? ????? ??? ????? ??? ???????? ???????? ??? ??? ???????? ??? ?? ???? ??? ???? ???????? ?????? ????? ?? ????? ??????? ??? ????????? ????? ??? ??????. ????? ?? ???? ????? ??? ??? ????? ???????? ???????? ????????.

?? Microsoft Excel 97 ?????????? ??????? ????? ????? ???????? ??? ???? ??? ????? "??? ??????????? ???????" (SQL) ???????? ?????? ??????? ???? ?? ?????? ?? ???? ?????? ????? (???? ??? ???? ????????) ??? ????? ?? ???? ??? ?? ???? ??? ??????. ??? ????????? ??? DSN ?? ??????? ?? ?????? ??? ????? ???????? ??? ????? ??????? ??????. ??? ????? ???? ????????? ???????? ?? ??? ??????. ??? ???? ??? ????? ???? ?? ?????? ??????? ??????? ????? ????? ???????? ??????? (ODBC) ??? ?? ??????? ??????????? ??? ??????.

?? ??? ????? ????? ??? DSN ???? ?

?????? ???? DSN - ??? ????? ???????:
   DBQ=C:\TEST\QUERY FILES;DefaultDir=C:\TEST\QUERY FILES; _
   Deleted=1;Driver={Microsoft dBase Driver (*.dbf)}; _
   DriverId=277;FIL=dBase IV;PageTimeout=600;Statistics=0
				
???? ?? ???? ??? ????? ??? ?????? ???????? DSN ?? ????.

?????? ??? ????? ???? ????????

???? Microsoft Query ??????? 2.0 ??????? ???? ???????? ?? ?????. ?? ?????? Microsoft Query 97 ?????????? ?????? ??????? ?????? ??????? ???? ????????. ????? ?? ???? ??? ????? ???? ?????? ???? ??? ????? ??????? ??????? ?? ??? ??? ????? ??? ??? .dsn. ????? ??? ????? ????? ??? DSN.

????? ?? ??? DSN ??? ??? ODBC ???? Microsoft Office ??????? ?? ????? ??? ??????? ??? ???? ????????? ???? ?????? ????? ???????? ????? ?????? ????????. ?????? ?? ?????? ????????? ???? ??? ???????? ??? ??? DSNX ???
   C:\Program Files\Common Files\ODBC\Data Sources
				
?????? ?? ?????? ????????? ???????? ??? ??? ???????:
   C:\Program Files\Microsoft Office\Queries
				
????? ????? ???????? ???? ??? ??????? ?? ????? ?? ??? DSNs ??? ?? ??? ????? ???? ???????.

?????? ?? ???? ??? DSN ??????? ?????? ????? ????? ???????? ?? Microsoft Access 7.0 (?????? ????? ODBC ??????? ?? Microsoft Office 97):
   [ODBC]
   DSN=MS Access 7.0 Database
				
??? ????? ??? DSN ???? ??? ??? ????? ??? ???? ??????? ????? ???? ????? ?????? ??? ??? ???? ????? ????? ?? ????? ??? ???? ??????? ??? ?? ??? DSN. ?? ????? ??? ?????? ?? ????? ??? ???? ?????? ??? DSN ?? ?????? ?? ?????????? ??? ???? ??????? ???? ???? ???????? ??? DSN ??? ???? ??? ????? ?????????? ???? ?????? ????. ??????? ?????? ??? ??? ??????? ?????? ???? ????? ???????.

??????? ??????

??? ???????? ?????? ????? ????? ???? ?????? (UNC) ????? ?? ???? ????? ?????.

??????? ???????

???? ??? DSN ?? ??????? ???????? ??????? ??? ??? ???? ??????? ??????? ???? UNC. ?? ???? ???????? ?????? ??????:
   [ODBC]
   DRIVER=Microsoft Excel Driver (*.xls)
   UID=admin
   UserCommitSync=Yes
   Threads=3
   SafeTransactions=0
   ReadOnly=1
   PageTimeout=5
   MaxScanRows=8
   MaxBufferSize=512
   ImplicitCommitSync=Yes
   FIL=excel 5.0
   DriverId=790
   DefaultDir=<drive letter>:\ 
   DBQ=<drive letter>:\<source filename>
				
?? ??? ??????? < ??? ???? ??????? > ?? ???? ??????? ??????? ? < ??? ????? ?????? > ?? ??? ???????? ??????.

????? ???? ????????? ??????
   DefaultDir=\\<server name>\<share>
   DBQ=\\<server name>\<share>\<source filename>
				
Where < ??? ?????? > ?? ???? ?????? ? <share>?? ???????? ??? ???? ?????? ? < ???? filename > ?? ??? ???????? ??????.

??? ????? ????? ???? ????? ?????????? ??????? "??? DSN" ?????.

????? ?? ????????? ??? ??????? ?????? ??????? ?? ??? DSN ?????? ?????? ??? ????????? ?????? ?????? ????? ODBC ???? ???????.

????? ????? ??????? ??? ???? ???? ODBC 32-?? ?????? ??? DSN. ?????? ????? ???? ??????? ???????:

  1. ?? ??????? ???? ? ???? ??? ??????? ????? ??? ???? ??????. ?? ???? ????? ??????? ??? 32 ?? ODBC.
  2. ???? ??? ????? ??????? ??? DSN.
  3. ???? ??? ?????.
  4. ?? ???? ?????? ????? ???? ?????? ???? ? ???? ??? ?????? ??????? ???? ???? ????? ???? ??????. ???? ??? ??????.
  5. ???? ??? ????? ??????? ?????? ????? ???????? ?????? (??? ???? ??????? C:\Program Files\Common Files\ODBC\Data Sources\Test.dsn). ?? ???? ??? ??????.
  6. ???? ??? ?????.

    ???? ???? ?????? ????? ODBC ??????? ????? ODBC ???? ????? ?? ?????? 4.
  7. ?? ???? ?????? ? ???? ????????? ????????.

    ??????: ??? ?? ??? ???? ??? ???? ????? ???? ???? ??????? ?? ??? DSN ????? ???? UNC ?? ?????? ??? ????? ???????? ?? ???? ?????? ????? ????? ??????.
  8. ???? ??? ?????.
  9. ???? ??? ????? ?????? ???? ?????? "????? ????? ?????? ODBC.
????? ??? DSN ????????? ?? ??? Microsoft Query.

??????? Microsoft Query ?? ???????

Microsoft Query ???????? ?????? ???? ???? ???? ????????? ????? ?? ????? ??????? ?? ?? ???? ????? ???? ???? ???? ???? ?? ????? ??? ?????. ????? ????? ????? ???? Microsoft Query ?? ??????? ?????? ??? ????? Microsoft Query. ?? Microsoft Windows 95 ?????????? ??????? ????? ????? ???? Microsoft Query ?? ???? ????? ?? ????? ??????? ??????:
   HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\MSQuery
				
??? ????? Microsoft Office 97 ?? ????? ???? ?????? "???????" ?????? ????? ????? ???? ???? ??? ?????? ????????? ?????? DSN. ??? ????? ??? ?????? ?? ????? ??????? ??????:
   HKEY_LOCAL_MACHINE\Software\ODBC\odbc.ini\ODBC File DSN\DefaultDSNDir
				
???? ????? ???? ???? ?????? DSN ?? ???? ????? ????? ??????? ??????.
   HKEY_CURRENT_USER\Software\ODBC\odbc.ini\ODBC File DSN\DefaultDSNDir
				
??? ????? ??? ??????? ????? ??? HKEY_LOCAL_MACHINE ?????.

?????

????? ?? ????????? ??? ??????? ?????? ???? ??? "????? Office" ? ???? ????? ???????? ? ???? ??? ??? ? ?? ???? ??? ???? "??? ??????? ???????? ?? ???????? ????? ????????."

??????: ??? ??? ??????? ?????? ???? ??? ?? "????? Office" ??? ???? ??????? ?????. ??? ?? ??? ????? ??????? Microsoft ??? ?????????, ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
120802Office: ????? ????? ?? ????? ?????? Office ???? ?? ????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
159557XL97: ??????? ???? "?" ???????? "?" ????? ?????? ???

???????

???? ???????: 165866 - ????? ??? ??????: 17/?????/1427 - ??????: 2.3
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Query 2000
????? ??????: 
kbmt kbhowto kbprogramming kbualink97 KB165866 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????165866

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com