Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Data-Bound Controls Server Installation Requirements

Posted on 2002-03-17
5
Medium Priority
?
140 Views
Last Modified: 2013-12-23
Hi!

To use Visual Interdev data-bound controls, what are the server-side installation requirements?

Does Visual Interdev need to be installed on either the web server or the database server? Or do certain libraries only need to be installed, like the Script_Library?, and if so, on the web server or the database server?

Any answers greatly appreciated....
0
Comment
Question by:kabg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 19

Accepted Solution

by:
DreamMaster earned 200 total points
ID: 6876266
Whatever you do...do not install anything but the database on the database server, that's the whole idea of N-tier applications...to keep them seperated.

So what you'd need on the webserver is the dll's needed to connect to the database. The script_library of Visual Interdev is likely to contain the needed DLL's for database connectivity..

Hope this helps,
Max.
0
 

Expert Comment

by:merlinb
ID: 7437675
The web server and your pc will need the OLEDB/ADO/ODBC data access dll's loaded (and probably already are).  These facilities are installed via a single executable called MDAC.  There are various versions, that seem to co-exist quite hapily.  You will need to install ver 1.5 at least, though 1.6 is better.

Once installed, the web server and your pc can connect to a whole host of databases.  You can connect to these data sources using Visual Basic, C++ or via ASP in JavaScript or VBScript.  You may need to install various database-specific client libraries - so Oracle would provide DLLs for a client pc to communicate with the server, and the ODBC/OLEDB drivers would use these.

The DTC's in VI are handy, because they generate all of the required connection and recordset handling code for you, but you can copy-paste this code if you are unsure of DTC's.  You will NOT need any additional software on the server unless...

VI, and the DTC's support an optional thing called the DataEnvironment.  It is a way of centrally storing all SQL commands for use in your app.  It can be very useful and powerful - but it can be tricky to configure and update on the live server.  You WILL need to install the DataEnvironment dll's on the server - which is done by installing the VI Server Components (on disk 2 of the VI disk set). This is needed both on your PC and the Server ONLY if you want to use the DataEnvironment - but I recommend it!

The location of the database (on the web server or on a dedicated server) is irrelevent.  You would use a dedicated database server only if the performance or security needs demanded it.

The _ScriptLibrary in Visual Interdev contains Server-Side (.ASP) runtime files and Client-Side (.HTM) files.  These are chosen depending on the page options - DTC Scripting Platform - that you choose.  Have a look at these files - particalurly RECORDSET.ASP, to understand how the thing works.

At DESIGN TIME only, a whole host of ActiveX Controls are used to render the controls in the VI editor, and to provide the Property Setting dialogs for the various DTC's.  These are NOT USED at runtime at all.  They simply write the required JavaScript that later calls the routines contained in the _ScriptLibrary at runtime.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

671 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question