Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 20th, 2008, 12:12 AM
Registered User
 
Join Date: Jul 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Slayer_CauTioN
Default Show Foxpro Database in ASP

Hi ,

I trying to show foxpro database on ASP but there shown the error :

Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
Feature is not available.
/vknow/searchrecord.asp, line 23


Here is the source code using vbscript:

dim conMK
dim ConnStr, sSql
Set conMK = Server.CreateObject("ADODB.Connection") 'line19
ConnStr= "Provider=VFPOLEDB.1;UID=root;" +_ 'line20
"SourceType=DBF;SourceDB=" & Server.MapPath("loitemm.dbf")& ";Exclusive=No;" 'line21
conMK.Open ConnStr 'line22
'line23
dim bFound 'line24
dim rs, rs1 'line25
...
%>


The VFPOLEDB.dll is already install on C:\Program Files\Common Files\System\Ole DB folder

I have no idea which part is going wrong .Any help will be appreciate.

 
Old July 20th, 2008, 07:28 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Only thing I find is this:
http://www.carlprothman.net/Default....orVisualFoxPro

And that seems to indicate that you are using SourceDB when you should be using DataSource. Plus it connects to the ".dbc" file, though I suspect your use of SourceType may make that okay.

Anyway, I'd suggest following the links on that page to the MS Knowledge Base articles, et al.





Similar Threads
Thread Thread Starter Forum Replies Last Post
foxpro database Otto Mashon Pro VB Databases 1 October 18th, 2007 03:12 PM
Database unable to show result. (ASP.NET C#) richie86 ASP.NET 1.0 and 1.1 Basics 3 November 10th, 2005 01:59 PM
Foxpro Database Connection anubhav.kumar Pro VB Databases 0 May 16th, 2005 11:04 AM
Transfer FoxPro database to Access pavel Pro VB Databases 2 August 21st, 2003 04:25 PM
Transfer Foxpro database to Access pavel Access 2 July 29th, 2003 12:03 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.