Postgres Pro
Downloads
Home   >   mailing lists

Thread: access question

access question

From
radius
Date:
why do i get

ERROR:  Relation 'msysconf' does not exist

when connecting to an empty database via odbc?  just curious .. i'm rather
new to the postgres + odbc world

-j

firewall issues..

From
radius
Date:
i'm trying to punch a hole in my firewall so i can reach my database from
outside.. but i'm running into problems.. any suggestions as to what needs
to be able to get through .. port 5432 tcp ? is that it?

-j

Re: access question

From
radius
Date:
could this be related to me not being able to edit tables in access? i
have this wierd issue w/ access 2000 wher i can't edit the tables at all..
but odbc isn't read only .. and works properly.. i checked it w/ an oracle
odbc test tool and pgadmin.. ??

On Mon, 28 May 2001, Tomas Fulajtar wrote:

> Hello,
>  msysconf is a table which sets optimization for
> communication between Access and SQL server. You
> can find more in MS Acces Help - search string
> msysconf.
>
> Tomas Fulajtar
>
> > why do i get
> >
> > ERROR:  Relation 'msysconf' does not exist
> >
> > when connecting to an empty database via odbc?  just curious .. i'm rather
> > new to the postgres + odbc world
> >
> > -j
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
> ---------------------------------------------
>   Ing. Tomas Fulajtar
>   MORAVIAPRESS, a.s.
>   U pony 3061
>   690 02 Breclav
>   tel.: 0627/305 216
>
>   E-mail: tomas.fulajtar@moraviapress.cz
>   WWW:    www.moraviapress.cz
>   ---------------------------------------------
>   P.S.:Please use pure ASCII or ISO-8859-2 code
>

Re: access question

From
"Tomas Fulajtar"
Date:
MS Acces needs unique index on table to able edit it. Do
you have Recognize unique indexes enabled on ODBC
driver settings ?.  More in FAQ on
http://odbc.postgresql.org/ .

Tomas


> could this be related to me not being able to edit tables in access? i
> have this wierd issue w/ access 2000 wher i can't edit the tables at all..
> but odbc isn't read only .. and works properly.. i checked it w/ an oracle
> odbc test tool and pgadmin.. ??
>
> On Mon, 28 May 2001, Tomas Fulajtar wrote:
>
> > Hello,
> >  msysconf is a table which sets optimization for
> > communication between Access and SQL server. You
> > can find more in MS Acces Help - search string
> > msysconf.
> >
> > Tomas Fulajtar
> >
> > > why do i get
> > >
> > > ERROR:  Relation 'msysconf' does not exist
> > >
> > > when connecting to an empty database via odbc?  just curious .. i'm rather
> > > new to the postgres + odbc world
> > >
> > > -j
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> >
> >
> > ---------------------------------------------
> >   Ing. Tomas Fulajtar
> >   MORAVIAPRESS, a.s.
> >   U pony 3061
> >   690 02 Breclav
> >   tel.: 0627/305 216
> >
> >   E-mail: tomas.fulajtar@moraviapress.cz
> >   WWW:    www.moraviapress.cz
> >   ---------------------------------------------
> >   P.S.:Please use pure ASCII or ISO-8859-2 code
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

RE: access question

From
"Henshall, Stuart - WCP"
Date:
Hello,
    msysconf is used for efficiency purposes by jet. Here's a link that
should give more info:
http://msdn.microsoft.com/library/default.asp?URL=/library/books/dnjet/c9_bo
dy_58.htm
- Stuart

> -----Original Message-----
> From:    radius [SMTP:radius@codegrinder.com]
> Sent:    Thursday, May 24, 2001 8:26 PM
> To:    pgsql-odbc@postgresql.org
> Subject:    access question
>
> why do i get
>
> ERROR:  Relation 'msysconf' does not exist
>
> when connecting to an empty database via odbc?  just curious .. i'm rather
> new to the postgres + odbc world
>
> -j
>

Re: access question

From
radius
Date:
cool... that did it... now is there anyway to edit the table structure
from within access?

-j

On Tue, 29 May 2001, Tomas Fulajtar wrote:

> MS Acces needs unique index on table to able edit it. Do
> you have Recognize unique indexes enabled on ODBC
> driver settings ?.  More in FAQ on
> http://odbc.postgresql.org/ .
>
> Tomas
>
>
> > could this be related to me not being able to edit tables in access? i
> > have this wierd issue w/ access 2000 wher i can't edit the tables at all..
> > but odbc isn't read only .. and works properly.. i checked it w/ an oracle
> > odbc test tool and pgadmin.. ??
> >
> > On Mon, 28 May 2001, Tomas Fulajtar wrote:
> >
> > > Hello,
> > >  msysconf is a table which sets optimization for
> > > communication between Access and SQL server. You
> > > can find more in MS Acces Help - search string
> > > msysconf.
> > >
> > > Tomas Fulajtar
> > >
> > > > why do i get
> > > >
> > > > ERROR:  Relation 'msysconf' does not exist
> > > >
> > > > when connecting to an empty database via odbc?  just curious .. i'm rather
> > > > new to the postgres + odbc world
> > > >
> > > > -j
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 5: Have you checked our extensive FAQ?
> > > >
> > > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > >
> > >
> > >
> > > ---------------------------------------------
> > >   Ing. Tomas Fulajtar
> > >   MORAVIAPRESS, a.s.
> > >   U pony 3061
> > >   690 02 Breclav
> > >   tel.: 0627/305 216
> > >
> > >   E-mail: tomas.fulajtar@moraviapress.cz
> > >   WWW:    www.moraviapress.cz
> > >   ---------------------------------------------
> > >   P.S.:Please use pure ASCII or ISO-8859-2 code
> > >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
> >
>
>
>