Message-ID: <36B8DE7B.64AE@kdschmid.de>
Date: Wed, 03 Feb 1999 15:40:43 -0800
From: Karsten Kaus <kk@kdschmid.de>
Reply-To: kk@kdschmid.de
Organization: Konzertdirektion Hans Ulrich Schmid
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: [NOVICE] ODBC-Setup
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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