ActiveX

hi,

I am doubtful in getting an answer from this forum as I see a lot of threads unanswered. I would rather post it in VB general. Still...

Well.. I want to develop a muti-tier system using ASP,Oracle,A dll at server and a user interface for client. The problem is with the selection user interface. If choose VBDocument or Activex Control the browser must be IE (isn't it?). But I want netscape compatibility too. I do not know how to program in Java. Can some one suggest the best practice I can follow? Since this is going to be a major app i do not think just HTML forms would be sufficient.

Any suggestions will be highly appreciated.

Thanks in advance

Go for ASP, COM and database stored procedures.
Should be alright as far as I think.

-abhijit :) ;) :rolleyes:

Hi,

My confusion is all about the user interface. About the rest I have made up my mind (ASP,COM,ORACLE)

Then use cross-browser compatible HTML for the UI.

And keep any ActiveX on the server side and you will stay cross-platform..

Thanks all for your suggestions.

Actually, I was planning to devide my front end into two parts.

1. HTML Forms (for Outside organization users.)
2. VB forms (For in-house users).

However the backend data and DLLs remain same in the server. Now, can someone explain why do i get the error message "Unspecified Errror" when I try to open an ASP link from vb as a recordset.

rs.open "http://xyzserver/abc.asp?id=123"

Of course, the ASP returns the relevant data in my browser (if I type the above link in my browser). The returned data is an XML file.

Can someone help?

thnx

Quote:

---

rs.open "http://xyzserver/abc.asp?id=123"

---

The recordset can't connect to a web server like that. You'll have to get the data first, then open the recordset from the data as a local file.

Why?!! If you can open a text/xml file from harddrive (rs.open "xyz.rst") you must be able to open it from a web server too. The ASP returns XML data (response.write xmldoc) to the client. Or show me another way.

thnx

There's a HUGE difference between reading a file from the file system and requesting a file from a web server. Remember that the web server isn't sending you a file, but data that is encapsulated and sent over the HTTP protocol, which is encapsulated and sent over the TCP protocol, which is encapsulated and sent over the Ethernet protocol.

Hi joshT,

I think you need to research on ADO record, recordset, XML (msxml), ASP and MS Internet Publishing before you express your expert comments here. I don't need any abstract theories (which are available in bulks in this forum and ms website). If u could show a working solution it would have been appreciated by me and the thread readers.

Best Regards,

Then why are you wasting your (and our) time here?

JoshT is correct, you can not simply open a recordset based on HTTP protocol. Once you have the text local, you can open it into a recordset.

JoshT is NOT correct and you too. Who asked anything about HTTP protocol? You also need to read material related to Internet Publishing using ADO from Microsoft Web Site.

I am not wasting my time here, but try to get a solution for my problem. Actually you are wasting my time by forcing me to come to this thread again only to see useless answers. If you can't come up with a solution or point out why my code doesn't work, please shut up. Just preaching about HUGE differences doesn't help.

Anyway thanks for educating

.. and I found the answer to my problem from

http://support.microsoft.com/support.../Q253/6/96.ASP

Thanks you all gurus,

With best regards,

Quote:

---

Microsoft OLE DB Provider for Internet Publishing

---

You failed to mention that you are using an obscure provider. I can tell you that the commonly used SQL server and Access providers do not have the capability of opening recordsets based on URLs.