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 SLXIDGen.slx_GetNextID_ConnString(String table, String ConnectionString)
Author: Alan Frelich - 8/29/2012