ActiveX

[rikshawdriver]

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

[abhijit]

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

-abhijit

[rikshawdriver]

Hi,

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

[JoshT]

Then use cross-browser compatible HTML for the UI.

[monte96]

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

[rikshawdriver]

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

[JoshT]

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.

[rikshawdriver]

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

[JoshT]

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.

[rikshawdriver]

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,

[monte96]

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.

[rikshawdriver]

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

[rikshawdriver]

.. 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,

[JoshT]

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.