2013年6月25日 星期二

有兩個Oracle Home時,PL/SQL Developer 怎麼連接?

為了需要,在自已電腦裝了Oracle XE版,但發現VS2012連不上?? 想說是不是還要裝Oracle Client才行。裝完後,VS2012可以連了,卻發現PL/SQL連不上了?? 
 













查看了一下,發現現在有兩個Oracle Home,一個Oracle XE的, 一個Oracle Client的。上網找了一下,才知道原來我裝的是x64的Client,而PL/SQL只支援32bit,所以無法連上,但是我又不想重裝 Oracle Client 32bit,只好試試網路上找到的方法了,解法就是把PL/SQL指到 Oracle XE的home 就行了,步驟如下:

設定 PLSQL Developer
進入PL SQL後,到 Tools/Preferences 設定Oracle Home和 oci.dll的位置:
先在Oracle Home的地方選 XE:

然後指定 oci.dll 的位置(指到 Oracle XE 的 oci.dll, 我的是D:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll)




































這樣就行了~









2013年5月17日 星期五

ViewModal載入的時機

在 xaml 中,設定 ComboBox 的 SelectedIndex 結果並沒有效,結果是因為指定 ViewModal 給 View.DataContent 的時機不對造成的。

若是在 MainWindow的建構子中 Create ViewModal ,然後再指給 Window 的DataContent ,這樣的話,由於畫面早已畫完了, MainWindow 的建構子來不及把 ViewModal 建立起來丟給 MainWindow,這樣的話,當畫面在建立時,ComboBox跟本沒有來源給它建立 Item,空空如也的,當然指定 SelectedIndex 沒有效的。

若是在 xaml 中,宣告 namespace ,然後指定 DataContent 的話,這樣在畫面建立之前就已經先建立 ViewMoal ,那 ComboBox 也有來自 ViewModal 的資料可以建立它的 ListItem 了。

2013年4月30日 星期二

Microsoft.ACE.OLEDB.12.0 提供者並未登錄於本機電腦上


我用 VS2012 (x64) 連 OFFICE 2013(x64)時,出現下列錯誤訊息:
「Microsoft.ACE.OLEDB.12.0 提供者並未登錄於本機電腦上」

Google找了些文章..發現似乎是電腦中..缺少些元件…

有人建議要安裝: Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

裝了沒用…XD….

後來安裝了:
2007 Office system 驅動程式:資料連線元件
http://www.microsoft.com/downloads/zh-tw/confirmation.aspx?displaylang=zh-tw&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891



終於OK了…

參考自:http://kennycarol.pixnet.net/blog/post/27188076-%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%3A-'microsoft.ace.oledb.12.0'-%E6%8F%90%E4%BE%9B%E8%80%85%E4%B8%A6%E6%9C%AA%E7%99%BB

2013年4月14日 星期日

File or Extension Description



cfg
Project configuration file. Stores project configuration settings. It has the same name as the project file, but with the extension .cfg.
The compiler searches for a dcc32.cfg in the compiler executable directory, then for dcc32.cfg in the current directory, and then finally for projectname.cfg in the project directory. You can therefore type:
dcc32 project1
on the command line and compile the project with all the same options as specified in the IDE. You can also type:
make -f projectgroup1.bpg
to make all the targets in the project group.

dci
Holds Code Insight changes you make in the IDE.

delphi.upg
Includes information used to upgrade packages from one version of the product to the next. It is located in the bin directory.

delphi.dct
Holds component template changes you make in the IDE.

dmt
Holds changes you make to menu templates in the IDE (may cause a "Stream Read Error" if corrupt; deleting it will lose your changes to menu templates but resolve the error).

dof
Project options file. Contains the current settings for project options, such as compiler and linker settings, directories, conditional directives, and command-line parameters. Set these options using the Project Options dialog box (Project|Options), they are saved in text form for easy maintenance, version control, and sharing.

dro
Holds changes when items are added to the repository. Can be deleted but your additions to the repository will lost. Can be restored to default by copying the original file \bin\delphi32.dro (Windows only applications) or \bin\CLXdelphi.dro (cross-platform applications) from the product CD.

dsk
Desktop settings. Saves the current state of the desktop, such as which windows are open, and in what positions. Used when Tools|Environment Options|Preferences Autosave Desktop is checked. Depending on where you're working, you'll save desktop settings for the project (Project.dsk), project group (Group.dsk), or IDE (.dsk). Delete these if you do not want to save the desktop settings.

res
Contains the version info resource (if required) and the application's main icon. This file may also contain other resources used within the application but these are preserved as is. Do not delete this file if your application contains any references to it.

tds
Holds the external debug symbol table.

todo
To-do list file. Includes the current to-do list for the project. It has the same name as the project file, but with the extension .todo.