Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, March 28, 2020 
 
View User Profile  

 User Profile - Alan Frelich  
Alan Frelich
Global Knowledge

fiogf49gjkf0d
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
fiogf49gjkf0d

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.
System.Data.OleDb.OleDbException:
   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
fiogf49gjkf0d
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
fiogf49gjkf0d
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.
Alan

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 © 2020 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): 3/28/2020 8:03:30 PM