So we have for the most part been successful in creating a linked server and connecting back to our IBM I. However it seems like every time we touch the trigger on SQL server things break, and we have to spend a lot of time trying to resolve.
I'm in that very situation right now and can't find a solution.
Created a new trigger(modified version of the one we were using). We were trying to test some conditions within the trigger.
Disabled the original trigger(OUTAGETRG)
Enabled the new trigger(OUTAGETRG1)
New trigger didn't work.
Reenabled the old trigger and disabled the new trigger. Old trigger no longer works.
After playing around trying to determine what is wrong, this is where I stand.
If I remove the trigger on my DB2 file, the trigger on SQL server works.
If I add it back, then I receive SQLSTATE 38501 sqlcode - 443
If I add the trigger on my DB2 file, I can add a record directly to it, and it will process.
The basic process is when a record is added on sql server, it triggers a write to my db2 file, which in turn kicks off a process calling other programs.
Also a couple of basic questions
Is there a way to modify the provider string on the linked server?
Also is there a way to set up the linked server so that my db2 file does not have to be journaled?
Thanks
Mike
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Smith, Mike
Sent: Tuesday, November 26, 2019 1:22 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: [EXTERNAL] RE: linked server and appserver4rpg
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.
--
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,eVERi-25eU1n9bcevi0jIgmJifDRssQgkm4slPrUO1RZgF09_k0g82HSw6-J3VLtjP37seqWm7301TD2I6dz2pGhqqkCDl-5uFvU4rbwKkYbDniUeA,,&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,fGCZe4hEG-qAdPjB4V-5Mawabzm_agadDowYMF9fidh3R0AQQGC5Uz7VkNxY2gjABpolwAh2ymOo6z0PckHMD2w4p8-Ri1r7lp_72ydr6yvbhnWt&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,nJGTAYwvf90rw_ZqSgsR5T0rQ6yQOQE6uLGl8Zzta0-9-NjTyR6g3c2x8L4O8msUGjSXd8fN1lXLRVmFZZokIAI7gLFmUp3NncaIho5aJ1qHFw,,&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,yJwtMjIH0l8g_r2p5nU7V3AbO6H0phJzxdgRp-MoC-pOm9FuGKAQ7g1M7nBUQ38yt6iF2yok4YGHu-jSAW7UIbl4S6R953Eh1vJUWfJq9fJod8LJYMs,&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
