Results 1 to 2 of 2
2003-06-24, 00:21 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
Access/SQL/IIS (Access XP/SQL2K/IIS)
I have one employee that knows web front end and building a knowledge base system for our area. Right now, they have built the database in Access and most of the front end is in ASP. I have another employee that knows the back end being SQL 2000. The Access database will be migrated to SQL 2000.
We are having a problem getting the 2 pieces to talk (SQL and IIS). They are both on their own server. What handshaking has to go on between the web application and SQL?
Appreciate any input or where to look for this.
2003-06-25, 14:01 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 58 Times in 58 Posts
Re: Access/SQL/IIS (Access XP/SQL2K/IIS)
Your question is really related to ASP and the use of data sources with it. In short, you have a couple of options for connecting to a SQL Server database. One involves using ODBC and working with the SQL tables through an ODBC connection. The other option is to use OLE-DB and ADO, and for new development would be the recommended path. One issue is what version of ASP you are attempting to use. If you are using ASP 3.X, you have a different set of tools than if you are trying to use ASP.net. In either case, you will probably want to pick up a book appropriate to the technology you are trying to use. I like the WROX books on ASP, but they may be a bit hard to find at the moment.Wendell