sqlserver/sybase問題解決

闂锛?

瀹夎sqlserver鎻愮ず浠ュ墠鐨勬煇涓▼搴忓畨瑁呭凡鍦ㄥ畨瑁呰绠楁満涓婂垱寤烘寕璧風殑鏂囦歡鎿嶄綔銆傝繍琛屽畨瑁呯▼搴忎箣鍓嶅繀椤婚噸鏂伴噸鍚绠楁満--闂鐨勮В鍐?

楂樼増鏈笅瀹夎浣庣増鏈殑sybase12.52聽

涓簊ybase12.5閲嶇艦sa鍙ｄ護

瑙ｅ喅Sybase涓枃闂

瀹夎sqlserver鎻愮ず浠ュ墠鐨勬煇涓▼搴忓畨瑁呭凡鍦ㄥ畨瑁呰绠楁満涓婂垱寤烘寕璧風殑鏂囦歡鎿嶄綔銆傝繍琛屽畨瑁呯▼搴忎箣鍓嶅繀椤婚噸鏂伴噸鍚绠楁満--闂鐨勮В鍐?

聽聽聽瀹夎杞歡鏃訛紝鍑虹幇鏃犳硶瀹夎鐨勯棶棰橈紝瀹冩彁绀猴細鈥滀互鍓嶇殑鏌愪釜绋嬪簭瀹夎宸插湪瀹夎璁＄畻鏈轟笂鍒涘緩鎸傝搗鐨勬枃浠舵搷浣溿€傝繍琛屽畨瑁呯▼搴忎箣鍓嶅繀椤婚噸鏂伴噸鍚绠楁満鈥濋棶棰樻槸锛岄噸鍚簡x娆★紝閮芥病鏈夌敤锛岃繕鏄繖涓敊璇紝绯葷粺鏄垰鍒氬畨瑁呯殑鍙堟病鏈夊畨瑁呰繃鍒殑闂鎬庝箞浼氬張杩欎釜闂锛岃闂悇浣嶅浣曡В鍐籌紒锛?娉細濡傛灉鏄鎴戦噸鏂闆畨瑁呯郴缁熺殑璇濆氨涓嶈鍥炰簡锛?

聽聽聽瑙ｅ喅锛氭敞鍐岃〃

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager

杩欓噷闈㈡湁涓€涓狿END...寮€澶寸殑涓滆タ锛?

涓轟簡瀹夊叏鍏堝浠藉嚭鏉ャ€傘€傜劧鍚庡垹浜嗗氨琛岋紒

sybase瀛︿範鐐規淮

杩炴帴

isql -Usa -P -Jcp936

娓呴櫎涓庡叧闂棩蹇?dump transaction fmisdb with truncate_only

dump transaction fmisdb with no_log

淇敼瀵嗙爜锛?sp_password null,longtop,sa

鏌ョ湅闃誨鏄惁缁撴潫

sp_logshold

//淇敼Sybase璁懼澶у皬

alter database tempdb on master=512

楂樼増鏈笅瀹夎浣庣増鏈殑sybase12.52聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

聽聽聽 杩戞潵鍙戠幇鍦籍锛寸幆澧冧笅鍗歌澆锛籌脊锛肌锛籌譏锛戯紥銆傦紩锛撳悗瀹夎浣庣増鏈暟鎹簱浼氭姤濡備笅閿欒锛?

Errors occurred during the installation.

Unable to install Sybase Adaptive Server Enterprise Suite over Sybase Adaptive Server Enterprise Suite: Installed product has newer version.

涓嶈兘鍦ㄧ洰鍓嶇増鏈笅瀹夎銆傚湪缃戜笂涓€浣嶆湅鍙嬬殑鎸囩偣涓嬭В鍐熾€?

聽聽聽瑙ｅ喅锛氬湪/winnt鐩綍涓嬫绱㈠嚭鈥渧pd.properties鈥濇枃浠訛紝瀵矽鏂囦歡鏀瑰悕鎴栬€呭垹闄ゅ嵆鍙€傝繖鍙槸浜哄鐨勭粡楠屾墍寰楀摝锛岃刀绱ф敹钘忚褰曞惂锛屽笇鏈涘浣犳湁鎵€鐢ㄣ€?

