Доброго времени суток, роботостроители! Случайно набрел на этот проект. Зачетная вещь, чего и говорить. Хочется тоже присоединиться к вашему сообществу. С# освоил, т.к. програмлю на асм с детства. Одна проблема - не совсем понятно, как устанавливать базу данных. Когда запускаю скрипт trading.sql - вылазят ошибки Может в WIN7 хитрости какие-то ? С SQL раньше дел не имел, если не трудно - направьте на путь истинный. Где косяк ? И где порыть ?
Комментарии (5)
Вход или Создать аккаунт, Войдите или зарегистрируйтесь, чтобы оставить комментарий
вот чего пишет Msg 15025, Level 16, State 1, Line 41 The server principal 'trading' already exists. Msg 1801, Level 16, State 3, Line 3 Database 'Trading' already exists. Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '100'. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'HONOR_BROKER_PRIORITY'. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 5120, Level 16, State 101, Line 2 Unable to open the physical file "C:\StockSharp\Trading.mdf". Operating system error 2: "2(Не удается найти указанный файл.)". File activation failure. The physical file name "C:\StockSharp\Trading_log.ldf" may be incorrect. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 3446, Level 16, State 2, Line 2 Primary log file is not available for database 'Trading'. The log cannot be backed up. Msg 5069, Level 16, State 1, Line 2 ALTER DATABASE statement failed. Msg 945, Level 14, State 2, Line 2 Database 'Trading' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. Msg 15023, Level 16, State 1, Line 3 User, group, or role 'trading' already exists in the current database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Exchange' in the database. Msg 6246, Level 16, State 1, Line 2 Assembly "Ecng.Data.SqlServer" already exists in database "master". Msg 6249, Level 16, State 1, Line 1 The associated file "Ecng.Data.SqlServer.pdb" already exists for assembly "Ecng.Data.SqlServer". Msg 6249, Level 16, State 1, Line 1 The associated file "Properties\AssemblyInfo.cs" already exists for assembly "Ecng.Data.SqlServer". Msg 6249, Level 16, State 1, Line 1 The associated file "SqlExtendedProcedures.cs" already exists for assembly "Ecng.Data.SqlServer". Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'AutoDeployed' already exists for 'Ecng.Data.SqlServer'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'Ecng.Data.SqlServer'. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #3: Cannot find data type time. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HistorySession' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Strategy' in the database. Msg 2714, Level 16, State 3, Procedure usp_RethrowError, Line 26 There is already an object named 'usp_RethrowError' in the database. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Portfolio' in the database. Msg 2714, Level 16, State 51, Procedure PageSelect, Line 2 There is already an object named 'PageSelect' in the database. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'AutoDeployed' already exists for 'dbo.PageSelect'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyFile' already exists for 'dbo.PageSelect'. Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 38 Property cannot be added. Property 'SqlAssemblyFileLine' already exists for 'dbo.PageSelect'. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #3: Cannot find data type time. Parameter or variable '@WorkingFrom' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #4: Cannot find data type time. Parameter or variable '@WorkingTo' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #5: Cannot find data type time. Parameter or variable '@Interval' has an invalid data type. Msg 2714, Level 16, State 3, Procedure MarketDataSourceSettings_ReadBySourceId, Line 4 There is already an object named 'MarketDataSourceSettings_ReadBySourceId' in the database. Msg 2714, Level 16, State 3, Procedure HistorySession_Count, Line 3 There is already an object named 'HistorySession_Count' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_Count, Line 3 There is already an object named 'Exchange_Count' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_UpdateByName, Line 18 There is already an object named 'Exchange_UpdateByName' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_ReadByName, Line 4 There is already an object named 'Exchange_ReadByName' in the database. Msg 2714, Level 16, State 3, Procedure Exchange_ReadAll, Line 6 There is already an object named 'Exchange_ReadAll' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HydraSecurityInfo' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Order' in the database. Msg 2714, Level 16, State 3, Procedure HistorySession_ReadAll, Line 6 There is already an object named 'HistorySession_ReadAll' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Position' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Trade' in the database. Msg 2714, Level 16, State 3, Procedure Security_ReadAll, Line 6 There is already an object named 'Security_ReadAll' in the database. Msg 2714, Level 16, State 3, Procedure Security_Count, Line 3 There is already an object named 'Security_Count' in the database. Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Parameter or variable '@LastTradeTime' has an invalid data type. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'OrderFail' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'MyTrade' in the database. Msg 2714, Level 16, State 6, Line 1 There is already an object named 'HistorySessionOrder' in the database. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_HistorySessionOrder_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_HistorySessionOrder_Session' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_HydraSecurityInfo_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_MyTrade_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_MyTrade_Trade' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Order_Portfolio' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Order_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_OrderFail_Order' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Portfolio_Exchange' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 2714, Level 16, State 4, Line 2 There is already an object named 'FK_Position_Portfolio' in the database. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Position_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 4902, Level 16, State 1, Line 2 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Trade_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission. Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
и в папке c:\stocksharp\ пусто
как и где сделать "Run the RECONFIGURE statement to install." не могу никак вдуплить. SQL пока для меня совсем никак...
Удалил все приложения, связанные с SQL Установил SQL Server 2005 Express
Запускаю скрипт trading.sql из SQL Server Management Express и вот такая хрень вылазит
Msg 22002, Level 16, State 1, Line 0 RegCreateKeyEx() returned error 5, 'Отказано в доступе.' Необходимо перезапустить SQL Server Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '100'. Msg 102, Level 15, State 6, Line 2 Incorrect syntax near 'HONOR_BROKER_PRIORITY'. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #3: Cannot find data type time. Msg 2715, Level 16, State 7, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #3: Cannot find data type time. Parameter or variable '@WorkingFrom' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #4: Cannot find data type time. Parameter or variable '@WorkingTo' has an invalid data type. Msg 2715, Level 16, State 3, Procedure MarketDataSourceSettings_UpdateBySourceId, Line 1 Column, parameter, or variable #5: Cannot find data type time. Parameter or variable '@Interval' has an invalid data type. Msg 2715, Level 16, State 3, Procedure Security_UpdateById, Line 1 Column, parameter, or variable #24: Cannot find data type datetime2. Parameter or variable '@LastTradeTime' has an invalid data type. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_HydraSecurityInfo_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_HydraSecurityInfo_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Order_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Order_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Position_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Position_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 4902, Level 16, State 1, Line 2 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 4902, Level 16, State 1, Line 1 Cannot find the object "dbo.Security" because it does not exist or you do not have permissions. Msg 1767, Level 16, State 0, Line 2 Foreign key 'FK_Trade_Security' references invalid table 'dbo.Security'. Msg 1750, Level 16, State 0, Line 2 Could not create constraint. See previous errors. Msg 4917, Level 16, State 0, Line 1 Constraint 'FK_Trade_Security' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'MarketDataSourceSettings_UpdateBySourceId', because it does not exist or you do not have permission. Msg 15151, Level 16, State 1, Line 1 Cannot find the object 'Security_UpdateById', because it does not exist or you do not have permission. Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.
Через администрирование/службы перезапускаю службу SQL Server повторно запускаю скрипт - та же самая хрень... Уже неделю бьюсь. Ничего не понимаю, что еще надо сделать-то чтоб базы сформировались и запустились. В папке c:\stocksharp создалось 2 файла - база и лог, все ок. Но почему дальше ошибки летят - неясно. Выручайте, профи-SQLщики ! А то руки опускаются уже.
я победил аналогичную проблему так: