Changes
From SME Server
Jump to navigation
Jump to search
← Older edit
Newer edit →
ODBC
(view source)
Revision as of 09:18, 19 June 2009
24 bytes added
,
09:18, 19 June 2009
m
Changed host name
Line 159:
Line 159:
Add text (modify to suit your conditions):
Add text (modify to suit your conditions):
−
[
xp3c
]
+
[
remoteserver
]
Driver = FreeTDS
Driver = FreeTDS
Description = Connection to DB_KALLE on server xp3c
Description = Connection to DB_KALLE on server xp3c
Line 183:
Line 183:
====tsql====
====tsql====
Test connection, using input in freetds.conf:
Test connection, using input in freetds.conf:
−
tsql -S
xp3c
-U testuser -P testpass
+
tsql -S
remoteserver
-U testuser -P testpass
This should output something like this:
This should output something like this:
Line 195:
Line 195:
At the command line enter the command isql -v DSN USERNAME PASSWORD e.g.:
At the command line enter the command isql -v DSN USERNAME PASSWORD e.g.:
−
isql -v
xp3c
dbuser dbpass
+
isql -v
remoteserver
dbuser dbpass
+---------------------------------------+
+---------------------------------------+
Per
206
edits
Navigation menu
Page actions
Page
Discussion
View source
History
Page actions
Page
Discussion
More
Tools
In other languages
Personal tools
English
Log in
Koozali SME Server
Main Page
Welcome
Releases
Testimonials
Documentation
SME Server FAQ
Volunteering
Commercial Support
Recent activities
Dashboard
Recent wiki changes
Recent bug changes
Unread Forum posts
Koozali resources
Contribs
How-To's
Forums
Bugzilla
Mailing Lists
Translations
Download
Koozali SME Server wiki
Wiki statistics
Wiki categories
Wiki Help
Koozali Wiki Help
Tools
Special pages
Printable version
Search