Thread: ms access 97

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

If your recordset is going to be not updateable,
you should try a dbOpenReadOnly instead of dbOpenDynaset.

In fact I would say dbOpenDynaset should be reserved for Jet datasources.

Make DML updates using individual UPDATE, INSERT, and DELETE statements.


Vidas Makauskas wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Much thanks,
As i understoot it do not imposible update recordset without table linking.

""Greg Campbell"" <greg.campbell@us.michelin.com> wrote in message
news:42A842B5.9050100@us.michelin.com...
> If your recordset is going to be not updateable,
> you should try a dbOpenReadOnly instead of dbOpenDynaset.
> In fact I would say dbOpenDynaset should be reserved for Jet datasources.
> Make DML updates using individual UPDATE, INSERT, and DELETE statements.
>> 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?