Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Vista Forums > General Discussion

Vista - Cannot connect to FoxPro database in Vista, IIS 7

Reply
 
Old 01-02-2008   #1 (permalink)


Vista Home Premium 32bit
 
 

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


Similar Threads
Thread Forum
Can VBScript read foxpro 2.6 database? VB Script
'Connect' database for WLM? Live Mail
reboot each day to connect to a SQL Express Database .NET General
iis 5.1 can't connect to database server .NET General
I have a problem creating a ODBC connection to a Foxpro Database!! Vista file management


Vista Forums 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 Ltd

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