Quantcast

Problem with ODBC

classic Classic list List threaded Threaded
6 messages Options
Alexey Danilov Alexey Danilov
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Problem with ODBC

This post has NOT been accepted by the mailing list yet.
Hello

We try to use ODBC driver (x86 version)
I compile src with VC2010, install this driver, configure setup and when want to connect ... receive
messaage "ODBC version is not supported" ... I enable ODBC trace:
(and adding some LOG_MSG into entry_points.cpp (SQLAllocHandle and SQLSetEnvAttr)

SQLAllocHandle: entry_points:SQLAllocHandle called: 1 00669B64
ignite::SQLAllocHandle: odbc:SQLAllocHandle called
ignite::SQLAllocEnv: SQLAllocEnv called
SQLSetEnvAttr: entry_points:SQLSetEnvAttr called: 200 00000002, 0
ignite::SQLSetEnvAttr: SQLSetEnvAttr called
ignite::odbc::diagnostic::DiagnosableAdapter::AddStatusRecord: Adding new record: ODBC version is not supported.


In Environment odbcVersion=3, but when calling SQLSetEnvAttr from ODBC32.DLL in paramenters attr=200,value=2 !?
Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem with ODBC

Alexey Danilov wrote
Hello

We try to use ODBC driver (x86 version)
I compile src with VC2010, install this driver, configure setup and when want to connect ... receive
messaage "ODBC version is not supported" ... I enable ODBC trace:
(and adding some LOG_MSG into entry_points.cpp (SQLAllocHandle and SQLSetEnvAttr)

SQLAllocHandle: entry_points:SQLAllocHandle called: 1 00669B64
ignite::SQLAllocHandle: odbc:SQLAllocHandle called
ignite::SQLAllocEnv: SQLAllocEnv called
SQLSetEnvAttr: entry_points:SQLSetEnvAttr called: 200 00000002, 0
ignite::SQLSetEnvAttr: SQLSetEnvAttr called
ignite::odbc::diagnostic::DiagnosableAdapter::AddStatusRecord: Adding new record: ODBC version is not supported.


In Environment odbcVersion=3, but when calling SQLSetEnvAttr from ODBC32.DLL in paramenters attr=200,value=2 !?
Alexey,

First of all, please properly subscribe to the mailing list so that the community
can receive email notifications for your messages. To subscribe, send empty
email to user-subscribe@ignite.apache.org and follow simple instructions in
the reply.

Let me clarify, do you mean that you call SQLSetEnvAttr(..., SQL_ATTR_ODBC_VERSION, SQL_OV_ODBC3) but driver manager changes it to SQL_OV_ODBC2?

If this is true this it really weird. Can you specify which OS do you use?
Alexey Danilov Alexey Danilov
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem with ODBC

This post has NOT been accepted by the mailing list yet.
Igor,

in system panel - OS windows 8.1 x64

in odbc panel - c:\windows\system32\odbc32.dll ver. 6.3.9600.17415

Info by Depends utility
Dependency Walker: 2.2.6000 (32-bit)
Operating System: Microsoft Windows NT/2000/XP/2003/Vista based Enterprise (64-bit)
OS Version: 6.02.9200
Processor: Intel64 Family 6 Model 58 Stepping 9, GenuineIntel, ~2794MHz
Number of Processors: 4, Mask: 0x0000000F
Local Time: 11:09:58 RTZ 2 ( (GMT+03:00)
OS Language: 0x0419: Russian
Alexey Danilov Alexey Danilov
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem with ODBC

This post has NOT been accepted by the mailing list yet.
In reply to this post by Igor Sapego
Igor,
entry_pointes.cpp:
SQLRETURN SQL_API SQLSetEnvAttr(SQLHENV     env,
                                SQLINTEGER  attr,
                                SQLPOINTER  value,
                                SQLINTEGER  valueLen)
calling from ODBC32.DLL (after call SQLAllocHandle)
with parameters attr=200,value=00000002,valueLen=0
Alexey Danilov Alexey Danilov
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem with ODBC

This post has NOT been accepted by the mailing list yet.
Igor,

May be problem into ... many version of file sql.h on my comp?

C:\MinGW\include\sql.h
C:\PB10\Shared\PowerBuilder\cgen\h\nt\sql.h
C:\PB9\Shared\PowerBuilder\cgen\h\nt\sql.h
C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Include\sql.h
C:\Program Files (x86)\Windows Kits\8.0\Include\um\sql.h
C:\Qt\Tools\mingw492_32\i686-w64-mingw32\include\sql.h
C:\vc6\sql.h

in VC2010 includes path
$(VCInstallDir)include
$(VCInstallDir)atlmfc\include
$(WindowsSdkDir)include
$(FrameworkSDKDir)\include
$(IGNITE_HOME)\platforms\cpp\jni\include;
$(IGINITE_HOME)\platforms\cpp\common\include;
$(IGNITE_HOME)\platforms\cpp\common\os\win\include;
$(IGNITE_HOME)\platforms\cpp\binary\include;
$(IGNITE_HOME)\platforms\cpp\core\include;
$(JAVA_HOME)\include;
$(JAVA_HOME)\include\win32;$(IncludePath)

VCInstallDir = C:\Program Files (x86)\Microsoft Visual Studio 10.0\
WindowsSdkDir = C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\
FrameworkSDKDir = C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\
IGNITE_HOME = D:\Projects.C++\ignite
JAVA_HOME = C:\Program Files\Java\jdk1.8.0_45
Igor Sapego Igor Sapego
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem with ODBC

Alexey,

Do you have the same issue with the 64-bit version driver?
Loading...