Thursday, November 15, 2007

Freebsd + PHP + MSSQL How To Connect Witt FreeTDS

// /usr/local/etc/freetds.conf

[global]
# TDS protocol version
tds version = 4.2
text size = 64512

[MSSQL2000]
host = XX.XX.XX.XX
port = 1433
tds version = 8.0

test connection with php

$dbhandle=mssql_connect("MSSQL2000", "username", "password")
or die("Couldn't connect to SQL Server on $myServer");

Centos 7 reset root/ any user lost password / lockout due to cant remember password

1. Need to be in front of the terminal. (Physically if not vm). 2. Reboot the server 3. Press 'e' in the GRUB2 boot screen. 3. bunch...