ok sorry for that i newbie on this forum... ok go to explain.... i read on this article http://www.theserverside.com/news/thread.tss?thread_id=46456 on one of his comment that is posible use pgadminIII (client of postgresql) for open one h2 database so i put my effort on do this....
first step read h2 documentation...this part... http://www.h2database.com/html/advanced.html?highlight=odbc&search=od#odbc_driver later download odbc http://visionmap.googlecode.com/files/setup_psqlODBC_x64_8.3.4.0.exe AND http://ftp5.ca.postgresql.org/mirrors/postgresql/odbc/versions/msi/psqlodbc_08_04_0200.zip creating the Data Source like show this image adding info of thwe h2 db <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2_3.png?gda=byXeq0UAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaDGD-63FskLJHjQzLSsOsfKO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=7> also add the recommended property <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2_4.png?gda=fTGcYkUAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaGZ3hISrkpJ03AoKAPC-_0OO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=8> and finally the conection was successful <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2_5.png?gda=H6nFjkUAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaDHfWR9MQsqn3d9DwNOm_tyO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=9> and this is show on the list of datasources <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2_2.png?gda=5dJcfUUAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaNVDjS_7cNi6CkI0kpiLKAiO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=6> later go to my h2 db and creates schema "pg_catalog" <https://h2-database.googlegroups.com/attach/3f918641a0b40326/PGADMINH2_6.png?gda=i-aSzkUAAAChcZLlTA4cMBYzjwytg3-zk4Z7sdVIiE3DuTK-SNyVNeaKHb7y3klqGEfS0xbnxraO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=4> all is OK :D but now is that not works on pgadmin on this photo show the information of the register server... <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2.png?gda=B-_9h0UAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaA0X3KedR5Iagbu5ww-xKBSO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=4> and when go to open this..show me this message <https://h2-database.googlegroups.com/attach/529ab6ed77c852f5/PGADMINH2_1.png?gda=mZR6_kUAAABzFZHQYJ7hCYRhIWWcr2vorl9B-zJfCXp4zf3YbBLyaAV35cvLTg58Hlxp0oDvzXWO3f1cykW9hbJ1ju6H3kglGu1iLHeqhw4ZZRj3RjJ_-A&view=1&part=5> and none databases ...this is bad... well i hope this is a better to understand Thotheolh ..thanks for the reply -- 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.
