Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: c_owl on May 16, 2010, 07:18:28 AM

Title: new to php mssql
Post by: c_owl on May 16, 2010, 07:18:28 AM
hi all
im new to php and im stuck...
i have installed ms sql 2008 express, works fine and remote login wokrs good.
i have installed apache 2.2
i have installed php 5.2.13
on os server 2008. all works ok on there own
now this is were im stuck...:eek::eek:

i cant get php to connect to mssql to get database info.

can anyone help please:confused::confused:
Title: new to php mssql
Post by: toetag on May 16, 2010, 09:57:57 PM
i can't offer any real assistance to your problem.  I spent a few days looking into PHP connectivity with MSSQL and the best solution I came up with was to dump MSSQL and load MySQL.

Unless it's changed since I looked I read something about PHP not supplying MSSQL dll files any longer and to use some alternative.  there's a few links in google that might help but honestly after 4 days of trying with MSSQL, i loaded MySQL and had MySQL and RoundCube running in about 15 minutes.

a quick and dirty way is to install XAMPP (http://www.apachefriends.org/en/xampp-windows.html)  apache, mysql, php (you can choose not to install filezilla and mercury mail transport).
Title: new to php mssql
Post by: c_owl on May 17, 2010, 08:57:44 AM
hi
i installed mysql and i like it. will have a play with it today to get me head around it.

how do i get php to work with mysql, ie edit apache config file and add some sort of mod for mysql:rolleyes:
Title: new to php mssql
Post by: toetag on May 17, 2010, 09:10:16 AM
if you used XAMPP, it automatically configures all of the products to work together.  If you didn't. You might have to edit your extensions in PHP.ini and make sure the mysql libs are uncommented.

Google is your friend here.
Title: new to php mssql
Post by: c_owl on May 17, 2010, 11:13:24 AM
hi
i seem tobe ok with basics on mysql now(very basics)..
i have installed phpmyadmin and phpmyadmin cant connect to mysql???
error message :-
Cannot load mysqli extension. Please check your PHP configuration. - Documentation
on web page


ive google but still cant get it to work. i just have this one step todo to get my web page working..
:eek::eek::eek:
Title: new to php mssql
Post by: Julius Caesar on May 18, 2010, 03:46:48 AM
Did you install the PHP-MYSQLI extension?

Check here (http://php.net/manual/en/install.windows.extensions.php) for more information installing extensions on Windows-based computers
Title: new to php mssql
Post by: c_owl on May 18, 2010, 06:15:17 AM
hi thanks for your help
i still cant get it to work.

extension=php_bz2.dll done and dir path
Title: new to php mssql
Post by: Julius Caesar on May 18, 2010, 06:54:52 AM
php_bz2.dll is an extension for bzip2.

The extension for mysql 5.x is php_mysqli.dll as you could have seen in the list.
Title: new to php mssql
Post by: c_owl on May 18, 2010, 08:37:19 AM
hi
tryed it, still same problem??
Title: new to php mssql
Post by: c_owl on May 18, 2010, 06:14:19 PM
so after trying everything i got it working..
i used my programming pc to do a fresh install of xampp, and found were i went wrong
i didnt uninstall my old apache setup, just installed xampp on top and got config files mixed up.

so well happy its now working.

is there a program that alows import of ms access dbs to mysql

thanks again everyone:):)