Shimon Krokhmal's blog

A friend calls me earlier today(and wakes me up), with a problem on a system that he is maintaining.
since the customer needed the system ASAP, he asked me to deal with it .

So, what is the problem ?

getting in to the system, wins the happy user with this error message :

8007000e System resource exceeded
Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

needless to say that is an "ASP-Access" system.

lets review all our facts :

• The system written in ASP
• The system's database is Access
• It deployed on a shared hosting server
• the system sends some error message - probably DB related

after googling a while, got the answer that the problem is connection pooling related.
this could mean one of two things :

1. There are places in the system which the connection not closed properly, which overloads the connection pool.
2. There are too many simultaneous users, which cousing too many connections at the same time.

Since there is only one user on the system, the second option is probably not the answer.

so, how do we clear the connection pool on a shared hosting server ???

lets see what are the options (or to be exact : what are our limits on shared hosting on that issue ?)

• We can't access the IIS configurations.
• We can't get a remote desktop connection (is it too much to ask ?)
• We don't have an access to the connection pool configurations
• We cant restart the server.

Here is the solution :

1. Access to the system to get the error.
2. rename the DB from db.mdb to db1.mdb
3. run the system again (this is an important step),
   the system will think that it's missing it's database and recycle the connection pool(mission accomplished)
4. rename the database file to the original name (db.mdb)
5. run the system again.

now, i have to say , that this is a problem solver for the short run,
whatever caused the problem will probably cause it again at some point.
so, the best solution , is to do some harsh code review and find the problem (where the connection is opened but not closed...)

take care.

OK,
lets start from the begining...

after i reinstalled my PC, i had to install a bunch of drivers.
one of them was for my Web-cam.

so, i connected the camera, clicked on the windows auto install,
but the damn windows won't recognize the camera.

So, i tried to google the drivers, but no luck there.
Apparently, there is no such company named Quantum (well, there is, but it does not do web-cams)

I decided to go extreme on this one.

for this "critical mission" i needed :

• 1 leatherman
  
  
• 1 canon Digital camera
  

first i opened the little Web-Cam to see what is inside.

found some board connected with a cable.

on the back of the board i found a chip with some data printed on him.
because it was so small, i couldn't see the printing, so i used my camera for this task.


but seems someone wanted to erase that model (is Quantum not the real company behind this camera ?)
after thinking a little bit, i took another shoot of this chip, but with a different angle.

this photo revealed important info :

the company that made this chip is : Sonix
The chip model is : sn9c101

so, fast as a lightning, i googled up their site and went for the drivers section for the product.

but the drivers didn't work for me... (Why ???)

i started to look for more data on this hardware...

a closer look on this board gave me some more interesting data :

the board model is : DC-2110A

googling again for this model gave me a direct link for the drivers (god knows who made them...)
the drivers and the board made by "Chicony Electronics"

this is their download page :
http://www.chicony.com.tw/download/di/driver.asp

so installing them for the second time went smoothly.

after assembling back the camera, it is once again usable :)

update :

after browsing the company site, i discovered they do have a camera for that model
http://www.chicony.com.tw/products/PCC/pandaCIF.htm

but no relations to quantum what so ever.
Did someone got their product and changed its name to sell better ?

I found some tests related to Math infi 1 that i study in college.
thought that it would be useful to share these tests.

Notice,
the file is encrypted, if you want the password, email me :)

after installing IE7 on my workstation, i noticed one thing that really annoyed me ,
the position of the menu toolbar.

for those that installed the browser, you probably noticed that the menu bar is positioned right below the address bar.
Ok, who tha hell in Microsoft thought that it will be convenient ?

Well, after doing some digging on the net, i found some interesting info about it (apparently not only me considered this "feature" as annoying)
So, what have i found ? what should we do to get things back to normal ?

(this is not the wanted position)

apparently, the only way is to change some registry values (aren't we love Microsoft ?)

• go to the registry editor : (type RegEdit in the Start-> run)

• go to this path :
  "HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Toolbar\WebBrowser"

• add a new registry value and name it "ITBar7Position"
  

• Change the value of the new object to 1
  
  (this should look like this :)
  

• restart your Internet Explorer

• you're done !

now your IE7 menu bar will be placed in the normal position where it should be

if you don't want to mess around with the registry by yourself, you can download the file attached to this post,
it should do the job for you.

enjoy !