Error connecting to SQL server 2005 from Dreamweaver 8

[fazthegreat]

Hi I have a database in SQL server 2005.I just started using dreamweaver's server behaviours.When I use the "log in" behaviour I get the following error.

Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/MyBlog/Connections/connBlog.asp, line 9, column 38
MM_connBlog_STRING = Provider=SQLOLEDB;workstation id="FAZ-F6EE655890B";integrated security=SSPI;data source="FAZ-F6EE655890B\SQLEXPRESS";persist security info=False;initial catalog=MyBlog;
-------------------------------------^

First thing that came to my mind was obviously my database conn isnot right but when I define a conn using the built in dreamweaver's dialogue and test it, it says that the test succeeded.Also in the dialogue for the "login page" it shows the values of fields from the database, so it is definitely connecting to the database.So I don't know why am i getting this error.Please someone help!

[Newsgroup_User]

See if this TechNote helps:

ASP error "VBScript compilation error '800a0401' "
http://www.adobe.com/go/15717

Are you using the ASP VBScript server model?

Try creating a simple recordset that displays all records from a table and
see if you can get that to work. It's less complex code than the user
authentication server behavior and might help to isolate the problem.

--
David Alcala
Adobe Product Support