efimov.org - Works and Thoughts of Michael Efimov | Everything Development

Success! Domain efimov.org was analyzed on Saturday 10. December 2016!

DomainsData.org: Works and Thoughts of Michael Efimov | Everything Development

Title:

Works and Thoughts of Michael Efimov | Everything Development
Age:

15 years old
Alexa Rank:
Total Sites Linking In (Alexa):
Domain's IP Country:

United States
Status Code:

OK
IP Address:

216.250.120.109
Description:
Keywords:

efimov.org Whois Information:

1.

Domain Name:

efimov.org
2.

Domain Age:

15 years old
3.

Name Server 1:

ns29.1and1.com
4.

Name Server 2:

ns30.1and1.com
5.

Created:

Monday 11. June 2001
6.

Expires:

Sunday 11. June 2017
7.

Domain Registrar:

1 & 1 Internet AG

Website Important Html Tags:

TAG
TEXT
h1
Works and Thoughts of Michael Efimov
h3
Recent Posts
h3
Recent Comments
h3
Archives
h3
Categories
h3
Meta
h2
Everything Development
li
Comments are filtered by system language. In development console I see comments in English, Russian, Japanese and Korean, but in the market itself it only shows English to me.
li
There is facility to report errors from devices, but I haven’t gotten any reports.
li
Interesting metric is a number of active installs (as opposed to number of downloads).
div
It happens, if we are accessing more then one database in one COM+ transaction. We are relying on ODBC connection pooling, so we typically open a connection to one database, run some queries, close the connection, then open connection to another database, run some queries, etc. It used to work nicely with MTS.
div
Behind the scene, after ODBC method ::SQLDisconnect is called, connection to Oracle is not broken, because transaction still continues, so Oracle needs to be notified of its final outcome.
div
Unfortunately second call to ODBC method ::SQLConnect returns the very same open connection, that was used before, even if DSN, User name and password are different. That is clearly a bug.
div
If first connection is kept open during transaction, then everything works correctly. Also everything works correctly, if databases are accessed from different COM+ applications, because they don’t share connection pool.
div
I’ve come up with small test program, that reproduces the bug.
div
I also enclosed source code for the COM+ component, and MTS package, if anyone wants to try it on NT (I’ve done that).
div
I don’t know, if it happens with any database, other then Oracle, but I’ve tried different MDAC versions, and they seem to behave consistently.
div
There seem to be no good work around. We’ve implemented fair workaround, which uses SQLGetInfo function right after SQLConnect, to verify, that database user is indeed the same, as program has asked for. Obviously it means performance hit, so any other clever ideas are very welcome.
div
INSTALLATION:
div
1. Install enclosed odbc_test_app_win2k.MSI package, that contains ODBC_TEST_APP COM+ library application, that requires transactions.
div
2. Modify enclosed odbc_test.js script to specify your connection parameters and sql statement.

efimov.org IP Information:

1.

Ip Address:

216.250.120.109
2.

Country:

United States
3.

Status Code:

OK
4.

Region Name:

Pennsylvania
5.

City Name:

Wayne
6.

Zip Code:

19087
7.

Speed test:

54.5 ms

efimov.org Alexa Information:

5 Websites linking to efimov.org:

Websites related to efimov.org:

Top Keywords from Search Engines:

Site Screenshots:

Screenshot created on Saturday 10. December 2016

This is a screenshot of efimov.org, created on Saturday 10. December 2016
Click on thumb to enlarge the screenshot.

Google Ranking Screenshots:

Screenshot created on Saturday 10. December 2016

This is a Google Top 10 results' screenshot for keyword Works and Thoughts created on Saturday 10. December 2016.
The position for keyword Works and Thoughts is: Not in top 10
Google Ranking Position checked from US (United States of America) Ip Address on Saturday 10. December 2016.
Click on thumb to enlarge the screenshot.