Solved

Accessing ACCESS Database

Posted on 1998-06-25
12
166 Views
Last Modified: 2013-12-25
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
0
Comment
Question by:khairi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 4
12 Comments
 

Author Comment

by:khairi
ID: 1858417
Edited text of question
0
 

Author Comment

by:khairi
ID: 1858418
Adjusted points to 150
0
 
LVL 28

Accepted Solution

by:
sybe earned 150 total points
ID: 1858419
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:khairi
ID: 1858420
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
 

Author Comment

by:khairi
ID: 1858421
opssss.... I found it .. my DSN is still not working ...

Let me test again
0
 
LVL 28

Expert Comment

by:sybe
ID: 1858422
Is it working now ?
0
 

Author Comment

by:khairi
ID: 1858423
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
 

Author Comment

by:khairi
ID: 1858424
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
 
LVL 28

Expert Comment

by:sybe
ID: 1858425
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
 

Author Comment

by:khairi
ID: 1858426
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
 
LVL 28

Expert Comment

by:sybe
ID: 1858427
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
 

Author Comment

by:khairi
ID: 1858428
Thanks a lot
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question