Glad you agree. I don't think though your test on which one (JDBC or ODBC) was faster was fair however. Where you testing the speed of the database APIs or the forums? Classic ASPs are interpreted and JSPs are turned to servlets and are compiled, so they (JSPs) would most of the time run faster than interpreted ASP pages.

First, thank you for your post inscissor, and please accept my apologies for such a belated reply.

Second, let me state my knowledge on this subject: zilch, nada, nothing and pretty much zero - but I am quite interested.

Thrid, why would it matter in justifying which technology used to accomplish the task? In this day and age it seems that speed reigns supreme above all else, so why use ASP over JSP?

Well for a lot of reasons. This question reminds me of myself and my old high school mentality. I would ask myself, "If C++ has one of the fastest execution times, why would any company use anything else? Anything else (like VB, COBOL, Delphi) would be slower." This was bad thinking. But it was ok though. I didn't know much about real world programming or the business world.

If I'm your boss and I tell you to make an application that generates invoices, and be meticulous on the GUI portion, what would you use? Oh yeah, and I told you that I need it tomorrow morning. Would you use Assembly? Visual C++? Visual Basic? I think we know the answer to that. Rapid software development matters. Execution time is not always an issue. It does matter, and it should, but creating the whole application in Visual C++ would not be worth it for just gaining some performance time. Well, not for this specific application. You could if you wanted create libraries in C++ that would handle any load processing from Visual Basic. But you get the idea.

Also, what if you were under a Unix/Linux OS? Could you use VB? Nope. You'd be limited to the tools available under Unix/Linux (which are a lot by the way).

The same issue applies to web languages. Rapid software development could be an issue. In this case we could use ColdFusion. But ColdFusion costs money... so then the current budget would be an issue. We would need to go with something that was free or low cost. We could go with something like PHP, Perl or J2EE. But what if my staff is used to using Visual Basic and Office products? Do you think learning ASP/ASP.NET (which emphasizes strongly on VBScript) would be easier compared to ColdFusion, PHP, Perl, or even Java? This is a tough question. Just because it runs the fastest doesn't always mean it's the best.

Still there are debates on which runs the fastest (mod_perl, PHP with an accelator like Zend's, compiled Java/ASP.NET, or ColdFusion (which now compiles to Java byte code). Wherever you go, they claim that they're the fastest. If you go to a PHP web site, they claim it's the fastest, if you go to a Perl web site, they claim it's the fastest, and so on.

So before you go and select a server side language or application server, you should consider the following:

1. Company Budget (always be concerned about how much you'll save and how much you'll make). Be aware of open source solutions and how much money it will save your company.
2. What technologies you have already. What OS? What database server? How many computers and what types?
3. How easy will it be to pickup the language? If your staff already knows Visual Basic, why not ASP/ASP.NET? Why Java? If Java, what are the benefits?
4. When does the web site go live? How long will it take to develop? Does everything have to be built from scratch?
5. Does the technology you're choosing come with all the tools you need to create your application? For example, if you want to upload in ASP, you'd have to buy or find a free a component to add this functionality. Coldfusion comes with this. Java and ASP.NET already come bundled with a lot of functionality.
6. How easy will it be to extend/maintain/debug the application? To update? Will the syntax and facilities within the technology make it easier? How well will it integrate with the current technologies you have?
7. How does the application server (what runs ColdFusion, ASP, PHP, etc.) handle under load? Is it scalable?
8. How easy is it to get support? Is there a strong community?
9. If you go with technology you pay for, you have someone to point the finger at if something goes wrong. With open source software you have little liability. You don't have one single company you can sue that owns it. If you pay for a service, you're paying for a reason; to get a guarantee that it will work (even though this is not always the case).
10. Does the technology have a future? You don't want to spend money buying a technology and find out it will be discontinued soon.
11. How does the technology handle security? Internationalization? How does it handle external services (HTTPS, web services, LDAP) and other protocols?

Those are a few issues to consider. As you can see, you always start any answer to a question with "it depends." Even if someone asks you "what's 1 + 1?" You say "it depends, is it in binary?"

Hope this helped!

I likewise am having some difficulty writing to a database. However, I am using a Microsoft tutorial that came from their website. Here is the link.
http://msdn.microsoft.com/library/de...sptutorial.asp

I have followed its steps, and when I try to view it and test it on my localhost (which is running PWS and IIS 5.0), I get this error on my page "Microsoft VBScript compilation error '800a0409'

Unterminated string constant

/tutorial/guestbook.asp, line 21

strProvider = "Driver={Microsoft Access Driver (*.mdb)};


My root folder is c:/Inetpub/Wwroot/tutorial as they have suggested. However I noticed that my DSN was located in my

C:\Program Files\Common Files\ODBC\Data Sources

could that be the problem?

thanks,

Well, first of all, that error has nothing to do with the location of the database. You're getting that error because you're not closing the string with a quote. Just put a quote a the end that string, like this:

Then you will probably have another error now. That string defines the connection and you have not provided the location of the database, just what driver to use, in this case, a Microsoft Access Driver. Look carefully at the sixth post of this thread where I show an example of how to access a database. Look at the second example.

If you have any other questions, ask away!

Agreed! My Bad! Thanks for the correction!

Glad you agree. Whoa, almost a year already since I said that.

hello everyone,
i just want to ask any idea about my problem..i have an access file that i want to it be used as my datafile and i'm using vb.net to access this file..as of now i works fine if i path the file to the machine where my vb.net installed..and i want to make a program that will be used by many users thru vb.net and access as my back end... as of nowI have a sever(windows server 2003) which have a domain..all the user are logging in with thier password and username to have shared some files..my question is....

1. how to set up my access file if i put it in my server?

i want that every time i make a code in vb.net, i path will go directly to my server where my access file reside.

hope u get my problem..

thank you

hai,
i want to kno about the vb 6.0. so that i started to work with the project, not a high level, i m in beginner level, i connected with access and ADD is functioning i want to know how to delete the record that is full record and checking the condition. its the ADD coding
ADD coding to add the datas in access
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Gopi\employee\db1.mdb"
cn.ConnectionString = Connstr
cn.Open()
Dim qry As String
qry = "insert into emp1 (emp_id,emp_name,emp_phne,emp_add,emp_mail_id) values(" & TextBox1.Text & ",'" & TextBox2.Text & "'," & TextBox3.Text & ",'" & TextBox4.Text & "','" & TextBox5.Text & "')"
Dim Olecmd As OleDbCommand
Dim Olduprdr As OleDbDataReader
Olecmd = New OleDbCommand(qry, cn)
Olduprdr = Olecmd.ExecuteReader
cn.Close()
End Sub

helllo,
I do have a problem with access...

this is my code:
<%

var connection= new ActiveXObject("ADODB.Connection");
connection.Provider="Microsoft.Jet.OLEDB.4.0";
connection.ConnectionString = "Data Source=" +Server.MapPath("/database/Training11.mdb");
connection.Open;

var SQL = "INSERT INTO User (FirstName, MiddleName, LastName) VALUES ('lolo', 'keymo', 'rub')";

connection.Execute(SQL);
connection.Close();

%>

And i do get this error message:

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/testy.asp, line 16

so how could i solve this problem??
do i have some problem in the insert query??
help!!