Rebol MSAccess ODBC: works with DNS connection but not with DNSLess Connection

Posted by Rebol Tutorial on Stack Overflow See other posts from Stack Overflow or by Rebol Tutorial
Published on 2010-03-05T20:53:08Z Indexed on 2010/04/15 0:33 UTC
Read the original article Hit count: 501

Filed under:
|
|

I have tested the new free Rebol ODBC with MS Access after reading the doc here

http://www.rebol.com/docs/database.html

It works with ODBC DNS connection but when I tested with this DNSLess connection (MSAccess2003 file with MSAccess2007 installed):

connect-name: open [
    scheme: 'odbc
    target: join "{DRIVER=Microsoft Access Driver (*.mdb)}; "
        "DBQ=c:\test\test.mdb"
]

It shows this error:

>>     connect-name: open [
[            scheme: 'odbc
[            target: join "{DRIVER=Microsoft Access Driver (*.mdb)}; "
[                "DBQ=c:\test\test.mdb"
[        ]
** Access Error: Invalid port spec: scheme odbc target join {DRIVER=Microsoft Access Driver (*.mdb)};
  DBQ=c:\test\test.mdb
** Near: connect-name: open [
    scheme: 'odbc
    target: join "{DRIVER=Microsoft Access Driver (*.mdb)}; "
    "DBQ=c:\test\...
>>
>>

Do you know why ?

Thanks.

© Stack Overflow or respective owner

Related posts about rebol

Related posts about ms-access