For Strace command i got the output as below::::::<br> strace odbcinst -u -s -l -n MSSQLTestServer<br>execve("/usr/local/bin/odbcinst", ["odbcinst", "-u", "-s", "-l", "-n", "MSSQLTestServer"], [/* 22 vars */]) = 0<br>
brk(0) = 0x8f73000<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>mmap2(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f07000<br>
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)<br>open("/etc/ld.so.cache", O_RDONLY) = 3<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=59363, ...}) = 0<br>mmap2(NULL, 59363, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7ef8000<br>
close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/usr/local/lib/libodbcinst.so.1", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\"\0"..., 512) = 512<br>
fstat64(3, {st_mode=S_IFREG|0755, st_size=447533, ...}) = 0<br>mmap2(NULL, 88136, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7ee2000<br>mmap2(0xb7ef6000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13) = 0xb7ef6000<br>
close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/lib/tls/i686/cmov/libdl.so.2", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 \n\0\000"..., 512) = 512<br>
fstat64(3, {st_mode=S_IFREG|0644, st_size=9676, ...}) = 0<br>mmap2(NULL, 12408, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7ede000<br>mmap2(0xb7ee0000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1) = 0xb7ee0000<br>
close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/lib/tls/i686/cmov/libpthread.so.0", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0000H\0\000"..., 512) = 512<br>
fstat64(3, {st_mode=S_IFREG|0755, st_size=116457, ...}) = 0<br>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7edd000<br>mmap2(NULL, 98784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7ec4000<br>
mmap2(0xb7ed9000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14) = 0xb7ed9000<br>mmap2(0xb7edb000, 4576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7edb000<br>close(3) = 0<br>
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/lib/tls/i686/cmov/libc.so.6", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\340g\1"..., 512) = 512<br>
fstat64(3, {st_mode=S_IFREG|0755, st_size=1425800, ...}) = 0<br>mmap2(NULL, 1431152, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d66000<br>mmap2(0xb7ebe000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x158) = 0xb7ebe000<br>
mmap2(0xb7ec1000, 9840, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7ec1000<br>close(3) = 0<br>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7d65000<br>
set_thread_area({entry_number:-1 -> 6, base_addr:0xb7d656b0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}) = 0<br>mprotect(0xb7ebe000, 8192, PROT_READ) = 0<br>
mprotect(0xb7ed9000, 4096, PROT_READ) = 0<br>mprotect(0xb7ee0000, 4096, PROT_READ) = 0<br>mprotect(0xb7ef6000, 4096, PROT_READ) = 0<br>mprotect(0x804d000, 4096, PROT_READ) = 0<br>mprotect(0xb7f24000, 4096, PROT_READ) = 0<br>
munmap(0xb7ef8000, 59363) = 0<br>set_tid_address(0xb7d656f8) = 19334<br>set_robust_list(0xb7d65700, 0xc) = 0<br>futex(0xbfd24d00, 0x81 /* FUTEX_??? */, 1) = 0<br>rt_sigaction(SIGRTMIN, {0xb7ec82e0, [], SA_SIGINFO}, NULL, 8) = 0<br>
rt_sigaction(SIGRT_1, {0xb7ec8720, [], SA_RESTART|SA_SIGINFO}, NULL, 8) = 0<br>rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0<br>getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0<br>uname({sys="Linux", node="sathiya", ...}) = 0<br>
getuid32() = 0<br>brk(0) = 0x8f73000<br>brk(0x8f94000) = 0x8f94000<br>socket(PF_FILE, SOCK_STREAM, 0) = 3<br>fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br>
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)<br>close(3) = 0<br>socket(PF_FILE, SOCK_STREAM, 0) = 3<br>fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0<br>
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)<br>close(3) = 0<br>open("/etc/nsswitch.conf", O_RDONLY) = 3<br>
fstat64(3, {st_mode=S_IFREG|0644, st_size=513, ...}) = 0<br>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f06000<br>read(3, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 513<br>
read(3, "", 4096) = 0<br>close(3) = 0<br>munmap(0xb7f06000, 4096) = 0<br>open("/etc/ld.so.cache", O_RDONLY) = 3<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=59363, ...}) = 0<br>
mmap2(NULL, 59363, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7ef8000<br>close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/lib/tls/i686/cmov/libnss_compat.so.2", O_RDONLY) = 3<br>
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\16\0"..., 512) = 512<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=30436, ...}) = 0<br>mmap2(NULL, 33356, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d5c000<br>
mmap2(0xb7d63000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x6) = 0xb7d63000<br>close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>
open("/lib/tls/i686/cmov/libnsl.so.1", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\00001\0\000"..., 512) = 512<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=87804, ...}) = 0<br>
mmap2(NULL, 100328, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d43000<br>mmap2(0xb7d58000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14) = 0xb7d58000<br>mmap2(0xb7d5a000, 6120, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7d5a000<br>
close(3) = 0<br>mprotect(0xb7d58000, 4096, PROT_READ) = 0<br>mprotect(0xb7d63000, 4096, PROT_READ) = 0<br>munmap(0xb7ef8000, 59363) = 0<br>open("/etc/ld.so.cache", O_RDONLY) = 3<br>
fstat64(3, {st_mode=S_IFREG|0644, st_size=59363, ...}) = 0<br>mmap2(NULL, 59363, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7ef8000<br>close(3) = 0<br>access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>
open("/lib/tls/i686/cmov/libnss_nis.so.2", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\31\0"..., 512) = 512<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=38448, ...}) = 0<br>
mmap2(NULL, 41532, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d38000<br>mmap2(0xb7d41000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8) = 0xb7d41000<br>close(3) = 0<br>
access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)<br>open("/lib/tls/i686/cmov/libnss_files.so.2", O_RDONLY) = 3<br>read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\30"..., 512) = 512<br>
fstat64(3, {st_mode=S_IFREG|0644, st_size=42508, ...}) = 0<br>mmap2(NULL, 45720, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d2c000<br>mmap2(0xb7d36000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9) = 0xb7d36000<br>
close(3) = 0<br>mprotect(0xb7d36000, 4096, PROT_READ) = 0<br>mprotect(0xb7d41000, 4096, PROT_READ) = 0<br>munmap(0xb7ef8000, 59363) = 0<br>open("/etc/passwd", O_RDONLY|0x80000 /* O_??? */) = 3<br>
fcntl64(3, F_GETFD) = 0x1 (flags FD_CLOEXEC)<br>_llseek(3, 0, [0], SEEK_CUR) = 0<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=1737, ...}) = 0<br>mmap2(NULL, 1737, PROT_READ, MAP_SHARED, 3, 0) = 0xb7f06000<br>
_llseek(3, 1737, [1737], SEEK_SET) = 0<br>munmap(0xb7f06000, 1737) = 0<br>close(3) = 0<br>open("/root/.odbc.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0<br>
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f06000<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0<br>_llseek(3, 0, [0], SEEK_SET) = 0<br>close(3) = 0<br>
munmap(0xb7f06000, 4096) = 0<br>open("/root/.odbc.ini", O_RDONLY) = 3<br>fstat64(3, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0<br>mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f06000<br>
read(3, "", 4096) = 0<br>close(3) = 0<br>munmap(0xb7f06000, 4096) = 0<br>fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 9), ...}) = 0<br>
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f06000<br>write(1, "odbcinst: DSN removed (if it exi"..., 89odbcinst: DSN removed (if it existed at all). ODBC_BOTH_DSN was used as the search path.<br>
) = 89<br>exit_group(0) = ?<br>Process 19334 detached<br><br><br><br><br><div class="gmail_quote">On Mon, Apr 19, 2010 at 4:15 PM, Nick Gorham <span dir="ltr"><<a href="mailto:nick.gorham@easysoft.com">nick.gorham@easysoft.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">sathiya dasan wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
Hi,<br>
I have successfully added datasource name to /usr/local/etc/odbc.ini file using the command<br>
"*odbcinst -i -s -l -f dsn.template*".<br>
Now am trying to remove datasourcename from system dsn by using the command "*odbcinst -u -s -l -n dsnName*".<br>
After executing the command, it throws the *output* as,<br></div>
*odbcinst: DSN removed (if it existed at all). ODBC_BOTH_DSN was used as the search path*.<br>
</blockquote>
I just tried it with current sources, and it seems to work fine. What version are you using?<br>
<br>
Maybe use strace to see if the command is doing what you expect?<br><font color="#888888">
<br>
-- <br>
Nick<br>
_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
</font></blockquote></div><br>