'm having trouble connecting to a Lotus Notes DB using CF MX 7 and DW MX 2004. So far what I've done is:
1) Setup a System DSN in the ODBC Admin for a Lotus NotesSQL Driver. I gave it a name, told it which server, which DB and in the NotesSQL option, added a username based off of my current notesid file and gave it the current password.
2) Setup a datasource in CF MX 7 Admin using the ODBC with the System DSN that was setup. I used the username (full lostus notes username) and password, and the source was varified as ok.
However, when I try to create a record set in DW, I'm asked for a Data Source Login. I provide the same username and password however I get and error saying [odbc lotus notes]invalid string or buffer length
Thanks in advance
1) Setup a System DSN in the ODBC Admin for a Lotus NotesSQL Driver. I gave it a name, told it which server, which DB and in the NotesSQL option, added a username based off of my current notesid file and gave it the current password.
2) Setup a datasource in CF MX 7 Admin using the ODBC with the System DSN that was setup. I used the username (full lostus notes username) and password, and the source was varified as ok.
However, when I try to create a record set in DW, I'm asked for a Data Source Login. I provide the same username and password however I get and error saying [odbc lotus notes]invalid string or buffer length
Thanks in advance