Database Linking (DBF)

ekcunha

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>

jhardman

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

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

Jared

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

ilearneditonline

Quote:

Originally Posted by ekcunha

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.

ekcunha

Quote:

Originally Posted by ilearneditonline

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.

Database Linking (DBF)

re: Database Linking (DBF)

re: Database Linking (DBF)

re: Database Linking (DBF)

re: Database Linking (DBF)

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about