January 15, 2010 at 1:53 pm
Hello,
I have no problem creating a ODBC data source, and I am able to connect Notes from Access (2003, 2007), why I don't see the ODBC option in the provider drop down list in SQL 2005? where did it go? or should I install some extra driver?
Thank you very much.
***This is not SSIS question, please don't move it to any other forum, thanks***
January 18, 2010 at 4:14 pm
up
January 20, 2010 at 5:34 pm
up
January 22, 2010 at 9:07 am
nobody knows?
January 22, 2010 at 9:59 am
Look for: linked servers [SQL Server], ODBC in BOL (Books Online).
You use the OLE DB Provider for ODBC when creating a Linked Server that uses ODBC.
February 4, 2010 at 8:23 pm
Hi Lynn,
Thank you for your reply, but I am desperately in dark here, I've attached some snapshots in the attachment, can you help me with it? all the approaches I tried as well as procedures are presented in the document, please do take a look and write me back if you need the related software.
I know this would be very useful to many people with this problem, thank you very much in advance to you or any one who can resolve this issue.
February 5, 2010 at 10:43 am
Please run this in SSMS when connected to the server in question and post the results:
select @ @VERSION -- no spaces between the @ signs, had to add a space to post the code from work --- don't ask, don't know why.
February 5, 2010 at 10:45 am
Here is the query result:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
February 5, 2010 at 10:48 am
I do have another 2k5 version with more recent patch:
Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Regarding to the data source when I run import wizard, both servers show same option: I am guessing there is just no such an option in SQL 2005 than in 2000.
February 5, 2010 at 11:02 am
At this point, not sure where to go. I haven't had to work with Lotus Notes since early 2005. If I get some time, I'll do some more research, but at the moment I really have to do some paid work regarding Database Mirroring with SQL Server 2008.
February 5, 2010 at 11:16 am
Thank you and please DO do something when you have time later on, I did lots of search, I didn't find any complete working example so far, so this got to be very useful and helpful to other people. Also, I do believe there is some work around to it, like in my attachment, maybe programatically read the data in via .NET?
February 5, 2010 at 11:26 am
At the previous employer where we had Notes, the Notes programmer wrote code that pushed data into a database on SQL Server, so I never had to setup a transfer from Notes.
I will try and do some research over the weekend, but not making any promises.
February 5, 2010 at 12:34 pm
thank you
February 9, 2010 at 9:59 am
I have done this in the past using the NotesSQL driver. The latest version is 8.5 which can be found here:
The ODBC interface require an authenticated Notes client ID - I recommend that you get a dedicated Notes ID file generated for this use.
In the past when I have been doing this - the Notes client has to be installed on the SQL Server host. A good write up on the whole process can be found here:
It may be that later versions of the NotesSQL driver have removed this requirement and will let you talk directly to the server.
Hope this helps.
ProPodean - A podean who lost his amateur status
Viewing 14 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy