Printable View
Greetings
I would like to access and manipulate MSSQL data over the Internet and using IIS with VB6 (by ADO - OLEDB no ODBC).
I am in doubt regards two different approaches: Web Classes or RDS. I 'll appreciate any advice from anyone experienced in this field.
Thanks in advance
sasha
[email protected]
I'm currently working on a project that uses webclasses and ADO.
I have not worked with RDS, but Webclasses are very, very useful especially if you're not familiar with ASP. Webclasses are much easier to debug than ASP.
------------------
CompuGEEK
WebClasses have worked pretty well for me so far. I'm on my second project using webclasses connected to mssql7 data, so far no major unsolvable probs.
out of curiosity why no odbc?
Hi BG,
When you are connecting to SQL7, are you using stored procedures?
Also, how do manage state in your project? Just curious...
Thanks
I havn't tried to execute a stored procedure from a webclass, I know the execute method on a ADODB.connection object works I have used that so you probably can.
I use the database to maintain most of my state (user, profile, etc.). For simple values that I just need to pass from one template to another I use hidden input form fields, URLData, or if convenient in the eventname of my user events.
FYI
There is a memory leak when using Webclasses, and the apps will not scale to handle more than a few hundred (I think) users at a time before your server crashes.
Stick with ASP if you guys are doing any MAJOR internet apps
Hi Clunietp
Does it mean that you are prefer RDS?
sasha
Clunietp,
Where did you hear that Webclasses produce a memory leak?
As long as you set your SQL connection to allow connection pooling, set the appropriate state management in the WebClass app and configure IIS correctly, there should be absolutely no problems.
------------------
CompuGEEK
what is RDS? Remote Data Service? I don't know much info about that, but the point I was trying to make was that real ASP pages are more scalable than Webclasses.