?
Solved

Can connect to MSSQL SERVER

Posted on 2014-03-11
14
Medium Priority
?
725 Views
Last Modified: 2014-03-13
Dear Experts,
got a problem trying to create a connection thru DECS, but first let me give you some info.

I'm running Lotus Domino 8.5 on a Windows Server 2008R2. On this server I installed as well the SQL Native Client 2008.
I execute the DECS Administrator (decsadm.nsf) but I got back the error that you can find in the attchment.
Before installing the SQL Native Client I had another one, but similiar to this one, so I don't know how to fix it and btw I'm new to this Lotus IBM World
DECSAdmin.PNG
0
Comment
Question by:gokyo66
  • 8
  • 6
14 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39921454
No clue as to what the error is about. Suggested reading: http://www.veiligheid.nl/help/help85_designer.nsf/b3266a3c17f9bb7085256b870069c0a9/dbe9234c805803b485257607005ffa35!OpenDocument

What exact release do you have? Are you sure that the Domino R8.5 release is compatible with SQL Server 2008?

And at a first glance, just this: the IP-address/port seems wrong, shouldn't it be 192.168.0.5:1433 ?
0
 

Author Comment

by:gokyo66
ID: 39921513
Hi Sjef,
thank you regarding the article. About the address/port I got the same error even putting in the properly format.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39922840
Ok... And my other questions?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:gokyo66
ID: 39922933
Hi Sjef,
sorry I didn't reply before...

"What exact release do you have? Are you sure that the Domino R8.5 release is compatible with SQL Server 2008?"

Release 8.5.3 FP4.
I don't know if is compatible with SQL Server 2008 and actually I didnt't find anything that say that is not, at least in developWork website or in IBM web site.

Thank you
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39923050
Hm, R8.5.3 is a good and stable one, I'd expect it to be compatible. Not by experience though, but many of the Internet pages with similar issues suggest to verify the connection setting (ID, password, etc.). I assume you started creating a Connection in DECS Admin?

For more help, see also the help/decsdoc.nsf database.
0
 

Author Comment

by:gokyo66
ID: 39923079
Yes I started from DECS Admin, and it's already there that I encounterd the problem, I already check out the help section in the troubleshooting but nothing related to that error. I got the feeling that is not related to Lotus Domino, but I developed other program in Excel for instance, where I use those parameter to connect to MSSQL Server and it works properly.
0
 

Author Comment

by:gokyo66
ID: 39925769
Sief,
do you know anything about using driver provided by IBM? I wasn't aware that there are specific driver in order to let DECS works with various database.

Any input or suggestion over this subject?
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39925901
Not sure. You need to have the Connectors installed, but AFAIK they come with the Enterprise installation which includes DECS.

Here's a page that might help you: http://www-01.ibm.com/support/docview.wss?uid=swg27002633
0
 

Author Comment

by:gokyo66
ID: 39926630
Ok I change strategy after reading some article around.

I create an ODBC Connection via c:\Windows\SysWOW64\odbcad32.exe
After the creation I test it and it works

Then using the command C:\Program Files (x86)\IBM\Lotus\Notes\ndctest.exe I tested the ODBC connection and the result is "Success".

So I went back to DECS I create now a new connection thru ODBC insert all the parameter and again a message error that you can find in the attachment, but since is in italian I'll try to translate it:

Wrong corrispondance of architecture between the driver and the application in the specify DNS.
ODBCError.png
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 1000 total points
ID: 39926686
Ah, that might have given us some clues.

"It turns out there are two versions of the ODBC Administrator in Windows 7 64bit, one for 32bit, one for 64bit. The one launched from the control panel is the 64bit version. Since Lotus Notes launches as a 32bit process, it requires a 32Bit ODBC driver. "

http://www-10.lotus.com/ldd/nd85forum.nsf/dba3ca7e515d55ff85256a0700727b35/15eb2cc0124b07d0852578530056212d?OpenDocument

Maybe that's why your system complains about "errata di architettura" ? 32-bit vs 64-bit?
0
 

Author Comment

by:gokyo66
ID: 39926752
I payed attention to use the correct odbcad32 from command line and not from the Control Panel.
But if I well understood from the link that you kindly provided me, Lotus Domino is installed in the directory where usually 64bit program are installed, so I guess is there where the conflict is generated between architecture...
0
 

Author Comment

by:gokyo66
ID: 39926880
Sjef,
I'm so happy to say that now it works!!! Ok let me share with you some stuff.

First of all after reading your last link I couple of time w/out success. We got Lotus Domino installed in the 64bit folder on windows server. Since I know that a 32bit program can run on a 64 architecture I thought that it should work.

So, I create a couple of ODBC Connection, trying different combination "DSN User"; "DSN System"... with SQL Server driver and then with SQL Native Client...

At the end I realize that once I created the connection, I run ndctest, once under the folder C:\Program Files\IBM\Lotus\Domino and once under the folder C:\Program Files(x86)\IBM\Lotus\Notes and guess what, the one under the 32bit folder didn't work (I got back the same message as DECS gave me)

To cut short I created a DSN System ODBC Connection using the ODBC via Control Panel, that means the 64bit version. I used the SQL Server driver and not the SQL Native Client and the result is in the attachment!!

Man! I'm so happy is almost 3days that I'm struggeling with this problem!!

Sjef, you're been very supportive and w/out you help I don't think I could it solve. So definitely you got your deserved point!!

Thank you very much!!
Roberto
ODBCWorks.png
0
 

Author Closing Comment

by:gokyo66
ID: 39926883
Great and constant support!
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 39928233
Perfetto ! Really glad you managed to solve it yourself (well, I only gave some hints, let's be honest), for it's some time ago that I had the 'pleasure' to do some ODBC digging myself in 32- and 64-bits environments myself. Rather rusty skills... ;-))

Good night, from the other side of the border!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

829 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