?
Solved

Can connect to MSSQL SERVER

Posted on 2014-03-11
14
Medium Priority
?
717 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 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