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: 549
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