Solved

ODBC + virtual server + isapi = confusion

Posted on 1998-08-28
7
216 Views
Last Modified: 2013-11-18
basically, i have the need to write an isapi extension which manipulates a database.. obviously, dao can't be used because it's not thread-safe.. so i'm left with two options: a flat file database or odbc.. problem is, my website is on a virtual server so i don't have means to set up a datasource on the nt box.. given this, what are my database options?

i suppose a flat file would work, but would probably be a complete waste of time..
0
Comment
Question by:rabbitears
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:danyell
ID: 1171512
You could use direct DLL calls to dbLibrary (for MS SQL Server) or OCI (a.k.a. Oracle Client Interface), both of which exist in thread-safe versions (but only the more recent releases).

Consider also that in the case of an ISAPI extension, if your web server and DB server run on the same machine, the overhead of ODBC is not so bad. It's when you have an ODBC driver talking to a data source over the network that the performance really tanks. Unless you have some other objection to ODBC....

Does this help?

0
 
LVL 2

Expert Comment

by:danyell
ID: 1171513
Oops -- little follow-up to clarify: I don't understand how being on a virtual server prevents you from setting up an ODBC data source -- I do that all the time....

0
 

Author Comment

by:rabbitears
ID: 1171514
ok, i guess i should clarify.. i'm at home running a dial-up connection in sc. my server, however, is somewhere in md.. the database will remain on the server.. i think you thought i was housing it on my machine.. the only real interaction i have with the computer is an ftp log-on and password..
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 2

Expert Comment

by:danyell
ID: 1171515
Where you are doesn't matter. What matters is the relationship between the Web SERVER and the database server (or database file, if, e.g., you're using MS-Access). As long as the Web Server (e.g. IIS or Apache) is on the SAME computer as the database server or file, then ODBC will give you good to excellent performance. Your ISAPI filter will, of course, also run on that same computer.

You can't create an ODBC data source because you're using a web hosting service, and/or don't have physical access to the server (although I hear the drive from sc to md is lovely this time of year, hurricanes notwithstanding... ;-).

Can't you just ask the server operators to create and ODBC data source for you? Most web-hosting facilities will do this. If they can't or won't do this, how did you expect to ever install your ISAPI filter? You'll neet help from a SysAdmin with local access to the server to install that piece as well.
 
0
 

Author Comment

by:rabbitears
ID: 1171516
actually, i'm making that drive in a week or so to see a friend that lives there.. :) anyway, i'm sure they'll create the source for me.. i can also run my extension from the cgi-bin directory.. (don't ask me why i have a cgi-bin directory on an nt box.. they set it up) though i've heard you can set up iis4 to actually run cgi's, but that's irrelevant.. cgi-bin is an execute only directory so it does work..

if you'll post anoher answer, i'll give you the points..
0
 
LVL 2

Accepted Solution

by:
danyell earned 50 total points
ID: 1171517
Thanks for the points, and while we're on the subject....

I think it makes LOTS of sense to have a cgi-bin on an NT server. I've done lots of work on sites that combine, for example, ASP and "regular" CGI scripts in Perl. I'm also really big on PerlScript, an ISAPI filter that works with the ASP 2.0 engine (in IIS 4) to let you write ASP files in Perl instead of VBSCript! All the real Perl features are there including the great parsing and facility dealing with local text files (something that requires backflips in VBScript).

Plus, in the present case having a cgi-bin worked out well for you since you can run your thing as an executable instead of an ISAPI filter.

Lastly, if you don't want to wait until you make that drive to get your ODBC data source, consider giving them a call or an e-mail... Web hosting facilities are used to getting requests like that... If you do it before you drive up there, you'll have a chance to see if there's a problem and correct it when you go there (instead of unpleasant surprises when you return home).

Again, good luck and don't hesitate to ask more questions or post additional comments here (I'm remaining "subscribed" to this question).

0
 

Author Comment

by:rabbitears
ID: 1171518
thanks again for the help.. the thought of mixing isapi with odbc frightens me a little bit so i'll probably be calling again :)  

good day
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

860 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