pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] ODBC - MSAccess W95/98
2+ messages / 2 participants
[nested] [flat]
* ODBC - MSAccess W95/98
@ 1999-02-04 21:39 Karsten Kaus <kk@kdschmid.de>
1999-02-04 14:14 ` Re: [INTERFACES] ODBC - MSAccess W95/98 David Hartwig <daveh@insightdist.com>
0 siblings, 1 reply; 2+ messages in thread
From: Karsten Kaus @ 1999-02-04 21:39 UTC (permalink / raw)
To: pgsql-interfaces
Hi there,
(this time it is posted to interface also.)
thanks a lot for the hints so far.
this is my pg_hba.conf:
------------------------------------
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 192.168.0.0 255.255.255.0 trust
------------------------------------
what I understand is: 3rd line says all stations 192.168.0.x
are allowed
Now I try to be careful about the PsqlODBC FAQ from insightdigest:
I remove my User- and System-DSN from 32Bit-ODBS as well as
my SQL-Server kk1 from ODBC.
I create a new System DSN:
PostgeSQL Driver Version 6.40.0004
Data Source: PostgreSQL
Database: kk1 (still exist, just tested on capella)
Server: 192.168.0.3
Username: www
Port: 5432
Password: still secret
then I (re)set the advanced driver options to default.
advanced datasourceoptions (untouched i hope)
all switches off, protocol 6.4
back in system dsn i click on ok.
I delete c:\*.log and enter the tracing section, where i request
tracing all the time to c:\SQL.LOG.
After <start tracing now> I close 32Bit-ODBC and move over to ODBC.
There I <add driver> and select <SQL Server>:
Datenquellenname: kk1 (datasourcename)
Beschreibung: kk testet (description)
Server: 192.168.0.3 (entered by typing, not selected from the list)
Netzwerkadresse: (Standart) (networkadress)
Netzwerkbibliothek: (Standart) (networklibrary)
with <options> I enter the databasename kk1
I quit this using ok and find the driver kk1 under the
list of datasources.
then I have to wait the remaining 21 minutes for my backup to come ready
and
will restart my computer (just in case).
Meanwhile:
I fed the database kk1 as user www on capella (192.168.0.3 running
a fairly new linux version 2.0.35 from suse 5.3 (did I tell) ) with 2
records,
investigated the whereabouts of a signaturefile for one of the users and
set up a new cofee, wich has nothing to do with the problem.
The computer I'm working on is 192.168.0.33 (Muenchen) running W95.
It is also mentioned in /etc/hosts on capella.
nslookup of my station there gets a correct answer from our nameserver
arktur (192.168.0.1).
LABEL: Try2
starting m$access, creating a new database.
Tabelle - einbinden ( include table? ), file format: <SQL-Datenbank>
datasource: kk1
Anmeldename: www (does it matter: www or WWW?)
Kennwort: stillsecret
I start tcpdump on capella 2 times for traffic to capella and muenchen
and
press <OK> in Access.
that is what I get:
Error Message translated:
----------------------------------------------------------------
Connection failed:
SQL State: '01000'
SQL Server-Error: -1
[Microsoft][ODBC SQL Server Driver][dbnmp3]ConnectionOpen (sopen()),
Connection failed:
SQL State: '08001'
SQL Server-Error: 0
[Microsoft][ODBC SQL Server Driver]Connection could not be established.
----------------------------------------------------------------
the file c:\sql.log contains 0 bytes and there is no other *.log
tcpdump to my station (muenchen ....33) contains no significant packets.
tcpdump to capella (....3) contains no significant packets.
okay, I retry starting from 32Bit-ODBC thistime using capella as the
servername
and redefine the logsettings.
in ODBC I change servername to capella and networkadress to 192.168.0.3.
then I go to Label: Try2
The errormessage ist the same as in try 1 and the tcpdumpfiles do not
contain useful information for me, except that I would expect more
packets there.
some time later:
after trying this and that i got a mayby hintful message from tcpdump.
It is from capella to my station:
15:10:30.710266 192.168.0.3.139 > 192.168.0.33.1027: P 95:134(39) ack
237 win 16368
>>> NBT Packet
NBT Session Packet
Flags=0x0
Length=35
SMB PACKET: SMBopenX (REPLY)
SMB Command = 0x2D
Error class = 0x2
Error code = 4
Flags1 = 0x80
Flags2 = 0x1
Tree ID = 114
Proc ID = 7947
UID = 100
MID = 16643
Word Count = 0
SMBError = ERRSRV - ERRaccess (The requester does not have the
necessary access rights within the specified context for the
requested function. The context is defined by the TID or the UID.)
smbvwv[]=
Com2=smb_bcc=0
---------------------------------------------
throughout the whole dump it is preceeded by this: (muenchen to
capella):
15:10:31.330266 192.168.0.33.1027 > 192.168.0.3.139: P 322:407(85) ack
173 win 8109
>>> NBT Packet
NBT Session Packet
Flags=0x0
Length=81
WARNING: Short packet. Try increasing the snap length (44)
SMB PACKET: SMBopenX (REQUEST)
SMB Command = 0x2D
Error class = 0x0
Error code = 0
Flags1 = 0x0
Flags2 = 0x1
Tree ID = 114
Proc ID = 7947
UID = 100
MID = 16899
Word Count = 15
smbvwv[]=
Com2=0xFF
Off2=0
Flags=0x1
Mode=0x42
SearchAttrib=HIDDEN SYSTEM DIR
Attrib=
Time=Mon Sep 8 07:53:48 2031
OFun=0x1
Size=0
TimeOut=0
Res=0x0
smbbuf[]=
Path=
(DF)
------------------------------------------------
Does "WARNING: Short packet. Try increasing the snap length (44)" warn
about
something (serious).
and still there is an empty c:\sql.log and no other *.log.
the logfile of postmaster (running -d 6) does not mention anything at
all during
the period I try to connect.
hoping for help,
Karsten Kaus
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC - MSAccess W95/98
1999-02-04 21:39 ODBC - MSAccess W95/98 Karsten Kaus <kk@kdschmid.de>
@ 1999-02-04 14:14 ` David Hartwig <daveh@insightdist.com>
0 siblings, 0 replies; 2+ messages in thread
From: David Hartwig @ 1999-02-04 14:14 UTC (permalink / raw)
To: kk@kdschmid.de; +Cc: pgsql-interfaces
Here a few items which you can check which I do not see mentioned here.
1. Are you using the -i option when you start the postmaster?
2. Is the user set up in the DSN established on the server side/
3. Are the protocols compatable. (6.4 server vs 6.4 driver setting)
Have faith. We'll get the configuration worked out.
Karsten Kaus wrote:
> Hi there,
>
> (this time it is posted to interface also.)
>
> thanks a lot for the hints so far.
>
> this is my pg_hba.conf:
> ------------------------------------
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all 192.168.0.0 255.255.255.0 trust
> ------------------------------------
> what I understand is: 3rd line says all stations 192.168.0.x
> are allowed
>
> Now I try to be careful about the PsqlODBC FAQ from insightdigest:
> I remove my User- and System-DSN from 32Bit-ODBS as well as
> my SQL-Server kk1 from ODBC.
> I create a new System DSN:
> PostgeSQL Driver Version 6.40.0004
> Data Source: PostgreSQL
> Database: kk1 (still exist, just tested on capella)
> Server: 192.168.0.3
> Username: www
> Port: 5432
> Password: still secret
>
> then I (re)set the advanced driver options to default.
> advanced datasourceoptions (untouched i hope)
> all switches off, protocol 6.4
> back in system dsn i click on ok.
>
> I delete c:\*.log and enter the tracing section, where i request
> tracing all the time to c:\SQL.LOG.
> After <start tracing now> I close 32Bit-ODBC and move over to ODBC.
> There I <add driver> and select <SQL Server>:
> Datenquellenname: kk1 (datasourcename)
> Beschreibung: kk testet (description)
> Server: 192.168.0.3 (entered by typing, not selected from the list)
> Netzwerkadresse: (Standart) (networkadress)
> Netzwerkbibliothek: (Standart) (networklibrary)
>
> with <options> I enter the databasename kk1
> I quit this using ok and find the driver kk1 under the
> list of datasources.
> then I have to wait the remaining 21 minutes for my backup to come ready
> and
> will restart my computer (just in case).
>
> Meanwhile:
> I fed the database kk1 as user www on capella (192.168.0.3 running
> a fairly new linux version 2.0.35 from suse 5.3 (did I tell) ) with 2
> records,
> investigated the whereabouts of a signaturefile for one of the users and
> set up a new cofee, wich has nothing to do with the problem.
>
> The computer I'm working on is 192.168.0.33 (Muenchen) running W95.
> It is also mentioned in /etc/hosts on capella.
> nslookup of my station there gets a correct answer from our nameserver
> arktur (192.168.0.1).
>
> LABEL: Try2
> starting m$access, creating a new database.
> Tabelle - einbinden ( include table? ), file format: <SQL-Datenbank>
> datasource: kk1
> Anmeldename: www (does it matter: www or WWW?)
> Kennwort: stillsecret
>
> I start tcpdump on capella 2 times for traffic to capella and muenchen
> and
> press <OK> in Access.
> that is what I get:
> Error Message translated:
> ----------------------------------------------------------------
> Connection failed:
> SQL State: '01000'
> SQL Server-Error: -1
> [Microsoft][ODBC SQL Server Driver][dbnmp3]ConnectionOpen (sopen()),
> Connection failed:
> SQL State: '08001'
> SQL Server-Error: 0
> [Microsoft][ODBC SQL Server Driver]Connection could not be established.
> ----------------------------------------------------------------
> the file c:\sql.log contains 0 bytes and there is no other *.log
>
> tcpdump to my station (muenchen ....33) contains no significant packets.
> tcpdump to capella (....3) contains no significant packets.
>
> okay, I retry starting from 32Bit-ODBC thistime using capella as the
> servername
> and redefine the logsettings.
>
> in ODBC I change servername to capella and networkadress to 192.168.0.3.
> then I go to Label: Try2
>
> The errormessage ist the same as in try 1 and the tcpdumpfiles do not
> contain useful information for me, except that I would expect more
> packets there.
>
> some time later:
> after trying this and that i got a mayby hintful message from tcpdump.
> It is from capella to my station:
>
> 15:10:30.710266 192.168.0.3.139 > 192.168.0.33.1027: P 95:134(39) ack
> 237 win 16368
> >>> NBT Packet
> NBT Session Packet
> Flags=0x0
> Length=35
>
> SMB PACKET: SMBopenX (REPLY)
> SMB Command = 0x2D
> Error class = 0x2
> Error code = 4
> Flags1 = 0x80
> Flags2 = 0x1
> Tree ID = 114
> Proc ID = 7947
> UID = 100
> MID = 16643
> Word Count = 0
> SMBError = ERRSRV - ERRaccess (The requester does not have the
> necessary access rights within the specified context for the
> requested function. The context is defined by the TID or the UID.)
> smbvwv[]=
> Com2=smb_bcc=0
> ---------------------------------------------
>
> throughout the whole dump it is preceeded by this: (muenchen to
> capella):
> 15:10:31.330266 192.168.0.33.1027 > 192.168.0.3.139: P 322:407(85) ack
> 173 win 8109
> >>> NBT Packet
> NBT Session Packet
> Flags=0x0
> Length=81
> WARNING: Short packet. Try increasing the snap length (44)
>
> SMB PACKET: SMBopenX (REQUEST)
> SMB Command = 0x2D
> Error class = 0x0
> Error code = 0
> Flags1 = 0x0
> Flags2 = 0x1
> Tree ID = 114
> Proc ID = 7947
> UID = 100
> MID = 16899
> Word Count = 15
> smbvwv[]=
> Com2=0xFF
> Off2=0
> Flags=0x1
> Mode=0x42
> SearchAttrib=HIDDEN SYSTEM DIR
> Attrib=
> Time=Mon Sep 8 07:53:48 2031
> OFun=0x1
> Size=0
> TimeOut=0
> Res=0x0
> smbbuf[]=
> Path=
>
> (DF)
> ------------------------------------------------
> Does "WARNING: Short packet. Try increasing the snap length (44)" warn
> about
> something (serious).
>
> and still there is an empty c:\sql.log and no other *.log.
> the logfile of postmaster (running -d 6) does not mention anything at
> all during
> the period I try to connect.
>
> hoping for help,
> Karsten Kaus
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-02-04 21:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-04 21:39 ODBC - MSAccess W95/98 Karsten Kaus <kk@kdschmid.de>
1999-02-04 14:14 ` David Hartwig <daveh@insightdist.com>
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