Need Help With Registration Errors.

02/07/2012 08:42 Varczette#1
hey I am currently trying to input web registration onto my server and here is my problem.

I get the error: Fatal error "Call to undefined function mssql_connect() in C:\xampp\htdocs\processor.php on line 10'' everytime I try to create an account. I found out its because it wasnt connecting to my sql server or something and the fix was to uncomment php_mssql and php_pdo_mssql.
I have done this but now my apache server will not restart after I stopped it.
I first got the error php_mssql.dll could not be found in c:/xampp/php/ect I think it was so I downloaded the .dll file and places it into the correct path.
Now when ever I try to restart the apache server I get that same error along with php4ts.dll can not be found.
I am just having one problem after another. If somebody could please help me I would be very appreciative.
And before you ask yes I have searched e-pvpers, looked on Google and done extensive searching on XAMPP forums aswell as PHP.
02/07/2012 09:24 RebeccaBlack#2
Just use one of the ODBC versions, or make a SQLServ version.

It's more than likely that you have a version of PHP that dropped mssql functions. Though I am unsure, since MSSQL functions were dropped in PHP 5.3, and php4ts.dll is only loaded within PHP4.x versions (PHP5.x obviously looks for php5ts.dll)
02/07/2012 21:13 mr.outc4st#3
you have the correct version of xampp? I kno when i set mine up i had to play around seems like the newest version of xampp doesnt like mssql along with the php and i had to d/l and older version to make things mingle correctly... my curr ver is April 2009 1.7.1 Beta5, maybe look at that and try it out
02/08/2012 10:43 Varczette#4
Quote:
Originally Posted by RebeccaBlack View Post
Just use one of the ODBC versions, or make a SQLServ version.

It's more than likely that you have a version of PHP that dropped mssql functions. Though I am unsure, since MSSQL functions were dropped in PHP 5.3, and php4ts.dll is only loaded within PHP4.x versions (PHP5.x obviously looks for php5ts.dll)
Im not sure what exactly ODBC is so I will have to look into it alot before I go ahead and try and use it. But I did do a search in the forums and found a nice little .rar file from you with a few scripts rewritten in it and downloaded. I did thank you for it by the way.

Quote:
Originally Posted by mr.outc4st View Post
you have the correct version of xampp? I kno when i set mine up i had to play around seems like the newest version of xampp doesnt like mssql along with the php and i had to d/l and older version to make things mingle correctly... my curr ver is April 2009 1.7.1 Beta5, maybe look at that and try it out
I did as you said and downloaded that one but Im just getting error after error with shit that confuses me lol. So I will try the ODBC and see how I go.




-Edit: I did a google search on ODBC but Im still not sure on how to set it up and how it works exactly. Im still new to this side of the servers and I was wondering if you would be able to explain it or even just send me a few links about it so I can read in depth.
If its easier you may add me to skype.

Skype: varczette_

Thanks very much in advanced for any information you may be able to help me with.
02/08/2012 13:52 RebeccaBlack#5
ODBC (or Open DataBase Connectivity) is a driver that allows connections to multiple databases, MSSQL being one of them.

You do not need to set up ODBC (at least not in my experiences), as it comes built on top of your preexisting OS. The additional configuration (Setting up the driver for ODBC -(Connection)> MSSQL) is done during the correct setting up of the MSSQL Database. Now, connecting through ODBC is different from the native MSSQL functions they dropped. First, you use a connection string, instead of a host. This you can see in the .rar file you mentioned.

Using the PHP Help site itself ([Only registered and activated users can see links. Click Here To Register...])You could attempt to understand how to use it. Try comparing two files, one using the MSSQL Functions, and one using the ODBC functions. Look at the PHP Manual I linked and compare. You'll find it'll be quite easy to convert your own from that, with slight reading.
02/12/2012 00:27 Varczette#6
Thanks very much for your reply. I have been away for 2 days but now Im back and very keen on learning. I shall do as you suggested.
I will hopefully learn alot so that one day I can help people like you have helped me xD