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 Newsgroups > Vista General

Vista - FoxPro ODBC

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


Vista Home Premium 32bit
 
 

FoxPro ODBC

Hello,
I have just bought the new pc with Vista Home 32 installed.

I have installed my Visual Foxpro 5.0, so in ODBC there is Visual FoxPro Driver version 5.00.00.402 and I have created a system DSN using this driver (with free directory).

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

I am using ASP and when I run the code and trying to connect to my FoxPro tables it doesnot work, connection cannot be opened.

There is a part of my code:

myCommand = "SELECT * FROM country"
DataConn_ConnectionString = "DSN=mydsn;PASSWORD=;UID=;"
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout = 15
objConn.CommandTimeout = 30
'------ Following row doesnot work -------------------------------
objConn.Open DataConn_ConnectionString
'-----------------------------------------------------------------
SET objComm = Server.CreateObject("ADODB.Command")
objComm.CommandType = 1
SET objComm.ActiveConnection = objConn
objComm.CommandText = myCommand
SET rsTemp = Server.CreateObject("ADODB.Recordset")
rsTemp.Open objComm, , 1, 1
If Not rsTemp.EOF Then
SQL_Country_Select = rsTemp.GetRows()
Else
SQL_Country_Select = null
End If
rsTemp.Close
Set rsTemp = Nothing
Set objComm = Nothing
Set objConn = Nothing

Thank you very much for ideas
Marek

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Can VBScript read foxpro 2.6 database? VB Script
Cannot connect to FoxPro database in Vista, IIS 7 General Discussion
ms dos foxpro 2.6a (X) will work ? Vista General
ODBC / Vista / Foxpro Vista 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