Access ODBC Driver questions

the.weavster · Post by **the.weavster** » Mon Apr 04, 2005 11:42 am

Does anybody know the escape character for the MS Access ODBC driver?

Also, does it support transactions? If so what are the statements for BeginTransaction, Commit and RollBack?

Thanks

Weave

Tension · Post by **Tension** » Mon Apr 04, 2005 2:00 pm

Hi the.weavster,

Regarding transactions, I think it can be done, here's a link to a site with some VB code using access/transaction server.

http://www.softlookup.com/tutorial/data ... #Heading20

Also aXend did some useful preliminary work that may help you with this vis purebasic (he uses com to access msAccess). This thread:

viewtopic.php?t=14214&highlight=

Not sure what you mean by an ODBC escape sequence.

the.weavster · Post by **the.weavster** » Tue Apr 05, 2005 9:55 am

Thanks Tension.

The escape character is necessary if the text you are storing to a database contains a quotation character.

In MySQL it is \, so if you wanted to store 'don't respond' to a database you would have to format it as 'don\'t respond' in the SQL statement you sent to the server.

I have actually found what it is with the access driver, it is another quote.
e.g. 'don''t respond'

Weave

Tension · Post by **Tension** » Wed Apr 06, 2005 7:59 am

the.weavster wrote:it is another quote. e.g. 'don''t respond'Weave

"To quote a guy a I asked on this: ""yep"""

the.weavster · Post by **the.weavster** » Wed Apr 06, 2005 2:15 pm