Connecting to server database through ODBC

Tchocky

I am extremely new to PHP and have been trying to connect to a SQL server I have on the system DSN of my ODBC. However, the whole process is adamant in its refusal to work. The server is located on my company's network.

The code below brings up the die message-

<?php

if(!($db=odbc_connect("SAGE2000LIVE"," ", " ")))

        die("nothing really matters... to me");

When I try to connect to an access database which is saved locally, it works fine.

Does anyone have an idea where I am going wrong? Should I change the Queen lyrics before I lose my mind?

rinjani

Hi, it sounds like you have a networked NT server running a database and you need to make an ODBC connection to it. I recently set soemthing like this up using an ODBC bridge client from easysoft.

The trouble is you will need to purchase the product from them but it does work pretty well.

Set up the Easysoft client on your SQL server box. Install the bridge cleint on your second server (Linux, Unix, Windows) and configure the odbc.ini file with the server name, login and password.

Then the standard ODBC connection script should work for you.

The installation instructions from Easysoft are fairly straightforward and you can download a test version to make sure it works before purchasing it.

Hope this helps

rinjani