[REBOL] Re: Connecting to the database
From: rebol:optushome:au at: 20-Jul-2002 7:59
> This one also doesn't work:
> <code>
> connect-name: open [scheme: 'odbc target: "{DRIVER=Microsoft Access Driver
> (*.mdb)}; DBQ=C:\rebol\view\WorkSpace\mydb.mdb"]
> </code>
>
Hi Abdel
The connection string example in the docs has a few typos (corrections were
submitted in Feb)
------------------
Under "Connecting without a DSN (ODBC only)"
The example shows
connect-name: open [scheme: `odbc target: "{DRIVER=Microsoft Access Driver
(*.mdb)}; DBQ=c:\Databses\mydb.mdb"]
it should be
connect-name: open [scheme: 'odbc target: {DRIVER=Microsoft Access Driver
(*.mdb); DBQ=c:\Databses\mydb.mdb}]
----------------
So in your piece of code it should become
connect-name: open [scheme: 'odbc target: {DRIVER=Microsoft Access Driver
(*.mdb); DBQ=C:\rebol\view\WorkSpace\mydb.mdb}]
Cheers,
Allen K