Try:
[Driver={SQL Native Client};Server=SAMAAN3\SQLEXPRESS;Database=mist2006;Trusted_Connection=yes;]



>Hi Borislav,
>
>unfortunately that hasn't worked either. :(
>
>>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,