Re: Hurrah!
ZoneAlarm >What was wrong with your PostgreSQL? > >Regards, Dave.
buildall.bat problem
In italian version the dircetory "program files" is "programmi". Use the global variable %ProgramFiles% for specify program directory. E.s "%ProgramFiles%\Microsoft Visual Studio\VB98\VB6.EXE" /make ..\pgschema\pgSchema.vbp /outdir ..\binaries Sorry for my english Frank Lupo (Wolf) !! -- Frank Lupo (Wolf) !! Questo messaggio e' stato inviato con Telemail http://www.telemail.it , La freemail per la comunicazione unificata gratuita
Devel / Release on same pc / Mark's ZIP of Designer code
>Compatibility. With pgAdmin I, by far the most common faq was answered with >'install MDAC 2.6 or higher'. I don't remember getting that question at all >since we released pgAdmin II. Yup. However I noticed when running 1.3.25 devel (or whatever it curerntly is) I had to install MDAC2.7 in order to get ADO 2.7 Ext for DDL and Security (Migration vbp). Fortunately I had already downloaded it a few weeks back but had not got round to installing it! > > 2. I tried running pgAdmin from VB and it stops on > > frmMain.svr.DeferConnection = True > > saying Defer connection is not a member of this svr object (which I > > sussed whas a ref to pgSchema).checking references it is pointing to > > the pgschema.dll thats in the 1.2.0 release build in my program > > files\pgadmin directory. I have downloaded the cvs tree (from 2 days > > back) into a separate place. > > I downloaded the vbp of pgschema I downloaded this AM and I cant find > > the deferconnection member in the latest pgschema. I pointed the > > refernces at a download of the binaries download of pgSchema and it > > says error 430:class does not support expected interface. Should I be > > doing a buildall before ever trying to run the code I download? > >I wrote a guide for this last night - it's in >pgadmin2/help/html/developerinfo/devenv.html. Basically you can develop and >run a release version on the same box. You're right though, uninstall the >installed version, then run BuildAll.bat. Ta. Sort of guessed there are troubles between a devel and a release version on same PC. I will follow this guidance. I did a buildall anyway, which helped, but I dont get many addins in the menu, so I will remove devel and do build all to see if much changes. I also got Mark's zip file installed and have started to tour round it a bit. Slowly getting up to speed on the basic layout of all code and object model. Well done with pgSchema, I can see how this is making life considerably easier. Has anyone else put on Mark's code yet to see where its up to? (other than Mark himself of course!) Tim Finch, FosterFinch Ltd http://www.fosterfinch.co.uk
ViewDesigner Code
Mark, Thanks, got the code and installed it. Am i right in thinking you have not doen any work yet to draw objects in the top pane for the tables/relationship lines? I saw a lot of stub procedures for many operations all which launch a new window - I guess you cut/paste a lot of code, huh? Any hints on getting anything work that DOES work so far? I managed to load a .SQL file and see the coloured syntax SQL in pane 3 but nothing in panes 1,2,4 - is that right? Great to have something already started on this feature, as it will give us all a chance to get places. I can forsee needing a CVS facility for it sooner rather than later. Do you anticipate seeing it as a add-in module a la Excel exporter etc. In this case it would fit very nicely into the plugins folder on the existing CVS. Dave, who do you deal with to get the pgadmin CVS facility arranged with to see about the idea of partial upload facility for Mark & I?? Exchanging Zips of code with instructions to merge in is barmy when CVS exists and is already used for this project? Alternatively, Mark, could we get a slot on Sourceforge/OSDN in the short term? Tim Finch, FosterFinch Ltd http://www.fosterfinch.co.uk
Here we go....
Dave/Jean, 1. Starting to tour round the code (at last). Any specific reason why you used ADO 2.0 library in pgSchema and not later version like 2.6? 2. I tried running pgAdmin from VB and it stops on frmMain.svr.DeferConnection = True saying Defer connection is not a member of this svr object (which I sussed whas a ref to pgSchema).checking references it is pointing to the pgschema.dll thats in the 1.2.0 release build in my program files\pgadmin directory. I have downloaded the cvs tree (from 2 days back) into a separate place. I downloaded the vbp of pgschema I downloaded this AM and I cant find the deferconnection member in the latest pgschema. I pointed the refernces at a download of the binaries download of pgSchema and it says error 430:class does not support expected interface. Should I be doing a buildall before ever trying to run the code I download?
A consult
Hello, I have this problem. Anybody can help me? Thanx! Bug using ADODB and Visual Basic for acceding PSQL We have a problem using ADODB (from Visual Basic) and POSTGRESQL when trying to use an unconnected recordset which´s property "locktype" is set to "adLockBatchOptimistic" (Rs.locktype=adLockBatchOptimistic). When trying to access to a database through ODBC, using ADODB, we have noticed an important delay in comparison to other databases such as SQLServer. Investigating this problem, we have detected where that delay is produced. The problem is produced when we are trying to get an unconnected recordset with the "adLockBatchOptimistic" block type. When it is trying to execute the query (tracing it) we have seen that arrives three select results, but only one of them corresponds to the sentence of the query but the other two are not. We conclude that the last two results are important to recover the recordset structure that will be disconnected later. The problem is that one of this two extra queries runs a complete select over the table that we are accessing with the written select.This table has a lot of records, and it turns the answer really slow because it brings all the talbe recordsets.But this records are not kept into the recordset. It only brings the data requested by the written sentence.Now, we present the Visual Basic code used to access the database and, after that, a log obtained through POSTGRE ODBC. Visual Basic Code Dim objRs As New ADODB.Recordset Dim objConn As New ADODB.Connection Dim strSql As String Dim strCadenaConexion As String strCadenaConexion = _ "DSN=contabilidad_psql;DATABASE=contabilidad;" & _ "SERVER=192.168.1.41;PORT=5432;UID=credito;PWD=;" objConn.Open strCadenaConexion strSql = "select * from agentes where id_sucursal = 7 and id_agente = 100" objRs.CursorLocation = adUseClient objRs.CursorType = adOpenStatic objRs.LockType = adLockBatchOptimistic Set objRs.ActiveConnection = objConn objRs.Open strSql objRs.ActiveConnection = Nothing objConn.Close MsgBox "Cant: " & objRs.RecordCount Log ODBC POSTGRE conn=409745072, query='select * from agentes where id_sucursal = 7 and id_agente = 100' [ fetched 1 rows ] conn=409745072, query='SELECT * FROM agentes' [ fetched 10773 rows ] conn=409745072, query='select ta.attname, ia.attnum from pg_attribute ta, pg_attribute ia, pg_class c, pg_index i where c.relname = 'agentes' AND c.oid = i.indrelid AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] order by ia.attnum' [ fetched 2 rows ] conn=409745072, PGAPI_Disconnect I hope you could help us to solve this problem. Thank you! GastónDescargue GRATUITAMENTE MSN Explorer en http://explorer.yupimsn.com/intl.asp.
Re: buildall.bat problem
Thanks Frank - I was unaware of that environment variable. I've committed an update to CVS. Regards, Dave. > -Original Message- > From: Frank_Lupo Frank_Lupo [mailto:[EMAIL PROTECTED]] > Sent: 06 March 2002 07:59 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] buildall.bat problem > > > In italian version the dircetory "program files" is > "programmi". Use the global variable %ProgramFiles% for > specify program directory. E.s "%ProgramFiles%\Microsoft > Visual Studio\VB98\VB6.EXE" /make ..\pgschema\pgSchema.vbp > /outdir ..\binaries > > Sorry for my english > Frank Lupo (Wolf) !! > -- > Frank Lupo (Wolf) !! > -- > -- > Questo messaggio e' stato inviato con Telemail > http://www.telemail.it , > La freemail per la > comunicazione unificata gratuita > > > ---(end of > broadcast)--- > TIP 6: Have you searched our list archives? > http://archives.postgresql.org
Re: Here we go....
Tim Finch allegedly said: > Dave/Jean, > > 1. Starting to tour round the code (at last). Any specific reason > why you used ADO 2.0 library in pgSchema and not later version like > 2.6? Compatibility. With pgAdmin I, by far the most common faq was answered with 'install MDAC 2.6 or higher'. I don't remember getting that question at all since we released pgAdmin II. > 2. I tried running pgAdmin from VB and it stops on > frmMain.svr.DeferConnection = True > saying Defer connection is not a member of this svr object (which I > sussed whas a ref to pgSchema).checking references it is pointing to > the pgschema.dll thats in the 1.2.0 release build in my program > files\pgadmin directory. I have downloaded the cvs tree (from 2 days > back) into a separate place. > I downloaded the vbp of pgschema I downloaded this AM and I cant find > the deferconnection member in the latest pgschema. I pointed the > refernces at a download of the binaries download of pgSchema and it > says error 430:class does not support expected interface. Should I be > doing a buildall before ever trying to run the code I download? I wrote a guide for this last night - it's in pgadmin2/help/html/developerinfo/devenv.html. Basically you can develop and run a release version on the same box. You're right though, uninstall the installed version, then run BuildAll.bat. Regards, Dave.
