Wish everything would have been easier to remember in this world! But that’s not true.
“rowspan” is one of such tag in HTML that I always forget to implement. This Sunday I have decided to make it clear and clear forever. Hope this picture helps you in understanding the HTML tag and remembering forever. Similar concept will be applicable for “colspan’ as well.
For the first time, I was having a deep look into the dashboard provided by WordPress. The statistics page is really awesome.
For my blog, I got 4528 unique views from 2946 visitors for the year 2016 across the globe with highest visitors from USA. This year I will be targeting for 10k as unique views. Thanks for visiting my site.
I am sure, if you are a beginner for Mirth – this screen would have made you to cry. You wont get the text box to enter the Username and Password to login to Mirth Connect.
When it happened for me for the first time, I followed few guidelines over the web; but still could not be recovered. Since I was in hurry and I had a back up of all my mirth channels, hence I went for a fresh installation. But again after few days – the same screen has appeared.
This time I was not into a position to do a re-installation. So here is the proper and perfect solution to get rid off this:
1. Windows 7 and onward system, go to start and in search type – “Java Control“. Click the Java which falls under Control Panel.
The same will appear as Start->Control Panel -> Java
2. After click – now go to General -> Settings -> Delete File
At the same time you can make a larger space for your temporary file by editing the values.
After delete, go to your Mirth Connect Administrator – it should bring up the user name and password screen into a right format.
If you have more channels and processing are of high volumes, In Mirth Connect 3.3.x
right click on Mirth icon at your system tray -> Show Manager -> Under Server Tab – Server Memory -> Put a higher value now.
In Mirth Connect 3.4.x
right click on Mirth icon at your system tray -> Show Manager -> At the last row of the screen beside “Administrator” there is a “setting/tool” icon
Change the Max Heap Size
But the best would be to change directly from the Mirth configuration file:
C:\Program Files\Mirth Connect\conf\mirth.properties ( or a similar path)
Look for administrator.maxheapsize = <?>
This should fix the problem for some more days – but ultimately you must be cleaning the Java temp file on a regular basis. I don’t want to consume the entire memory to heap, hence I will set an optimal value – never mean I can put a 3 or 4 GB to it.
MySQL is more like a girl friend and cozy with WAMP.
MS SQL Server becomes the arrogent gal for WAMP. She does all the drama before falling in love with WAMP.
I know WAMP should not be preferred if you want to be away with MySQL. But many of us prefer in installing WAMP cause it comes with
The desired PHP version
Apache webserver is automatically taken care as compatible with your PHP 5.x.x version (You just cant put any Apache httpd with your PHP X)
You get many required DLL files with installation to /ext folder like – C:\wamp\bin\php\php5.5.12\ext. Need not to download them from here and there.
Ofcourse the GUI is so quick and easy to
a) run/stop the services, b) look for the PHP.ini for any changes, c) look for the httpd.conf for any changes
See what happens when you try to work with SQL server into WAMP’s PHP
1. You need to download the DLL for SQL server supported by PHP
2. Make a change to php.ini file for this dll
Here is the step by step guideline from installation to troubleshoot: A. Download the DLL file
1) Complete this table from your installed environment (done so far)
a) PHP Version – Something like 5.5.12 or 5.3.4 or ?
b) PHP dll – Like php5ts.dll or php5.dll or ? [ Look to the directory – C:\wamp\bin\php\php5.5.12]
c) Microsoft Driver Version -> ? ( We will do it in next few minutes)
d) Required SQL Server DLL file -> ? ( We will do it in next few minutes)
B. Changes to PHP.ini file
Look for the php.ini file into Apache folder, not the one at PHP folder – like C:\wamp\bin\apache\apache2.4.9\bin
Add these two lines at related place into the ini file as per your downloaded dll extension=php_sqlsrv_55_ts.dll extension=php_pdo_sqlsrv_55_ts.dll C. Restart the server
Are you still getting an error while running your PHP code – “Unable to find sqlsrv_connect()”
D. You are happy to GO – May be or No No No!
If so, issue could be with the dll and that is something more your OS as 32 bit or 64 bit.
Let us try to overcome this:
1. Download this Microsoft ODBC Driver 11 for SQL Sever https://www.microsoft.com/en-us/download/details.aspx?id=36434
ENU\x64\msodbcsql.msi -> 64 bit