Hi, > but they result with error about foreign key.
Is there an database exception, if yes could you post it (the complete error message including error code and stack trace)? Regards, Thomas On Wednesday, September 28, 2011, Vadim K wrote: > 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]<javascript:;> > . > To unsubscribe from this group, send email to > [email protected] <javascript:;>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- 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.
