I have installed the Notes SQL drivers that get loaded along with the Crystal reports installation, but I am unable to create an ODBC resource name in the ODBC connections. I was neither prompted to enter the password nor can I even see the server name in the list. What could be the problem?
I was working on the R5 database. It was connecting fine, but I don't know why it is not able to create for R6. Please help me solve this problem. Thanks in advance.
My guess is that the NotesSQL driver that came with Crystal is an older version and does not support the Domino 6 ODS. You need to download and install NotesSQL 3.02, which you can get from LDD here.