Jan K. van Dalen
|
| Posted: 10/16/2007, 2:39 PM |
|
As soon as a solution is found, I'll send the check (US Bank) under your
name to the address of your choosing. I will test the recomendations in
order of arrival (date/time).
The email address to contact me for this isphperror@janvandalen.com
Also, I have submitted the errors to Yes Software but no luck.
If you solve 1 issue, I'll send you $50.
Issue 1:
PHP 5 / MSSQL / CCS 3.2.0.4
When add/edit/delete records, a Database error appears on the form. The
action is performed but the form does not return to the list. Also, the
File Upload is not working which I believe is related ... but maybe not.
Screenshot of error:
http://www.janvandalen.com/errors/CodeChargePHPMSSQLError.jpg
Test Applicaiton:
http://d1037957-4.dotsterhost.com/mrgcphp/LibraryDocs_list.php
Issue 2:
PHP 5 / MSSQL (Remote connection) / CCS 3.2.0.4
Running the same application mentioned above on my development desktop I
receive the following error. The same (type) test application in ASP &
ASP.Net work without a problem.
Database error: Cannot connect to mssql Database
MSSQL Error
Session halted.
I have tried several suggestions found on the forums but still have the
problem.
Here is a link to the phpinfo: http://www.janvandalen.com/errors/phpinfo.pdf
Here is a link to the connection setup information:
http://www.janvandalen.com/errors/connection.pdf
Good luck and I hope I get this resolved soon 
|
|
|
 |
