Crystal Reports for Download

Page has versions of Crystal Reports from v. 9.1 to 13.x for download.

 

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567

 

Get the IT career you want: Develop business value - Page 1 - IT Workplace

Get the IT career you want: Develop business value - Page 1 - IT Workplace

VS2010AutoScroller - Release: AutoScroller v0.4.2

I have no idea why Microsoft does this. They took the autoscroll functionality from Visual Studio 2010!
So, to solve this problem I found this extension!
VS2010AutoScroller - Release: AutoScroller v0.4.2: "AutoScroller.vsix"

After you finish download the file, you can copy the file into %appdata%\Local\Microsoft\VisualStudio\10.0\Extensions
folder.

Then you open VS2010 and... enjoy it!

Renaming a column using oracle from version 9i

ALTER TABLE <TABLE_NAME> RENAME COLUMN <CURRENT_COLUMN_NAME> TO<NEW_COLUMN_NAME>;

TO_DATE Oracle Function

Syntax: TO_DATE (date, format) 

 

Example: TO_DATE('11/11/2010 13:00:00', 'dd/MM/YYYY HH24:MI:SS')  - in this case for 24 hours. For 12 hours, you should also specify AM or PM.

 

Find out more in this website (another one that I hope lasts forever) - http://www.techonthenet.com/oracle/functions/to_date.php

 

 

Oracle JDBC string Connection for thin driver

Simple, simple (I took too much time trying to find this string)…

 

jdbc:oracle:thin:[user/password]@//[host][:port]/SID

 

String connection for Microsoft ODBC for Oracle

Direct connection, no DSN, no TSN:

Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=dbName)));Uid=sqv;Pwd=sqv;

 

Extract from: http://www.connectionstrings.com/oracle#p17 (very good website)