Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Leonard Trevor
  Where is Leonard Trevor?
 Edinburgh
 United Kingdom
 Leonard Trevor
 Tags
Subject: RE: pasword in SQL SERVER & ODBC problem
Thread ID: 230619 Message ID: 230620 # Views: 36 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Sunday, June 07, 2009 5:43:25 PM         
   


>
<B>STORE SQLCONNECT('admin', 'sichr', 'ultimate') TO nHandle</B

>
> I have this hanldler in a working program.
>
> 1. Does the USER ID User= 'sichr' come from the USER_ID defined in the configuration of the ODBC
>
> or from the SQL SERVER USER_ID
>
>
>
>
> 2. Does the PASSWORD 'Ultimate' come from the passworf defined in the configuration of the
>
> ODBC or from the SQL SERVER password
>
>
>
>
> Kindly provide me with an example.
>
>
> Thanks

Both com efrom the defined Sql server user id and pwd.

I prefer SQLConnectString() and trusted connections. ie:

lnHandle = SQLConnectString("driver={SQL Native Client};server=.\sqlexpress;trtusted_connection=yes")


Cetin Basoz

.Net has got better.Think about moving - check my blog:
Blog (main)
Blog (mirror)



COMPLETE THREAD
pasword in SQL SERVER & ODBC problem Posted by Leonard Trevor @ 6/7/2009 5:11:03 PM
RE: pasword in SQL SERVER & ODBC problem Posted by Cetin Basoz @ 6/7/2009 5:43:25 PM