Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COM server with SQL data
Message
General information
Forum:
Visual FoxPro
Category:
COMCodebook
Miscellaneous
Thread ID:
00813784
Message ID:
00817170
Views:
23
Thanks for your response; I've been traveling and just received your message. This same web user has been accessing the network for over a year while the COM process worked against FoxPro 2.x tables. It doesn't seem like a network rights issue. The problem seems to be creating a proper connect string for SQL. The string used used by the application (DSN and database plus trusted_connection=YES) doesn't work with the COM process.

>>There are no special steps you need take to connect to SQL Server via COM component. Does that Network User, logged onto the computer running COM, have access to the network? If yes, you can use connect to SQL Server using NT/Windows Authentication with read-only rights to the SQL database. If Network access cannot be granted, you can use SQL Authentication to connect but your network admin has to open up TCP/IP port (generally 1433) and change some firewall settings for the SQL requests to come through.<<
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform