navcan
Posts: 61
|
| Posted: 06/16/2006, 6:39 AM |
|
Hello all,
Using ASP 3.0, CCS 3.0.4.6, SQL 2000 and IIS 6.0
For database Server Connection settings, I am trying to use the Connection String pointing to a UDL file like this:
File Name=" & Server.MapPath(".") & "\DataConn.udl
I get the following error message
Unable to establish connection to database.
Error information:
Microsoft VBScript runtime error (0x1B0)
File name or class name not found during Automation operation
However when I use the complete path of UDL file like below it works:
File Name=C:\inetpub\wwwroot\guestbookapp\DataConn.udl
Any suggestion, idea to use "Server.MapPath" method instead of using the physical path to the UDL file???
Thank you for your valuable info.
|
 |
 |
navcan
Posts: 61
|
| Posted: 06/18/2006, 6:58 PM |
|
Hello folks,
Any suggestions to use Server.MapPath instead of physical path please...
|
|
|
|
Edd
Posts: 547
|
| Posted: 06/18/2006, 7:38 PM |
|
Try
File Name=" & Server.MapPath("/") & "guestbookapp\DataConn.udl
where Server.MapPath("/") is your root directory.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
navcan
Posts: 61
|
| Posted: 06/19/2006, 12:52 PM |
|
Hey Edd,
It worked using the following:
File Name=" & Server.MapPath("/guestbookapp") & "\DataConn.udl
Fantastic! Appreciate your solution. Thanks Edd.
|
|
|
|
|
