Database Linking (DBF)

Hi Forum-

I am trying (my hardest) to connect an ACT database (DBF) to an ASP I created. I am totally new to the process - and it all seems to look right - but it won't link in and drop names on the database. I don't get it...and I have fried my brain coming up with alternatives.

Here is the code...and I have a submit page - which comes up and says submitted - but it doesn't link to the database. Any help would be really appreciated.

thanks

Expand|Select|Wrap|Line Numbers

 
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Untitled Document</title>

</head>

<%

Function OpenDBFConn(Path)

  Dim Conn: Set Conn = CreateObject("ADODB.Connection")

  Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

                   "Data Source=shcil" & Path & "c:\inetpub\wwwroot\contacts" & _

                   "Extended Properties=""DBASE IV;"";" 

  Set OpenDBFConn = Conn

End Function

%>

<form action="submit.asp" method="post" name="shcil">

<style type="text/css">

.style1 {font-family: Arial, Helvetica, sans-serif}

.style2 {font-family: Arial, Helvetica, sans-serif; font-weight: bold;}

</style>

<body>

<p class="style2">Contact Database </p>

<p class="style1">Please fill in the following fields:</p>

<p class="style1"><input name="Name" type="text" id="Name" value="CONTACT FULL NAME" size="40">

&nbsp;</p>

<p class="style1">

  <input name="COMPANY" type="text" id="COMPANY" value="COMPANY" size="40">

</p>

<p class="style1">

  <input name="ADDR1" type="text" id="ADDR1" value="STREET ADDRESS" size="40">

</p>

<p class="style1">

  <input name="CITY" type="text" id="CITY" value="CITY" size="40">

</p>

<p class="style1">

  <input name="STATE" type="text" id="STATE" value="STATE" size="40">

</p>

<p class="style1">

  <input name="ZIP" type="text" id="ZIP" value="ZIP CODE" size="40">

</p>

<p class="style1">&nbsp;</p>

<p class="style1">&nbsp;</p>

<p class="style1">&nbsp;<input name="Submit" type="submit" value="Submit">

</p>
 
</body>

</html>

Sep 19 '07 #1

Subscribe Post Reply

1781

jhardman

3,406

Expert 2GB

Please use the code tags to display your code (notice the button marked --#--).

this is ASP.NET, rather than classic ASP right?

Jared

Sep 20 '07 #2

ekcunha

Gotcha - thanks - I think you did it for me already.

Yes - this was started in ASP.NET but it doesn't have to be - I will try anything at this point to link into a DBF.

Thanks again

Sep 20 '07 #3

ilearneditonline

130

Expert 100+

Expand|Select|Wrap|Line Numbers

<%

Function OpenDBFConn(Path)

Dim Conn: Set Conn = CreateObject("ADODB.Connection")

Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=shcil" & Path & "c:\inetpub\wwwroot\contacts" & _

"Extended Properties=""DBASE IV;"";"

Set OpenDBFConn = Conn

End Function

%>

You may want to try this LINK to have a look at the connection string.

Sep 20 '07 #4

ekcunha

You may want to try this LINK to have a look at the connection string.

Thank you very much - I think this just may work for me.

Sep 26 '07 #5

by: Matt Young | last post by:

I've been tasked with integrating an older management system based on DBF files with my snappy new ASP application to provide users of the ASP application with real-time data from the management...

ASP / Active Server Pages

ASP Login / Database Help.

by: harris | last post by:

I am needing some help with a few asp pages and a login script. Let me start by describing my project. I am trying to connect to a database and verify a users login and password, then based on...

ASP / Active Server Pages

linking to a password protected database

by: gasturbtec | last post by:

please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...

Microsoft Access / VBA

help whit DBF linking

by: Admir Hod?ic via AccessMonster.com | last post by:

I use some old fashion program whit DBF files and now i step by step moving thth to acces. Problem occurs when i try to link DBF tables whit MEMO FILED wich requvest file whit ''name''.ftp extension...

Microsoft Access / VBA

Exporting From Access to a Dbase iV. via Object. Fails with error The Microsoft Jet Database engine could not find the object

by: chippy | last post by:

Hi, I've a VB script that creates a Access object in a word doc. Here is the full script. It works for all but the Export. Which always fails with a 3011 error. If I do the same in Access as a...

Microsoft Access / VBA

Database normalization

by: Shwetabh | last post by:

Hi, I am using MS-SQL server to store my database. My problem is that I have around 150+ database files in DBF format. Each database file consists of fields ranging from 2 to 33 in number. Also,...

Microsoft SQL Server

city state database

by: greg.scharlemann | last post by:

Does anyone know where I could find a complete city and state database for MySQL? I've looked at the Zip Code data on the census website, but don't know the best approach to get a .dbf file into...

MySQL Database

Altering a DBF File

by: JimmyKoolPantz | last post by:

IDE: Visual Studio 2005 Language: VB.NET Fox Pro Driver Version: 9.0.0.3504 Problem: I currently have a problem altering a DBF file. I do not get any syntax errors when running the program. ...

Visual Basic .NET

how to convert .dbf database to mysql database

by: Saami | last post by:

hi, i want to convert .dbf database to mysql database. plz help me. i have my college results in .dbf format file. i want to convert it from .dbf to .sql . plz help me.... thanking you. ...

MySQL Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Similar topics