A test environment
Operating system red hat as 5.5
sqlserver2000 installed in windows xp professional, I assume that the database has the user autotest password is autotest and the database file is atsdb
1ms never provided sqlserver for linux, so don't try to install sqlserver on linux system, but you can connect through odbc
sqlserver database of windows system;
2 The installed sqlserver2000 will not open port 1433, so please ask windows xp users to install sqlserver sp3 pudding after installing sqlserver. You can use the command netstat -a to see if port 1433 is open.
3 For windows xp, the default firewall does not allow port 1433 to communicate,So you must turn off the windows firewall,This problem tossed me all day,Always connecting unsuccessfully,I thought it was a problem with the configuration of the odbc software. The most annoying is that using the sqlserver command isql on other windows machines can access the database,(Do not turn off the firewall). It is found through the packet capture tool that communication is not through the 1433 port at all.But through the internal port 445 or 139,How terribleIt seems the windowsdown stuff is good,But it's too domineering
4 chs_sql2ksp3.exe patch must be applied when installing sqlserver2000 in XP SP2.telnet ip 1433 will not connect,Of course, you cannot connect from a remote client.Tossing this afternoon for an afternoon,Dizzy
odbc for linux
Driver for connecting to sqlserver or sybase
Two installation configuration (must be installed by the user under root)
#tar vxzf unixodbc-2.2.8.tar.gz
#./configure --prefix =/usr/local/unixodbc --enable-gui=no
#tar vxzf freetds-0.62.4.tar.gz
#./configure --prefix =/usr/local/freetds --with-unixodbc =/usr/local/unixodbc --with-tdsver=8.0
Modify the following paragraph,And put;remove
After the change:
#tds protocol version
[Sqlserver2000] represents the server name used in the client (add -s sqlserver2000 to the tsql command), host represents the IP address of the sqlserver server, and port represents the port.client charset is the character set used by the client,My machine will report a connection failure error when using UTF-8.Found that tsql can connect successfully using the iso-8859-1 character set,So here it is too
$tsql -s sqlserver2000 -u autotest -p autotest
./tsql -s sqlserverdev -u selasreader -p only4selas
locale is "en_us"
locale charset is "iso-8859-1"
msg 2403, level 16, state 0, server openclient, line 0
warning! some character (s) could not be converted into client "s character set. unconverted bytes were changed to question marks ("?").
1>select * from auth_function
func_id name english_name parent_id is_log notes
[[email protected] bin] $./tsql -s sqlservermdm -u selasreader -p only4selas
locale is "lc_ctype=en_us.utf-9;.gb18030;lc_address=zh_cn.gb18030;lc_telephone=zh_cn.gb18030;lc_measurement=zh_cn.gb18030;lc_identification=zh_cn.gb18030 "
locale charset is "utf-8"
msg 5703, level 0, state 1, server sqlcnbj015 \ i01, line 1
changed language setting to us_english.
1>select count (*) from v_standard_staff;
This shows that the installation of freetds was successful
Add sqlserver driver to odbc
Write the following:
Save and exit
Write the following
Note that the driver should write the driver name in odbcinst.ini,database is the name of the database
Save and exit.
Test odbc connection
#bin/isql -v atsdb autotest autotest cd/usr/local/unixodbc/bin ./isql -v atsdb selasreader only4selas sql> sql>quit
- python - you may need to restart the kernel to use updated packages error
- php - coincheck api authentication doesn't work
- php - i would like to introduce the coincheck api so that i can make payments with bitcoin on my ec site
- [php] i want to get account information using coincheck api
- the emulator process for avd pixel_2_api_29 was killed occurred when the android studio emulator was started, so i would like to
- python 3x - typeerror: 'method' object is not subscriptable
- i want to call a child component method from a parent in vuejs
- xcode - pod install [!] no `podfile 'found in the project directory
- sh - 'apt-get' is not recognized as an internal or external command, operable program or batch file