Jan K. van Dalen
|
| Posted: 10/19/2007, 1:17 PM |
|
Ok, I was not able to solve the problems ... going back to ASP
"Jan K. van Dalen" <jan@windmilltechnology.com> wrote in message
news:ff3b33$43v$1@news.codecharge.com...
> As soon as a solution is found, I'll send the check (US Bank) under your
> name to the address of your choosing. I will test the recomendations in
> order of arrival (date/time).
>
> The email address to contact me for this isphperror@janvandalen.com
>
> Also, I have submitted the errors to Yes Software but no luck.
>
> If you solve 1 issue, I'll send you $50.
>
> Issue 1:
> PHP 5 / MSSQL / CCS 3.2.0.4
>
> When add/edit/delete records, a Database error appears on the form. The
> action is performed but the form does not return to the list. Also, the
> File Upload is not working which I believe is related ... but maybe not.
>
> Screenshot of error:
> http://www.janvandalen.com/errors/CodeChargePHPMSSQLError.jpg
> Test Applicaiton:
> http://d1037957-4.dotsterhost.com/mrgcphp/LibraryDocs_list.php
>
>
> Issue 2:
> PHP 5 / MSSQL (Remote connection) / CCS 3.2.0.4
>
> Running the same application mentioned above on my development desktop I
> receive the following error. The same (type) test application in ASP &
> ASP.Net work without a problem.
>
> Database error: Cannot connect to mssql Database
> MSSQL Error
> Session halted.
>
> I have tried several suggestions found on the forums but still have the
> problem.
>
> Here is a link to the phpinfo:
> http://www.janvandalen.com/errors/phpinfo.pdf
> Here is a link to the connection setup information:
> http://www.janvandalen.com/errors/connection.pdf
>
>
> Good luck and I hope I get this resolved soon
>
>
>
>
|
|
|
|
wkempees
|
| Posted: 10/22/2007, 3:40 AM |
|
So the $100 will no longer be availiable?
Still try and figure out this:
It is very obvious that your PhP application cannot connect to the MSSQL
database.
In both issues that seemsto be the case.
Without being able to see you MSSQL install, check out :
A: Database authentication, is it set to SQL or NT?
If it is the latter checkout php.ini: mssql.secure_connection, it should be
ON.
If this solves your problem no need for a US Bank check.
(I have paypal)
Walter
"Jan K. van Dalen" <jan@windmilltechnology.com> schreef in bericht
news:ff3b33$43v$1@news.codecharge.com...
> As soon as a solution is found, I'll send the check (US Bank) under your
> name to the address of your choosing. I will test the recomendations in
> order of arrival (date/time).
>
> The email address to contact me for this isphperror@janvandalen.com
>
> Also, I have submitted the errors to Yes Software but no luck.
>
> If you solve 1 issue, I'll send you $50.
>
> Issue 1:
> PHP 5 / MSSQL / CCS 3.2.0.4
>
> When add/edit/delete records, a Database error appears on the form. The
> action is performed but the form does not return to the list. Also, the
> File Upload is not working which I believe is related ... but maybe not.
>
> Screenshot of error:
> http://www.janvandalen.com/errors/CodeChargePHPMSSQLError.jpg
> Test Applicaiton:
> http://d1037957-4.dotsterhost.com/mrgcphp/LibraryDocs_list.php
>
>
> Issue 2:
> PHP 5 / MSSQL (Remote connection) / CCS 3.2.0.4
>
> Running the same application mentioned above on my development desktop I
> receive the following error. The same (type) test application in ASP &
> ASP.Net work without a problem.
>
> Database error: Cannot connect to mssql Database
> MSSQL Error
> Session halted.
>
> I have tried several suggestions found on the forums but still have the
> problem.
>
> Here is a link to the phpinfo:
> http://www.janvandalen.com/errors/phpinfo.pdf
> Here is a link to the connection setup information:
> http://www.janvandalen.com/errors/connection.pdf
>
>
> Good luck and I hope I get this resolved soon
>
>
>
>
|
|
|
|
Jan K. van Dalen
|
| Posted: 10/26/2007, 8:35 AM |
|
Hi Walter,
Your solution did not fix my problem. I'm starting to think that I may have
to re-install my windows as there may be something corrupted.
"wkempees" <kempe819@planet.nl> wrote in message
news:ffhuma$tje$1@news.codecharge.com...
> So the $100 will no longer be availiable?
> Still try and figure out this:
> It is very obvious that your PhP application cannot connect to the MSSQL
> database.
> In both issues that seemsto be the case.
>
> Without being able to see you MSSQL install, check out :
> A: Database authentication, is it set to SQL or NT?
> If it is the latter checkout php.ini: mssql.secure_connection, it should
> be ON.
>
> If this solves your problem no need for a US Bank check.
> (I have paypal)
>
> Walter
>
>
> "Jan K. van Dalen" <jan@windmilltechnology.com> schreef in bericht
>news:ff3b33$43v$1@news.codecharge.com...
>> As soon as a solution is found, I'll send the check (US Bank) under your
>> name to the address of your choosing. I will test the recomendations in
>> order of arrival (date/time).
>>
>> The email address to contact me for this isphperror@janvandalen.com
>>
>> Also, I have submitted the errors to Yes Software but no luck.
>>
>> If you solve 1 issue, I'll send you $50.
>>
>> Issue 1:
>> PHP 5 / MSSQL / CCS 3.2.0.4
>>
>> When add/edit/delete records, a Database error appears on the form. The
>> action is performed but the form does not return to the list. Also, the
>> File Upload is not working which I believe is related ... but maybe not.
>>
>> Screenshot of error:
>> http://www.janvandalen.com/errors/CodeChargePHPMSSQLError.jpg
>> Test Applicaiton:
>> http://d1037957-4.dotsterhost.com/mrgcphp/LibraryDocs_list.php
>>
>>
>> Issue 2:
>> PHP 5 / MSSQL (Remote connection) / CCS 3.2.0.4
>>
>> Running the same application mentioned above on my development desktop I
>> receive the following error. The same (type) test application in ASP &
>> ASP.Net work without a problem.
>>
>> Database error: Cannot connect to mssql Database
>> MSSQL Error
>> Session halted.
>>
>> I have tried several suggestions found on the forums but still have the
>> problem.
>>
>> Here is a link to the phpinfo:
>> http://www.janvandalen.com/errors/phpinfo.pdf
>> Here is a link to the connection setup information:
>> http://www.janvandalen.com/errors/connection.pdf
>>
>>
>> Good luck and I hope I get this resolved soon
>>
>>
>>
>>
>
>
|
|
|
|
TonyReid
Posts: 159
|
| Posted: 10/26/2007, 8:49 AM |
|
to find out what sql is being sent to mssql - uncomment the two print debug lines in the mssql.php common file.
Then publish the mssql file.
That has helped me heaps in discovering whats wrong in situations like this.
_________________
-----------
PHP/indy Game Developer - http://www.AbsoluteBreeze.co.uk |
 |
|
|
