Accessing ACCESS Database

1) How do I make a link that can extract data from ACCESS database and view it in other frame ?  If possible the steps taken is using ASP and if not then use CGi or Javascript.  For example: Link A will extract all name that start with A from the database

2) Do I need to install JDBC or ODBC kind of stuff ?

Thanks
khairiAsked:
Who is Participating?
 
sybeConnect With a Mentor Commented:
using ASP:

1. make an ODBC connection to the database, using ODBC32 in the control panel. Remember the name you gave it.

2. in your asp make a connection to the database using this code:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionTimeout = 15
Conn.CommandTimeout = 30
Conn.Open "DSN=TheNameYouGaveIt"
%>

3. Make a recordset with this code:

<%
strSQL = "SELECT * FROM Table"
Set RS = Conn.Execute(strSQL)
%>

You can strSQL is the SQL statement that you want, you can use any SQL statements that are valid to Access.


4. Display the data with a loop:

<%
Do While Not RS.EOF
 Response.write RS("Fieldname1") & " "
 Response.write RS("Fieldname2") & " "





 Response.write "<p><hr><p>"
RS.MoveNext
Loop
%>

0
 
khairiAuthor Commented:
Edited text of question
0
 
khairiAuthor Commented:
Adjusted points to 150
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
khairiAuthor Commented:
I have try the above statement given.... but on the SQL Server

I have make DSN for the above ... and test using SQL Server and the connection using ODBC32 is test successful

But when I open the ASP page ... it gave me error line at 12 which is the connection using the DSN

Where should I put the above statement.. in body or in head ..

Can I have your Email address?
0
 
khairiAuthor Commented:
opssss.... I found it .. my DSN is still not working ...

Let me test again
0
 
sybeCommented:
Is it working now ?
0
 
khairiAuthor Commented:
Hmmm ... I'm not in good luck .. my server crashed last Saturday and I just got the server up this morning ... the secondary hdd failed ... have to restore my intranet again ...

Bit busy lately .. a  lot of customer complaining .... Hope to get this week
0
 
khairiAuthor Commented:
okay... im ready  but not at my server, at my pc using Personal Web Server using Access

i have put the code in the body section.  i have create one default page that have link to the a asp page that has the code to extract the file " http://nobody/contact/contact.asp "

okay,  when i click on the link ..it just open my asp file using my frontpage editor and hang there and message that the server is busy

what should i do ?
0
 
sybeCommented:
ASP's should be in an executable virtual directory. So you'll have to make such a directory.
I would explain opening the ASP in FP editor because your browser has associated the extension .asp with Frontpage. This has to disappera when the ASP is executed on the server.


0
 
khairiAuthor Commented:
I have move my contact web page to new virtual directory at my server...on IIS on NT4

I now edit my asp using notepad program

When open the page ..http://server/contact.asp
the following error occur
1) "Microsoft OLE DB Provider for ODBC Drivers error '80004005'

   [Microsoft][ODBC Driver Manager] Data source name not
   found and no default driver specified

   /contact/contact.asp, line 15 "

2) "Microsoft OLE DB Provider for ODBC Drivers error '80004005'

   [Microsoft][ODBC Access 97 ODBC driver Driver]General
   error Unable to open registry key 'DriverId'.

   /contact/contact.asp, line 15"


I look at that line it about Conn.Open "DSN=contact"

So, I check at my ODBC32 Manager at control panel. The "contact" DSN is there but at which tab should I create ... there are
User DSN, System DSN, File DSN,

I have created the contact DSN at User and System tab
also I have try at File DSN still same error

0
 
sybeCommented:
Create the ODBC in System DSN.
Error 1, means that the DSN could not be found
Error 2, is unknown to me
Maybe some one else knows ?
0
 
khairiAuthor Commented:
Thanks a lot
0
All Courses

From novice to tech pro — start learning today.