Txhawm rau pib lub server ntawm 1C program, nws yog ib qho tseem ceeb tsis yog ua raws li cov kab lus uas tau hais meej meej nkaus xwb, tab sis kuj tseem yuav tsum tau coj mus rau hauv tus account peculiarities ntawm kev sib cuam tshuam ntawm cov yam ntxwv ntawm kev tsim lub program nrog SQL.
Nws yog qhov tsim nyog
MS SQL 2000
Cov Lus Qhia
Kauj ruam 1
Npaj txhua yam rau kev teeb tsa neeg rau zaub mov. Nco ntsoov tias koj muaj SP3 lossis siab dua rau MS SQL Server 2000. Rau cov neeg rau zaub mov hloov kho cov pob khoom sib xyaw nrog 1C version, nrhiav ntawm cov ncauj lus thematic thiab cov vev xaib, vim tias qhov hloov tshiab rau lub thib ob tau tshaj tawm ntau dua.
Kauj ruam 2
Nruab qhov server thiab client software ntawm lub server, feem ntau qhov no yog qhov kev xaiv thib ob hauv lub thawv pop-up program qhib lub thawv. Ntawm daim disk nrog cov muab faib ntawm DataSQL, xaiv qhov tsim ntawm cov ntawv tais ceev tseg ntawm tib lub npe, tshwj xeeb nws yog qhov tseem ceeb rau khaws cov ntaub ntawv. Yav tom ntej, cov ntaub ntawv siv koj los ntawm koj txoj haujlwm yuav muab khaws cia rau hauv cov ntawv khaws cia no.
Kauj ruam 3
Hauv cov kev xaiv teeb xaiv, xaiv Nchuav. Tom qab ntawd, teeb tsa SQL software khoom uas koj xav tau uas koj yuav xav tau yav tom ntej. Txhawm rau ua qhov no, khij lawv nrog checkboxes hauv cov thawv sib tham ntawm lub kaw lus. Nco ntsoov xyuas cov phau ntawv SQL Phau Ntawv Online thiab.
Kauj ruam 4
Hauv txoj kev xaiv koom nrog, qhia kom paub hom Mixed, kuj sau qhia tus password. Tshawb nrhiav kom paub ntau ntxiv txog kev siv cov ntaub ntawv no los ntawm version ntawm 1C program koj tau txhim kho. Taug qab mus teeb tsa qhov kev txiav txim tso tawm.
Kauj ruam 5
Thaum hloov DBF database rau SQL, xaiv lub neej ntawd teeb tsa tus nqi. Tom qab ntawd, qhov no, qhov kev xaiv ntawm kev txiav txim plaub hau Cyrillic_General_CI_AS yuav ua raws. Yog tias koj tab tom tsiv ib qho infobase los ntawm MS SQL Server 7.0 rau MS SQL Server 2000, koj yuav tsum xaiv qhov kev txiav txim SQL_Latin1_General_CP1251_CI_AS.
Kauj Ruam 6
Hauv qhov Network Cov Tsev Qiv Ntawv qhov rai, qhia kom tseeb tsuas yog xaiv TCP / IP. Tom qab koj ua tiav kev txhim kho SQL tus neeg rau zaub mov, npaj mus rau qhov kev pabcuam pob ntawv teeb tsa zoo li niaj zaus yam tsis muaj kev hloov pauv ib yam.
Kauj Ruam 7
Kho cov SQL server thiab cov neeg siv sab. Qhib Server Ua Haujlwm Network Utility. Ntawm cov nqis tab nrog lub npe General, tawm tsuas yog TCP / IP, tom qab ntawv khaws cov kev hloov pauv. Hauv Client Network Utility, rov ua zoo ib yam.
Kauj ruam 8
Kho lub npe ntawm koj cov neeg rau zaub mov rau ntawm "Alias" tab. Teem sijhawm teeb tsa sab ntawm cov neeg siv ntawm cov khoos phis tawj.
Kauj Ruam 9
Nruab ib ntu SQL cov neeg siv ntawm cov khoos phis tawj los ntawm cov khoom siv faib tib yam li koj tau nruab ib ntu ntawm server. Hauv cov kev xaiv teeb tsa, xaiv Txuas Txuas nkaus xwb, thiab teeb tsa ntawm Client Network Utility yuav pib. Nruab qhov pob pabcuam.
Kauj ruam 10
Txheeb xyuas kev sib txuas siv cov ntaub ntawv Cov Ntaub Ntawv (ODBC) cov zaub mov. Nyob rau ntawm System DSN chaw tab, xaiv SQL yam khoom, mus rau nws kev teeb tsa. Sau cov npe neeg rau zaub mov hauv qhov chaw sau. Txheeb xyuas tus program siv tus account ncaj qha los ntawm kev nkag mus rau cov ntaub ntawv nkag mus muab ntawm tus neeg rau zaub mov. Nyem Txav tas thiab tshawb xyuas cov ntaub ntawv peev txheej. Yog tias qhov kev xeem dhau, koj ua txhua yam zoo.
