Solved

ODBC doesn't show list of databases

Posted on 2014-10-22
10
259 Views
Last Modified: 2014-10-28
Hi Experts

I've installed NotesSQL 8.5 on Windows 7 64bit, and I wasn't able to see the driver. After research I found that I'm using the wrong ODBC. So now I'm using C:\Windows\SysWOW64\odbcad32.exe which shows the driver.

Once started, I specified the Data Source name, Description, Domino Server (it asked me for the Lotus Notes password which I provided), but the list of Databases is still empty. Any thoughts ?

Many thanks in advance.ODBC Snapshot
0
Comment
Question by:Faraj1969
  • 5
  • 4
10 Comments
 
LVL 33

Expert Comment

by:sarabande
ID: 40398549
So now I'm using C:\Windows\SysWOW64\odbcad32.exe
did you add 'user' or 'system' data sources or both? the first would only available for the current user while the system data sources might need admin rights to be recognized as valid data sources.

try to start the odcb lotes notes setup "as administrator". if that doesn't help define your data sources as 'system' and try again.

Sara
0
 

Author Comment

by:Faraj1969
ID: 40399025
The Odbcad32 started as Administrator, and I'm creating the connection under System DSN. Still facing the same issue.
0
 
LVL 34

Expert Comment

by:Gary Patterson
ID: 40399318
You may want to review the following:

http://www-01.ibm.com/support/docview.wss?uid=swg27041194

Also, this may be relevant:

Note In some cases, Notes may need to create a cross-certificate for the server you want to access. In this case, the Database field will not be populated and you will not be able to access the server. To resolve this problem, access the server in Notes (using the appropriate user ID) and create the cross-certificate when prompted.

http://publib-b.boulder.ibm.com/lotus/c2735080.nsf/66208c256b4136a2852563c000646f8c/17e4bc791cb2b6d485256dd7004d7ff4?OpenDocument
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 33

Expert Comment

by:sarabande
ID: 40399508
I'm creating the connection under System DSN. Still facing the same issue.

probably Gary is right and Notes shows only databases where it has access to.

you could make an attempt by also starting ODBC Notes Setup as administrator. the system dsn entries are in the local machine part of the registry and might not be accessible for non-admin users. also you may try with user dsn.

is the database field a mandatory field? I mean, can you store the data source without a database name?

Sara
0
 

Author Comment

by:Faraj1969
ID: 40407948
Apologies for the delay, we had a serious Ebola issue here that led us to leave the offices abruptly.

I've followed the links by Gary to the letter, also tried the suggestions provided by Sara, and sad to say, none of it really gave a noticeable result, which leads me to think it might not be the Odbc.

However, I've tried to type the database Folder\DbName.nsf and it worked, I was able to see the connection from Crystal Reports.

Though the question is not urgent anymore, it would be good if we can discuss it further.

Cheers.
0
 
LVL 33

Expert Comment

by:sarabande
ID: 40408110
if you check the following link

www-12.lotus.com/ldd/doc/notessql/3.0.1/notes_sql.nsf/37bd54e7ec83e261852561560064c53a/a19ebdb0e044628385256a7100563f36?OpenDocument

you see that the "database" list is only for local or remote "lotus notes databases", what means it is for .nsf files only.

that means the odbc is only the access method and does not imply that you could configure any arbitrary odbc datasource with the setup dialog.

Sara
0
 

Author Comment

by:Faraj1969
ID: 40408121
Ok Sara, I've already read the provided link, however I wasn't able to understand your explanation.

I used to have it before, and I'm trying to reconfigure the Odbc conncetions after my workstation crashed. Same configuration, same connections, no change.

And that makes me a bit surprised.
0
 
LVL 33

Accepted Solution

by:
sarabande earned 500 total points
ID: 40408186
I meant that the list only shows nsf databases which you configured with the odbc lotus notes setup and nothing else. if I am right, lotus notes stores the information in its own settings and doesn't use the datasources configured with the odbc applet.

I used to have it before
did you have databases in the list which were not lotus notes databases?

I'm trying to reconfigure the Odbc conncetions after my workstation crashed
the list of available databases should be provided by the lotus (domino) server. perhaps you could look at another workstation whether it worked there, and if so, look for differences.

Sara
0
 

Author Comment

by:Faraj1969
ID: 40408198
Sara, with all due respect, I'm unable to really grasp the concept you're trying to explain.

Before my HDD crashed, I used to create a lot of Odbc connections (we're migrating from LN to different platforms), so when I select the Server, and provide my password, the Database list gets populated with all LN Db's available on that Server.

Now the population is not happening, I have to type the Db path and name manually, and I'm talking about nsf files, nothing changed in my roles to Server's or Db's.

In any case, I'll accept your answer for the efforts you extended thankfully, and close the question.

Best wishes.
0
 
LVL 33

Expert Comment

by:sarabande
ID: 40408290
sorry for explaining so badly. the problem is that my experiences of odbc do not include lotus notes databases at all.

therefore I thought you were talking of oracle, db2, sql server, ms access, ... databases which do not appear in the odbc lotus setup. I learned now, that before crash, the notes databases were shown both as datasources in the windows odbc applet and in the odbc lotus notes setup.

if now nothing shows up, it means at least that lotus is not looking into the system or user dsn but only into its own settings (which still are incomplete).

Sara
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to split this in C++ 4 101
Eclipse Neon start with Admin account only 6 120
egit plugin on eclipse 8 62
How to remove numeric and alpha from an alphanumeric field? 5 83
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now