Database Connection Problems

[RussOSU]

I am trying to create a web application where my asp page has a form used to connect to the database to enter the data. I have created the database and have it on the server. I have tried creating an asp page with the connection and I have also exported the table in Access to an asp page inorder to double check my connection string. I get very similar connection strings both resulting in the same error.
------------------------------------------------------------

Error Type:
(0x800401F9)
Error in the DLL
/dds/russ/maiform3_1.asp, line 16

------------------------------------------------------------
I get another error if I have the page and database on a different server
------------------------------------------------------------
Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/dds/DDS_Organized/MAIform3_1.asp, line 16
------------------------------------------------------------
I think both errors are cause by the same problem. However I am not sure how to fix this.

I tried the fix that was posted earlier however it did not work.

Thanks
Russ

 

[vasah20]

what does line 16 of your code say?

 

[RussOSU]

I knew I forgot to put some information in there.
------------------------------------------------------------
Conn.Open "DSN=FolderRequests","userid","pswd"
------------------------------------------------------------
If I load the html and asp files along with the database into my IIS default dir everything works fine. However when I load these files onto the webserver (intranet) I get those errors above.

 

[vasah20]

did you create the DSN on your webserver?

does the database have a username "userid" with password "pswd", or should it look more like:

'notice the missing quotes
Conn.Open "DSN=FolderRequests",userid,pswd

i think the problem might be the DSN, though...

hth
leo