Recent content by celeron895

We have a Great Plains 7.0 installation on a Win 2k / SQL 2000 server. We are looking at moving this to a Win 2K3 / SQL 2000 server. However, there is a difference in the collation sequences. The current SQL Server is binary. The new SQL Server is in the default collation. Anyone have any...

Ever find an answer to this? Just ran into the same problem...

We were trying to avoid using the upload technique that you were talking about. So, this is possible using an activeX control? This will be part of a secure application, so there is no problem with forcing the user to install an ActiveX control. Do you know of any examples that do this? I...

Is it possible to have a C# ASP.NET web page read data from a web users local file system? I was told this was not possible unless the web server and file system where on the same network (or otherwise connected). How about using an ActiveX control? Basically, I want the user to click a...

GP does not support running over a VPN. You should have the remote location use RDP or Citrix to access the main server. Using a VPN will be super slow.

Accidently posted this in the 8 forum... but I am on 9... Getting the following error trying to connect to my Oracle database: ORA-12500: TNS:listener failed to start a dedicated server process This only occurs when I am using terminal services to get into the win 2k server box. If I am at...

Getting the following error trying to connect to my Oracle database: ORA-12500: TNS:listener failed to start a dedicated server process This only occurs when I am using terminal services to get into the win 2k server box. If I am at console, this error does not happen.

I've been advised by my VAR that the Blue_GrantAccess() is not used for alternate forms. David's method above would need to be used.

Has anyone use the Blue_GrantAccess() function to accomplish this task? This is what is explained in the Dexterity integration guide. However, the example is for a new form, not an alternate SBF form. I cannot find an example of SBF using an alternate form. Is no one doing Dexterity...

I have developed a modification to an existing form in Small Business Financials. How do I give users access to this form? The security is different than Great Plains, and I don't see where I accomplish this.

I am using a pass-through sql statement to select an id and name from a table and populate the contents of a drop down list with a list of the names. (select id, name from table) After selecting a name in the drop down box, I need to populate another field on the form with the id that...

I recant my stance on dexterity stated in this thread: http://tek-tips.com/viewthread.cfm?qid=883259 Apparently, dex is still needed and the only way to accomplish many tasks. Where would you put the 2 triggers to accomplish this? Is there an example of this in one of the programmers guides?

There is a scrolling window on one of the apply screens within Great Plains. Is there a way to change the sort order of this grid? Transactions --> Sales --> Cash Receipts (then click on Apply) Instead of sorting by the Document Number, I would like the grid sorted by Due Date. VBA...

Awesome credentials screwloose! You are an IT god. Way to be!

How are certifications going to work though? We just spent considerable resources becoming certified in the Great Plains competency. Is this going to roll over to the new 'Project Green' certifications? 2006 is not that far off, and though I understand the need to keep learning and remain...