206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 159:
Line 159: − + + Line 169:
Line 170: + + + + + + + + + + + + + + + + +
→Test again with tsql: added isql
expand-template /etc/odbc.ini
expand-template /etc/odbc.ini
===Test again with tsql===
===Test again===
====tsql====
Test connection, using input in freetds.conf:
Test connection, using input in freetds.conf:
tsql -S xp3c -U testuser -P testpass
tsql -S xp3c -U testuser -P testpass
1> indicate that you are connected, logged in and the server are ready for SQL commands. Exit tsql console with:
1> indicate that you are connected, logged in and the server are ready for SQL commands. Exit tsql console with:
quit
quit
====isql====
At the command line enter the command isql -v DSN USERNAME PASSWORD e.g.:
isql -v xp3c dbuser dbpass
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
If you do not get output similar to the above, then check your config files, pay special attention to upper/lowercase, for example XP3C is not the same as xp3c!
===Check PHP===
===Check PHP===
