Could someone explain to me how to connect ODBC

Asked By fable 0 points N/A Posted on - 01/25/2012

Could someone explain to me how to connect ODBC data sourcing that will identify Lotus Notes? Here is an example, If I make a file named dsn (lotus), then I use Talend Open Studio to try connecting to it, I receive the message “not found”. Even though I can still use Microsoft Access to contact the data source. Any suggestions would be appreciated.

• Status: Open
• Question Views: 888
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ProgScripting Languages

Answered By pankajvishwakarm 0 points N/A #124091

Could someone explain to me how to connect ODBC

With an ODBC connection, we can connect to any database, on any computer in your network, as long as an ODBC connection is available.

First if you are using windows xp, windows7,windows vista then you should first enable the IIS services on your computer.For this you go to start panel click on control panel

    Go to the Programs and Features

    Then you click on turn windows feature on or off

   Enable the IIS services and click ok After restart computer you apply the procedure below.

1. Open the ODBC icon in your Control Panel.
2. Choose the System DSN tab.
3. Click on Add in the System DSN tab.
4. Select the Microsoft Access Driver. Click Finish.
5. In the next screen, click Select to locate the database.
6. Give the database a Data Source Name (DSN).
7. Click OK.

About pankajvishwakarm

Questions
0

Answers
26

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 01/25/2012
• Question Category: ProgScripting Languages