ASP connection string to SQL2005   

I am trying to connect to SQL2005 server, and the script is written in ASP.

I am trying to figure out why I am getting this error as below;

   Microsoft VBScript runtime error '800a0005' 
   Invalid procedure call or argument: 'Mid' 

I currently have following connection string;
   "Provider=SQLDB; User ID=fm_user; Password=fm_user; data       
   source=SQLFM,8701;persist security info=True;initial catalog=FM;"

I would greatly appreciate for any feedback.

Thanks.

date: Thu, 26 Jun 2008 17:21:02 -0700   author:   Justin Doh

RE: ASP connection string to SQL2005   

nevermind. problem resolved.

"Justin Doh" wrote:

> I am trying to connect to SQL2005 server, and the script is written in ASP.
> 
> I am trying to figure out why I am getting this error as below;
> 
>    Microsoft VBScript runtime error '800a0005' 
>    Invalid procedure call or argument: 'Mid' 
> 
> I currently have following connection string;
>    "Provider=SQLDB; User ID=fm_user; Password=fm_user; data       
>    source=SQLFM,8701;persist security info=True;initial catalog=FM;"
> 
> I would greatly appreciate for any feedback.
> 
> Thanks.
>

date: Fri, 27 Jun 2008 15:16:01 -0700   author:   Justin Doh