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.
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.