I use latest odbc driver to connect from windows7/windows 2008 to h2 (latest).
In my odbc client I don't see any tables I created in the test database. I can make visible only information.schema tables, but they result with error about foreign key. Here what I have in log. [176936-0.000]globals.extra_systable_prefixes = 'dd_;' [176936-0.001]exe name=alpha5 plaformId=2 [176936-0.002][[SQLAllocHandle]][176936-0.002]**** in PGAPI_AllocEnv ** [176936-0.003]** exit PGAPI_AllocEnv: phenv = 09882DC0 ** [176936-0.003][[SQLSetEnvAttr]] att=200,3 [176936-0.004][[SQLAllocHandle]][176936-0.004]PGAPI_AllocConnect: entering... [176936-0.005]**** PGAPI_AllocConnect: henv = 09882DC0, conn = 09882DF0 [176936-0.005]EN_add_connection: self = 09882DC0, conn = 09882DF0 [176936-0.006] added at 0, conn->henv = 09882DC0, conns[0]->henv = 09882DC0 [176936-0.007][SQLGetInfoW(30)][176936-0.007]PGAPI_GetInfo: entering...fInfoType=77 [176936-0.008]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=12 [176936-0.009][SQLSetConnectAttrW][176936-0.009]PGAPI_SetConnectAttr for 09882DF0: 115 00000001 [176936-0.010]the application is ansi [176936-0.010][SQLSetConnectAttrW][176936-0.010]PGAPI_SetConnectAttr for 09882DF0: 102 00000001 [176936-0.011]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 [176936-0.012][SQLSetConnectAttrW][176936-0.012]PGAPI_SetConnectAttr for 09882DF0: 103 00000005 [176936-0.013]PGAPI_SetConnectOption: entering fOption = 103 vParam = 5 [176936-0.014][SQLSetConnectAttrW][176936-0.014]PGAPI_SetConnectAttr for 09882DF0: 113 00000000 [176936-0.015]CC_error_statements: self=09882DF0 [176936-0.015]CONN ERROR: func=PGAPI_SetConnectAttr, desc='', errnum=216, errmsg='Couldn't set unsupported connect attribute 113' [176936-0.016][SQLDriverConnectW][176936-0.017]PGAPI_DriverConnect: entering... [176936-0.018]**** PGAPI_DriverConnect: fDriverCompletion=0, connStrIn='DSN=h2;' [176936-0.018]our_connect_string = 'DSN=h2;' [176936-0.019]attribute = 'DSN', value = 'h2' [176936-0.019]copyAttributes: DSN='h2',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1) [176936-0.021]getDSNinfo: DSN=h2 overwrite=0 [176936-0.022]rollback_on_error=1 [176936-0.023]force_abbrev=0 bde=0 cvt_null_date=0 [176936-0.025]globals.extra_systable_prefixes = '' [176936-0.025]our_connect_string = 'DSN=h2;' [176936-0.025]attribute = 'DSN', value = 'h2' [176936-0.026]copyCommonAttributes: A7=100;A8=4096;A9=0;B0=255;B1=8190;B2=0;B3=0;B4=0;B5=1;B6=0;B7=1;B8=1;B9=1;C0=0;C1=0;C2=[176936-20.189]PGAPI_Disconnect: about to CC_cleanup [176936-20.189]in CC_Cleanup, self=09882DF0 [176936-20.190]after CC_abort [176936-20.190]SOCK_Destructor [176936-20.190]after SOCK destructor [176936-20.191]exit CC_Cleanup [176936-20.191]PGAPI_Disconnect: done CC_cleanup [176936-20.192]PGAPI_Disconnect: returning... [176936-20.192][[SQLFreeHandle]][176936-20.192]PGAPI_FreeConnect: entering... [176936-20.193]**** in PGAPI_FreeConnect: hdbc=09882DF0 [176936-20.193]enter CC_Destructor, self=09882DF0 [176936-20.194]in CC_Cleanup, self=09882DF0 [176936-20.194]after SOCK destructor [176936-20.195]exit CC_Cleanup [176936-20.195]after CC_Cleanup [176936-20.196]after free statement holders [176936-20.197]exit CC_Destructor [176936-20.197]PGAPI_FreeConnect: returning... [176936-20.197][[SQLFreeHandle]][176936-20.198]**** in PGAPI_FreeEnv: env = 09882DC0 ** [176936-20.198]in EN_Destructor, self=09882DC0 [176936-20.199]clearing conns count=128 [176936-20.199]exit EN_Destructor: rv = 1 [176936-20.199] ok [176936-20.200]DETACHING PROCESS There is no error in it. But no tables I receive. Could anybody suggest how to deal with odbc preferences, or may be there is another option? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
