FAQ

Search Discussions

47 discussions - 165 posts

  • I'm running PostgreSQL on a Debian GNU/Linux box and have installed pgAdmin successfully on a Windows 98 machine. pgAdmin works fine for updating tables. I can use Access 2000 to insert a new row in ...
    Chris GrayChris Gray
    May 7, 2001 at 6:09 pm
    May 15, 2001 at 6:39 am
  • Nope. Thanks for the info. Hey everyone, this should be advertised a bit more... ;) BTW, is someone maintaining this page?
    Cedar CoxCedar Cox
    May 21, 2001 at 11:05 am
    May 23, 2001 at 4:13 pm
  • Hi, I've committed several bug fixes. Psqlodbc is 7.01.0005 now. 1) Parameter handling patch by Hiroki Kataoka. This fixes bugs reported by Ludek Finstrle, Matteo Cavalleri and Johann Zuschlag. 2) ...
    Hiroshi InoueHiroshi Inoue
    May 1, 2001 at 2:40 am
    May 25, 2001 at 4:30 pm
  • In the table I'm having trouble with all fields are varchar except for the primary key which was defined as a serial type. Chris
    Chris GrayChris Gray
    May 9, 2001 at 1:20 pm
    May 11, 2001 at 5:54 pm
  • why do i get ERROR: Relation 'msysconf' does not exist when connecting to an empty database via odbc? just curious .. i'm rather new to the postgres + odbc world -j
    RadiusRadius
    May 24, 2001 at 7:24 pm
    May 29, 2001 at 12:25 pm
  • I am having problems writing to a postgres database using ODBC. Here are the steps I have taken: 1. I have greated a lo type in the database create type lo ( internallength=4, externallength=10, ...
    Matthew DormerMatthew Dormer
    May 3, 2001 at 4:43 pm
    May 11, 2001 at 12:29 pm
  • [snip] I don't agree to apply the patch because the patch makes the current code hardly understandable. regards, Hiroshi inoue
    Hiroshi InoueHiroshi Inoue
    May 9, 2001 at 2:05 am
    May 9, 2001 at 1:04 pm
  • OK, I have created a context diff of your changes, which is attached. Can someone comment on this? The patch appears to deal with STMT_PREMATURE differently than our current code. In fact, it seems ...
    Bruce MomjianBruce Momjian
    May 8, 2001 at 4:55 pm
    May 9, 2001 at 1:57 am
  • I'm using postgres 6.5.2 on Red Hat Linux 6.1 When updating tables in Access97 on a Windows NT 4.0 we've been getting '#deleted's showing up on records we're adding to a table. I've run vacuum on the ...
    Tom.BakkenTom.Bakken
    May 4, 2001 at 5:19 pm
    May 7, 2001 at 9:26 pm
  • Hi, I have encountered a problem with following query run over ODBC in MS VS 6.0 SP5 in DataEnvironment designer: "SELECT SUM(field1) FROM table1;" field 1 is of type INT4. There is "E_FAIL" error ...
    Sekcja Informatyki MedycznejSekcja Informatyki Medycznej
    May 31, 2001 at 3:10 pm
    Jun 1, 2001 at 11:45 pm
  • Attached is a small patch to SQLStatistics() to allow proper information about CLUSTER and HASH indexes, as proposed by the ODBC code. Right now the CLUSTER information is not maintained, but the ...
    Bruce MomjianBruce Momjian
    May 15, 2001 at 7:18 pm
    May 16, 2001 at 2:39 am
  • I have been sitting on my ODBC source code cleanup patch for a while. Now that we are in 7.2, does anyone have outstanding ODBC patches before I apply this? Hiroshi, did you apply yours already? -- ...
    Bruce MomjianBruce Momjian
    May 7, 2001 at 8:28 pm
    May 7, 2001 at 11:54 pm
  • Hello, You can't alter table design from access using linked tables, if thats what you meant by not being able to update columns. You say you can only add/update/delete records, if you can't read ...
    Henshall, Stuart - WCPHenshall, Stuart - WCP
    May 29, 2001 at 8:09 am
    May 29, 2001 at 1:12 pm
  • Hi everyone, I'm attempting to compile the odbc interface for postgresql 7.1, and it keeps giving me these unresolved symbol errors. Any help would be appreciated, as I am admittedly somewhat of a ...
    William OsmondWilliam Osmond
    May 16, 2001 at 9:20 pm
    May 25, 2001 at 3:57 pm
  • ANY HELP PLEASE!!!! Regards, Abhimanyu Bhola -----Original Message----- From: Abhimanyu_Bhola Sent: Monday, May 21, 2001 10:54 PM To: Bo Lorentsen; pgsql-general Subject: [GENERAL] how to install ...
    Abhimanyu_BholaAbhimanyu_Bhola
    May 22, 2001 at 2:25 pm
    May 22, 2001 at 2:27 pm
  • A suggestion for a feature to add to your already wonderful ODBC capability. Could you add a boolean option that enables/disables case sensitivity with ODBC calls? Consider this example, a Delphi ...
    Robert HurstRobert Hurst
    May 11, 2001 at 12:29 pm
    May 15, 2001 at 8:43 am
  • Hello, I'm worried about the transactions of sensitive data on the network without encryption. Is there any way to secure not only passwords but also data? I read in the mailling list archive ...
    Rony KhouryRony Khoury
    May 7, 2001 at 9:25 am
    May 9, 2001 at 9:51 pm
  • My problem reminds me of the poem "I saw a man who wasn't there". I created a table some time ago. When I try to drop it it says "no such file or directory". When I run vacuum or copy out it also ...
    Tom.BakkenTom.Bakken
    May 4, 2001 at 1:12 pm
    May 4, 2001 at 6:44 pm
  • Hi, I have recently purchased Kylix for developing applications ( in particular a Billing system ) and would like to use Postgress if possible. Kylix comes with interface for MYSQL , DB2 , Oracle , ...
    Balvinder DhinsaBalvinder Dhinsa
    May 28, 2001 at 12:29 pm
    May 29, 2001 at 7:18 am
  • (I've posted this once before, but it didn't make it to the list I hope this time it will work) hi, I tried the combination of the above three (for now only for reading) but did not succeed. I ...
    Tulassay ZsoltTulassay Zsolt
    May 27, 2001 at 2:51 pm
    May 29, 2001 at 5:39 am
  • Hello everybody: I am trying to use a PostgreSQL -7.1.1 database through psqlODBC with NO SUCCESS (I mean I can not connect to the database). Has anyone manage to do it?. Do I need iodbc at all? I am ...
    Ramiro AlbaRamiro Alba
    May 15, 2001 at 1:16 pm
    May 21, 2001 at 11:06 pm
  • Hell, In postgresql ODBC when a user type in a password is it sent over the network in its original text format or does it get encrypted and then sent? thank you, Rony. Get Your Private, Free E-mail ...
    Rony KhouryRony Khoury
    May 14, 2001 at 8:03 am
    May 21, 2001 at 11:30 am
  • Hello, I do not know what is it with this deleted thing ?!? After downloading the latest postgresql (postgresql 7.1) and the latest odbc driver on two totaly newly installed machines. I narrowed down ...
    Rony KhouryRony Khoury
    May 16, 2001 at 4:03 pm
    May 17, 2001 at 12:45 pm
  • I have applied the following patch to ODBC index lookups for HASH. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
    Bruce MomjianBruce Momjian
    May 16, 2001 at 5:58 pm
    May 16, 2001 at 10:35 pm
  • Hi, ODBC seems to be having a problem with the following prepared statement: "SELECT t3.* FROM JURISDICTION2 t3 WHERE jurisdiction_name = ?" I am trying to use a software tool called Feature ...
    Graeme LeemingGraeme Leeming
    May 29, 2001 at 3:32 am
    May 29, 2001 at 5:30 am
  • How do you log on to the site containing the drivers. It seems to be password protected alan
    RootRoot
    May 22, 2001 at 2:24 pm
    May 23, 2001 at 8:46 am
  • Hello, in my VBA code I execute a plpgsql-function via a pass through query and ODBCdirect, but I don't know, how I can use the returned value for further calculations in VBA. Is there a possibility ...
    DI HasenöhrlDI Hasenöhrl
    May 22, 2001 at 8:31 pm
    May 23, 2001 at 8:28 am
  • Hi, I'm using version 7.01.0005 of the psqlodbc.dll driver, with Windows 98 and Office 97. I'm trying to use MSQuery to grab some data into Word for a mailmerge. The problem is that when MSQuery ...
    Chris AndrewsChris Andrews
    May 16, 2001 at 8:54 pm
    May 17, 2001 at 12:52 am
  • Can anyone tell me if the Postgresql ODBC is a 32-bit driver? Thanks
    Issurdatt, Portia CECOM RDEC STCD SRCIssurdatt, Portia CECOM RDEC STCD SRC
    May 16, 2001 at 12:55 pm
    May 16, 2001 at 1:32 pm
  • Hm, I notice #define TEXT_FIELD_SIZE 8190 /* size of text fields * (not including null * term) */ in src/interfaces/odbc/psqlodbc.h ... does changing that help? regards, tom lane
    Tom LaneTom Lane
    May 11, 2001 at 3:57 pm
    May 14, 2001 at 2:48 am
  • Hi, Could u just tell me if it is possible to have a Windows Client and the Server running on Linux and having Postgres and the two communicate thru something like the ODBC Thanx Kapil Chat with your ...
    Kapil c. tilwaniKapil c. tilwani
    May 11, 2001 at 6:07 pm
    May 11, 2001 at 6:09 pm
  • I've searched and dug around and just a couple of questions if someone could sort me out. I'm trying to make sure I have the right/current files to install the postgreSql ODBC drivers on win32. The ...
    Ken GodeeKen Godee
    May 10, 2001 at 5:57 pm
    May 11, 2001 at 7:45 am
  • Hello all, I seems that ADODB is not fully implemented in PostgreSQL odbc driver. When working in VB, it is possible to create a connection, query the database and retrieve field names. But I did not ...
    Jean-Michel PoureJean-Michel Poure
    May 8, 2001 at 3:02 pm
    May 8, 2001 at 4:15 pm
  • I have sent the last 2 days trying to find the postgresql driver for windows. The ftp site seems to be password protected. Can any body help me with an alternative to download the drivers (msi). ...
    Luke MahonyLuke Mahony
    May 8, 2001 at 7:38 am
    May 8, 2001 at 1:12 pm
  • I've got a sudden hard disk space problem that appears to be related to core and pg_sorttemp2761.2 like files in the base/database directory. Can these be deleted with no ill effects? I removed one ...
    Tom.BakkenTom.Bakken
    May 7, 2001 at 4:01 pm
    May 7, 2001 at 8:57 pm
  • Hi all, So far the driver is ok (using cvs from today). But while looking for my 'page fault error when exiting' I found the following: When I tried to connect with a wrong ip (on purpose) I found ...
    Johann ZuschlagJohann Zuschlag
    May 31, 2001 at 7:51 pm
    May 31, 2001 at 7:51 pm
  • Hi, does the driver support dynaset Recordset yet? Thx! -haffi
    Hafsteinn Þór HafsteinssonHafsteinn Þór Hafsteinsson
    May 31, 2001 at 11:53 am
    May 31, 2001 at 11:53 am
  • sorry about the test, I got dumped from the list and haven't seen anything since coming back yesterday morning. Just makin sure it works. Vince. -- ...
    Vince VielhaberVince Vielhaber
    May 22, 2001 at 3:10 pm
    May 22, 2001 at 3:10 pm
  • Hi mordicus, I believe I already fixed this problem though my solution is different from yours. I'm working on getting rid of query size limit now. I hope both will appear in 7.01.0006. thanks, ...
    Hiroshi InoueHiroshi Inoue
    May 21, 2001 at 2:00 am
    May 21, 2001 at 2:00 am
  • Hello, I have installed all the above (see subject) software and whenever I try to see the tables in a database with DataManager (a program supplied alongside unixODBC), th program just won't show ...
    Jorge SantosJorge Santos
    May 18, 2001 at 8:52 pm
    May 18, 2001 at 8:52 pm
  • Why am I unable to store long strings using TEXT fields if the size of my string is 8190 chars? If I try to increase Max LongVarChar to 20000 (in the Advanced Options box of the Odbc driver) i get ...
    Ing. Ivo SchwarzerIng. Ivo Schwarzer
    May 18, 2001 at 2:36 pm
    May 18, 2001 at 2:36 pm
  • Hello PostgreSQL friends, it was a fault to install Office XP because since then my Access Database doesnt work properly. The ODBC Driver says this all the time: ------------------------------- ...
    Norbert SchollumNorbert Schollum
    May 13, 2001 at 4:38 pm
    May 13, 2001 at 4:38 pm
  • I am gettin a run-time error '3669' when using VB for applications. The first recordset runs fine, but the second recordset takes a few minutes to run and then gives me the error message. I do not ...
    Jamie LackeyJamie Lackey
    May 11, 2001 at 12:28 pm
    May 11, 2001 at 12:28 pm
  • Hello my friends, First of all, I would like to thank you all for this wonderful job. I have been using PostgreSQL for two years now, along with other db such as Oracle8 and MS SQL Server 7. Now, I ...
    Jean-Michel PoureJean-Michel Poure
    May 8, 2001 at 7:09 am
    May 8, 2001 at 7:09 am
  • Hi. I've just compiled PostgreSQL on Cygwin, and I want to start some tests about. As I read in docs, I downloaded an ODBC package from openlinksw.com, however I didn't able to configure it in order ...
    Julio César GázquezJulio César Gázquez
    May 4, 2001 at 11:51 pm
    May 4, 2001 at 11:51 pm
  • Hi, I am quite new to Postgres. My problem arises while UPDATING a record containing a text field if the length of it is 8190 characters. I use Postrgres 7.1 (RedHat 6.2, RPM version) and version ...
    Ing. Ivo SchwarzerIng. Ivo Schwarzer
    May 3, 2001 at 4:43 pm
    May 3, 2001 at 4:43 pm
  • I have compiled the latest ODBC driver code (07.01.0005) for Win32, and made it available for download at ftp://ftp.postgresql.org/pub/odbc/versions/. The following text is taken from download.html ...
    Dave PageDave Page
    May 2, 2001 at 7:59 am
    May 2, 2001 at 7:59 am
Group Navigation
period‹ prev | May 2001 | next ›
Group Overview
grouppgsql-odbc @
categoriespostgresql
discussions47
posts165
users49
websitepostgresql.org
irc#postgresql

49 users for May 2001

Hiroshi Inoue: 24 posts Bruce Momjian: 17 posts Dave Page: 12 posts Tom Lane: 12 posts Henshall, Stuart - WCP: 10 posts Radius: 7 posts Tom.Bakken: 7 posts Vince Vielhaber: 6 posts Cedar Cox: 5 posts Chris Gray: 5 posts Peter Wilkinson: 4 posts Jean-Michel Poure: 3 posts Kapil c. tilwani: 3 posts Matthew Dormer: 3 posts Rony Khoury: 3 posts William Osmond: 3 posts DI Hasenöhrl: 2 posts Ing. Ivo Schwarzer: 2 posts Issurdatt, Portia CECOM RDEC STCD SRC: 2 posts Johann Zuschlag: 2 posts
show more
Archives