涓簊ybase12.5閲嶇艦sa鍙ｄ護

銆€銆€浠婂ぉ锛屽仛涓祴璇曪紝鎯蟲妸sa鍙ｄ護涓㈠け鎯呭喌涓嬮噸缃€?

銆€銆€鍏堝仠鎺夋湇鍔★紝鑰屽悗淇敼Run_XXX.bat(XXX涓烘湇鍔″悕)銆傛垜鐨勫疄渚嬪涓嬶細

rem

e:/sybase/ASE-12_5/bin/sqlsrvr.exe聽 -de:/oadb/master.dat -scq -ee:/oadb/cq.log -ie:/sybase/ini -Me:/sybase/ASE-12_5 -psa

鐩存帴鍙屽嚮杩愯璇ユ壒澶勭悊鏂囦歡锛屽惎鍔ㄦ暟鎹簱銆傛帶鍒跺彴鏄劇ず鍙ｄ護濡備笅锛?

00:00000:00001:2005/11/08 15:43:23.56 server聽 Database 'sybsystemprocs' is now o

nline.

New SSO password for sa:bqsfwvnrpuiib8锛堟涓烘柊鍙ｄ護锛?

瑙ｅ喅Sybase涓枃闂

瑙ｅ喅Sybase涓枃闂锛?(1)JDBC杩炴帴涓茶鏈夊瓧绗﹂泦璁劇疆

jdbc:sybase:Tds:192.168.3.11:5000/Wfis_db?charset=cp936

(2)鏈嶅姟鍣ㄩ厤缃垚cp936

(a)浣跨敤isql鏌ョ湅褰撳墠宸茬粡瀹夎鐨勫瓧绗﹂泦

isql -Usa -Plongtop

>use master

>go

>select id,name from syscharsets

>go

聽id聽 name

聽--- ----------------

聽聽 0 ascii_8

聽聽 1 iso_1

聽聽 2 cp850

聽 20 defaultml

聽 21 thaidict

聽 22 iso14651

聽 24 utf8bin

聽 25 binary

聽 39 altnoacc

聽 45 altdict

聽 46 altnocsp

聽 47 scandict

聽 48 scannocp

聽 50 bin_iso_1

聽 50 bin_cp850

聽 51 dict

聽 52 nocase

聽 53 nocasep

聽 54 noaccent

聽 55 espdict

聽 56 espnocs

聽 57 espnoac

聽 59 rusnocs

聽 64 cyrnocs

聽 65 elldict

聽 69 hundict

聽 70 hunnoac

聽 71 hunnocs

聽 73 turknoac

聽 74 turknocs

聽129 cp932bin

聽130 dynix

聽137 gb2312bn

聽140 cyrdict

聽155 turdict

聽161 euckscbn

聽163 gbpinyin

聽165 rusdict

聽179 sjisbin

聽192 eucjisbn

聽194 big5bin

(41 rows affected)

浠庡垪琛ㄤ腑鐪嬪嚭娌℃湁瀹夎cp936瀛楃闆?

(b)鏌ョ湅褰撳墠浣跨敤鐨勭己鐪佸瓧绗﹂泦

>sp_configure "default char"

>go

聽Parameter Name聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 Default聽聽聽聽 Memory Used Config Value

聽聽聽聽聽聽聽聽 Run Value聽聽 Unit聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 Type

聽------------------------------ ----------- ----------- ------------

聽聽聽聽聽聽聽聽 ----------- -------------------- ----------

聽default character set id聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 2聽聽聽聽聽聽聽聽聽聽 0聽聽聽聽聽聽聽聽聽聽 2

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 2 id聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 static

缂虹渷瀛楃闆嗙殑id鏄?锛屾煡鐪嬩笂闈㈢殑鍒楄〃锛屽彲浠ュ緱鐭ユ槸cp850

