This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1FC36.9B9D10C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi,



Has anyone ever used a UDL file to make a connection to a database? If 
so,
can someone help me with this error?



Provider error '800a01b0'

File name or class name not found during Automation operation

/fcs-sfc/Register/leadership/module1.asp, line 11



I have the dbconn.udl in the folder
Inetpub/wwwroot/fcs-sfc/Register/leadership/ and the database back at 
the
root in a folder called databases/fcs-sfc/leadership/Leader.mdb.

With the UDL file you choose your database, then in your code on your 
asp
page you add these lines of code, but it is not working I am getting 
the
above error.  Would anyone know why?



ConnectionToDatabase=3Dserver.CreateObject("ADODB.Connection")

ConnectionToDatabase.Open "file
name=3DD:\Inetpub\wwwroot\FCS-SFC\Register\Leadership\dbconn.udl"



Darrell Locke

Intranet Web Site Administrator & Coordinator/Administrateur et 
coordinateur
du r=E9seau Intranet
Information Technology Services/Services en technologie de 
l'information
Family and Community Services/Services familiaux et communautaires
Tel:  (xxx) xxx-xxxx/T=E9l.:  (xxx) xxx-xxxx
Fax:  (xxx) xxx-xxxx/T=E9l=E9c.:  (xxx) xxx-xxxx

E-mail/Courriel:  <mailto:darrell.locke@g...> darrell.locke@g...

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1FC04.691A8920
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,



Has anyone ever used a UDL file to make a connection to a database? If 
so,
can someone help me with this error?



Provider error '800a01b0'

File name or class name not found during Automation operation

/fcs-sfc/Register/leadership/module1.asp, line 11



I have the dbconn.udl in the folder
Inetpub/wwwroot/fcs-sfc/Register/leadership/ and the database back at 
the
root in a folder called databases/fcs-sfc/leadership/Leader.mdb.

With the UDL file you choose your database, then in your code on your 
asp
page you add these lines of code, but it is not working I am getting 
the
above error.  Would anyone know why?



ConnectionToDatabase=3Dserver.CreateObject("ADODB.Connection")

ConnectionToDatabase.Open "file
name=3DD:\Inetpub\wwwroot\FCS-SFC\Register\Leadership\dbconn.udl"



Darrell Locke

Intranet Web Site Administrator & Coordinator/Administrateur et 
coordinateur
du r=E9seau Intranet
Information Technology Services/Services en technologie de 
l'information
Family and Community Services/Services familiaux et communautaires
Tel:  (xxx) xxx-xxxx/T=E9l.:  (xxx) xxx-xxxx
Fax:  (xxx) xxx-xxxx/T=E9l=E9c.:  (xxx) xxx-xxxx

E-mail/Courriel:  <mailto:darrell.locke@g...> darrell.locke@g...