- 帖子
- 172
- 主題
- 39
- 精華
- 20
- 積分
- 177
- 點名
- 0
- 作業系統
- Microsoft Windows XP
- 軟體版本
- Microsoft Office 2003
- 閱讀權限
- 100
- 性別
- 男
- 來自
- 高雄
- 註冊時間
- 2010-5-1
- 最後登錄
- 2023-3-19
 
|
本帖最後由 Min 於 2010-5-1 23:53 編輯
1.SQL SERVER設定
my.ini (mysqld-nt)設定下- #This File was made using the WinMySQLAdmin 1.4 Tool
- #2006/9/6 下午 02:00:49
- #Uncomment or Add only the keys that you know how works.
- #Read the MySQL Manual for instructions
- [mysqld]
- basedir=C:/mysql
- #bind-address=10.10.10.10
- datadir=C:/mysql/data
- #language=C:/mysql/share/your language directory
- #slow query log#=
- #tmpdir#=
- #port=3306
- #set-variable=key_buffer=512M
- [color=Red]default-character-set=big5
- [WinMySQLadmin]
- Server=C:/mysql/bin/mysqld-nt.exe
- user=root
- password=baby
- [color=Red]default-character-set=big5
- [client]
- default-character-set=big5
- init_connect='SET NAMES big5'
複製代碼 2.ADO連線設定- Cnnl.Open "Driver={MySQL ODBC 3.51 Driver};Server=SERVER_NAME;Port=3306;Database=test;CharSet=big5;Uid=root;Pwd=;Option=16387"
複製代碼 (紅色字 是需新增的!) |
|