Using PostgreSQL transactions through MS Access? 
Author Message
 Using PostgreSQL transactions through MS Access?

Drop the semicolon at the end of the string.  In this context, it's not needed
to tell where the end of the statement is.

You might want to use a parameterized stored procedure that does multiple
updates inside a transaction.  You would invoke the stored procedure via
mdb.Execute, as per your example.

--Wes


06:31:24 PM


cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject:  [GENERAL] Using PostgreSQL transactions through MS Access?

I am trying to update my database with a big transaction so I don't get
an invalid state.  My front end is in Access 97.  Is there anyone out
there who does this that could tell me what I'm doing wrong?  Here's my
code:

queryString = "BEGIN TRANSACTION;"
mdb.Execute queryString, dbSQLPassThrough

It tells me that it's an "Invalid SQL Statement".  It seems like Access
is trying to parse it instead of sending it on to the DB server.  I
thought that the dbSQLPassThrough was supposed to stop that.  Does
anyone know where I went wrong?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sat, 10 Jan 2004 01:47:18 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Using Connecting to Postgresql from MS Access

2. Using MS Access 2.0 db's via ODBC from Delphi v1.0 with transactions

3. Using explicit transactions in Delphi 2.0 and Ms Access

4. Regarding Accessing External database using MS-Access and MS-Visual Basic

5. LAN Traffic issues between using VB Frontend/MS Access Backend vs Just MS Access

6. connect to the MS Access database without using the ODBC driver for MS Access

7. MS-Access: MySQL vs. PostgreSQL

8. interfacing ms-access with postgresql?

9. Using MS Windows 3.1 common dialogs DLL from MS Access

10. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY

11. MS SQL Server vs. Mysql using MS Access


 
Powered by phpBB® Forum Software