Hi. I'm trying to integrate my website running ASP with inventory records in our RMS system, but in irder to be able to do that, I need to send SQL query statements from my webserver to the server nruning RMS over the Internet. Of course, due to the sensitive nature of the information, these need to be secure transactions. Is there a secure way for me to connect to the RMS database using sn ADO connect string? I'm a little hung up on the correct values for Data Source, Initial Catalog, and Network Library. Our retail stores connect to the RMS server using an : structure, so I'm assuming this will need to be part of the Data Source string. I'm pretty sure that Initial Catalog should be the database name. I'm puzzled about the Network Library setting though. Isn't that dependent on the dll's available on both machines?
Any help with this would be greatly appreciated. Is there any way to gain access to developer information like this without becoming a certified partner? Frankly, I don't understand how Microsoft expects anyone to pass a certification exam when the informatino they need to learn in order to get certified is not provided to them until after they are certified, a definite Catch-22.