I'm running PWS and my asp pages run fine.  However, when I upload them to 
our server, I get the following message.  I've read somewhere that it 
could be something to do with my DSN connections.  I'm using a system DSN 
on computer, but when I try to set it up the same way on the server, it 
doesn't work.  Let me know if you need more information.

Database Results Error
The database connection named 'unify' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root

One or more form fields were empty. You should provide default values for 
all form fields that are used in the query.

In order to configure a system DSN on a server, you must have 
Administrative access to the server.  Access to a website on a server will 
not allow you to set up a system DSN.  Your host or server administrator 
will need to set up the DSN for you.

The other option is to use a DSNless connection, here is an example of one:

****** script clip ******

Dim DBCONN
DBCONN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath
("/data/customers.mdb") & ";"
		
Set rs = Server.CreateObject("ADODB.Recordset")
		
rs.Open "Select * From Customers WHERE Email = '" & StrRecord & "'", 
DBCONN, adOpenKeyset, adLockPessimistic, adCmdText

**** end ***

good luck

William

> I'm running PWS and my asp pages run fine.  However, when I upload them 
to 
o> ur server, I get the following message.  I've read somewhere that it 
c> ould be something to do with my DSN connections.  I'm using a system 
DSN 
o> n computer, but when I try to set it up the same way on the server, it 
d> oesn't work.  Let me know if you need more information.

> Database Results Error
T> he database connection named 'unify' is undefined.

> This problem can occur if:
*>  the connection has been removed from the web
*>  the file 'global.asa' is missing or contains errors
*>  the root folder does not have Scripting permissions enabled
*>  the web is not marked as an Application Root

> One or more form fields were empty. You should provide default values 
for 
a> ll form fields that are used in the query.

Yeah, our System Admin let me work directly on the Server with System 
Admin Access...of course he was there watching.  

I'll try to do the DSNless connection as well.

> In order to configure a system DSN on a server, you must have 
A> dministrative access to the server.  Access to a website on a server 
will 
n> ot allow you to set up a system DSN.  Your host or server administrator 
w> ill need to set up the DSN for you.

> The other option is to use a DSNless connection, here is an example of 
one:

> ****** script clip ******

> Dim DBCONN
D> BCONN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath
(> "/data/customers.mdb") & ";"
	> 	
S> et rs = Server.CreateObject("ADODB.Recordset")
	> 	
r> s.Open "Select * From Customers WHERE Email = '" & StrRecord & "'", 
D> BCONN, adOpenKeyset, adLockPessimistic, adCmdText

> **** end ***

> good luck

> William

> > I'm running PWS and my asp pages run fine.  However, when I upload 
them 
t> o 
o> > ur server, I get the following message.  I've read somewhere that it 
c> > ould be something to do with my DSN connections.  I'm using a system 
D> SN 
o> > n computer, but when I try to set it up the same way on the server, 
it 
d> > oesn't work.  Let me know if you need more information.

> > Database Results Error
T> > he database connection named 'unify' is undefined.

> > This problem can occur if:
*> >  the connection has been removed from the web
*> >  the file 'global.asa' is missing or contains errors
*> >  the root folder does not have Scripting permissions enabled
*> >  the web is not marked as an Application Root

> > One or more form fields were empty. You should provide default values 
f> or 
a> > ll form fields that are used in the query.