Try:
[DRIVER=SQL Native Client;SERVER=SAMAAN3\SQLEXPRESS;DATABASE=mist2006;WSID=SAMAAN3;APP=Your APP Name Here;Trusted_Connection=Yes;]
>Hi,
>I'm having trouble getting a connection to a SQL Server database. The connection string I am trying is:
>
>DRIVER=SQL Native Client;SERVER=SAMAAN3\SQLEXPRESS;UID=frank;DATABASE=mist2006;WSID=SAMAAN3;APP=Microsoft Data Access Components;Trusted_Connection=Yes;
>
>This gives me an "Unable to connect to the server using the specified connection" error.
>
>I created a File DSN and tested it using the Data Sources (ODBC) applet and that gave me this :
>
>[ODBC]
>DRIVER=SQL Native Client
>UID=frank
>DATABASE=mist2006
>WSID=SAMAAN3
>APP=Microsoft Data Access Components
>Trusted_Connection=Yes
>SERVER=SAMAAN3\SQLEXPRESS
>Description=MIST 2006
>
>Does anyone have any idea what I have done wrong?
>
>Thanks,
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.