FreeTDS Development Group

["Grieve, Shane (TIFPC)" <SGrieve AT templeinland.com>]

I am using freetds 0.60 on Solaris 8 64bit, and I have tried against
unixodbc and iodbc, I can connect with ISQl but any other ODBC attempt to
connect fails with this error.

Here is the truss from ODBC test. Thank You

- Shane


bash-2.03# truss /usr/local/bin/odbctest DSN=sql_lite
execve("/export/local/bin/odbctest", 0xFFBEFD64, 0xFFBEFD70)  argc = 2
mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON,
-1, 0) = 0xFF3A0000
resolvepath("/usr/lib/ld.so.1", "/usr/lib/ld.so.1", 1023) = 16
stat("/export/local/bin/odbctest", 0xFFBEFAA0)  = 0
open("/var/ld/ld.config", O_RDONLY)             Err#2 ENOENT
open("./libiodbc.so.2", O_RDONLY)               Err#2 ENOENT
open("/usr/local/lib/libiodbc.so.2", O_RDONLY)  = 3
fstat(3, 0xFFBEF434)                            = 0
mmap(0x00000000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF390000
mmap(0x00000000, 204800, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF350000
mmap(0xFF37E000, 8540, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 122880) = 0xFF37E000
munmap(0xFF370000, 57344)                       = 0
memcntl(0xFF350000, 10568, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("./libdl.so.1", O_RDONLY)                  Err#2 ENOENT
open("/usr/local/lib/libdl.so.1", O_RDONLY)     Err#2 ENOENT
open("/usr/local/lib/libdl.so.1", O_RDONLY)     Err#2 ENOENT
open("/usr/lib/libdl.so.1", O_RDONLY)           = 3
fstat(3, 0xFFBEF434)                            = 0
mmap(0xFF390000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF390000
close(3)                                        = 0
open("./libc.so.1", O_RDONLY)                   Err#2 ENOENT
open("/usr/local/lib/libc.so.1", O_RDONLY)      Err#2 ENOENT
open("/usr/local/lib/libc.so.1", O_RDONLY)      Err#2 ENOENT
open("/usr/lib/libc.so.1", O_RDONLY)            = 3
fstat(3, 0xFFBEF434)                            = 0
mmap(0x00000000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF340000
mmap(0x00000000, 786432, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF200000
mmap(0xFF2B8000, 24812, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 688128) = 0xFF2B8000
munmap(0xFF2A8000, 65536)                       = 0
memcntl(0xFF200000, 113332, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("./libnsl.so.1", O_RDONLY)                 Err#2 ENOENT
open("/usr/local/lib/libnsl.so.1", O_RDONLY)    Err#2 ENOENT
open("/usr/lib/libnsl.so.1", O_RDONLY)          = 3
fstat(3, 0xFFBEF434)                            = 0
mmap(0xFF340000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF340000
mmap(0x00000000, 704512, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF100000
mmap(0xFF19C000, 32740, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 573440) = 0xFF19C000
mmap(0xFF1A4000, 30928, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED|MAP_ANON, -1, 0) = 0xFF1A4000
munmap(0xFF18C000, 65536)                       = 0
memcntl(0xFF100000, 82248, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("./libmp.so.2", O_RDONLY)                  Err#2 ENOENT
open("/usr/local/lib/libmp.so.2", O_RDONLY)     Err#2 ENOENT
open("/usr/lib/libmp.so.2", O_RDONLY)           = 3
fstat(3, 0xFFBEF434)                            = 0
mmap(0xFF340000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF340000
mmap(0x00000000, 90112, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF320000
mmap(0xFF334000, 865, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_FIXED,
3, 16384) = 0xFF334000
munmap(0xFF324000, 65536)                       = 0
memcntl(0xFF320000, 3124, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("/usr/platform/SUNW,Ultra-80/lib/libc_psr.so.1", O_RDONLY) = 3
fstat(3, 0xFFBEF2C4)                            = 0
mmap(0xFF340000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF340000
mmap(0x00000000, 16384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF310000
close(3)                                        = 0
munmap(0xFF340000, 8192)                        = 0
ioctl(1, TCGETA, 0xFFBEEEFC)                    = 0
iODBC Demonstration program
write(1, " i O D B C   D e m o n s".., 28)      = 28
This program shows an interactive SQL processor
write(1, " T h i s   p r o g r a m".., 48)      = 48
brk(0x000220A8)                                 = 0
brk(0x000240A8)                                 = 0
access("//.odbc.ini", 4)                        = 0
open("//.odbc.ini", O_RDONLY)                   = 3
fstat64(3, 0xFFBEE090)                          = 0
brk(0x000240A8)                                 = 0
brk(0x000260A8)                                 = 0
ioctl(3, TCGETA, 0xFFBEE01C)                    Err#25 ENOTTY
read(3, " ;\n ;     o d b c . i n".., 8192)     = 851
read(3, 0x00022B2C, 8192)                       = 0
llseek(3, 0, SEEK_CUR)                          = 851
close(3)                                        = 0
access("//.odbc.ini", 4)                        = 0
open("//.odbc.ini", O_RDONLY)                   = 3
fstat64(3, 0xFFBEE090)                          = 0
ioctl(3, TCGETA, 0xFFBEE01C)                    Err#25 ENOTTY
read(3, " ;\n ;     o d b c . i n".., 8192)     = 851
read(3, 0x00023134, 8192)                       = 0
llseek(3, 0, SEEK_CUR)                          = 851
close(3)                                        = 0
access("//.odbc.ini", 4)                        = 0
open("//.odbc.ini", O_RDONLY)                   = 3
fstat64(3, 0xFFBEE1F0)                          = 0
ioctl(3, TCGETA, 0xFFBEE17C)                    Err#25 ENOTTY
read(3, " ;\n ;     o d b c . i n".., 8192)     = 851
read(3, 0x00023134, 8192)                       = 0
llseek(3, 0, SEEK_CUR)                          = 851
close(3)                                        = 0
access("//.odbc.ini", 4)                        = 0
open("//.odbc.ini", O_RDONLY)                   = 3
fstat64(3, 0xFFBEE1F0)                          = 0
ioctl(3, TCGETA, 0xFFBEE17C)                    Err#25 ENOTTY
read(3, " ;\n ;     o d b c . i n".., 8192)     = 851
llseek(3, 0xFFFFFFFFFFFFFEF8, SEEK_CUR)         = 587
close(3)                                        = 0
open("/usr/local/freetds4/lib/libtdsodbc.so", O_RDONLY) = 3
fstat(3, 0xFFBEE8B4)                            = 0
mmap(0x00000000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0xFF340000
mmap(0x00000000, 204800, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF2D0000
mmap(0xFF2FC000, 17840, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 114688) = 0xFF2FC000
munmap(0xFF2EE000, 57344)                       = 0
memcntl(0xFF2D0000, 21532, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("./libsocket.so.1", O_RDONLY)              Err#2 ENOENT
open("/usr/local/lib/libsocket.so.1", O_RDONLY) Err#2 ENOENT
open("/usr/local/lib/libsocket.so.1", O_RDONLY) Err#2 ENOENT
open("/usr/lib/libsocket.so.1", O_RDONLY)       = 3
fstat(3, 0xFFBEE7F4)                            = 0
mmap(0xFF340000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF340000
mmap(0x00000000, 114688, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF1E0000
mmap(0xFF1FA000, 4365, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 40960) = 0xFF1FA000
munmap(0xFF1EA000, 65536)                       = 0
mmap(0x00000000, 8192, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANON,
-1, 0) = 0xFF1D0000
memcntl(0xFF1E0000, 14496, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
open("./libiconv.so.2", O_RDONLY)               Err#2 ENOENT
open("/usr/local/lib/libiconv.so.2", O_RDONLY)  = 3
fstat(3, 0xFFBEE7F4)                            = 0
mmap(0xFF340000, 8192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_FIXED, 3, 0) =
0xFF340000
mmap(0x00000000, 720896, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0xFF000000
mmap(0xFF0AA000, 23492, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_FIXED, 3, 630784) = 0xFF0AA000
munmap(0xFF09C000, 57344)                       = 0
memcntl(0xFF000000, 34624, MC_ADVISE, MADV_WILLNEED, 0, 0) = 0
close(3)                                        = 0
munmap(0xFF340000, 8192)                        = 0
llseek(0, 0, SEEK_CUR)                          = 4944329
open("/usr/local/freetds4/etc/locales.conf", O_RDONLY) = 3
fstat64(3, 0xFFBEE8E8)                          = 0
ioctl(3, TCGETA, 0xFFBEE874)                    Err#25 ENOTTY
read(3, " [ d e f a u l t ]\n\t d".., 8192)     = 124
llseek(0, 0, SEEK_CUR)                          = 4944549
llseek(3, 0xFFFFFFFFFFFFFF8E, SEEK_CUR)         = 10
read(3, "\t d a t e   f o r m a t".., 8192)     = 114
read(3, 0x000236B4, 8192)                       = 0
llseek(3, 0, SEEK_CUR)                          = 124
close(3)                                        = 0
munmap(0xFF2FC000, 18616)                       = 0
munmap(0xFF2D0000, 120154)                      = 0
munmap(0xFF1FA000, 4960)                        = 0
munmap(0xFF1E0000, 40558)                       = 0
munmap(0xFF0AA000, 23496)                       = 0
munmap(0xFF000000, 634026)                      = 0
[iODBC][Driver Manager]Driver's SQLAllocEnv() failedwrite(2, " [ i O D B C ]
[ D r i v".., 52)  = 52
, SQLSTATE=write(2, " ,   S Q L S T A T E =", 11)               = 11
IM004write(2, " I M 0 0 4", 5)                  = 5

write(2, "\n", 1)                               = 1

Have a nice day.write(1, "\n H a v e   a   n i c e".., 17)      = 17
llseek(0, 0, SEEK_CUR)                          = 4945239
_exit(0)


Shane Grieve 
Unix Systems Administrator, Server Services
Temple Inland Forest Products
(936) 829 7471
Sgrieve AT templeinland.com


-----Original Message-----
From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
Sent: Friday, October 11, 2002 8:23 AM
To: TDS Development Group
Subject: [freetds] RE: Initialization function SQLAllocConnect not found


This is quite strange...

$ nm libtdsodbc.so | grep SQLAllocConnect
00005660 T SQLAllocConnect
000055f4 t _SQLAllocConnect


What version of FreeTDS are you using? What environment (Operating system
and version, odbc driver manager...)

freddy77


> 
> 
> Can anyone please shed some light on this error, I apologize 
> for reposting
> but I really need to get some direction on this soon.
> 
> Initialization function SQLAllocConnect not found
> 
> 
> Thanks in Advance for the help
> 
> Shane Grieve 
> Unix Systems Administrator, Server Services
> Temple Inland Forest Products
> Sgrieve AT templeinland.com
> 

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================

---
You are currently subscribed to freetds as: [SGrieve AT templeinland.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')