ASP page display delay

Must wait to bring up an ASP page

[webble]

Hi all. I created an asp site using dreamweaver mx, access, iis. The only way i can successfully browse thru the site is to wait at least 30 secs before displaying the next page or else i get a server error. I get an "unspecified error" message in the testing server. This only happens on pages linked to the database.I dont know what to do other than check access rights. I have IIS set to anonymous access and the database connection itself is not exclusive. Whats going on? Thanx.

[Krapulator]

Are you using a dsnless connection to the Access DB? If not you might want to give it a try and see if this improves your situation.

[webble]

Yes I was using a dsn connection. I'm trying to set up a dsnless but dreamweaver doesnt like my connection string:

"Driver={Microsoft Access Driver (*.mdb) }; DBQ=C:\Inetpub\wwwroot\(dirname)\(dbname).mdb;"

I get a "Data source name not found and no default driver specified" error.

[Krapulator]

The following Dsnless connection works for me:

"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=C:\directory\file.mdb;"

[webble]

Thanks. All the sudden now, the site's working great and I didn't even do anything to it. Very strange.