Rebol MSAccess ODBC: works with DNS connection but not with DNSLess Connection
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:
>>开发者_StackOverflow; 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.
I suspect that you're using Rebol 2.7.7 core which does not come with ODBC. You need to use View.
Here's the link
http://synapse-ehr.com/forums/showthread.php?18-Rebol-odbc
for the example
精彩评论