Re: [Iodbc-bugs] SQLDriverConnect = (2704) SQLSTATE=

[Hugh W. <hwi...@op...>]

Hi Theo,

What version of iODBC are you using as this looks like a possible problem in
the iodbctest sample program, which used an incorrect param in the
SQLDriverConnect() call at one point, and is fixed in iODBC 3.52.3 versions
and above as detailed in the following iODBC FAQ:

    http://www.iodbc.org/index.php?page=docs/faq#iodbc512142108

Hope this solves your problem ...

Best Regards,
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers

On 31/01/2008 20:37, "Oksel Man" <oks...@ho...> wrote:

> Hi,
>  
> When trying to establish a connection with a Datadirect ODBC driver, I get an
> error on connection :
>  
>> $ ./iodbctest
>> iODBC Demonstration program
>> This program shows an interactive SQL processor
>> Driver Manager: 03.52.0607.1008
>> Enter ODBC connect string (? shows list): ?
>> DSN                              | Driver
>> 
----------------------------------------------------------------------------->>
-
>> OraWP                            | DataDirect 5.3 Oracle Wire Protocol
>> Enter ODBC connect string (? shows list): DSN=OraWP;UID=scott;PWD=tiger
>> 1: SQLDriverConnect =  (2704) SQLSTATE=
>> 1: ODBC_Connect =  (2704) SQLSTATE=
> 
> My DataSource config :
>> [OraWP3]
>> Driver=/opt/odbc32v53/lib/ivora23.so
>> HostName=<My Server IP>
>> PortNumber=1521
>> SID=ora10r2
> a trace looks like :
>> [000033.072539]
>> iodbctest       00000000 ENTER SQLDriverConnect
>>                 SQLHDBC           0x8e0fb78
>>                 SQLPOINTER        0x0
>>                 SQLCHAR         * 0xbfff9c00
>>                                   | DSN=OraWP;UID=scott;PWD=*****
>> |
>>                 SQLSMALLINT       -3 (SQL_NTS)
>>                 SQLCHAR         * 0x80827a0
>>                 SQLSMALLINT       4096
>>                 SQLSMALLINT     * 0xbfff97ca
>>                 SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)
>> 
>> [000033.081839]
>> iodbctest       B75E7AC0 EXIT  SQLDriverConnect with return code -1
>> (SQL_ERROR)
>>                 SQLHDBC           0x8e0fb78
>>                 SQLPOINTER        0x0
>>                 SQLCHAR         * 0xbfff9c00
>>                 SQLSMALLINT       -3 (SQL_NTS)
>>                 SQLCHAR         * 0x80827a0
>>                 SQLSMALLINT       4096
>>                 SQLSMALLINT     * 0xbfff97ca
>>                 SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)
>>                 
> 
> If I try the driver with a different Driver manager (UnixODBC, DataDirect)
> this connection string works fine.
> When using another driver with iODBC I am also able to connect.
> 
>  
> 
> I looked up error 2704 :
>> 
>> -2704: Dialog failed
>> ODBC Error. During the call of SQLDriverConnect() the driver attempted to
>> display its login dialog and failed.
> Why would the driver attempt to display a login dialog? the connection string
> provided contains enough information to connect.
> What can I do to resolve this issue?
>  
> Thanks,
>  
> Theo
> 
> 
> Express yourself instantly with MSN Messenger! MSN Messenger
> <http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/>
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> 
> _______________________________________________
> Iodbc-bugs mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-bugs
> 
>