I have written, in VB, and been using for some time, a DLL that accepts a list of parameters, will connect to any server on our system and return a record set or an error message. It also checks the login details and group details against the NT domain before connecting to the required DB via an application role.
Using this DLL from other VB apps work wonderfully it does everything I ask of it.
My problem is, as soon as I try to use it from within PHP it stops working. The User ID and password parts work fine but as soon as the open.connection to the DB is attempted it falls over. What appears to be happening is the user id and domain name aren’t being passed to the DB.
I assume this on the basis that when I track the connections to the database and attempt to connect from a VB app the connection is show as "Domain/userID" when I try to connect from a PHP page I get connection failed for user "/" and the return error shows the domain and ID to be empty.
I am attempting all this using Personal Web server set up on my machine as a localhost.
I apologies for any missing information as I am very new to this web development business, if I've missed anything please say and I'll supply it ASAP.
Any help is very much appreciated 🙂
Edit : I did have a problem with the PW/ID bit but after a bit of testing found that the domain was not being found, I assume the same is happening to the DB connection but I cant find a way to cure that 🙁
