General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only