(c)鍥犱負涓婇潰鐨勫垪琛ㄤ腑娌℃湁瀹夎cp936锛屾墍浠ュ氨瀹夎cp936瀛楃闆?杩涘叆鐩綍C:/sybase/charsets/cp936

杩愯鍛戒護 charset -Usa -Plongtop binary.srt cp936

杩愯瀹屾垚鍚庯紝绯葷粺灏卞畨瑁呬簡cp936瀛楃闆?

(d)楠岃瘉鏄惁纭疄瀹夎浜哻p936瀛楃闆?isql -Usa -Plongtop

>use master

>go

>select id,name from syscharsets

>go

聽id聽 name

聽--- ------------------------------

聽聽 0 ascii_8

聽聽 1 iso_1

聽聽 2 cp850

聽 20 defaultml

聽 21 thaidict

聽 22 iso14651

聽 24 utf8bin

聽 25 binary

聽 39 altnoacc

聽 45 altdict

聽 46 altnocsp

聽 47 scandict

聽 48 scannocp

聽 50 bin_iso_1

聽 50 bin_cp850

聽 50 bin_cp936

聽 51 dict

聽 52 nocase

聽 53 nocasep

聽 54 noaccent

聽 55 espdict

聽 56 espnocs

聽 57 espnoac

聽 59 rusnocs

聽 64 cyrnocs

聽 65 elldict

聽 69 hundict

聽 70 hunnoac

聽 71 hunnocs

聽 73 turknoac

聽 74 turknocs

聽129 cp932bin

聽130 dynix

聽137 gb2312bn

聽140 cyrdict

聽155 turdict

聽161 euckscbn

聽163 gbpinyin

聽165 rusdict

聽171 cp936

聽179 sjisbin

聽192 eucjisbn

聽194 big5bin

(43 rows affected)

浠庡垪琛ㄤ腑鍙互鍙戠幇宸茬粡瀹夎浜哻p936锛宨d鏄?71

(e)鎶婄郴缁熺殑褰撳墠缂虹渷瀛楃闆嗚缃負cp936

>sp_configure "default char",171

>go

In changing the default sort order, you have also reconfigured SQL Server's

default character set.

聽Parameter Name聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 Default聽聽聽聽 Memory Used Config Value

聽聽聽聽聽聽聽聽 Run Value聽聽 Unit聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 Type

聽------------------------------ ----------- ----------- ------------

聽聽聽聽聽聽聽聽 ----------- -------------------- ----------

聽default character set id聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 2聽聽聽聽聽聽聽聽聽聽 0聽聽聽聽聽聽聽聽 171

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 2 id聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 static

(1 row affected)

Configuration option changed. Since the option is static, Adaptive Server must

be rebooted in order for the change to take effect.

Changing the value of 'default character set id' to '171' increases the amount

of memory ASE uses by 6 K.

(return status = 0)

(f)閲嶅惎Sybase鏈嶅姟锛屼嬌鏇存敼鐢熸晥

绗竴娆￠噸鍚紝绯葷粺浼氬宸茬粡瀛樺湪鐨勬暟鎹繘琛岃漿鎹紝杞崲瀹屾垚鍚庤嚜鍔ㄥ仠姝㈡湇鍔★紝鍙鍐嶆鍚姩鏈嶅姟灏卞彲浠ヤ簡銆?

(g)鏇存敼DB瀹㈡埛绔殑瀛楃闆?DBArtisan涓鏇存敼瀹㈡埛绔殑瀛楃闆嗕負cp936鎵嶈兘杩炴帴cp936鐨勬湇鍔″櫒

閫氳繃鑿滃崟/Logfile/Options...鎵撳紑瀵矽瘽妗嗭紝閫夋嫨Connection鏍囩锛?鏇存敼Client Character杈撳叆妗嗙殑鍊間負cp936銆?

鏁版嵁搴撶殑charset淇敼涓篶p936鏃?浣跨敤isql鎸夊涓嬬殑鏂瑰紡

isql -Usa -Plongtop -Sdbserver -Jcp936

聽

