Title: Message
|
If you
leave your identifiers as they are (i.e. mixed case, unquoted) then use your
existing mixed case names in Access, and lower case names in PostgreSQL,
everything should be OK.
Regards, Dave.
Wow.
Ok, since I started on this particular project using an
Access database for the backend with the idea now of migrating to PostgreSQL,
if I change my syntax as you suggest for mixed case, will the Access db choke
on it? If I were to switch to SQL Server or Oracle, etc after changing the
syntax, would they accept the quoted syntax?
Thanks.
Larry
[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.
|
