ASP database MS access problem

100 100+

Hi,
i have MS access database db1.mdb in "c:\"

my code is this

Expand|Select|Wrap|Line Numbers

 
<html>

        <head>

            <title>Time Clock</title>
 
        </head>

        <body>

            <%

                dim dbPath,cn,sql

                dbPath="c:\db1.mdb"

                Response.Write "Here I am"

                set cn=Server.createobject("ADODB.Connection")
 
                cn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & " DBQ=" &dbPath
 
                sql = "select * from Table1"

                set rs=cn.execute(sql)

                dim row

                row = rs.getRows()
 
                Response.Write row

                Response.Write "<p>The Server time now is "

                Response.Write Time 

            %>
 
        </body>

</html>

but it is giving error

Technical Information (for support personnel)

Error Type:
Response object, ASP 0106 (0x80020005)
An unhandled data type was encountered.
/rag1.asp

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727

can any one help
i am new to ASP

Thanks

Sep 20 '07 #1

Subscribe Post Reply

654

by: MHenry | last post by:

Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network...

Microsoft Access / VBA

Problème data tramsmission from tableadapter to ACCESS database

by: philip | last post by:

On a form, I have a datagridview. This datagridview is constructed on a dataset filled by a tableadapter. The table adapter do very well what it must do when filling dataset. Insertions,...

Visual Basic .NET

Is This Possible ... ?

by: Wayne Smith | last post by:

I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...

ASP.NET

Visual Studio 2005 and Access database mystery

by: surfrat_ | last post by:

Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...

.NET Framework

how to upload my database on web server

by: PALLAVI SHARMA | last post by:

I have made a web site using asp.net and c#. I used ms access for database, but i have problem that i don't know how to upload my ms access database on web server. I have domain name and password,...

ASP.NET

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

ASP database MS access problem

Similar topics