Hi,

I've installed the DBISAM ODBC drivers on a win7 64bit machine and added a system-DSN.

When i try to connect a ASP webpage to the DSN my browser just returns a error
("500 internal server error ") message.

I'm using DBISAM ODBC driver v3.24 with a v3.24 database.
The driver is correctly installed(as far as i can see) and the DSN is added correctly aswell(with the odbcad32.exe file in the SYSWOW folder).


I'm hoping anyone can help me.

Hi,

It could well be your access rights to the path where your data is
stored (Check that IUSR_xxxx has permission to access the data).
Depending upon what web server are you running.

Chris Holland
[Team Elevate]

On 01/04/2011 10:06, rkloeg wrote:
> Hi,
>
> I've installed the DBISAM ODBC drivers on a win7 64bit machine and added a system-DSN.
>
> When i try to connect a ASP webpage to the DSN my browser just returns a error
> ("500 internal server error ") message.
>
> I'm using DBISAM ODBC driver v3.24 with a v3.24 database.
> The driver is correctly installed(as far as i can see) and the DSN is added correctly aswell(with the odbcad32.exe file in the SYSWOW folder).
>
>
> I'm hoping anyone can help me.
>

--
Chris Holland
[Team Elevate]

Hi Chris,

Checked the permissions of the database folder.
IUSR_*** has read, write permission, I also tried it with full acces but no luck.

The server is a Windows 7 64 bit machine running IIS7 as webserver.

Greetings,

Robert

Chris Holland wrote:

Hi,

It could well be your access rights to the path where your data is
stored (Check that IUSR_xxxx has permission to access the data).
Depending upon what web server are you running.

Chris Holland
[Team Elevate]
--
Chris Holland
[Team Elevate]

Hi Robert,

Okay, go into your IIS7 control panel and select the Application Pool
that you are running. Then click on Advanced (right hand menu) and check
that "Enable 32 bit Applications" is set to true.

Chris Holland
[Team Elevate]


On 05/04/2011 11:34, rkloeg wrote:
> Hi Chris,
>
> Checked the permissions of the database folder.
> IUSR_*** has read, write permission, I also tried it with full acces but no luck.
>
> The server is a Windows 7 64 bit machine running IIS7 as webserver.
>
> Greetings,
>
> Robert
>
> Chris Holland wrote:
>
> Hi,
>
> It could well be your access rights to the path where your data is
> stored (Check that IUSR_xxxx has permission to access the data).
> Depending upon what web server are you running.
>
> Chris Holland
> [Team Elevate]

--
Chris Holland
[Team Elevate]

Hi Chris,

That did the trick!

Many thanks.

Robert Kloeg


>Chris Holland wrote:

>Hi Robert,

>Okay, go into your IIS7 control panel and select the Application Pool
>that you are running. Then click on Advanced (right hand menu) and check
>that "Enable 32 bit Applications" is set to true.

>Chris Holland
>[Team Elevate]

Hi Chris,

I've got another strange issue, same setup as above(only difference is my webpage is only browseable via HTTPS(SSL).
As soon as i set "enable 32-bits Application" to true i get a error 500.

Do you have any ideas?

Thanks in advance!

Chris Holland wrote:

Hi Robert,

Okay, go into your IIS7 control panel and select the Application Pool
that you are running. Then click on Advanced (right hand menu) and check
that "Enable 32 bit Applications" is set to true.

Chris Holland
[Team Elevate]


On 05/04/2011 11:34, rkloeg wrote:
> Hi Chris,
>
> Checked the permissions of the database folder.
> IUSR_*** has read, write permission, I also tried it with full acces but no luck.
>
> The server is a Windows 7 64 bit machine running IIS7 as webserver.
>
> Greetings,
>
> Robert
>
> Chris Holland wrote:
>
> Hi,
>
> It could well be your access rights to the path where your data is
> stored (Check that IUSR_xxxx has permission to access the data).
> Depending upon what web server are you running.
>
> Chris Holland
> [Team Elevate]

--
Chris Holland
[Team Elevate]

I found the solution...
Seems IIS had some troubles with some modules after installing Win2008 sp 3!

I had to add precondition="64bitness" to applicationHost.Config

After that it works for me.