Windows Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

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.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Vista Forums > General Discussion

Cannot connect to FoxPro database in Vista, IIS 7

Update your Vista Drivers Update Your Drivers Now!!
Reply
 
Thread Tools Display Modes
Old 01-02-2008   #1 (permalink)
Newbie


Join Date: Jan 2008
Vista Home Premium 32bit
 
Rep Power: 6
tucnak is on a distinguished road
  tucnak is offline

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 SpecsSystem Spec
Reply

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


Vistax64.com is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51