I got the string to work. The problem is that the framework I am using gets the connection handle, then ran some simple SQL to make sure the connection works. This simple SQL was incorrect so the framework then reported the error that the connection was wrong.
Thanks for your help.
>Ok, my connection string isn't that complicated, try something more simple like:
>
>ODBC Driver:
>
>Standard Security
> "Driver={SQL Native Client};Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;"
>
>Trusted Connection
>Driver={SQL Native Client};Server=Aron1;Database=pubs;Trusted_Connection=yes;"
>
>OleDB Provider
>
>Standard security:
>"Provider=SQLNCLI;Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;"
>
>Trusted connection:
>"Provider=SQLNCLI;Server=Aron1;Database=pubs;Trusted_Connection=yes;"
>
>
>
>I took these samples from
http://www.connectionstrings.com. I alway use the oledb provider to connect to SQL Server Express and it works with the sample provided here.
>
>HTH,
>
>Enmanuel
>
>>Hi Enmanuel,
>>
>>thanks, but that didn't work either.
>>
>>>The driver for Sql Server Express should be SQLNCLI, try changing that.
>>>
>>>>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,