Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COM server with SQL data
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COMCodebook
Title:
COM server with SQL data
Miscellaneous
Thread ID:
00813784
Message ID:
00813784
Views:
48
I have a VFP COM server that receives parameters from a web site and passes back a formatted XML string for display on the site. The COM object is on a box outside our firewall and has limited rights (read and execute, I think) o FoxPro 2x tables on the LAN server. This has worked fine for a couple of years (so long that I've forgotten exactly how I implemented it in the first place <g>.) This month, the data has been moved to SQL 2000. Somehow I'm missing something and haven't been able to establish a connection to the SQL server from the COM process. What user(s) and rights need to be added to the SQL database to accommodate the COM object? What's the optimum way to establish the SQL connection?
Next
Reply
Map
View

Click here to load this message in the networking platform