Hey guys i got this new irose server set up but i need a website that supports MSSQL the MSQL websites dont work on this MSSQL DB ;/ Can somone mayby support me with some MSSQL websites? i can use.
Hey guys i got this new irose server set up but i need a website that supports MSSQL the MSQL websites dont work on this MSSQL DB ;/ Can somone mayby support me with some MSSQL websites? i can use.
Open php.ini find mssql and remove ; and restart apache and voala ! Rose online work fine with MSSQL im using it !
Install xampp, that support mssql by default,
and use mssql 2000, i haven't get 2005 worked with php
i got xampp installed but it dosent connect to my mssql database ;/
#xamppdir#\apache\bin\php.ini
and read the xampp site, you can read it there!
so do i remove all this >>
[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On
; Maximum number of persistent links. -1 means no limit.
mssql.max_persistent = -1
; Maximum number of links (persistent+non persistent). -1 means no limit.
mssql.max_links = -1
; Minimum error severity to display.
mssql.min_error_severity = 10
; Minimum message severity to display.
mssql.min_message_severity = 10
; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off
; Connect timeout
;mssql.connect_timeout = 5
; Query timeout
;mssql.timeout = 60
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
; Limits the number of records in each batch. 0 = all records in one batch.
;mssql.batchsize = 0
; Specify how datetime and datetim4 columns are returned
; On => Returns data converted to SQL server settings
; Off => Returns values as YYYY-MM-DD hh:mm:ss
;mssql.datetimeconvert = On
; Use NT authentication when connecting to the server
mssql.secure_connection = Off
; Specify max number of processes. -1 = library default
; msdlib defaults to 25
; FreeTDS defaults to 4096
;mssql.max_procs = -1
Then the mysql websites will work with mssql ?
Warning: mysql_query() [function.mysql-query]: Can't connect to MySQL server on 'localhost' (10061) in D:\xampplite\htdocs\rose2\index.php on line 68
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\xampplite\htdocs\rose2\index.php on line 68
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampplite\htdocs\rose2\index.php on line 68
Total Characters:
Warning: mysql_query() [function.mysql-query]: Can't connect to MySQL server on 'localhost' (10061) in D:\xampplite\htdocs\rose2\index.php on line 69
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\xampplite\htdocs\rose2\index.php on line 69
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampplite\htdocs\rose2\index.php on line 69
Users Connected:
Warning: mysql_query() [function.mysql-query]: Can't connect to MySQL server on 'localhost' (10061) in D:\xampplite\htdocs\rose2\index.php on line 70
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\xampplite\htdocs\rose2\index.php on line 70
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampplite\htdocs\rose2\index.php on line 70
Still get errors
crap?!
topic: website that work on mssql! <<<<<<
why php.ini?!?!
the website cms is using mysql_connect and not mssql_connect, so why php.ini ?!
@ CronicT
u need a different cms which supports mssql, you have to change all mysql_* commands to mssql. they are nearly the same :D but it wont work...
the cms must be rewritten
;/ Anyway u can help me with a website ?
You can download the ruff-rose site, and use that.
Or if you are a coder you code your own site.
I'm busy with a clone that looks like the first sevenhearts site.
were can i download the ruff-rose site and does it use mssql ?