![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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. |
| |||||||
![]() |
| |
| | #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 Specs![]() |
![]() |
| 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 | |||