I'm making an effort to create my first linked server and running into issue
Microsoft Sql Server 2014
OLE DB provider for DB2 Version 5.0
I installed the OLE DB provider. Created a data source(MYTEST) connecting to my test library on my development machine. I am able to successfully connect using my SECOFR level profile. I have run the sample query displaying files in my library.
I then proceeded to create a linked server
I provided a name(testconnect)
Checked 'Other data source'
Selected provider 'Microsoft OLE DB Provider for DB2'
Entered data source the created in above test
Copied the connection string from the data source into 'Provider string'
Entered Catalog as my test library.
Then I click on the Security page and selected my local user(it's the user id I use from my rpg programs to connect to the Sql Server) and my SECOFR level profile as the remote user
When I try to test the connection I get
'The user does not have the authority to access the host resource. SQL Server error 7303)
I've looked at the Security for the local profile. It has public and Serveradmin
Any idea what I might be missing? Steps missed?
Mike
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Thursday, November 14, 2019 9:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] RE: linked server and appserver4rpg
IDK if messing with set connection blasts any open cursors. Just haven't done enough with that.
Get too many WTF errors playing with CONNECT TO and that genre in Run SQL Scripts.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.dekko.com&c=E,1,Oh27RMCTVB4sMn59rLUuqohUNWRChl3jzvCVRubnYjYDJ1tWMmURTEmFddZ1bfb7wAgTjAdSEziMrJqMvt3_dDVuUvBcvzPHe8aOdoeVzA,,&typo=1
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of D*B
Sent: Thursday, November 14, 2019 9:57 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: linked server and appserver4rpg
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
<Rob>
The trick is, there is no join involved. It's all faked by the code.
IDK if you can use 3 part naming in a procedure/udtf either but it's worth
the try.
Rob Berendt
<Rob>
Three part alias is not the problem. You won't need it. In functional logic,
you could simply connect to as much databases as you want and toggle between
them with set connection. In this scenario I would prefere a data access
SRVPGM with CRUD procedures but this might be a matter of taste.
D*B
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fmidrange-l&c=E,1,D92Sy1CbgZmXyS5op7xZvQIuOJU5JZzlZ3pmIe4m5e6TNsqtdqbV5rREjk_IEFO2OIQjqjiKhjgWlJNW9pokWY_qP6XCnbOOEa-QP8z9-SUNSiUoW6qHRJ3R&typo=1
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fmidrange-l.&c=E,1,bEz1lh4ENtUsrMgyKeUdSo3ltGCCQri3H79tuzrT6kALSnGWG-KbjOqC1P-KRvwgEekc0ruVufyY1hMOoioxwgLg66_iW4qbdxnClDOlfDI_WnX6cDvu1xDdkS8,&typo=1
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,Ikmr9FROIS15vG1oegIwC8D7N8dUWMs6fLpahfrCd3ZRwq2NQKTHnrIuDMcmALTTat31ze4g-iPsvZWURffsUuyMglkvZ_rRrW7HwdZo&typo=1 by shopping at amazon.com with our affiliate link:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,OPgt0MHwcLulYhQG2gTywpL1UR00zgNxBQliHeN7C2gM0gJCvpyCRjBxo5ZqaigUHmwaLjMuzldfW77pLXCnSLTJbqMRJ2uhBX-P6lFtN1v-Fvv8Vk5hikQ1dQ,,&typo=1
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fmidrange-l&c=E,1,E8IXZ00MrfFy2XKfqFyZjyiw7bik0kLMWFDka4S5bwTkgdxWKL2FRvgmFb0OoVKY-n0rQUXNwXeZA-Ajm3maN1lzKYAjhFoFmdOwgsGKvf_I9RU,&typo=1
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fmidrange-l.&c=E,1,CgKanILKdiuy5T5Q5Wi1Vzuml-pCJN77pmDUWF0dZIZ1LPAalNtWWSZDC4cYMnusmPgQfnIRUy5BJoyLpb-4sFcoT9r8ATh6bUq47dgaql9MqPdhtlw,&typo=1
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,dZ-77HPeTZ-3E9fBhi_gd2YLIRufCBNx6F9vtNTNtlBWzeEoOYfMQJy-RLxGd1YUIjDz4G1UMILLhPYXVRU4uaZXK0lFbzrc52CV7WLquczQ3Yw,&typo=1 by shopping at amazon.com with our affiliate link:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,kAJgThTNx4hA0bo-Jt-vcZZy6UlLGedfgYSKqWC-QHfYmyN4eKpERbuYEe5ClDLCgEQelsPIVH42-OuOKGugioZjVlRbxbKw1rqMdtvdoqzn2ys4_aoUoA,,&typo=1
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
midrange.com
