>I want to access the Lotus Notes personnal address book from fpw26 using ODBC. I don't exactly know how to setup a data source name with the ODBC administrator and I didn't had any success at all with ODBC in fpw26.
>
>Here is what I did:
>
>I have created a User Data Source with the ODBC Data Source Administrator like this:
>Lotus NotesSQL Driver (*.nsf) version 3.00.02.17 dated 2001.02.17
>Data Source Name is "Notes"
>Description is ""
>Domino server is "local"
>Database is "names.nsf"
>
>in the NotesSQL Options:
>
>Notes UserName is "user" (the name entered in the file user.id)
>Notes Password is "abc"
>and the rest is default
>
>My fpw26 code is:
>

>set library to fpsql
>?dbConnect("Notes", "user", "abc")
>

>the result is always -2 and if I call dbError(0, @ErrMsg, @ErrNo) I always get this message in the variable ErrMsg:
>
>"ODBC error IM002 (0): [Microsoft][ODBC DLL] Data source not found and no default driver specified"
>
>If I use vfp5 and I do a =SQLConnect("Notes", "user", "abc") it seems to work since I get a positive number as a result.
>
>My fpsql.fll is dated 94-03-07
>
>Any ideas?

Probably the problem is connected with the fact that FPW and the connectivity kit are 16 bit apps. They'd require a 16 bit driver for Notes.