闄や簡杩欑鏂瑰紡杩樺彲浠ュ湪sybase鐨勫浘褰㈢鐞嗙晫闈笅杩涜閫夋嫨锛屾垜瑙夊緱杩欑鏂規硶鏈€鐩磋銆傚湪澶勭悊涓枃闂鏃朵竴鑸缃畇ybase鏈嶅姟鍣ㄧ鐨勫瓧绗﹂泦涓簎tf8锛岃€屽湪瀹㈡埛绔垯浣跨敤cp936杩涜璁塊棶銆備笅闈㈠厛寮€濮嬭缃湇鍔″櫒绔殑瀛楃闆嗐€?

棣栧厛锛屾墦寮€Server Config鐣岄潰銆?

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

鍥?

聽聽聽聽聽聽 閫夋嫨閰嶇疆Adaptive Server鈥?

聽

鍥?

聽聽聽聽聽聽 閫夋嫨鏈嶅姟鍣ㄥ悗鐐瑰嚮鈥滅戶缁€濇寜閽€?

聽

鍥?

聽聽聽聽聽聽 杈撳叆鍙ｄ護鍚庣偣鍑燴€滅戶缁€濇寜閽紝杩涘叆绠＄悊鐣岄潰銆?

聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽

鍥?

聽聽聽聽聽聽 鐐瑰嚮鈥滆瑷€鈥濇寜閽繘鍏ュ瓧绗﹂泦閰嶇疆鐣岄潰銆?

聽

鍥?

聽聽聽聽聽聽 杩欎釜鐣岄潰鏄垜宸茬粡璁懼畾濂界殑鎯呭喌銆傜偣鍑誨瓧绗﹂泦涓嬮潰绗竴涓寜閽€滃鍔?鎾ら櫎鈥濇潵娣誨姞鏈嶅姟鍣ㄧ鐨勫瓧绗﹂泦銆?

聽

鍥?

聽聽聽聽聽聽 灏哢nicode 3.1 UTF-8 Character Set娣誨姞杩涙潵銆傜劧鍚庣偣鍑誨瓧绗﹂泦涓嬮潰绗簩涓寜閽€滆缃己鐪佲€濇潵璁劇疆榛樿瀛楃闆嗐€?

聽

鍥?

聽聽聽聽聽聽 璁劇疆瀹屽悗瑕佺偣鍑誨浘7浠ュ強鍥?鐨勭‘瀹氳繘琛屼繚瀛樿缃紝淇濆瓨鏃堕渶瑕佽€愬績绛夊緟鍑犲垎閽熴€傜劧鍚庣敱浜庡笇鏈涘湪璁塊棶鏁版嵁搴撴椂涓嶅尯鍒嗗ぇ灏忓啓锛屾墍浠ヨ繕瑕佽缃竴涓嬪瓧绗︾殑鎺掑簭椤哄簭銆?

聽聽聽聽聽聽 鐐瑰嚮鍥?涓帓搴忛『搴忎笅闈㈢殑鈥滆缃己鐪佲€濇寜閽繘鍏tf8瀛楃闆嗙殑鍚勭鎺掑簭绠＄悊鐣岄潰锛岃鐣岄潰涓垪鍑轟簡瀵瑰悇绉嶆帓搴忛『搴忕殑鎻忚堪銆?

聽

鍥?

聽聽聽聽聽聽 閫夋嫨鍥?涓閫変腑鐨勬帓搴忔柟寮忔棦鍙€傜敱浜庡璇濇鐨勫ぇ灏忎笉鑳芥敼鍙樻墍浠ヤ笉鑳界湅鍒闆畬鏁寸殑鎻忚堪璇彞銆備竴璺‘瀹氳繘琛屼繚瀛樹箣鍚庨』閲嶅惎璁＄畻鏈哄苟鍚姩sybase鏁版嵁鏈嶅姟銆傝繖鏍鋒湇鍔″櫒绔殑涓嶅尯鍒嗗ぇ灏忓啓鐨勪腑鏂囧瓧绗﹂泦灏辮缃ソ浜嗐€?

聽