Tezcatlipoca
Registered User.
- Local time
- Today, 06:55
- Joined
- Mar 13, 2003
- Messages
- 246
Firstly, apologies if this is the wrong sub-forum for this, but it's tricky to know where it should go, given that it spans a few technologies.
Right, I've got a situation where work has asked me to write them a small telephone call logging application and database. This is no problem, and more than doable with my Access and VB skills. I knocked up the database, which works beautifully, is secure, supports multi-user logins, and all the other features and functions you'd expect...
...however, they have now decided that they want me to add the facility to take calls from a certain type of client, who needs to be validated to ensure they are allowed to call. These client types are all stored in an SQL database on another company's servers. This company allows us to check this database online by the use of an ASP page which basically allows us to search on surname and then returns client information if found as XML data in a webpage.
So...my issue is now getting my local database system to talk to this remote SQL server so the database users can make these searches from within the database. It is here that my VB talents desert me.
Does anyone have the slightest idea of how I can get this to work? I suppose the absolute ideal way would be to somehow embed the ASP page that is used to search the SQL database into Access/VB, allowing my users to search directly, but I have no idea how to do this, or how to get VB to deal with the returned XML data for a successful match.
Please help!
Right, I've got a situation where work has asked me to write them a small telephone call logging application and database. This is no problem, and more than doable with my Access and VB skills. I knocked up the database, which works beautifully, is secure, supports multi-user logins, and all the other features and functions you'd expect...
...however, they have now decided that they want me to add the facility to take calls from a certain type of client, who needs to be validated to ensure they are allowed to call. These client types are all stored in an SQL database on another company's servers. This company allows us to check this database online by the use of an ASP page which basically allows us to search on surname and then returns client information if found as XML data in a webpage.
So...my issue is now getting my local database system to talk to this remote SQL server so the database users can make these searches from within the database. It is here that my VB talents desert me.
Does anyone have the slightest idea of how I can get this to work? I suppose the absolute ideal way would be to somehow embed the ASP page that is used to search the SQL database into Access/VB, allowing my users to search directly, but I have no idea how to do this, or how to get VB to deal with the returned XML data for a successful match.
Please help!
