Unspecified error

[MC]

Anyone got any suggestions for this? Have had a google but without success!

Error Type:
(0x80004005)
Unspecified error
/librarysql/main.asp, line 17


Code:
Dim conn, rs, username, password, sql
Set conn = Server.CreateOb ject("ADODB.Con nection")
Set rs = Server.CreateOb ject("ADODB.Rec ordset")
'line 17 below!
conn.open "Provider=SQLOL EDB; Data Source = (localhost); Initial Catalog =
LibrarySQL; User Id = sa; Password=XXXX"

[Aaron Bertrand [MVP]]

Re: Unspecified error

Make sure you have the latest MDAC, and go through here for possible
solutions:

http://www.aspfaq.com/2009

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"MC" <maxcoppin@-don't-send-me-any-spam-btinternet.com> wrote in message
news:F6Coc.2$98 7.0@newsfe1-win...[color=blue]
> Anyone got any suggestions for this? Have had a google but without
> success!
>
> Error Type:
> (0x80004005)
> Unspecified error
> /librarysql/main.asp, line 17
>
>
> Code:
> Dim conn, rs, username, password, sql
> Set conn = Server.CreateOb ject("ADODB.Con nection")
> Set rs = Server.CreateOb ject("ADODB.Rec ordset")
> 'line 17 below!
> conn.open "Provider=SQLOL EDB; Data Source = (localhost); Initial Catalog =
> LibrarySQL; User Id = sa; Password=XXXX"
>
>
>[/color]