Oracle Announces Plans to Support Microsoft Visual Studio 2012

Oracle plans to offer a new version of the Oracle Developer Tools for Visual Studio integrated with Microsoft Visual Studio 2012. This new version will be available within 40 days of Microsoft Visual Studio 2012's Release to Manufacturing (RTM) date. As with earlier releases of Visual Studio, Oracle has partnered closely with Microsoft as part of the Visual Studio Industry Partner Program to make this release possible. Keep an eye on on the OTN .NET Developer Center or Twitter for the upcoming release announcements.

How to SVN by using Dropbox: from team member's point of view

One Time Setup:

a). Install Dropbox (https://www.dropbox.com/downloading?os=win) on your computer. Define a folder for Dropbox contents. For example: D:\Dropbox.

b). Install TortoiseSVN on your computer: http://tortoisesvn.net/downloads.html

c). Once you have set this up, run the Dropbox.exe. You will get the shared folder, for example "REPOSITORIES", inside D:\Dropbox. This is the SVN repositories folder. Please DO NOT delete or edit this folder.

d). Now, create a workspace folder to checkout the SVN. For example: D:\Workspace. Right-click this folder, select "SVN Checkout...". You will need to link the URL of repository to D:\Dropbox\REPOSITORIES\ folder.

e). After that, you shall be able to see the following folders in D:\Workspace: .svn, branches, tags, trunk.

f). Now, you will get all of the latest source codes and scripts in D:\Workspace folder.

Standard Operation Procedure Before Development:

a). Before development, make sure you run Dropbox.exe to update the latest files from the team members, if any. Once all files are up-to-date, please exit Dropbox.exe.

b). After that, right-click the D:\Workspace folder and select SVN Update. System will update all of the changes done by your team members, if any. In case there is any conflict files (Exclamation marked), please kindly proceed to do a merging before start the development or changes.

c). Now, you may start your development or changes as usual. DO NOT run Dropbox.exe when you are developing your codes or changing any contents.

Standard Operation Procedure After Development:

a). After development, please kindly save all of the changes and close the development compiler. DO NOT run Dropbox.exe at this moment.

b). Then, right-click the D:\Workspace folder and select SVN Commit.... Remember to write some meaningful comments in the text box to keep track the SVN commit history. System will automatically commit the changes done by you to D:\Dropbox\REPOSITORIES\ folder. To save the updating time, please DO NOT commit EXE files, DLL files, BIN folder, OBJ folder, LOGS folder, MSI files and etc.

c). Once the SVN commit is done, run Dropbox.exe now. System will automatically sync the changes from your computer to Dropbox cloud, so your team members will be able to retrieve your changes.

Update OpenQuery v.s. Update LinkedServer.Table

In our recent findings, we have found that the Update statement with LinkedServer could cause database performance issue, which end up giving you a "server is not responding" or timeout error message.

The solution to resolve this issue, is to change the Update LinkedServer.Table statement to Update OpenQuery statement.

This solution is tested and proven workable.

How if iCloud is too small? Go for Box then.

50 GB free spaces : )

Crystal Reports Software Download from SAP Business Objects Support

If you do have the same experience, you will notice that it is hard to find Crystal Reports software from the internet. Luckily, we still manage to find the solution from SAP website:

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

The file 'XXX.aspx' has not been pre-compiled, and cannot be requested.

Development Tool: Microsoft Visual Studio 2008

Project Platform: ASP.NET Web

 

You are trying to browse your ASP.NET web after published it on your web server, but end up Windows giving you this error message in the browser: "The file 'XXX.aspx' has not been pre-compiled, and cannot be requested."

 

The weird part is, you already pre-compile the source codes, rights?

 

Here is the SOLUTION:

 

a). Publish your ASP.NET web project as usual.

 

b). IMPORTANT: Manually copy all of the DLL files into the <Pre-Compiled_Output_Folder>\bin folder. Those DLL files can be Crystal Reports DLL file, if you are using Crystal Reports in your ASP.NET web project.

 

c). Then, publish your ASP.NET web project on your web server as usual.

 

Have fun!

The table 'TABLE_NAME' could not be found. Error in File REPORT_FILE_PATH: The table could not be found.

Report Tool: Crystal Report from Visual Studio 2008
Database: MySQL Server (any version)
Project Platform: ASP.NET Web

Symptom 1: You can open the Crystal Report in developer's machine successfully.
Symptom 2: You cannot open the Crystal Report in other machines, including other developer's machine.

Error message: The table 'TABLE_NAME' could not be found. Error in File REPORT_FILE_PATH: The table could not be found.

SOLUTION:

• First, make sure the Crystal Report runtime is installed on the web server.
• Second, make sure the correct MySQL ODBC Connector is installed on the web server. For example: if you are using MySQL database version 5, then the version of the MySQL ODBC Connector shall be version 5 as well.
• After that, close all of the internet browsers.
• Run your web application now, and the error shall be resolved.