Sorry, that didn't work either.

Just to make sure it's not my code causing the problem, do you have a simple sample that I could run from the command window?


>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,