hybred code

[Matt_T_hat]

I have a Windows hosting account that as well as giving out really nice ammounts of space for my $12 (about £6) gives me:

ASP.NET
ASP
Code Behind
MS-SQL/MY-SQL etc

and

PHP (v4 I think)

Now this is where it gets interesting.

I have a bunch of code that I think of as a base or core system written in classic ASP. It provides include files with Class objects written in VBscript for ASP and a few general functions that go through the more complicated bits of database and get you the value you require.

The design is such that one should be able to create a wrapper for other apps and include them in the authentication etc and make them part of the system with minimal changes.

My question is could I do that with a PHP module and if so could I use the Class objects and can I call the functions?

[CornedBee]

No. While it is possible to use Automation objects from within PHP, the components within the include files you have do not form such proper objects and thus can't be used. You could try to rewrite them into real Visual Basic so that they form usable objects, but you don't have the server implicit object, which I suppose you really need.

[Matt_T_hat]

darn...

But I was starting to get that idea especially when google took me here:
http://forums.devarticles.com/t1154/s.html?highlight=Trouble+with+loading+up+an+image!!+HELP!!

The thing is I got PHP as the only answer for one problem and running nicely (if isolated) and a PERL/CGI doing another bit and stacks of ASP stuff that are about to move in and guess what some .NET stuff got thrown my way and the solutions also would be good.

Each solution is a discrete element and therefore "doesn't really need to" talk to the others (more work but with the mess brewing up it will do as well as anything else).

There are only two things I MUST do Unify Logins and Unify Look n feel.

On Logins
My best guess would be to create a sync script to load each database and replicate the user data into the others (unless you know of a way of getting: My-SQL / MS-SQL to point to another DB for data)

Look n feel.
Obviously a lot of this is just design issues and not a problem but it would be nice to build a central "portal" page that carried news includes etc from all the other sections.

Those two feats completed each app could be written in it's own special language for all I care.

So this is (I know) becoming a data layer and UI layer issue... not really the right section anymore (oops) but I understand that PHP can do some very cleaver things that ASP couldn't even pronounce (if you forgive the poetic license)

Any ideas?

(and should this thread be moved?)

[CornedBee]

You could access a single database from all scripts. PHP supports MSSQL, and ASP would support MySQL through the MyODBC driver, too.