Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What port does VFP use for SQL Connection
Message
From
11/06/2019 17:01:46
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01669000
Message ID:
01669013
Views:
56
>>Ok then, let me ask this - what's the difference between VS (c#) and VFP in making the connection to an SQL backend? I'm trying to use the same userid/password that our website uses to connect to the same server, different DB.
>>I can, however, connect to the server with this userid/password and run querys against the DB I'm trying to connect to; but when I try to use these credentials via VFP I get 'Login denied'
>
>I don't know how do you connect What do you use in C# and what in VFP?
>SqlConnection() in C# and SQLSTRINGCONNECT() in VFP?
>Caould you please post the connection strin from C# (remove all sensitive data in it)

c#
connectionString ="data source=204.67.nn.nnn; initial catalog=DataWarehouseDB; user id=#########;password=#########;Trusted_Connection=False;"
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform