From: | Karsten Kaus <kk(at)kdschmid(dot)de> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | ODBC - MSAccess W95/98 |
Date: | 1999-02-04 21:39:01 |
Message-ID: | 36BA1375.D56@kdschmid.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri | 1999-02-04 22:14:19 | Re: [SQL] problem with join & count |
Previous Message | Jackson, DeJuan | 1999-02-04 21:00:47 | RE: [SQL] problem with join & count |