Unspecified Error in ADODB.CONNECTION in IIS 6.0

The following code works fine when using VBScript. However it fails in
ASP page


dim con, dsn
dsn = "provider=SQLOLEDB;data source=MyXP,
1433;uid=user;pwd=pass;database=dbMy"
Set con = CreateObject("ADODB.Connection")
con.Open(dsn)

The code bombs at con.Open

I have IIS 6.0 installed on Windows XP. That code is well tested code
and used to fine well on my machine. However some configuration
change has triggered this error.

I get following error from the code:

Provider Unspecified Error


Any help in this regard will be highly beneficial.

Thanks
Sumit

Re: Unspecified Error in ADODB.CONNECTION in IIS 6.0

"Sumit Chawla" wrote in message
news:1185532408.167512.210440@z24g2000prh.googlegroups.com.. .
> The following code works fine when using VBScript. However it fails in
> ASP page
>
>
> dim con, dsn
> dsn = "provider=SQLOLEDB;data source=MyXP,
> 1433;uid=user;pwd=pass;database=dbMy"
> Set con = CreateObject("ADODB.Connection")
> con.Open(dsn)


Try this.
You have a connection string that looks like a mix of ODBC and an Oledb
connection string.

'now it is ole db
dsn = "provider=SQLOLEDB;data source=MyXP,1433;user
id=user;password=pass;data source=dbMy"

> Set con = CreateObject("ADODB.Connection")
> con.Open(dsn)

> The code bombs at con.Open
>
> I have IIS 6.0 installed on Windows XP. That code is well tested code
> and used to fine well on my machine. However some configuration
> change has triggered this error.
>
> I get following error from the code:
>
> Provider Unspecified Error
>
>
> Any help in this regard will be highly beneficial.
>
> Thanks
> Sumit
>