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 20:57:27
 
 
To
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:
01669016
Views:
61
>>>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;"

And what is your VFP ODBC connection string?

Hank
Previous
Reply
Map
View

Click here to load this message in the networking platform