Received: from NIH2WAAD (smtp4.site1.csi.com [149.174.183.73]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA09738 for ; Mon, 12 Apr 1999 08:36:20 -0400 (EDT) (envelope-from ghowe1@tampabay.rr.com) Received: from mail pickup service by csi.com with Microsoft SMTPSVC; Mon, 12 Apr 1999 08:35:42 -0400 Sender: ghowe1@tampabay.rr.com Received: from ibm78cvnv5 (atl-qbu-zpa-vty62.as.wcom.net [216.192.216.62]) by hil-img-11.compuserve.com (8.8.6/8.8.6/IMS-1.7) with ESMTP id IAA27454; Mon, 12 Apr 1999 08:34:41 -0400 (EDT) Reply-To: From: "Glenn Howe" To: Cc: Subject: RE: Problem migrating MSAccess97 table Date: Mon, 12 Apr 1999 08:34:20 -0400 Message-ID: <000001be84e0$caefb380$6d071bac@ibm78cvnv5> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0001_01BE84BF.44106E20" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01BE84BF.44106E20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Dave, First of all, thanks for the reply. Second, I'm quite sure I am accessing the same database. Infact, from psql I can list the table, just cannot access it. --------------------------------------------- contacts=> \dt Database = contacts +------------------+----------------------------------+----------+ | Owner | Relation | Type | +------------------+----------------------------------+----------+ | postgres | Addresses | table | | postgres | msysconf | table | | postgres | pga_forms | table | | postgres | pga_queries | table | | postgres | pga_reports | table | | postgres | pga_scripts | table | +------------------+----------------------------------+----------+ contacts=> select * from addresses; ERROR: addresses: Table does not exist. contacts=> ------------------------------------------------------------ Furthermore, I can access the table from within pgadmin using the data button. I cannot access the table from any other ODBC application though(even though I am using the same odbc system dsn). Attached is the database migration events. -----Original Message----- From: Dave Page [mailto:dpage@vale-housing.co.uk] Sent: Monday, April 12, 1999 4:27 AM To: ghowe1@tampabay.rr.com Cc: pgsql-interfaces@postgresql.org Subject: RE: Problem migrating MSAccess97 table Hi Glenn, I must say I a bit stumped by this so I've CC'd it to the PostgreSQL Interfaces mailing list in the hopes that someone there may have an idea whats happening. The obvious (and perhaps condescending!) question has to be: are you sure you are trying to access the same database you migrated to? I'm assuming that is the case, so could you re-run the migration with the ODBC drivers commlog option switched on and send me the logfile created so I can see if there is anything odd happening. 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.vale-it.demon.co.uk/ (Home of pgAdmin) Beer can be a permanent solution - but only if you have enough of it! > -----Original Message----- > From: Glenn Howe [mailto:ghowe1@tampabay.rr.com] > Sent: 11 April 1999 19:35 > To: Dave Page > Subject: Problem migrating MSAccess97 table > > > Hello, > > I am able to add tables and modify etc, using pgadmin on a > database that > resides on a linux box. That works great. I can then access > those tables via > psql or perl DBI. > > > the problem is when I migrate an access .mdb file. It does > the migration > just fine and using pgadmin I can access the newly created > postgres tables > just fine, I can see the data etc. But, if I use psql or > perl dbi, it tells > me the table does not exist. > > What am I doing wrong. I have tried checking and unchecking > all the odbc > driver boxes and trying it again. is there a procedure to > read regardind > migrating access 97 tables. > > > <>< ================== > Glenn Howe > Network Engineer, MCSE > 813.651.2700 > MAILTO:ghowe1@tampabay.rr.com > HomePage: http://home.tampabay.rr.com/tgh > ------=_NextPart_000_0001_01BE84BF.44106E20 Content-Type: application/octet-stream; name="psqlodbc_4294789115.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc_4294789115.log" conn=3D32966780, SQLDriverConnect( = in)=3D'DSN=3DPGSQL-Contacts;UID=3Dpostgres;PWD=3Dpostgres;', = fDriverCompletion=3D1 DSN info: = DSN=3D'PGSQL-Contacts',server=3D'ibm1234asdf',port=3D'5432',dbase=3D'cont= acts',user=3D'postgres',passwd=3D'postgres' = readonly=3D'0',protocol=3D'6.4',showoid=3D'1',fakeoidindex=3D'1',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D32966780, query=3D' ' conn=3D32966780, query=3D'set DateStyle to 'ISO'' conn=3D32966780, query=3D'set geqo to 'OFF'' conn=3D32966780, query=3D'set ksqo to 'ON'' conn=3D32966780, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D32966780, = SQLDriverConnect(out)=3D'DSN=3DPGSQL-Contacts;DATABASE=3Dcontacts;SERVER=3D= ibm1234asdf;PORT=3D5432;UID=3Dpostgres;PWD=3Dpostgres;READONLY=3D0;PROTOC= OL=3D6.4;FAKEOIDINDEX=3D1;SHOWOIDCOLUMN=3D1;ROWVERSIONING=3D0;SHOWSYSTEMT= ABLES=3D0;CONNSETTINGS=3D' conn=3D32966780, query=3D'SELECT Config, nValue FROM MSysConf' [ fetched 3 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'pg_class' = order by attnum' [ fetched 18 rows ] conn=3D32981308, SQLDriverConnect( = in)=3D'DSN=3DPGSQL-Contacts;UID=3Dpostgres;PWD=3Dpostgres;DATABASE=3Dcont= acts;SERVER=3Dibm1234asdf;PORT=3D5432;READONLY=3D0;PROTOCOL=3D6.4;FAKEOID= INDEX=3D1;SHOWOIDCOLUMN=3D1;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSE= TTINGS=3D;', fDriverCompletion=3D0 DSN info: = DSN=3D'PGSQL-Contacts',server=3D'ibm1234asdf',port=3D'5432',dbase=3D'cont= acts',user=3D'postgres',passwd=3D'postgres' = readonly=3D'0',protocol=3D'6.4',showoid=3D'1',fakeoidindex=3D'1',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D32981308, query=3D' ' conn=3D32981308, query=3D'set DateStyle to 'ISO'' conn=3D32981308, query=3D'set geqo to 'OFF'' conn=3D32981308, query=3D'set ksqo to 'ON'' conn=3D32981308, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D32981308, SQLDriverConnect(out)=3D'(null)' conn=3D32981308, query=3D'SELECT "relname" FROM "pg_class" WHERE = (("relname" =3D 'pgadmin_sys' ) AND ("relkind" =3D 'r' ) ) ' [ fetched 0 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'pg_class' = order by attnum' [ fetched 18 rows ] conn=3D32981308, query=3D'SELECT "relhaspkey" FROM "pg_class" WHERE = ("relname" =3D 'pg_class' ) ' [ fetched 1 rows ] conn=3D32995836, SQLDriverConnect( = in)=3D'DSN=3DPGSQL-Contacts;UID=3Dpostgres;PWD=3Dpostgres;DATABASE=3Dcont= acts;SERVER=3Dibm1234asdf;PORT=3D5432;READONLY=3D0;PROTOCOL=3D6.4;FAKEOID= INDEX=3D1;SHOWOIDCOLUMN=3D1;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSE= TTINGS=3D;', fDriverCompletion=3D1 DSN info: = DSN=3D'PGSQL-Contacts',server=3D'ibm1234asdf',port=3D'5432',dbase=3D'cont= acts',user=3D'postgres',passwd=3D'postgres' = readonly=3D'0',protocol=3D'6.4',showoid=3D'1',fakeoidindex=3D'1',showsyst= able=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' Global Options: Version=3D'06.40.0004', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, ksqo=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D32995836, query=3D' ' conn=3D32995836, query=3D'set DateStyle to 'ISO'' conn=3D32995836, query=3D'set geqo to 'OFF'' conn=3D32995836, query=3D'set ksqo to 'ON'' conn=3D32995836, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] conn=3D32995836, = SQLDriverConnect(out)=3D'DSN=3DPGSQL-Contacts;DATABASE=3Dcontacts;SERVER=3D= ibm1234asdf;PORT=3D5432;UID=3Dpostgres;PWD=3Dpostgres;READONLY=3D0;PROTOC= OL=3D6.4;FAKEOIDINDEX=3D1;SHOWOIDCOLUMN=3D1;ROWVERSIONING=3D0;SHOWSYSTEMT= ABLES=3D0;CONNSETTINGS=3D' conn=3D32981308, query=3D'BEGIN' conn=3D32981308, query=3D'CREATE TABLE "Addresses" ( "AddressID" "int4", = "FirstName" "text", "LastName" "text", "SpouseName" "text", "Address" = "text", "City" "text", "StateOrProvince" "text", "PostalCode" "text", = "Country" "text", "EmailAddress" "text", "HomePhone" "text", "WorkPhone" = "text", "WorkExtension" "text", "FaxNumber" "text", "Birthdate" "date", = "SendCard" "bool", "Notes" "text" );' conn=3D32981308, query=3D'COMMIT' conn=3D32981308, query=3D'BEGIN' conn=3D32981308, query=3D'INSERT INTO "Addresses" ("AddressID", = "FirstName", "LastName", "SpouseName", "Address", "City", = "StateOrProvince", "PostalCode", "Country", "EmailAddress", "HomePhone", = "WorkPhone", "FaxNumber", "Birthdate", "SendCard") VALUES ('1', 'Nancy', = 'Davolio', 'Paul', '507 - 20th Ave. E. Apt. 2A', 'Seattle', 'WA', '98122', 'USA', 'nancyd@anywhere.com', '(504) = 555-9857', '(504) 555-9922', '(504) 555-7722', '8/4/72', 'False');' conn=3D32981308, query=3D'INSERT INTO "Addresses" ("AddressID", = "FirstName", "LastName", "SpouseName", "Address", "City", = "StateOrProvince", "PostalCode", "Country", "EmailAddress", "HomePhone", = "WorkPhone", "FaxNumber", "Birthdate", "SendCard") VALUES ('2', = 'Andrew', 'Fuller', 'Anne', '908 W. Capital Way', 'Tacoma', 'WA', = '98401', 'USA', 'andrewf@anywhere.com', '(504) 555-9482', '(504) = 555-9933', '(504) 555-7733', '6/17/61', 'False');' conn=3D32981308, query=3D'INSERT INTO "Addresses" ("AddressID", = "FirstName", "LastName", "SpouseName", "Address", "City", = "StateOrProvince", "PostalCode", "Country", "EmailAddress", "HomePhone", = "WorkPhone", "FaxNumber", "Birthdate", "SendCard") VALUES ('3', 'Janet', = 'Leverling', 'Robert', '722 Moss Bay Blvd.', 'Kirkland', 'WA', '98033', = 'USA', 'janetl@anywhere.com', '(504) 555-3412', '(504) 555-9944', '(504) = 555-7744', '7/14/65', 'True');' conn=3D32981308, query=3D'INSERT INTO "Addresses" ("AddressID", = "FirstName", "LastName", "SpouseName", "Address", "City", = "StateOrProvince", "PostalCode", "Country", "HomePhone", "WorkPhone", = "FaxNumber", "Birthdate", "SendCard") VALUES ('4', 'Margaret', = 'Peacock', 'Michael', '4110 Old Redmond Rd.', 'Redmond', 'WA', '98052', = 'USA', '(504) 555-8122', '(504) 555-9955', '(504) 555-7755', '7/14/65', = 'True');' conn=3D32981308, query=3D'INSERT INTO "Addresses" ("AddressID", = "FirstName", "LastName", "Address", "City", "PostalCode", "Country", = "EmailAddress", "HomePhone", "WorkPhone", "Birthdate", "SendCard") = VALUES ('5', 'Steven', 'Buchanan', '14 Garrett Hill', 'London', 'SW1 = 8JR', 'UK', 'steveb@anywhere.com', '(71) 555-4848', '(71) 555-5858', = '8/12/70', 'False');' conn=3D32981308, query=3D'COMMIT' conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'pg_class' = order by attnum' [ fetched 18 rows ] conn=3D32981308, query=3D'SELECT "oid" ,"relname" ,"reltype" ,"relowner" = ,"relam" ,"relpages" ,"reltuples" ,"relhasindex" ,"relisshared" = ,"relkind" ,"relnatts" ,"relchecks" ,"reltriggers" ,"relukeys" = ,"relfkeys" ,"relrefs" ,"relhaspkey" ,"relhasrules" ,"relacl" FROM = "pg_class" WHERE ("relkind" =3D 'r' ) ORDER BY "relname" ' [ fetched 36 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'pg_user' = order by attnum' [ fetched 8 rows ] conn=3D32981308, query=3D'SELECT "usename" ,"usesysid" FROM "pg_user" ' [ fetched 2 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like = 'pg_description' order by attnum' [ fetched 2 rows ] conn=3D32981308, query=3D'SELECT "description" FROM "pg_description" = WHERE ("objoid" =3D 146272 ) ' [ fetched 0 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like = 'pg_attribute' order by attnum' [ fetched 14 rows ] conn=3D32981308, query=3D'SELECT "oid" ,"attrelid" ,"attname" = ,"atttypid" ,"attdisbursion" ,"attlen" ,"attnum" ,"attnelems" = ,"attcacheoff" ,"atttypmod" ,"attbyval" ,"attisset" ,"attalign" = ,"attnotnull" ,"atthasdef" FROM "pg_attribute" WHERE ("attrelid" =3D = 146272 ) ORDER BY "attnum" ' [ fetched 23 rows ] conn=3D32966780, query=3D'select u.usename, c.relname, a.attname, = a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from = pg_user u, pg_class c, pg_attribute a, pg_type t where = int4out(u.usesysid) =3D int4out(c.relowner) and c.oid=3D a.attrelid and = a.atttypid =3D t.oid and (a.attnum > 0) and c.relname like 'Addresses' = order by attnum' [ fetched 17 rows ] conn=3D32981308, query=3D'SELECT "oid" ,"AddressID" ,"FirstName" = ,"LastName" ,"SpouseName" ,"Address" ,"City" ,"StateOrProvince" = ,"PostalCode" ,"Country" ,"EmailAddress" ,"HomePhone" ,"WorkPhone" = ,"WorkExtension" ,"FaxNumber" ,"Birthdate" ,"SendCard" ,"Notes" FROM = "Addresses" ORDER BY "oid" ' [ fetched 5 rows ] conn=3D32995836, SQLDisconnect conn=3D32981308, SQLDisconnect conn=3D32966780, SQLDisconnect ------=_NextPart_000_0001_01BE84BF.44106E20--