Executing MSSQL-Queries on linux fedora 8.0
I have two machines.
One running linux and another running windows.
I am running my web site on linux with xampp server and i want to use the database thatis mssql-2005 installed on windows.I have no option of shifting to mysql bcz fromer company database is on mssql.
So please suggest me some solution....
I hav tried connecting with FreeTDS 0.61.2.
Initially, I install FreTDS on my Fedora machine as follows:
1) unzip file by issuing the following commands:
tar xvfz FreeTDS-0.61.2.tar.gz
2)From the /public folder, issue:
3) This is what I used for the installation of FreeTDS:
./configure --prefix=/usr/local/freetds --sysconfdir=/usr/local/freetds --with-tdsver=7.0 --enable-msdblib --enable-threadsafe --enable-sybase-compat
4) Next, we compile the module tree, issue the following:
And install FreeTDS by issuing:
5) change directory to this folder, and issue:
6) Edit freetds.conf:
7) I have a windows box running MS SQL Server 2005 on it. The machine name is LAB6-16 with IP address 192.168.x.xxx. Append the following part to FreeTDS.conf, and save it:
host = 192.168.x.xxx
tds version = 7.0
Change to the bin folder under /usr/local/freetds, and issue:
tsql -S 'LAB6-16' -H '192.168.x.xxx' -p '1433' -U 'sa' –P '123456'
BUT instead of prompting 1> it returns ERROR as follows:
locale is "en_US.UTF-8"
charset is "UTF-8"
src/tds/login.c: tds_connect: 192.168.x.xxx:1433: Network is unreachable
Msg 20009, Level 9, State 0, Server OpenClient, Line 0
Server is unavailable or does not exist.
There was a problem connecting to the server
Can any body solve this problem or is there any other way to connect MSQL 2005 with Linux.
Please reply to firstname.lastname@example.org
Webinar: 8 Signs You’re Beyond Cron
11am CDT, April 29th
Join Linux Journal and Pat Cameron, Director of Automation Technology at HelpSystems, as they discuss the eight primary advantages of moving beyond cron job scheduling. In this webinar, you’ll learn about integrating cron with an enterprise scheduler.Join us!
- Not So Dynamic Updates
- New Products
- Users, Permissions and Multitenant Sites
- Flexible Access Control with Squid Proxy
- Security in Three Ds: Detect, Decide and Deny
- Tighten Up SSH
- DevOps: Everything You Need to Know
- Solving ODEs on Linux
- Non-Linux FOSS: MenuMeters
- Android Candy: Bluetooth Auto Connect