Cannot connect to FoxPro database in Vista, IIS 7

tucnak

New Member
Hello,
I cannot connect to my database (free tables) when I have upgraded to Vista.

I have created system DSN using Visual FoxPro 6 driver in ODBC.

I have copied my web directory to new Inetpub directory and in IIS 7.0 manager I have marked it as an Application.

I have given manage permissions to IUSR, Users and IIS_IUSRS on directory with my data and on some temporary directory
C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp
as I have read about.
As I have checked, I can via my ASP script create text files in these directories, so permissions should be ok.

When I run my ASP code, it works fine, but when I try to connect to my FoxPro tables it doesnot work, connection cannot be opened. The error will appear at the following command:
objConn.Open myConnectionString

There is a part of my code:
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=mydsn;PASSWORD=;UID=;" ' this row doesnot work
SET objComm = Server.CreateObject("ADODB.Command")
...

The problem is also that my Internet Explorer and Firefox too show only the message that Web site cannot be shown, nothing else. Although I have marked all necessary switches (show details error messages in Internet Tools and in IIS Manager - Error pages)

Thank you very much for your support.
 

My Computer

Back
Top