Problems with Access, Vista, ASP

Report · Apr 27, 2008

Hello, I'm using DW CS3 and ASP classic on a machine with Vista Ultimate and having problems connecting to the MS Access Database via the testing server. When I try to add the database connection and create a DSN through the dialog box, I hit "Test" and get the following message:

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I suspect it is a permissions-based problem but have been unable to isolate it. The database is in the directory, C:\Users\Public\Documents\Database. So far at the folder level I have tried:

- verifying full control permission for the Administrators group
- giving full control permission to the IUSR_ComputerName account

I also verified the access database itself has no permission restrictions.

Incidentally I am new to CS3 and working through the book, "Adobe DW CS3 with ASP, ColdFusion and PHP Training from the Source", specifically the example in Chapter 7 using the newland database. I am somewhat familiar with dynamic web development (veteran of GoLive 6) but am not up to speed on developing under Windows Vista. BTW I have turned User Account Control off in Vista.

Report · Apr 27, 2008

> Hello, I'm using DW CS3 and ASP classic on a machine with Vista Ultimate
> and
> having problems connecting to the MS Access Database via the testing
> server.
> When I try to add the database connection and create a DSN through the
> dialog
> box, I hit "Test" and get the following message:
>
> [Microsoft][ODBC Microsoft Access Driver] Disk or network error.
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
>
> I suspect it is a permissions-based problem but have been unable to
> isolate
> it. The database is in the directory, C:\Users\Public\Documents\Database.
> So
> far at the folder level I have tried:
>
> - verifying full control permission for the Administrators group
> - giving full control permission to the IUSR_ComputerName account
>
> I also verified the access database itself has no permission restrictions.

IIS7 on Vista uses a different temp directory. Give 'modify' permission to
IUSR for this folder:
C:\Windows\ServiceProfiles\NetworkService\AppData\Local

Report · Apr 27, 2008

Ted:

Thanks. I tried your suggestion, giving IUSR full control to the following folders:

C:\Windows\ServiceProfiles\NetworkService\AppData\Local
C:\Windows\ServiceProfiles\LocalService\AppData\Local

However I get the same ODBC errors when I hit "Test".

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Any other suggestions?

Thanks again.

Report · Apr 27, 2008

> Thanks. I tried your suggestion, giving IUSR full control to the following
> folders:
>
> C:\Windows\ServiceProfiles\NetworkService\AppData\Local
> C:\Windows\ServiceProfiles\LocalService\AppData\Local
>
> However I get the same ODBC errors when I hit "Test".
>
> [Microsoft][ODBC Microsoft Access Driver] Disk or network error.
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

Yes, move that database out of the Users directory and make sure the
permissions on the file aren't hurting you, and use an OLEDB connection
string.

Report · Apr 30, 2008

I tried using a custom connection string as an alternate to the DSN method. In the connection string box, as follows:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\newland\newland_tours.mdb;User ID=admin;Password=;

Now I get "Unspecified Error". Very frustrating, a lot of time spent on this problem and am running out of options. Hoping someone can offer a solution?