We use a linux webserver but have a need to connect to MSSQL databases. Since I used Fedora, I was lucky enough to find the PHP-MSSQL package but that has only been available via yum recently. My first attempt at connecting to MSSQL was much more difficult when I was using FC3. On Mon, Oct 27, 2008 at 2:02 PM, Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx>wrote: > On Mon, 2008-10-27 at 07:41 -0700, Robbert van Andel wrote: > > You also need to make sure that your server has the mysql drivers > > installed. A linux server does not come with this support natively. > > > > On Mon, Oct 27, 2008 at 6:19 AM, bruce <bedouglas@xxxxxxxxxxxxx> wrote: > > > > > hey sudhakar.. > > > > > > when you're changing database apps, you're normally going to have to > change > > > the connection codem as well as possibly the query structure for your > > > different select/insert/etc.. queries. > > > > > > there should be plenty of examples/tutorials on the net, as well as in > the > > > php.net website. > > > > > > have fun! > > > > > > > > > -----Original Message----- > > > From: Sudhakar [mailto:sudhakararaog@xxxxxxxxx] > > > Sent: Sunday, October 26, 2008 8:49 PM > > > To: php-general@xxxxxxxxxxxxx > > > Subject: question about using sql server with php > > > > > > > > > i have a question about how to use sql database with php instead of > using > > > my > > > sql database > > > > > > when i use my sql database the php code to connect to the my sql > database > > > is > > > = > > > > > > $conn = mysql_connect($hostname, $user, $password); > > > > > > if(!$conn) > > > { > > > echo "Unable to connect to Database"; > > > } > > > > > > else > > > { > > > mysql_select_db($database, $conn); > > > > > > $query = mysql_query($selectquery); > > > > > > mysql_close($conn); > > > } > > > > > > > > > if i have to connect to a sql databse instead of my sql database as > some > > > companies use sql database, how can i change the php code to connect, > run a > > > query and close connection to the sql database. > > > > > > apart from changing the code to connect to sql database is there > something > > > else i need to do. > > > > > > please advice. > > > > > > thanks > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > What distribution are you using for your server, as every distro I've > ever touched has them. Also, the question was regarding connection to a > mssql database, not mysql. As he didn't specify the operating system, > I'm going out on a limb by thinking the PHP was on a Windows web server > (who would run PHP on a Linux web server to then use the inferior mssql > database?) > > > Ash > www.ashleysheridan.co.uk > >
