Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help

Status
Not open for further replies.

zeldaxp

Programmer
Sep 4, 2002
2
ID
I have problem with dbase & foxpro.
I want connect dbase with asp & foxpro with asp.
I don't use file idx for foxpro & ndx for dbase.
I use foxpro 2.6 & dbase version 7.
I try Applo software but it run slow.
can I use file idx or ndx for asp with another way, because with idx or ndx, i can run sql fast in asp.
foxpro & dbase use shared.

my code(asp use foxpro):
<%

dim con, rs, sql, keyword

keyword = trim(request(&quot;keyword&quot;))
set con = Server.CreateObject(&quot;ADODB.Connection&quot;)

Con.ConnectionString = &quot;Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;&quot; _
& &quot;SourceDB=f:\;&quot; _
& &quot;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;&quot; _
& &quot;Collate=Machine;Null=Yes;Deleted=Yes;&quot;

con.open
set rs = Server.CreateObject(&quot;ADODB.RecordSet&quot;)

sql = &quot;select name, desc from master where code='&quot;& keyword & &quot;'&quot;

rs.open sql,con
%>

thanks for attention.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top