Hi,

I am using a link file (udl) to connect to a SQLBase database from my ASP

pages. When I test the connection from the properties page of the link file

I am able to ping database, however when It is executed from within the asp

It gives me no error message, just beeps and stops further processing.

This use to work and all of a sudden can't establish a connection no more

with the connection object..



Here is the sample of the connection string generated by the udl file:

Provider=MSDASQL.1;Password=sysadm;Persist Security Info=True;User

ID=sysadm;Data Source=WEB;Mode=ReadWrite



Here is how I call it from an asp page:

strDatabase = "File Name=c:\inetpub\wwwroot\connection_link.udl"

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open strDatabase        'Execution stops here and the only way for

me to get back to normal is to unload application in IIS.