pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedI am new to this
10+ messages / 5 participants
[nested] [flat]
* I am new to this
@ 1999-05-07 03:33 Khristos I. Khoury <ikhoury@user1.stritch.edu>
0 siblings, 0 replies; 10+ messages in thread
From: Khristos I. Khoury @ 1999-05-07 03:33 UTC (permalink / raw)
To: pgsql-interfaces
Greetings,
I am new to this and have very short time to complete this project, so
please excuse me if I this question has been asked before.
My situation:
I installed Postgress on Unix FreeBSD server 3.0 created a data base.
I can access data base from Microsoft Access97 with and update with no
problems. My project is to use Visual Basic 5.0 and be able to link to my
data base on the Unix server and upate information.
The problem I having is that VisData (Visual Data Manager) I see a
user:admin shwoing on the bottom left of the screen and everything is Read
Only. I checked The ODBC properties and made sure that ReadOnly was
unchecked. Also I gave full permission to anyone to access my Data Base on
the Unix server.
The question is what am I missing that is holding me from updating?
I tried in the option Worksapce to enter my username and password on the
Unix server Data Base to connect but it will not accept it..!!
Any help will be appreciated.
Khristos I Khoury
ikhoury@user1.stritch.edu
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-07 13:51 Michael J Davis <michael.j.davis@tvguide.com>
0 siblings, 1 reply; 10+ messages in thread
From: Michael J Davis @ 1999-05-07 13:51 UTC (permalink / raw)
To: 'Khristos I. Khoury' <ikhoury@user1.stritch.edu>; pgsql-interfaces
Turn on logging in the PostgreSQL ODBC driver and take a look in
c:\psqlodbc????.log after the error. This will show what is happening when
the error occurs.
-----Original Message-----
From: Khristos I. Khoury [SMTP:ikhoury@user1.stritch.edu]
Sent: Thursday, May 06, 1999 9:33 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] I am new to this
Greetings,
I am new to this and have very short time to complete this project,
so
please excuse me if I this question has been asked before.
My situation:
I installed Postgress on Unix FreeBSD server 3.0 created a data
base.
I can access data base from Microsoft Access97 with and update with
no
problems. My project is to use Visual Basic 5.0 and be able to link
to my
data base on the Unix server and upate information.
The problem I having is that VisData (Visual Data Manager) I see a
user:admin shwoing on the bottom left of the screen and everything
is Read
Only. I checked The ODBC properties and made sure that ReadOnly was
unchecked. Also I gave full permission to anyone to access my Data
Base on
the Unix server.
The question is what am I missing that is holding me from updating?
I tried in the option Worksapce to enter my username and password on
the
Unix server Data Base to connect but it will not accept it..!!
Any help will be appreciated.
Khristos I Khoury
ikhoury@user1.stritch.edu
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-07 15:17 Khristos I. Khoury <ikhoury@user1.stritch.edu>
parent: Michael J Davis <michael.j.davis@tvguide.com>
0 siblings, 1 reply; 10+ messages in thread
From: Khristos I. Khoury @ 1999-05-07 15:17 UTC (permalink / raw)
To: pgsql-interfaces
Dome that already, no luck.
Any other ideas?
On Fri, 7 May 1999, Michael J Davis wrote:
> Turn on logging in the PostgreSQL ODBC driver and take a look in
> c:\psqlodbc????.log after the error. This will show what is happening when
> the error occurs.
>
> -----Original Message-----
> From: Khristos I. Khoury [SMTP:ikhoury@user1.stritch.edu]
> Sent: Thursday, May 06, 1999 9:33 PM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] I am new to this
>
> Greetings,
> I am new to this and have very short time to complete this project,
> so
> please excuse me if I this question has been asked before.
> My situation:
> I installed Postgress on Unix FreeBSD server 3.0 created a data
> base.
> I can access data base from Microsoft Access97 with and update with
> no
> problems. My project is to use Visual Basic 5.0 and be able to link
> to my
> data base on the Unix server and upate information.
> The problem I having is that VisData (Visual Data Manager) I see a
> user:admin shwoing on the bottom left of the screen and everything
> is Read
> Only. I checked The ODBC properties and made sure that ReadOnly was
> unchecked. Also I gave full permission to anyone to access my Data
> Base on
> the Unix server.
> The question is what am I missing that is holding me from updating?
> I tried in the option Worksapce to enter my username and password on
> the
> Unix server Data Base to connect but it will not accept it..!!
> Any help will be appreciated.
>
>
>
> Khristos I Khoury
> ikhoury@user1.stritch.edu
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-07 15:49 Michael J Davis <michael.j.davis@tvguide.com>
0 siblings, 0 replies; 10+ messages in thread
From: Michael J Davis @ 1999-05-07 15:49 UTC (permalink / raw)
To: 'Khristos I. Khoury' <ikhoury@user1.stritch.edu>; pgsql-interfaces
What do you mean when you say 'Also I gave full permission to anyone
to access my Data Base on the Unix server'? Does this mean you executed a
"grant all to public on table_name" for all database objects (tables, views,
indexes, etc)? Since Access97 is working, this would imply that hba.conf is
configured correctly. I assume you are running Access97 and your VB
application from the same machine. You will either need to provide more
details and/or a copy of your psqlodbc log file.
-----Original Message-----
From: Khristos I. Khoury [SMTP:ikhoury@user1.stritch.edu]
Sent: Friday, May 07, 1999 9:17 AM
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] I am new to this
Dome that already, no luck.
Any other ideas?
On Fri, 7 May 1999, Michael J Davis wrote:
> Turn on logging in the PostgreSQL ODBC driver and take a look in
> c:\psqlodbc????.log after the error. This will show what is
happening when
> the error occurs.
>
> -----Original Message-----
> From: Khristos I. Khoury [SMTP:ikhoury@user1.stritch.edu]
> Sent: Thursday, May 06, 1999 9:33 PM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] I am new to this
>
> Greetings,
> I am new to this and have very short time to complete this
project,
> so
> please excuse me if I this question has been asked before.
> My situation:
> I installed Postgress on Unix FreeBSD server 3.0 created a
data
> base.
> I can access data base from Microsoft Access97 with and
update with
> no
> problems. My project is to use Visual Basic 5.0 and be able
to link
> to my
> data base on the Unix server and upate information.
> The problem I having is that VisData (Visual Data Manager) I
see a
> user:admin shwoing on the bottom left of the screen and
everything
> is Read
> Only. I checked The ODBC properties and made sure that
ReadOnly was
> unchecked. Also I gave full permission to anyone to access
my Data
> Base on
> the Unix server.
> The question is what am I missing that is holding me from
updating?
> I tried in the option Worksapce to enter my username and
password on
> the
> Unix server Data Base to connect but it will not accept
it..!!
> Any help will be appreciated.
>
>
>
> Khristos I Khoury
> ikhoury@user1.stritch.edu
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-07 15:53 Khristos I. Khoury <ikhoury@user1.stritch.edu>
parent: Khristos I. Khoury <ikhoury@user1.stritch.edu>
0 siblings, 1 reply; 10+ messages in thread
From: Khristos I. Khoury @ 1999-05-07 15:53 UTC (permalink / raw)
To: pgsql-interfaces
DSN info:
DSN='PostgreSQL',server='user3.stritch.edu',port='5432',dbase='vb5',user='ikhoury',passwd='123qwe'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
It says ReadOnly? On the other hand in Access it is Read-Write? Any clues?
Thanks
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] I am new to this
@ 1999-05-07 19:21 Byron Nikolaidis <byronn@solipsys.com>
parent: Khristos I. Khoury <ikhoury@user1.stritch.edu>
0 siblings, 1 reply; 10+ messages in thread
From: Byron Nikolaidis @ 1999-05-07 19:21 UTC (permalink / raw)
To: Khristos I. Khoury <ikhoury@user1.stritch.edu>; +Cc: pgsql-interfaces
"Khristos I. Khoury" wrote:
> DSN info:
> DSN='PostgreSQL',server='user3.stritch.edu',port='5432',dbase='vb5',user='ikhoury',passwd='123qwe'
>
> readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
> conn_settings=''
> translation_dll='',translation_option=''
>
> It says ReadOnly? On the other hand in Access it is Read-Write? Any clues?
> Thanks
Actually, readonly=0 means false, so it is NOT readonly.
If you can't update in Access, check to make sure you have a unique index on the table. The Jet
Database Engine queries the table when you link it to make sure there is a unique index on it. If it
is, then you should be able to update. If the JET can't find a unique index, then it should pop up
a dialog which asks you to tell it what the unique field(s) are.
Did you see such a dialog?
Byron
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] I am new to this
@ 1999-05-07 19:23 Khristos I. Khoury <ikhoury@user1.stritch.edu>
parent: Byron Nikolaidis <byronn@solipsys.com>
0 siblings, 1 reply; 10+ messages in thread
From: Khristos I. Khoury @ 1999-05-07 19:23 UTC (permalink / raw)
To: Byron Nikolaidis <byronn@solipsys.com>; +Cc: pgsql-interfaces
Do not get me qrong I can update on Access, but I can not update on Visual
Basic. using VisData adin.
>
> Actually, readonly=0 means false, so it is NOT readonly.
>
> If you can't update in Access, check to make sure you have a unique index on the table. The Jet
> Database Engine queries the table when you link it to make sure there is a unique index on it. If it
> is, then you should be able to update. If the JET can't find a unique index, then it should pop up
> a dialog which asks you to tell it what the unique field(s) are.
>
> Did you see such a dialog?
>
> Byron
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [INTERFACES] I am new to this
@ 1999-05-07 19:28 Byron Nikolaidis <byronn@solipsys.com>
parent: Khristos I. Khoury <ikhoury@user1.stritch.edu>
0 siblings, 0 replies; 10+ messages in thread
From: Byron Nikolaidis @ 1999-05-07 19:28 UTC (permalink / raw)
To: Khristos I. Khoury <ikhoury@user1.stritch.edu>; +Cc: pgsql-interfaces
"Khristos I. Khoury" wrote:
> Do not get me qrong I can update on Access, but I can not update on Visual
> Basic. using VisData adin.
>
Are you using the right kind of resultset? I can't remember exactly, but I think snapshot won't be
updateable. You need to use some other kind, like maybe a dynaset or something like that. I do remember
that in VisData, there is an option to set the kind of resultset.
Byron
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-07 20:40 Vince DiCiero <vdiciero@home.com>
0 siblings, 0 replies; 10+ messages in thread
From: Vince DiCiero @ 1999-05-07 20:40 UTC (permalink / raw)
To: 'Khristos I. Khoury' <ikhoury@user1.stritch.edu>; pgsql-interfaces
For what it's worth I have the same problem when using the visual data manager.
I have a VB app that can update the same db.
What I have noticed is that Visual Data Manager uses DAO for ODBC.
My app was previously DAO, and I was unable to get it to work with Postgress until
converting the app to use RDO. You may want to use Access or pgAdmin for
your administrative functions and write your app using RDO. Be sure that you
do not have any DAO objects selected in the project->references for you
vb project
hth
Vince DiCiero
vdiciero@home.com
On Thursday, May 06, 1999 10:33 PM, Khristos I. Khoury [SMTP:ikhoury@user1.stritch.edu] wrote:
> Greetings,
> I am new to this and have very short time to complete this project, so
> please excuse me if I this question has been asked before.
> My situation:
> I installed Postgress on Unix FreeBSD server 3.0 created a data base.
> I can access data base from Microsoft Access97 with and update with no
> problems. My project is to use Visual Basic 5.0 and be able to link to my
> data base on the Unix server and upate information.
> The problem I having is that VisData (Visual Data Manager) I see a
> user:admin shwoing on the bottom left of the screen and everything is Read
> Only. I checked The ODBC properties and made sure that ReadOnly was
> unchecked. Also I gave full permission to anyone to access my Data Base on
> the Unix server.
> The question is what am I missing that is holding me from updating?
> I tried in the option Worksapce to enter my username and password on the
> Unix server Data Base to connect but it will not accept it..!!
> Any help will be appreciated.
>
>
>
> Khristos I Khoury
> ikhoury@user1.stritch.edu
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* RE: [INTERFACES] I am new to this
@ 1999-05-08 17:27 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 10+ messages in thread
From: Dave Page @ 1999-05-08 17:27 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of
> Vince DiCiero
> Sent: 07 May 1999 20:40
> To: 'Khristos I. Khoury'; pgsql-interfaces@postgreSQL.org
> Subject: RE: [INTERFACES] I am new to this
>
>
> For what it's worth I have the same problem when using the
> visual data manager.
> I have a VB app that can update the same db.
> What I have noticed is that Visual Data Manager uses DAO for ODBC.
> My app was previously DAO, and I was unable to get it to work
> with Postgress until
> converting the app to use RDO. You may want to use Access or
> pgAdmin for
> your administrative functions and write your app using RDO.
Whilst I agree that pgAdmin is a good choice (shameless plug!), I
believe that RDO is now obsolete. pgAdmin uses DAO entirely without
problems, and some of Byron's latest mods to the ODBC driver have
enabled us to start looking at ADO which M$ seem to be plugging as the
way to go. I have looked at it briefly and have had simple test apps and
my own data control (which it is possible to write in VB6) running
without problems.
Regards,
Dave.
--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~1999-05-08 17:27 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-07 03:33 I am new to this Khristos I. Khoury <ikhoury@user1.stritch.edu>
1999-05-07 13:51 RE: [INTERFACES] I am new to this Michael J Davis <michael.j.davis@tvguide.com>
1999-05-07 15:17 ` Khristos I. Khoury <ikhoury@user1.stritch.edu>
1999-05-07 15:53 ` Khristos I. Khoury <ikhoury@user1.stritch.edu>
1999-05-07 19:21 ` Byron Nikolaidis <byronn@solipsys.com>
1999-05-07 19:23 ` Khristos I. Khoury <ikhoury@user1.stritch.edu>
1999-05-07 19:28 ` Byron Nikolaidis <byronn@solipsys.com>
1999-05-07 15:49 RE: [INTERFACES] I am new to this Michael J Davis <michael.j.davis@tvguide.com>
1999-05-07 20:40 RE: [INTERFACES] I am new to this Vince DiCiero <vdiciero@home.com>
1999-05-08 17:27 RE: [INTERFACES] I am new to this Dave Page <dpage@vale-housing.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox