Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Saturday, May 25, 2024 
View User Profile  

 User Profile - Alan Frelich  
Alan Frelich
Global Knowledge

SQL Server DBA. Currently running Saleslogix v5.2.2

Log in to send this member a message!

 Alan Frelich's Contributions
Alan Frelich has contributed 3 comments and 0 articles.
Select to view:    
Comment: Re: Generating Table IDs in T-SQL

I am receiving the error below when trying to select using the function fn_GetNextSLXID. The provider used in the connection manager on the SLX Server is SQLNCLI.1 Could this be the issue? I had this running at one time with this provider. The SLX admin tools and client are installed on the SLX Server. I can connect to the database through the SLX client apps on the server. We are running SLX version 7.5.2 on SQL Server 2005 Sp4. Any help is appreciated.

 Msg 6522, Level 16, State 1, Line 1
A .NET Framework error occurred during execution of user-defined routine or aggregate "fn_GetNextSLXID_ConnString":
System.Data.OleDb.OleDbException: Failed to connect to SLXServer. Check if server is running and is compatible with the current provider version.
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at SLXIDGen.slx_GetNextID_ConnString(String table, String ConnectionString)

Author: Alan Frelich - 8/29/2012

Comment: Populating a datagrid from an external datasourse in v5.2
Thanks for the advice. I was able to create a view to return the external data in a grid. However, the grid will only return data if the view is written against a database that is on the local SQL Server with the SLX database. The database that I need to query is on another SQL Server on the network. I created a linked server to that database. The query to the linked database runs in QA but will not return rows in the SLX datagrid. Any ideas?

Author: Alan Frelich - 6/3/2003

Comment: Populating a datagrid from an external datasourse in v5.2
Can anyone provide assistance in populating a datagrid from an external datasourse in v5.2? I am aware this will be much easier in v6 but at this time we cannot upgrade. Basically, we have a data warehouse that I would like to query and return a record set in a data grid. I have the external ID stored in the Contact table. I have been able to get this to work populating a listbox but the formatting of the columns becomes an issue.

Any assistance is greatly appreciated.

Author: Alan Frelich - 5/6/2003


 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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 5/25/2024 9:41:24 AM