[Forwarded to the list because our ISP seems to be on the blacklist Larry is using :-( ]
Hi Larry,
Try:
SELECT * FROM "People" WHERE "NameType" = 2 ORDER BY "LastName","FirstName","MiddleName"
Mixed case names must be quoted in PostgreSQL. The other easy way around it is to create (or rename) all your objects with lower case names.
Regards, Dave.
Thank you Dave, we figured it out using dropdb.
Another question: what is the proper .Provider string or .ConnectionString to connect to a PostgreSQL db from VB6 using ADO?
Here is what I tried:
.ConnectionString = "driver={PostgreSQL};server=ABCDATA;uid=lreagor;pwd=test123;database=BodyBuilder"
My SQL string to open the recordset is:
"SELECT * FROM People WHERE NameType = 2 ORDER BY LastName,FirstName,MiddleName"
It seems I get an error once I try to connect and open a recordset:
"Error while executing the query; ERROR: relation 'People' does not exist." (error -2147467259)
Larry
The code that *should* work was written was left in. I suppose it should be commented out though. If you're interested, the reason you can't drop the database is because Microsoft ADO helpfully keeps the connection open for reuse should we need it (a technique called pooling).
Regards, Dave.
I was able to drop an unwanted one earlier from pgAdmin (pgAdmin II) when I was just testing the Access migration plug in. Why is there a drop command available for databases if I can't do it from pgAdmin?
Larry
I attempt to delete (drop) a database and get the following message.
I am the only user. What do I have to do to delete an unwanted database?
Regards, Dave.