Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection String
Message
De
04/05/2006 08:21:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01119086
Message ID:
01119096
Vues:
18
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,
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform