View User Profile

I originally started programming HTML and JavaScript, then got a job developing Database driven Web Applications using ASP and SQL. Over the years I have gotten a little experience with PowerBuilder, a little college with Java, C, and VB. I like to play around with ASP.NET, VB.NET, XML, and such. Recently I started working in BI and began learning how to customize SalesLogix and integrate it with other BI products.

For fun I like to: hike, bike ride, snowboard, write random code, and I do some amature digital photography mostly family trips and gathings.

Log in to send this member a message!

Andrew Pettit's Contributions

Andrew Pettit has contributed 2 comments and 0 articles.

Select to view: Comments Articles

Comment: Re: How to Connect to External Data Using ADO
Ryan,

I am having trouble getting a Recordset to return from a Stored Procedure in a MAS 500 database. All the SP does is return one row of data that I want to strip out and place into some text controls on a SalesLogix tab. The MAS 500 connection works fine and returns a State of 1 or Open. The SP also executes without any errors, but the RS never Opens and always retruns a State of 0 or closed. I also tired using Output parameters and they came back blank as well. If I try and pull something else from the MAS 500 database like a table the RS works fine and returns the results, but nothing when using the SP. If I run the SP using Query Analyzer connected to the MAS 500 database as SYSDBA user it also works fine from there as well and returns the desired results.

Does Anyone know what this could be?

Thanks

Author: Andrew Pettit - 9/18/2006

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/26/2024 12:28:15 AM