Can connect to MSSQL SERVER

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
gokyo66Asked:
Who is Participating?
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
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
 
Sjef BosmanGroupware ConsultantCommented:
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
 
gokyo66Author Commented:
Hi Sjef,
thank you regarding the article. About the address/port I got the same error even putting in the properly format.
0
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.

 
Sjef BosmanGroupware ConsultantCommented:
Ok... And my other questions?
0
 
gokyo66Author Commented:
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
 
Sjef BosmanGroupware ConsultantCommented:
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
 
gokyo66Author Commented:
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
 
gokyo66Author Commented:
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
 
Sjef BosmanGroupware ConsultantCommented:
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
 
gokyo66Author Commented:
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
 
gokyo66Author Commented:
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
 
gokyo66Author Commented:
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
 
gokyo66Author Commented:
Great and constant support!
0
 
Sjef BosmanGroupware ConsultantCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.