Solved

Can connect to MSSQL SERVER

Posted on 2014-03-11
14
703 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

22 Experts available now in Live!

Get 1:1 Help Now