Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection String
Message
De
04/05/2006 09:21:11
 
 
À
04/05/2006 09:16:31
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:
01119123
Vues:
17
Strange, It works for me here:
lnSqlH = SQLSTRINGCONNECT([Driver={SQL Native Client};Server=SAMAAN3\SQLEXPRESS;Database=mist2006;Trusted_Connection=yes;])
IF lnSqlH < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ELSE
   MessageBox([Success])
ENDIF
>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,
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform