p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: DSN


Message #1 by "dale Borchardt" <dale@d...> on Wed, 19 Jun 2002 16:53:06
I developed this app on my xp workstation runnig IIS. I also had the 
database and the System DSN on my workstation. OK, Im all done; I put the 
asp pages on the server (NT4 service pack 6, MDAC 2.5, I think IIS 4 but 
I forget how to check). I moved the database (Access 97) to the server 
and created a system DSN called MaintReq.
I access the page and get this error:

"
Microsoft VBScript runtime error '800a01b6' 
Object doesn't support this property or method: 'Open' 
/FacilitiesManagement/MaintRequestForm/2frmJobTic.asp, line 37
"

I have other applications runnig and am not sure why this will not work. 
Here is the code. Line 37 is the line that starts with oConn.open

<%'On Error Resume Next
Dim oConn, oRS2, oRS2a, strDateOpen, 
Dim strNextAvalRec

Set oConn = Server.CreateObject("ADODB.Connection")'Open Connection
oConn.Open = "DSN=MaintReq"
Message #2 by "Roy, Siddarth S" <sroy@b...> on Wed, 19 Jun 2002 11:47:50 -0400
try including the adovbs.inc file or check the mdac in ur machine which 
u developed application on

thx
sid

-----Original Message-----
From: dale Borchardt [mailto:dale@d...]
Sent: Wednesday, June 19, 2002 12:53 PM
To: ASP Databases
Subject: [asp_databases] DSN


I developed this app on my xp workstation runnig IIS. I also had the
database and the System DSN on my workstation. OK, Im all done; I put 
the
asp pages on the server (NT4 service pack 6, MDAC 2.5, I think IIS 4 but 

I forget how to check). I moved the database (Access 97) to the server
and created a system DSN called MaintReq.
I access the page and get this error:

"
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'Open'
/FacilitiesManagement/MaintRequestForm/2frmJobTic.asp, line 37
"

I have other applications runnig and am not sure why this will not work. 

Here is the code. Line 37 is the line that starts with oConn.open

<%'On Error Resume Next
Dim oConn, oRS2, oRS2a, strDateOpen,
Dim strNextAvalRec

Set oConn =3D Server.CreateObject("ADODB.Connection")'Open Connection
oConn.Open =3D "DSN=3DMaintReq"

  Return to Index