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,
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain