asked on

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

khairi

ASKER

Edited text of question

khairi

ASKER

Adjusted points to 150

ASKER CERTIFIED SOLUTION

sybe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

khairi

ASKER

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?

khairi

ASKER

opssss.... I found it .. my DSN is still not working ...

Let me test again

sybe

Is it working now ?

khairi

ASKER

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

khairi

ASKER

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 ?

sybe

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.

khairi

ASKER

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

sybe

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 ?

khairi

ASKER

Thanks a lot