Changes

From SME Server

ODBC

237 bytes added, 14:20, 19 June 2009
m
update
unixodbc: yes
Test connection to a the foreign database, overriding settings in freetds.conf (modify to suit your conditions, ip could be replaced with FQDN):
tsql -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
[remoteserver]
Driver = FreeTDS
Description = Connection to DB_KALLE database DB_TEST on server xp3c
Trace = No
Server = xp3c
Database = db_kalledb_test
Port = 1433
TDS_Version = 8.0
====tsql====
Test connection, using input in freetds.conf:
tsql -S remoteserver -U testuser dbuser -P testpassdbpass
This should output something like this:
and
phpinfo();
and
$con = odbc_connect("remoteserver", "dbuser", "dbpass");
if (!$con) { print("There is a problem with SQL Server connection."); }
else { print("The SQL Server connection object is ready.");
odbc_close($con); }
=== Additional information ===
206
edits

Navigation menu