00134 Sql Cno Error
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Centura Software / Gupta : SQLBase Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesCentura Software / Gupta : SQLBase Forum Create a view from a SELECT Statement thread854-856323 Forum Search FAQs Links MVPs Create a view from a SELECT Statement Create a view from a SELECT Statement WizZerD (Programmer) (OP) 8 Jun 04 09:07 Hi I have run the following Select statement and got a result:SELECT @LEFT(EPISOD.PRODNR,2)||'-'||@MID(EPISOD.PRODNR,3,2)||'/'||@RIGHT(EPISOD.PRODNR,4) AS Prodnr,EPISOD.EPISODKOD AS Avs,UPPSKICK.UPPSKICKSDATUM AS Datum,BAND.BANDNR AS Matid, PROD.SVENSK AS Titel,@IF(@EXACT(TILLAGGSTYPID,10),'1','') AS Overs, @IF(@EXACT(TILLAGGSTYPID,11),'1','') AS PrgmTxt,BEST.MANUELL AS Man, BEST.OPPEN AS Opp, BEST.DOLD AS Dold,UPPSKICKSRAD.ANMARKNING,ANVANDARE.SIGN,KUND.NAMN AS KanalFROM ANVANDARE, UPPSKICK, UPPSKICKSRAD, EPISOD, BAND, PROD, BEST, UTLAGGNING, KUND WHERE (ANVANDARE.ID = UPPSKICK.ANVANDARID) AND (UPPSKICK.ID=UPPSKICKSRAD.UPPSKICKSID) AND(EPISOD.ID = UPPSKICKSRAD.EPISODID) AND (EPISOD.EPISODKOD = BAND.EPISODKOD) AND(EPISOD.PRODNR = BAND.PRODNR) AND(PROD.PRODNR = BAND.PRODNR) AND(UPPSKICKSRAD.BESTID = BEST.ID) AND(BEST.ID = UTLAGGNING.BESTID) AND(BEST.SANDENHET = KUND.ID) AND(PROD.SVENSK Is Not Null) AND(ANVANDARE.SIGN='123456') AND(UPPSKICK.UPPSKICKSDATUM='7/18/2003')
it to a new server, a ODBC link stopped working. The only differences between the two servers were the OS: XP on one and 2003 R2 on the other. The error's weren't telling me much: ERROR [HYC00] [MERANT][ODBC SQLBase driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC SQLBase driver][SQLBase]00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 09293 ERROR [IM006] [MERANT][ODBC SQLBase driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC SQLBase driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC SQLBase http://www.tek-tips.com/viewthread.cfm?qid=856323 driver][SQLBase]00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 09293 ERROR [IM006] [MERANT][ODBC SQLBase driver]Driver's SQLSetConnectAttr failed. After trying a lot of different things, the solution was quite simple. Because IIS uses app pools under 2003, the application was running under the "Network Service" account. This account didn't have enough rights to read the ODBC files (sql.ini http://blog.repsaj.nl/index.php/2008/08/odbc-drivers-sqlsetconnectattr-failed/ and some dll's). You can solve this by granting the account rights to the files needed (depends on your database manufacturer which you need) or using a dedicated application account to run your application (which I prefer) which has read-only rights to your filesystem (or at least the folders where your config / dll files reside). Be carefull granting rights to a web application which is available through the Internet! Less is more! Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Post navigation Dynamic Linq where queryCannot complete this action. Please try again. Recent Posts [IoT] Aquarium monitor; controlling LED from C# Speaking at Experts Live 2016 Changing jobs! [Azure] Logging out of Azure AD oauth [Azure] Custom Function bindings + notification tags in Cordova apps Blog Categories Gadgets (3) Miscellaneous (19) Social (42) Technical (207) Uncategorized (1) Sponsored Meta Log in Entries RSS Comments RSS WordPress.org sparkling Theme by Colorlib Powered by WordPress
from GoogleSign inHidden fieldsSearch for groups or messages
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 iudithm knowscognosdoi Clinton Jones mircea_luca Iqbalyk COMPANIES VAI SendGrid Apperian Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics PeopleSoft Groups Ask a New Question PeopleTools A forum where peers share technical expertise, solve problems, and discuss issues related to PeopleTools. Home | Invite Peers | More PeopleSoft Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. SQL.INI File Error in Peoplesoft Student Administration 7.5 prashis asked Mar 18, 2004 | Replies (5) Dear Friends, When I am trying to use SQR in peoplesoft student administration 7.5. I am getting error as Error.SQL not found looking up error 03701 Can any one, would suggest me how to go about it. Regards Prashis Join this group Popular White Paper On This Topic Human Capital Management Comparison Guide 5Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Unknown User replied Mar 18,