database connection through ASP

[rhitom dutta]

I am creating a table in Microsoft Access.

Table Name: dp_reg

Field Data type
cno (primary key) number
offic number
des text
da Text
ia Text
po Text
allg Text
lno Text
ldt Date
midt Date
remk text

Details of Database
Database name: C:\Documents and Settings\Administrator\My Documents\ disc.mdb
DSN name=rhit.dsn

In ASP, the following two approach is used for connection.
Approach :1

       dim conn
       set conn=server.createobject("adodb.connection")
       conn.ConnectionString = "DSN=rhit.dsn" 
       conn.Open
 

Then following error is displayed.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.


Approach :2

    dim conn
    set conn=server.createobject("adodb.connection")
    conn.ConnectionString ="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=C:\Documents and Settings\Administrator\My Documents\ disc.mdb" 
    conn.Open

Then following error is displayed.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xbe8 Thread 0x460 DBC 0x1957a7c Jet'.