Solved

Can connect to MSSQL SERVER

Posted on 2014-03-11
14
701 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 250 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 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

18 Experts available now in Live!

Get 1:1 Help Now