Using DOTNET constructor to create SqlConnection in PHP?

Question

0.00/5 (No votes)

See more:

I have learnt that we can create some (I think only some) .net objects in PHP using DOTNET constructor like this:

PHP

$dotNETobj = new DOTNET("assembly full name", "classname");

I have played with it creating some .NET object like Hashtable, Stack... and I tried with SqlConnection but it failed, maybe I made something wrong. Could you please tell me if it is possible to create that object in PHP? If possible, could you post some code here for that?
Here is my try:

PHP

$sqlcon = new DOTNET("System.Data", "SqlConnection");

The error message is too long, I'll post only some of it that I think it is important here:

"...'Failed to instantiate .Net object... The system cannot find the specified.  ' in myurl Stack trace:..."

All are in a line without any break. I can't understand why PHP can give us such an illegible error message? It is too complicate to any newbie and maybe many intermediate programmers, I'm sure to say that. Fortunately, dot net is not the same!
Your help would be appreciated!
Thank you!

Posted 29-Mar-12 3:53am

supernorb

Updated 29-Mar-12 4:57am

Herman<T>.Instance

v2

Add a Solution

Comments

Peter_in_2780 29-Mar-12 19:31pm

There is a very good reason the error message does not contain any line breaks (although it DOES contain "\n" sequences for later processing). The message is logged to a server error log file, and there are many programs that process those log files. Multiline log messages would break the formatting expected by those programs.
Meanswhile, it seems the .NET assembly can't be found. I'd start looking for it. Do you have the .NET runtine installed, like the PHP manual says?
btw, the error message is not too big to post, and contains useful information you haven't shown us.

supernorb 29-Mar-12 20:58pm

No, I don't think so. I have experienced programming with .NET for months and I have already installed Framework 3.5 on my computer going with VS 2008. The error message is long but it contains my url and that's why it is long, I think the what I posted is the most important. You can reproduce my error message simply by typing only one line of code that I posted (creating a .net object using DOTNET constructor). There was no other code involving here, I'm sure because I tested with only that line in a php file.
Thank you for your help!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AspDotNetDev · Answer 1 · 2012-04-09T06:59:00

I don't use PHP, but here's a shot in the dark that might just be your issue...

The SqlConnection class resides in the namespace System.Data.SqlClient. Perhaps you need to specify that when you call DOTNET. For example, you might try some of these:

PHP

$sqlcon = new DOTNET("System.Data", "System.Data.SqlClient.SqlConnection");
$sqlcon = new DOTNET("System.Data", "SqlClient.SqlConnection");
$sqlcon = new DOTNET("System.Data.SqlConnection", "SqlConnection");

Seems to me it would have no other way of knowing where SqlConnection is. There could, in fact, be two SqlConnection classes in different namespaces and it wouldn't know which to pick.

Alternatively, create a wrapper class for SqlConnection and build your own DLL that you can import. That might get complicated though... for example, you may have to put the DLL into the GAC.