Здравствуйте!
Это зависит от того, где хранятся данные СП3, по умолчанию в базах данных MS Access или же в MS SQL.
Если не помните, можете посмотреть это в приложении "Отчеты" (см. рисунок 1).
Если база данных СП3 находится по умолчанию, т.е. в базах данных MS Access, то Вам необходимо перенести файлы "SpDef.mdb" и "SpBase.mdb" из папки установки СП3 на компьютер (далее ПК) СП4. В СП4 при импорте указываете "Хранилище данных" в "База данных Microsoft Access" и указываете местоположение этих файлов (см. рисунок 2).
Если база данных СП3 находится в MS SQL, то в СП4 при импорте указываете "Хранилище данных" в "База данных Microsoft SQL Server" и указываете настройки подключения к БД СП3 (см. рисунок 3).
Добрый день! при импорте данных появилась ошибка:
Не удалось выполнить подключение к источнику данных.
Тип Исключения: VzljotSp.UserException
Трассировка стека:
at VzljotSp.Forms.VspFormDataImport.ebYyRDCvRXb(Object , VspThreadWorkEventArgs )
at VzljotSp.VspThread.VvyqNCc34P()
----------
Нельзя открыть базу данных. Строка подключения: 'Provider=Microsoft.Jet.OLEDB.4.0;Mode="Share Deny None";data source=C:\new\Spdef.mdb;user id=Admin;password=***REMOVED***;'; Ошибка:'System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()'
Тип Исключения: DevExpress.Xpo.DB.Exceptions.UnableToOpenDatabaseException
Трассировка стека:
at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()
at DevExpress.Xpo.DB.ConnectionProviderSql..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at VzljotSp.Data.VspAccessConnectionProvider..ctor(IDbConnection connection, AutoCreateOption autoCreateOption)
at VzljotSp.Data.VspAccessConnectionProvider.CreateProviderFromConnection(IDbConnection connection, AutoCreateOption autoCreateOption)
at VzljotSp.Data.VspAccessConnectionProvider.FNTPvSZLTSVkvLGe76PW(Object , AutoCreateOption autoCreateOption)
at VzljotSp.Data.VspAccessConnectionProvider.CreateProviderFromString(String connectionString, AutoCreateOption autoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.DB.DataStoreBase.QueryDataStore(String providerType, String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at DevExpress.Xpo.XpoDefault.GetConnectionProvider(String connectionString, AutoCreateOption defaultAutoCreateOption, IDisposable[]& objectsToDisposeOnDisconnect)
at VzljotSp.Data.VspDataHelper.GetConnectionProvider(String connectionString, AutoCreateOption autoCreateOption, Boolean throwOnError)
at VzljotSp.External.VzljotSp3.ExternalConnectionVzljotSp3.XfUXBHyQLC0aLbk2eMEW(Object , AutoCreateOption , Boolean )
at VzljotSp.External.VzljotSp3.ExternalConnectionVzljotSp3.OnOpen(Boolean throwOnError)
at VzljotSp.External.ExternalConnectionBase.bM6hlFyounJHQ6aGrf4G(Object , Boolean throwOnError)
at VzljotSp.External.ExternalConnectionBase.Open(Boolean throwOnError)
at VzljotSp.Forms.VspFormDataImport.ebYyRDCvRXb(Object , VspThreadWorkEventArgs )
----------
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Тип Исключения: System.InvalidOperationException
Трассировка стека:
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at DevExpress.Xpo.DB.AccessConnectionProvider.CreateDataBase()