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,