| From: | "Vidas Makauskas" <vms(at)centras(dot)lt> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | ms access 97 |
| Date: | 2005-06-09 10:45:04 |
| Message-ID: | d896jb$112c$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
I can connect to database via DSN:
Set wrkODBC = CreateWorkspace("", "uname", "", dbUseODBC)
odbc="ODBC;DSN={PostgreSQL};DATABASE=db;SERVER=server;PORT=5432;Uid=uname;Pwd=pass;"
Set conODBC = wrkODBC.OpenConnection("uname", , , odbc)
Some years ago i've been using DRIVER instead of DSN:
odbc="ODBC;DRIVER={PostgreSQL};DATABASE=db;SERVER=server;PORT=5432;Uid=name;Pwd=pw;"
& _
'"A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096;A9=0;"B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_"
but today i got error
what is wrong?
I can edit link'ed table. Primary key exists too. But
Set recordset = conODBC.OpenRecordset("SELECT * FROM table", dbOpenDynaset
[,dbOptimistic] )
recordset.updatable = false
what is wrong?
Thanks in advance,
Best regards,
Vidas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Campbell | 2005-06-09 13:23:01 | Re: ms access 97 |
| Previous Message | Alberto Velo | 2005-06-09 07:28:14 | Re: ODBC Error in logs |