General information
Title:
COM server with SQL data
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
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