![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
|
Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
br> br> |
| |||||||
![]() |
| | Thread Tools | Display Modes |
| | #1 (permalink) |
| Newbie Rep Power: 6 ![]() | Cannot connect to FoxPro database in Vista, IIS 7 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 System Specs![]() |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| iis 5.1 can't connect to database server | hs | .NET General | 0 | 08-13-2008 04:29 AM |
| Works database 2007 and Office database 2003 | maur scho | .NET General | 0 | 06-03-2008 01:48 AM |
| connect to paradox db from sqlserver database table | vishruth | .NET General | 0 | 03-11-2008 04:07 AM |
| ODBC / Vista / Foxpro | Robert Hooker | Vista General | 4 | 10-11-2006 04:07 PM |
| I have a problem creating a ODBC connection to a Foxpro Database!! | John C. Hill | Vista file management | 9 | 09-26-2006 02:02 PM |