Added: November/25/2006 at 2:14pm | IP Logged

I have used ASPPhotogallery for a long time, since the very first version in fact.

The Album stopped working. Not a problem and I just let it ride as I was busy with life, but I need to get it to work now and am having a problem.

There are a ton of other MSAccess database driven web sites on this server, so this is not an issue with MSAccess.

I went ahead and bought and downloaded the Pro Version. I checked for changes as detailed in your conversion document and found that the old databases already had the new changes and all of the picture files had already been renamed. I then remembered that I had already bought the pro version and that it was the upgrade from the old version to the new that initially caused this problem.

The old version has been installed under aspphotogallery, so I installed the new one under gallery. So, this was basically a new install in its own folder.

However, the problem was the same.

When you load the album, its like it freezes up. If you wait long enough (5 minutes plus) it will load the background, but locks the browser up so tight you have to force the workstation down by turning the power off.

This is in Explorer 7.0 or Firefox 2.0. This is the same problem I saw under Explorer 6.0. The server is Windows Server 2000.

I always use the OLEDB connection and you and I had discussed this years ago which resulted in your OLEDB add on :-)

So, I changed the connection string to the OLEDB connection string and received the following error instantly:

"There is not enough storage area for this operation"

This did not make much sense.

I also noted at this point that I could no longer delete the database on the server or renames it as I got a sharing violation. So I rebooted the server.

Once the server was back up everything looked fine. I uploaded the new connection string, checked to make sure it was mapping to the correct database, and tried to load the album home page. Same result. It hangs for a long time, finally loading the background, but locking the browser on the workstation.

This is weird and I thought you might have some answers.

Ken

Added: November/25/2006 at 2:30pm | IP Logged

Just another note on this.

While it is waiting to load a DLLHOST.EXE process launches on the server and runs at about 70%. If I end the process it stopps the web page rfrom continuing to load. If I hit refresh the same process reappears at about the same load.

If I deleted the process and launch another web site that uses Access, the same process loads, peaks at abot 10% as the connection to the database opens and closes, and then drops to 0.

Not sure if this is of any help.

Ken

Added: November/25/2006 at 2:54pm | IP Logged

Hi,

There is no such thing as the OLEDB add on.. not sure where your getting that from. We may have talked about OLE but there is no add-on. Of this I am sure. I dont even want people using OLE connection strings with this app as it was not coded and tested to work with one..

For now dont use a OLE connection string.. if you want to use one later on and fix any issues it causes that is your deal.. but I dont support using one... though most people dont realize it there are subtile differences in coding that can cause an ole connection string to cause issues just like this.. in an app like this the performace boost you'll get by going OLE isn't worth the bother anyway.. the database is barely tasked and the pics are stored in the filesystem

So, an OLE connection string may or may not be the case for your trouble but for the sake of me supporting you..

Please just use a connection string like in this example for now..

"DBQ=F:\Inetpub\wwwroot\aspphotogallery\_database\aspgallery _access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

And please read these threads extremely carefully and make sure permissions are set EXACTLY how I say to set them

http://support.cjwsoft.com/code/moreinfo136-1.htm
http://support.cjwsoft.com/code/moreinfo56-1.htm

Be sure to give permissions to entire folders, not just the .mdb file as my permission threads above explain. Jus giving permissions to the mdb file can cause big problems as well.

Also try different versions of the access database... starting with the newest versions..

As for the workstation acting up.. dll going crazy and needing to be deleted... been there, done that... it can happen when setting up an app and when things aren't just right... an iisreset from the cmd prompt will also clear things up just so you know. thats easier than going into task manager.

You should also tell me the version of IIS, The OS, and the regional settings of the server.

Then get back to me... its the weekend, I am sick, and I just had major dental work done yesterday, and some idiot friend has conned me into trying to help them fix their computer that they never backed up and save the day, so I may not be around again till monday to answer questions.

It is possible this thread has info that may help you as well. But still dont use an ole connection string for now.

http://support.cjwsoft.com/code/code_info.asp?TID=340&KW %20=%2D1

Added: November/25/2006 at 10:00pm | IP Logged

OK. I figured it out.

The DLLHOST.EXE that was running was running on the web server, not the local workstation.

In addition to the fields you listed in the conversion/upgrade docs there were other fields missing in the old database.

These were:

ALBUM

• Album_Visible
• Right_Click_Protection
• Album_Password

CONFIG

• Use_AspJpeg
• Use_ImgWriter

USERS

• Upload_Limit

The ones under config were in your upgrade docs, but not the others. Once I added thes, it works just fine and all of the old data shows up OK.

Sorry about the dentist thing. I really empathise. I don't like dentist visits at all :-(

If you look under the _database folder, there is a folder called OLEDB4. The contents of that folder are a result of the discussion you and I had on using oledb connection strings. I know its a long time ago (6 years perhaps) and you probably do not recall it, but I remember very well that I was amazed by the fact I could send you an email (those was the days before the forum existed) any time of day or night and I got a response within 5 minutes, sometimes at three o'clock in the morning! It seemed like you never slept and worked 24/7. I notice your habits have not changed much!

You have a lot more products now and seem to be growing which is wonderful to see in a very competive world.

Ken