Which language should I use?

I want to build a web based database so that I can search for answers from different locations. I am using IIS on an NT machine. Which language would be best for writing the search engine. What are my options? Am I limited to dll's and ODBC only. Is there something like CGI or Perl for NT? Maybe java would be best? I don't have a lot of experience with IIS, although I have done a decent amount with a unix based web server and cgi and perl.

If anyone has any suggestions I would appreciate any input you have.

Thanks,
LVL 1
johnsmAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

juliombCommented:
Well, you can use the ASP, it's a extension por IIS of Microsoft, it's programme in VisualBasic Script, and you can add Perl and Java & Javascript.

With VisualBasic, you can access to databases in ODBC, with SQL sentences via ADO.
0
johnsmAuthor Commented:
To misquote someone a little more famous than me

"It's all french to me"

In other words I don't exactly understand what you are talking about. Im coming from the unix side with very little knowledge of Visual Basic. What is ADO? How do you use ASP?

0
percynCommented:
ASP = Active server Scripting (similar to a shell script), that can be written in a variety of scripting languages, including PERL.

ADO = Active Data Objects, just an object that gives you an interface to an ODBC datasource.

If this is still "French" to you, then just write a CGI in PERL. Only a few lines will change there.
0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

johnsmAuthor Commented:
I only rejected your answer because i don't want to close this thread yet, and i don't have an email account right now. I'll give you the points when it is over, but I have a couple of questions.

How do I get ASP running on my iis server. I did some looking around and supposedly asp is part of iis and should be running automatically. I took some sample scripts and tried them on my server and nothing worked. It looks like asp is not running on my server. How do i start it, if i can at all?

JSM
0
percynCommented:
Ok,
   Install IIS 3.0 and see if it has created an ASPSamp dir under inetpub. If it has, chances are you have ASP installed. IIS 3.0's setup was really an upgrade of IIS 2.0, so you may not always get the ASP installed. In that case, you can download a seperate setup called ASP.exe and install it.
   Better yet, install NT Option pack 4 and you will get IIS 4.0, which DEFINATELY has support for ASP and a few other cool things.

   Boy all that stuff for 25 points...it better be an A ;-)
0
johnsmAuthor Commented:
Thanks, for your help, but something is still wrong. I got asp.exe and installed it, rebooted, everything seems to be alright, but whenever I try to open a sample file that came with the asp installation, explorer says it is trying to open a file of unknown type, do I want to save it to disk? It's like it doesn't know anything about asp.

How do I know if asp is installed and running properly?

0
percynCommented:
Are you accessing it via the webserver or trying to open the file via explorer (what is the URL)  ? Try http://localhost/aspsamp

If you still can't run them, check your NTFS and IIS permissions.
0
johnsmAuthor Commented:
Nothing seems to work.

Can iis be run on ntworkstation, or does it have to be ntserver?
I would rather switch everything over to another machine that is running workstation.

Thanks
0
percynCommented:
On a NT workstation, it will install Peer Webserver (a lite version of IIS), but ASPs will work.

Are you getting any error or are you getting the Save As dialog box ? Try running something in the http://localhost/scripts dir.
0
johnsmAuthor Commented:
I don't get any errors but I do get the 'Save As' dialog box.
It's now on the nt workstation and it still doesn't work.

Do I have to do anything to the registry to make asp work in peer web services?

I can't open anything in the scripts dir.

JSM



0
johnsmAuthor Commented:
Alright! Now it works.

I got asp.exe from some site i got from a search, installed it, it looked like everything went alright. That is what hasn't been working all this time. I reinstalled asp from the service pack 3.0 cd and all of a sudden it started working right. Imagine that!

Thanks a lot for you help Percy.
Enter anything as an answer and i'll give you the points.



0
johnsmAuthor Commented:
AAAGGGHHHH! I spoke too soon.

I can now open .asp pages witout getting asked to save them but the scripts aren't running.

I tried to open the following page saved as test.asp:

<HTML>
<BODY>
<% For i = 3 To 7 %>
<FONT SIZE=<% = i %>>
Hello World!<BR>
<% Next %>
</BODY>
</HTML>

All I get is Hello World! printed out ONCE!
This example is from Microsoft's site.

Now what?

0
slokCommented:
ASP need not be the best solution in terms of development etc.
Take a look at Cold Fusion http://www.allaire.com

and here's a link to compare between Cold Fusion and ASP
http://www.houseoffusion.com/asp.htm
0
johnsmAuthor Commented:
Yea, but i need to buy cold fusion.
0
percynCommented:
Make sure you are accessing the ASP as http://myserver/scripts/myasp.asp and not c:\inetpub\scripts\myasp.asp
0
johnsmAuthor Commented:
Why is that?
0
percynCommented:
Because ASPs are parsed by the SERVER and when you use the FILE:// protocol, you are bypassing the server !!!!

If you don't use the server, ASPs won't work.

Look, we have answered everything you asked for and more...this 100 point question is getting extremely streched out ;-)
0
johnsmAuthor Commented:
Well, if this 100 point question is not worth your time then don't bother with it anymore.

If you are just here to collect points as quickly as you can then I'm sure you can do better elsewhere.

This question would not have gotten so stretched out if the advice had been more complete at the beginning.

I appreciate the help, but it still doesn't work.

Thanks, anyway.

0
snapperheadCommented:
Wow, that percyn dude seems pretty rude.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsmAuthor Commented:
I agree.
0
percynCommented:
Just trying to help...
It is in the benifit of other as well if different questions are asked seperately, so that they may get answers to specific questions, instead of reading about 3 different problems.

I'm not looking for points, I have over 25,000 points and nothing to do with them ;-(
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.