Tuesday, March 2, 2010

Creating new ODBC connection on 64-bit Vista/ODBC driver for 64-bit Vista

If u are trying to make a odbc connection to say MS Access or Excel, so that it can be used by a programming language (like java), on a 64-bit OS. Then the things u need to do are:
1.)Go to Control Panel
2.)Go to Administrative Tools
3.)Right click on Data Sources and go to its properties
4.)In properties change the following and click 'OK'
Target field to:
%SystemRoot%\SysWOW64\odbcad32.exe
From:
%SystemRoot%\System32\odbcad32.exe
Start In to:
%SystemRoot%\SysWOW64
From:
%SystemRoot%\System32
5.)Having done the above go to Data Sources and in that go to System DSN.
6.)In System DSN click on Add and select the driver u want and click 'Finish'.
eg. Driver *.mdb(for Access 2003), *.accdb(for Access 2007), *.xls(for Excel) and so on.
7.)Having done this Select the file u want by going to 'Select' and choosing the file u want to use
in ur program and give the Data Source Name(DSN) the same as name the name of ur
file.This will do the job.
Note: The DSN need not be the same as the name of the file. But what ever u give the DSN ,makes ure u use that in ur program to get Connection.

How to change the port number of wamp(apache) server on windows machine

To change the port number of apache server , go tto the httpd.conf file and change the port number to the available port number(8080 or 8081).
If it is a wamp server u will find the httpd.conf file at this path
C:\wamp\bin\apache\Apache2.2.11\conf\httpd.conf
Open this file with note pad and change the port numbers.
or start the wamp server and u will find the apache icon in the tray(right hand bottom corner). Click on the icon and go to apache and and there u the httpd.conf file. Open this file and change the port number.

How to make jQuery work in blogger/blogspot

Go to Layout of ur blogspot and click on edit html.Add to the head section the following snippet:

To add
jQuery to the blogger post, make sure the whole jQuery snippet comes on a single line when u paste it on notepad or wordpad.If there are line breaks(carriage return or returns) in the note pad,then the jQuery snippet does not work.

Where to find host string and port name in oracle

The tnsnames.ora file has the host string and port number details needed to connect to the oracle server.So open the tnsnames.ora file with notepad or wordpad to get the details about the hostname, port number and SID.