Solved

Accessing ACCESS Database

Posted on 1998-06-25
12
160 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
  • 8
  • 4
12 Comments
 

Author Comment

by:khairi
Comment Utility
Edited text of question
0
 

Author Comment

by:khairi
Comment Utility
Adjusted points to 150
0
 
LVL 28

Accepted Solution

by:
sybe earned 150 total points
Comment Utility
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
 

Author Comment

by:khairi
Comment Utility
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
Comment Utility
opssss.... I found it .. my DSN is still not working ...

Let me test again
0
 
LVL 28

Expert Comment

by:sybe
Comment Utility
Is it working now ?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:khairi
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks a lot
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Reason for High TTFB 1 34
Problem to Popup 37 78
GPS save in database 19 36
Do we need servers??? 5 114
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

771 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now