ms access 97
От | Vidas Makauskas |
---|---|
Тема | ms access 97 |
Дата | |
Msg-id | d896jb$112c$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: ms access 97
|
Список | 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
В списке pgsql-odbc по дате отправления: