pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedextremely newbie questions
11+ messages / 5 participants
[nested] [flat]
* extremely newbie questions
@ 2001-01-22 02:28 Nicholas Chan <yumin@pl.jaring.my>
2001-01-24 10:46 ` Re: extremely newbie questions Oliver Elphick <olly@lfix.co.uk>
0 siblings, 1 reply; 11+ messages in thread
From: Nicholas Chan @ 2001-01-22 02:28 UTC (permalink / raw)
To: pgsql-interfaces
I'm very new when it comes to databases, and I'd like to try out
pgAdmin on my Windows NT to create, configure and manage some
databases on a remote linux server.
I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
I've installed the above two as well as MDAC v2.6
And i'm running Windows NT Workstation with Service Pack v6a
1) I want to test out PostgreSQL on a windows platform, so is there
anything else I have to install other than the software
I have mentioned above? I assume that pgAdmin is something like
MSSQL server, or am I wrong? is it just a frontend?
2) where can I find a sample database which can be used for pgAdmin?
Can any regular database created by Microsoft Access be used?
(*.mdb)
3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
Access database, but when I start pgAdmin and connect to the
source i've specified, this error message appears:
Error Details
*************
Error Number: -2147467259
Error Description: Could not connect to the server;
Could not connect to remote socket.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Subroutine of Function: frmODBCLogon, cmdOK_Click
Any help would be very much appreciated.
I can't even seem to open the main pgAdmin program!
And thanks in advance.
Warmest regards,
Nicholas Chan
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: extremely newbie questions
2001-01-22 02:28 extremely newbie questions Nicholas Chan <yumin@pl.jaring.my>
@ 2001-01-24 10:46 ` Oliver Elphick <olly@lfix.co.uk>
0 siblings, 0 replies; 11+ messages in thread
From: Oliver Elphick @ 2001-01-24 10:46 UTC (permalink / raw)
To: Nicholas Chan <yumin@pl.jaring.my>; +Cc: pgsql-interfaces
Nicholas Chan wrote:
>I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
>I've installed the above two as well as MDAC v2.6
>And i'm running Windows NT Workstation with Service Pack v6a
>3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
> Access database, but when I start pgAdmin and connect to the
> source i've specified, this error message appears:
>
>Error Details
>*************
>Error Number: -2147467259
>Error Description: Could not connect to the server;
Is the server listening for TCP/IP connections -- that is, has the
postmaster been started with the -i option?
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"If anyone has material possessions and sees his
brother in need but has no pity on him, how can the
love of God be in him?"
I John 3:17
^ permalink raw reply [nested|flat] 11+ messages in thread
* extremely newbie questions
@ 2001-01-22 02:52 Nicholas Chan <yumin@pl.jaring.my>
0 siblings, 0 replies; 11+ messages in thread
From: Nicholas Chan @ 2001-01-22 02:52 UTC (permalink / raw)
To: pgsql-interfaces
I'm very new when it comes to databases, and I'd like to try out
pgAdmin on my Windows NT to create, configure and manage some
databases on a remote linux server.
I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
I've installed the above two as well as MDAC v2.6
And i'm running Windows NT Workstation with Service Pack v6a
1) I want to test out PostgreSQL on a windows platform, so is there
anything else I have to install other than the software
I have mentioned above? I assume that pgAdmin is something like
MSSQL server, or am I wrong? is it just a frontend?
2) where can I find a sample database which can be used for pgAdmin?
Can any regular database created by Microsoft Access be used?
(*.mdb)
3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
Access database, but when I start pgAdmin and connect to the
source i've specified, this error message appears:
Error Details
*************
Error Number: -2147467259
Error Description: Could not connect to the server;
Could not connect to remote socket.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Subroutine of Function: frmODBCLogon, cmdOK_Click
Any help would be very much appreciated.
I can't even seem to open the main pgAdmin program!
And thanks in advance.
Warmest regards,
Nicholas Chan
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: extremely newbie questions
@ 2001-01-22 08:17 Dave Page <dpage@vale-housing.co.uk>
2001-01-22 14:26 ` Re: extremely newbie questions Nicholas Chan <yumin@pl.jaring.my>
0 siblings, 1 reply; 11+ messages in thread
From: Dave Page @ 2001-01-22 08:17 UTC (permalink / raw)
To: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
> -----Original Message-----
> From: Nicholas Chan [mailto:yumin@pl.jaring.my]
> Sent: 22 January 2001 02:53
> To: Postgresql Interfaces
> Subject: [INTERFACES] extremely newbie questions
>
>
>
> I'm very new when it comes to databases, and I'd like to try out
> pgAdmin on my Windows NT to create, configure and manage some
> databases on a remote linux server.
>
> I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
> I've installed the above two as well as MDAC v2.6
> And i'm running Windows NT Workstation with Service Pack v6a
You will also need to install the PostgreSQL ODBC driver which can be
obtained from ftp.postgresql.org
> 1) I want to test out PostgreSQL on a windows platform, so is there
> anything else I have to install other than the software
> I have mentioned above? I assume that pgAdmin is something like
> MSSQL server, or am I wrong? is it just a frontend?
pgAdmin is more like SQL's Enterprise Manager (in function, not design) - it
is not the dbms itself.
> 2) where can I find a sample database which can be used for pgAdmin?
> Can any regular database created by Microsoft Access be used?
> (*.mdb)
No, you you can't use mdb's (though pgAdmin can migrate them for you). You
need to install PostgreSQL on your linux box - you can get this from
ftp.postgresql.org, or some distros such as Suse and Redhat come with rpms.
> 3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
> Access database, but when I start pgAdmin and connect to the
> source i've specified, this error message appears:
Yes, that will happen because pgAdmin is expecting to be connected to
PostgreSQL.
Regards,
Dave.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: extremely newbie questions
2001-01-22 08:17 RE: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
@ 2001-01-22 14:26 ` Nicholas Chan <yumin@pl.jaring.my>
0 siblings, 0 replies; 11+ messages in thread
From: Nicholas Chan @ 2001-01-22 14:26 UTC (permalink / raw)
To: pgsql-interfaces
Thanks for your reply, Dave.
> > 2) where can I find a sample database which can be used for pgAdmin?
> > Can any regular database created by Microsoft Access be used?
> > (*.mdb)
>
> No, you you can't use mdb's (though pgAdmin can migrate them for you). You
> need to install PostgreSQL on your linux box - you can get this from
> ftp.postgresql.org, or some distros such as Suse and Redhat come with rpms.
So this means that I can't use pgAdmin unless my pc is connected to a
linux box? Oh :(
So are there any other alternatives on using PostgreSQL on a
standalone
windows based PC? And are there any converters around to convert
microsoft based databases to a PostgreSQL readable format?
Thanks.
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Re: extremely newbie questions
@ 2001-01-22 14:58 Dave Page <dpage@vale-housing.co.uk>
2001-01-22 17:39 ` Re: extremely newbie questions Nicholas Chan <yumin@pl.jaring.my>
0 siblings, 1 reply; 11+ messages in thread
From: Dave Page @ 2001-01-22 14:58 UTC (permalink / raw)
To: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
> -----Original Message-----
> From: Nicholas Chan [mailto:yumin@pl.jaring.my]
> Sent: 22 January 2001 14:26
> To: Postgresql Interfaces
> Subject: [INTERFACES] Re: extremely newbie questions
>
>
>
> Thanks for your reply, Dave.
>
>
> > > 2) where can I find a sample database which can be used
> for pgAdmin?
> > > Can any regular database created by Microsoft Access be used?
> > > (*.mdb)
> >
> > No, you you can't use mdb's (though pgAdmin can migrate
> them for you). You
> > need to install PostgreSQL on your linux box - you can get this from
> > ftp.postgresql.org, or some distros such as Suse and Redhat
> come with rpms.
>
> So this means that I can't use pgAdmin unless my pc is
> connected to a
> linux box? Oh :(
You can compile PostgreSQL to run on your PC if you are running NT4 or W2K
(that's how I develop pgAdmin when I'm parked in front of the telly at home
with my laptop!). You need to use the Cygwin package - there are
instructions in the PostgreSQL tarball.
> So are there any other alternatives on using PostgreSQL on a
> standalone
> windows based PC? And are there any converters around to convert
> microsoft based databases to a PostgreSQL readable format?
Yes, pgAdmin does that (converts Access tables/indexes but *not* programs to
PostgreSQL). I think a little clarification is needed here: pgAdmin is an
admin/design tool for the PostgreSQL database system. PostgreSQL is *not*
just a file like a simple Access database, it is a program that accepts and
processes SQL queries and returns resultsets when appropriate. It has it's
own data files that pgAdmin knows nothing about.
Typically PostgreSQL will run on a server and accept connections from 1 or
many (perhaps hundereds) of client programs (or people running the same
program). pgAdmin is one such program that just happens to be designed to
help manage and build your databases.
Check out www.postgresql.org for more info.
Regards,
Dave.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: extremely newbie questions
2001-01-22 14:58 RE: Re: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
@ 2001-01-22 17:39 ` Nicholas Chan <yumin@pl.jaring.my>
0 siblings, 0 replies; 11+ messages in thread
From: Nicholas Chan @ 2001-01-22 17:39 UTC (permalink / raw)
To: pgsql-interfaces
Again, thanks for your reply!
> You can compile PostgreSQL to run on your PC if you are running NT4 or W2K
> (that's how I develop pgAdmin when I'm parked in front of the telly at home
> with my laptop!). You need to use the Cygwin package - there are
> instructions in the PostgreSQL tarball.
Are there any readily compiled windows NT versions to be
downloaded?
> Yes, pgAdmin does that (converts Access tables/indexes but *not* programs to
> PostgreSQL). I think a little clarification is needed here: pgAdmin is an
> admin/design tool for the PostgreSQL database system. PostgreSQL is *not*
> just a file like a simple Access database, it is a program that accepts and
> processes SQL queries and returns resultsets when appropriate. It has it's
> own data files that pgAdmin knows nothing about.
>
> Typically PostgreSQL will run on a server and accept connections from 1 or
> many (perhaps hundereds) of client programs (or people running the same
> program). pgAdmin is one such program that just happens to be designed to
> help manage and build your databases.
Thanks for the clarification, Dave.
That explains a lot of things!
And are there any database converters out there which can
convert windows based databases, especially Microsoft Access,
to PostgreSQL database readable files other than pgAdmin?
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: extremely newbie questions
@ 2001-01-22 17:58 Michael Davis <mdavis@sevainc.com>
0 siblings, 0 replies; 11+ messages in thread
From: Michael Davis @ 2001-01-22 17:58 UTC (permalink / raw)
To: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
1) You need to create a Data Source Name (DSN) using the ODBC driver
manager. This can be done by opening ODBC32 in the Control Panel. Once
this is done, Access will allow you add tables via your new ODBC data
source. You should have a primary key installed on each table.
2) With Access you can databases that store data and databases that store
code and reference the data. If you are using code, then just link to the
PostgreSQL tables as described above and they will look and act exactly
like Access tables. You can even link Access table to PostgreSQL tables
using Access. If you are referring to data stored in Access97, then
PostgreSQL will not be able to access this data directly. You will have to
export your Access data and import it into PostgreSQL.
3) Looks like you did not do item 1 above and you choose a Data Source for
another database. If you complete item 1 above, and select it as your data
source, then it should work.
Hope this helps.
-----Original Message-----
From: Nicholas Chan [SMTP:yumin@pl.jaring.my]
Sent: Sunday, January 21, 2001 7:53 PM
To: Postgresql Interfaces
Subject: extremely newbie questions
I'm very new when it comes to databases, and I'd like to try out
pgAdmin on my Windows NT to create, configure and manage some
databases on a remote linux server.
I'm using pgAdmin 7.05 and PostgreSQL ODBC driver v6.50.00.00.
I've installed the above two as well as MDAC v2.6
And i'm running Windows NT Workstation with Service Pack v6a
1) I want to test out PostgreSQL on a windows platform, so is there
anything else I have to install other than the software
I have mentioned above? I assume that pgAdmin is something like
MSSQL server, or am I wrong? is it just a frontend?
2) where can I find a sample database which can be used for pgAdmin?
Can any regular database created by Microsoft Access be used?
(*.mdb)
3) i've tried creating a PostgreSQL ODBC connection with a Microsoft
Access database, but when I start pgAdmin and connect to the
source i've specified, this error message appears:
Error Details
*************
Error Number: -2147467259
Error Description: Could not connect to the server;
Could not connect to remote socket.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Subroutine of Function: frmODBCLogon, cmdOK_Click
Any help would be very much appreciated.
I can't even seem to open the main pgAdmin program!
And thanks in advance.
Warmest regards,
Nicholas Chan
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Re: extremely newbie questions
@ 2001-01-22 20:55 Dave Page <dpage@vale-housing.co.uk>
2001-01-23 09:43 ` RE: Re: extremely newbie questions Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 1 reply; 11+ messages in thread
From: Dave Page @ 2001-01-22 20:55 UTC (permalink / raw)
To: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
> -----Original Message-----
> From: Nicholas Chan [mailto:yumin@pl.jaring.my]
> Sent: 22 January 2001 17:40
> To: Postgresql Interfaces
> Subject: [INTERFACES] Re: extremely newbie questions
>
>
>
> Again, thanks for your reply!
>
>
> > You can compile PostgreSQL to run on your PC if you are
> running NT4 or W2K
> > (that's how I develop pgAdmin when I'm parked in front of
> the telly at home
> > with my laptop!). You need to use the Cygwin package - there are
> > instructions in the PostgreSQL tarball.
>
> Are there any readily compiled windows NT versions to be
> downloaded?
Probably. I don't know where though.
> > Yes, pgAdmin does that (converts Access tables/indexes but
> *not* programs to
> > PostgreSQL). I think a little clarification is needed here:
> pgAdmin is an
> > admin/design tool for the PostgreSQL database system.
> PostgreSQL is *not*
> > just a file like a simple Access database, it is a program
> that accepts and
> > processes SQL queries and returns resultsets when
> appropriate. It has it's
> > own data files that pgAdmin knows nothing about.
> >
> > Typically PostgreSQL will run on a server and accept
> connections from 1 or
> > many (perhaps hundereds) of client programs (or people
> running the same
> > program). pgAdmin is one such program that just happens to
> be designed to
> > help manage and build your databases.
>
> Thanks for the clarification, Dave.
> That explains a lot of things!
> And are there any database converters out there which can
> convert windows based databases, especially Microsoft Access,
> to PostgreSQL database readable files other than pgAdmin?
I believe there was once some Access code that did it (though I don't know
where it is). I doubt that it migrated tables, indexes, data as well as
primary and foreign keys as the upcoming pgAdmin will! The current version
does tables indexes and data BTW.
^ permalink raw reply [nested|flat] 11+ messages in thread
* RE: Re: extremely newbie questions
2001-01-22 20:55 RE: Re: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
@ 2001-01-23 09:43 ` Cedar Cox <cedarc@visionforisrael.com>
0 siblings, 0 replies; 11+ messages in thread
From: Cedar Cox @ 2001-01-23 09:43 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
On Mon, 22 Jan 2001, Dave Page wrote:
>
> I believe there was once some Access code that did it (though I don't know
> where it is). I doubt that it migrated tables, indexes, data as well as
> primary and foreign keys as the upcoming pgAdmin will! The current version
> does tables indexes and data BTW.
Is this it? www.cynergi.net/prod/exportsql/
At the time I looked at it only mSQL v1, mSQL v2 or MySQL was supported
but there is someone that added PG support. I ended up just hacking up
some quick and not _so_ dirty code to get my data into PG. It lets the
ODBC driver do the work. I've attached it for your amusement.
-Cedar
Attachments:
copy_be.txt (text/plain, 1.3K) download
Private Sub cmdcopyit_Click()
Dim dbs As Database
Set dbs = OpenDatabase("", , , "ODBC;")
If MsgBox("Warning!!@This will destroy existing tables in " _
& dbs.Name & " with the same name as tables in " _
& CurrentDb.Name _
& "@Are you sure you want to continue?" _
, vbApplicationModal + vbCritical + vbOKCancel + vbDefaultButton2, "Warning!!") _
= vbCancel Then Exit Sub
Me.cmdcopyit.Caption = "Please wait..."
Me.Repaint
Dim tdf As TableDef, intCounter As Integer, retval
retval = SysCmd(acSysCmdInitMeter, " ", CurrentDb.TableDefs.Count)
For Each tdf In CurrentDb.TableDefs
intCounter = intCounter + 1
retval = SysCmd(acSysCmdUpdateMeter, intCounter)
With tdf
If tdf.Attributes = 0 Then
On Error Resume Next
dbs.Execute "DROP TABLE " & Chr(34) & .Name & Chr(34), dbSQLPassThrough
' dbs.Execute "DELETE FROM " & Chr(34) & tdf.Name & Chr(34), dbSQLPassThrough
On Error GoTo 0
dbs.Execute "SELECT * INTO " & .Name & " FROM [" & CurrentDb.Name & "]." & .Name & ";"
End If
End With
Next tdf
dbs.Close
retval = SysCmd(acSysCmdRemoveMeter)
MsgBox "Copy finished!", vbInformation, "Finished"
Me.cmdcopyit.Caption = "Copy data to another back-end"
End Sub
* RE: Re: extremely newbie questions
@ 2001-01-23 09:19 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 11+ messages in thread
From: Dave Page @ 2001-01-23 09:19 UTC (permalink / raw)
To: 'Cedar Cox' <cedarc@visionforisrael.com>; +Cc: 'Nicholas Chan' <yumin@pl.jaring.my>; pgsql-interfaces
> -----Original Message-----
> From: Cedar Cox [mailto:cedarc@visionforisrael.com]
> Sent: 23 January 2001 09:43
> To: Dave Page
> Cc: 'Nicholas Chan'; Postgresql Interfaces
> Subject: RE: [INTERFACES] Re: extremely newbie questions
>
>
>
> On Mon, 22 Jan 2001, Dave Page wrote:
> >
> > I believe there was once some Access code that did it
> (though I don't know
> > where it is). I doubt that it migrated tables, indexes,
> data as well as
> > primary and foreign keys as the upcoming pgAdmin will! The
> current version
> > does tables indexes and data BTW.
>
> Is this it? www.cynergi.net/prod/exportsql/
> At the time I looked at it only mSQL v1, mSQL v2 or MySQL was
> supported
> but there is someone that added PG support. I ended up just
> hacking up
> some quick and not _so_ dirty code to get my data into PG.
> It lets the
> ODBC driver do the work. I've attached it for your amusement.
No it wasn't - I forget who wrote it but I recall that he/she did used to
contribute to this list occasionally.
Nice code BTW. It's easy to forget the joys of being able to SELECT INTO
across databases! You should see the current code in the pgAdmin Migration
Wizard - it's somewhat more complex to say the least!
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2001-01-24 10:46 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-22 02:28 extremely newbie questions Nicholas Chan <yumin@pl.jaring.my>
2001-01-24 10:46 ` Oliver Elphick <olly@lfix.co.uk>
2001-01-22 02:52 extremely newbie questions Nicholas Chan <yumin@pl.jaring.my>
2001-01-22 08:17 RE: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
2001-01-22 14:26 ` Nicholas Chan <yumin@pl.jaring.my>
2001-01-22 14:58 RE: Re: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
2001-01-22 17:39 ` Nicholas Chan <yumin@pl.jaring.my>
2001-01-22 17:58 RE: extremely newbie questions Michael Davis <mdavis@sevainc.com>
2001-01-22 20:55 RE: Re: extremely newbie questions Dave Page <dpage@vale-housing.co.uk>
2001-01-23 09:43 ` Cedar Cox <cedarc@visionforisrael.com>
2001-01-23 09:19 RE: Re: extremely newbie questions 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