pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: [NOVICE] ODBC-Setup 2+ messages / 2 participants [nested] [flat]
* Re: [NOVICE] ODBC-Setup @ 1999-02-02 09:31 Byron Nikolaidis <byronn@insightdist.com> 0 siblings, 0 replies; 2+ messages in thread From: byronn@insightdist.com @ 1999-02-02 09:31 UTC (permalink / raw) To: kk@kdschmid.de; +Cc: pgsql-interfaces > > Hi, > > I believe this belongs to the novice section: Actually, this is a good one for "interfaces". > > I got postgres6.4.2, it compiled and works fine, as long as I stay on th > localhost. My server's name is Capella on 192.168.0.3 and I don`t get > connected. > - I can see networktraffic from my station to capella using tcpdump on > capella when accessing samba-drives. > -I can see NO networktraffic from my station to capella using tcpdump on > capella when trying to connect to a database. > > -Postgres was configured --with-odbc > > -Yes, I do use the -i option with postmaster. > > This is what m$access says, when I try to connect > ---------------------------------------------------------------------- > Verbindung fehlgeschlagen (connection failed) > SQLStat 01000 > SQL Server Error: -1 > [Microsoft][ODBC SQL Server Driver][dbnmp3]ConnectionOpen (sopen()) > Verbindung fehlgeschlagen (connection failed) > SQLStat 08001 > SQL Server Error: 0 > ---------------------------------------------------------------------- > > Is [Microsoft][ODBC SQL Server Driver][dbnmp3] part of correct driver? > Here is no hint, that I'm using the postgres driver > > This is a logfile (from postgresdriver?): > ---------------------------------------------------------------------- > DSN info: > DSN='PostgreSQL',server='192.168.0.3',port='5432',dbase='kk1',user='www',passwd='secret' > > readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' > conn_settings='' > translation_dll='',translation_option='' > ---------------------------------------------------------------------- Can you try again and this time try to get a better "psqlodbc.log" file. It is created during an odbc session. You should be able to see the connect attempt and error message. The clip above is either a different session or just a portion of it. > user www had had a 'GRANT all on bar to www' and a 'create user www with > password secret' > and he can connect to the database when typing on the console of > capella. > > Is there any idea outside what is wrong here, or where I can read about > setting up ODBC for > Windows95/98? There is a good bit of information on the various settings at our web site (http://www.insightdist.com/psqlodbc). Should be an area there called configuration settings, as well as a FAQ. Byron ^ permalink raw reply [nested|flat] 2+ messages in thread
* [NOVICE] ODBC-Setup @ 1999-02-03 23:40 Karsten Kaus <kk@kdschmid.de> 0 siblings, 0 replies; 2+ messages in thread From: Karsten Kaus @ 1999-02-03 23:40 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
end of thread, other threads:[~1999-02-03 23:40 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1999-02-02 09:31 Re: [NOVICE] ODBC-Setup Byron Nikolaidis <byronn@insightdist.com> 1999-02-03 23:40 [NOVICE] ODBC-Setup Karsten Kaus <kk@kdschmid.de>
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