开发者

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

开发者 https://www.devze.com 2022-12-22 05:36 出处:网络
I have tested the new free Rebol ODBC with MS Access after reading the doc here http://www.rebol.com/docs/database.html

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

0

精彩评论

暂无评论...
验证码 换一张
取 消