206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 94:
Line 94: − A response something like this would indicate that connection was successful but login failed (wich is normal at this stage):+ − − Msg 18456, Level 14, State 1, Server XP3C\SQLEXPRESS, Line 1 + − Login failed for user 'dbuser'.+ − Msg 2002, Level 9, State -1, Server OpenClient, Line -1 − Adaptive Server connection failed − There was a problem connecting to the server Line 186:
Line 182: − + − − This should output something like this: − locale is "sv_SE" − locale charset is "ISO-8859-1" − 1> − 1> indicate that you are connected, logged in and the server are ready for SQL commands. Exit tsql console with: − quit + + Line 213:
Line 204: − +
Added info
tsql -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
tsql -H 192.168.0.112 -p 1433 -U dbuser -P dbpass
This should output something like this indicate that you are connected, logged in and the server are ready for SQL commands:
locale is "sv_SE"
locale is "sv_SE"
locale charset is "ISO-8859-1"
locale charset is "ISO-8859-1"
1>
Exit tsql console with "quit". If connection was made but you didn't log in indicates that you have a problem in your remote server, check settings and permissions.
===Configuration===
===Configuration===
===Test again===
===Test again===
====tsql====
====tsql====
Test connection, using input (DSN and driver) in the configuration files we just edited:
Test connection, using input (DSN and driver) in the configuration files we just edited, the result should be the same as the previous tsql test:
tsql -S remoteserver -U dbuser -P dbpass
tsql -S remoteserver -U dbuser -P dbpass
====isql====
====isql====
ISQL is a simple database client included in unixODBC package for testing and troubleshooting. The command "isql" give more info.
ISQL is a simple database client included in unixODBC package for testing and troubleshooting. The command "isql" give more info.
Generally speaking, isql is a bit more fuzzy about correct configuration settings than tsql, therefore we include also this test.
At the command line enter "isql -v DSN USERNAME PASSWORD" e.g.:
At the command line enter "isql -v DSN USERNAME PASSWORD" e.g.:
SQL>
SQL>
If you do not get output similar to the above, then check your config files, pay special attention to upper/lowercase, for example REMOTESERVER is not the same as remoteserver!
If you do not get output similar to the above, then check your config files, pay special attention to upper/lowercase, for example REMOTESERVER is not the same as remoteserver.
===Check PHP===
===Check PHP===
