Re: [Iodbc-applications] SWI-Prolog

[Tim H. <th...@op...>]

On 5 Apr 2006, at 10:50, I wrote:

>> ?- import(odbc).
>>
>> Yes
>> ?- use_module(ODBC).
>>
>> ODBC = []
>>
>> Yes
>> ?- open_wordnet :-
>> |    odbc_connect('pgstraw', _,
>> |    [user(me),
>> |    password(foo),
>> |    alias(pgstraw),
>> |    open(once)
>> |    ]).
>> ERROR: Undefined procedure: (:-)/2
>> ?-
>
> Could you suggest where I'm going wrong there? Maybe the above is  
> of some help anyway.

Actually, I appear to have proved the link from prolog to iODBC, but  
I don't know how to assign a handle variable thing to the connection:

> ?- odbc_connect('pgstrawinvalid', _, [user(me), alias(pgstraw), open 
> (once)]).
> ERROR: ODBC: State IM002: [iODBC][Driver Manager]Data source name  
> not found and no default driver specified. Driver could not be loaded
>    Exception: (7) odbc:odbc_connect(pgstrawinvalid, _G196, [user 
> (me), alias(pgstraw), open(once)]) ?

invalid gives an exception with error message from iODBC while  
omitting it says `Yes'. That's a successful demonstration in my book :)

~Tim
-- 
Tim Haynes
Product Development Consultant
OpenLink Software
<http://www.openlinksw.com/>