RE: Unable to connect to the SQL server Daniel W Heichel 27.Jun.14 11:27 PM Lotus Notes LEI LEI - All ReleasesWindows
The drivers should be available as part of your Domino license. I said "meant to work with LEI", but what I should have said was "meant to work with all Lotus Integration products", of which some (DECS and LSXLC) are included with any Domino Enterprise Server. So you should freely be able to download those.
It's possible that a firewall could be involved if it were blocking the ODBC port, but that's not a common cause of problems. You are also getting "Invalid String", not anything that would indicate firewall interference (such as "no path found to server" or the like).
I would highly urge you to:
1. Download the 64-bit IBM Datadirect Connect 5.3.3 drivers. The part number for the Windows English version is CZM48EN. I find that when I search Passport Advantage for just the search term ODBC that it then returns all the ODBC options. Install the drivers.
2. Then create a System Data Source in your 64-bit ODBC Manager (found under Start -> Control Panel -> Administrative Tools -> Data Sources (ODBC)) using the SQL Server Wire Protocol driver included in the package. Give it a unique name. You don't need to put the userID/password in the DSN.
3. Click Test Connect at the bottom of the DSN, and put the userID/password in the popup that appears, and send it. If it fails here, you have something incorrectly filled out in the DSN. If it succeeds, then move on to step 4.
4. In LEI, create a Connection to ODBC. Put the name of the Data Source created in step 2 in for the "Data Source" field, and enter the proper username / password.
5. Now you should be able to scroll down towards the bottom of the Connection to ODBC document, and click either the Owner or Table dropdown. It should return with a list of metadata (library or table names, depending on which dropdown you clicked). At that point you are retrieving data from the back-end and have a successful connection. You're ready to use it as a Source or Target in an LEI activity.
Return to top
. . . . . . . . RE: Unable to connect to the SQL se... (Daniel W Heiche... 27.Jun.14) 
Print this page
