SSCE Visual Studio Setup / Integration Woes
Dec 19, 2007
I have had a heck of a time trying to get SQL Compact Edition 3.5 working in by Visual Studio 2008 environment. I (now) know it comes along with Visual Studio 2008 by default, however, I didn't realize that at first and went and installed one of the SQL Compact Edition MSI's that were available from MS download. Since then I am unable to create a new compact edition database (Add New Item...) in visual studio it says:
The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated.
Also, When I try to create a new connection under server explorer, I notice the SQL Compact Edition is not a data source option.
I am running the relased build from the MSDN download iso: en_visual_studio_team_system_2008_development_x86_x64wow_dvd_X14-26382.iso
I have uninstalled the seperate install of the SQL Compact Edition and run repair on the visual studio 2008 installer and it does not fix the problem. I have seen a reference that says the design time installer should be under Program FilesMicrosoft Visual Studio 9.0Common7IDE, but it isn't in my install. I did find it on the source DVD under the folder WCUSSCESSCEDeviceRuntime-enu.msi.
After running that, I no longer get the original error message. Now I get a little further and then the Data Source Configuration Wizard comes up and says
An error occured while retrieving the information from the database:
SQL Server Compact is either not installed or the installation has been corrupted.
OK, so I look under C:Program FilesMicrosoft SQL Server Compact Editionv3.5 which install from the DVD (WCUSSCESSCEDeviceRuntime-enu.msi.) created and notice a readme file that inside has a link for downloading and installing the Runtime for Desktop computers.
Thinking that perhaps the runtime is a seperate install from the design tools I follow the link and setup starts. At this point I notice that the set says Compact Edition 3.5 BETA - hmm that doesn't seem right so I cancel. Not sure why the final product for the design tools would have a readme that points to a download link for the BETA of the runtime, but going back to the DVD I see the file WCUSSCESSCERuntime-enu.msi and run it. This time it says it will install Compact Edition 3.5 - looks good no BETA.
Finish the instal and viola! it works....
So what worked for me in the end:
1) Uninstall any other installs of Compact Edition 3.5 you might have
2) repair visual studio
3) install the design tools from the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
4) install the runtime fgrom the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
View 2 Replies
ADVERTISEMENT
May 25, 2007
Hi!
I have created a setup in visual studio and set the sql server as a pre-requsites.
now when the setup is run from
setup.exe
it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,
I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help
View 1 Replies
View Related
Feb 26, 2007
Hi,
I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.
I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)
There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.
Has anyone does this for SSMSE? Or am I going about this in the wrong way?
Thanks in advance,
Keith
View 3 Replies
View Related
Mar 20, 2008
Dear all,
I am trying to integrate Sql Clr with Visual studio 2005, but i am getting the following error when i try to deploy the solution:
CREATE ASSEMBLY for assembly 'SQLCLRIntegrationDemo' failed because assembly
'SQLCLRIntegrationDemo' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true: the database owner (DBO)
has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database
property on; or the assembly is signed with a certificate or an asymmetric key that has
a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or
attached this database, make sure the database owner is mapped to the correct login on
this server. If not, use sp_changedbowner to fix the problem. SQLCLRIntegrationDemo
I have even set the Permission to External in the Project --> Properties --> Database tab.
But still i am getting the above solution while deploying the solution.
One of the blogs suggested that the checkbox beside 'Trustworthy Database' should be checked. But i dont see any checkbase in the database tab of the Project properties.
Any help would be appreciated.
Thanks in advance.
Regards,
Sunny.
View 1 Replies
View Related
Apr 30, 2008
someone please tell me how
im using primavera V5.0 (www.primavera.com) and i want to export the data from the .net to primavera and versa versa
please tell me soon
View 3 Replies
View Related
Jan 18, 2007
Hi all
I have some performance issues when developing Integration Service Package ...
It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.
On another pc in the same environment it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??
Thanks for any comments
Best regards
Frank Uray
View 8 Replies
View Related
Sep 13, 2007
Greetings,
I am using Visual Studio 2005 SP1, SQL Server Developers Edition, Both installed recently and updated completely on an XP SP2 workstation (again all updates installed, the necessary ones at least) The issue I am having is when I try to load a solution for Integration services an error message box appears with the following:
An error prevented the view from loading. (Microsoft Visual Studio)
===================================
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)
This issue was of course occurring before the reinstall of both Visual Studio and SQL Server DE. The issue also extends to creating new projects, in which I am not able to...so the frustration is a little high at the moment, any help would be great...
View 2 Replies
View Related
Jan 22, 2007
Hi all
I have some performance issues when developing Integration Service Package ...
It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.
On another pc in the same environment (Domain etc.) it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??
Thanks for any comments
Best regards
Frank Uray
View 1 Replies
View Related
Apr 28, 2015
I created an ODBC to Lotus notes server and database. This ODBC connection works, however, when I put the ODBC into SSIS and test the connection my visual studio 2010 crashes and has to restart. Is there a fix I am missing on my VS2010? Or am I doing something wrong in my SSIS project?
View 2 Replies
View Related
Sep 4, 2015
I have all this gray space at the top of my tasks. When I <Ctrl>+<Alt>+<Left-click> to select all of my tasks and then try sliding it up, it creates even more gray space and actually moves it down. If instead when I <Ctrl>+<Alt>+<Left-click> and then <Ctrl>+<Arrow-up> it doesn't move it. Is there any easy way to eliminate all this gray space at the top?
View 3 Replies
View Related
Oct 28, 2015
I've used the Balanced Data Distributor with Visual Studio 2010 and SQL Server 2012 successfully. I've now installed BIDS 2013 and I'm trying to get the Balanced Data Distributor to appear again in the SSIS Toolbox.
I've installed the x86 and x64 version and it won't appear. I've tried the new version which is supposed to have a fix for some SQL Server 2008 issues but I get the message:
The installation is not successful. Check the following prerequisites: 1. Either Integration Services or BIDS has to be installed. 2. The version of these components has to be either SQL Server 2008 SP2 (or future SPs) or SQL Server 2008 R2 (or future SPs).
That seems this version only works for SQL Server 2008.
View 2 Replies
View Related
Jun 16, 2015
I've built an SSIS package in SSDT 2014. The package was running successfully
When I close and open the package it hangs on validation of single task out of all.
OLEDB DESTINATION Task
I have tried several times to close the SSDT and open but facing same issue.
These seems like bugs in SSIS/SSDT. What would cause the relocation of some script code to hang the validation process like this?
View 2 Replies
View Related
Sep 22, 2015
Basically i'm trying to create an SSIS workflow to download Sharepoint List data to SQL Server on a schedule of some kind.do we actually have to use the GAC install approach in order to get the Sharepoint List Destination and Sharepoint List Source entries to appear on the SSIS Project workflow entities?
View 4 Replies
View Related
Jul 15, 2015
Our project is on SSIS 2012 and we are using the project deployment model. We have parameter the connection managers, created environments, environment variables and configured the references. Hence, when we deploy the solution to higher environments, the connection strings are picked from the environments and not the ones stored in the connection manager.
However, we face issues when in development environment, we need to run the same package but by entering the values manually in the connection manager. Even though the connection details are correct, when we execute the package from Visual Studio, SSIS is not able to connect to the database. Is there any way to have SSIS prompt for the connection details after we have click on "Execute Task" or "Start" from Visual Studio?
View 6 Replies
View Related
Jul 18, 2006
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Thanks in advance.
View 1 Replies
View Related
Jul 18, 2006
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Thanks in advance.
View 2 Replies
View Related
Jan 19, 2006
I ask because I'm still looking for the source of interface problems I have in using the SSIS designer.
View 4 Replies
View Related
Jan 20, 2008
Hi All-
I'm using Visual Studio 6.0 (C++) and the northwindoledb sample. I'm getting:
-2147221164 (Class not registered) on the following line of code:
hr = CoCreateInstance( CLSID_SQLSERVERCE_3_0,
0,
CLSCTX_INPROC_SERVER,
IID_IDBInitialize,
(void**)&pIDBInitialize);
Can anybody please give me some pointers?
Thx.
View 16 Replies
View Related
Mar 31, 2008
I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.
Thanks.
View 7 Replies
View Related
Apr 3, 2007
So after getting no resolution to my previous problems installing SQL Express SP2 after having applied SP2 to the Developer SKU and needing Express for demo purposes (at a conference amusingly held at an MS regional office) I decided to start again.
After some struggles I uninstalled SQL Server (it crashed during uninstall, and I had to manually remove all the registry entries and clean up the directories).
Sql Express SP2 installed fine, but now developer edition refuses to install; more specifically the Management Tools and documentation portion. Absolutely stunning.
I found one problem in that the install would not proceed (installing the engine) because a more recent version of SQLXML was installed, which I got past by uninstalling the SQLXML installation Express had put onto the machine.
However now I am stuck without any management tools whatsoever (although books on-line installed).
Is it so hard to install two Microsoft products side by side? I am tearing my hair out here and utterly sick of this, especially as last time I tried to log a support call with the Express issue MS support refused to take it (despite having incident calls to burn)
Machine : PUCK
Product : Workstation Components, Books Online and Development Tools
Error : There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.
--------------------------------------------------------------------------------
<EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'>
PerfTime Stop: Set_CommitFlag : Tue Apr 03 13:22:47 2007
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (60:E8) [13:22:47:609]: Note: 1: 1722 2: SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A 3: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe 4: /setup
MSI (s) (60:E8) [13:22:47:640]: Transforming table Error.
MSI (s) (60:E8) [13:22:47:656]: Transforming table Error.
MSI (s) (60:E8) [13:22:47:656]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:47:656]: Transforming table Error.
MSI (s) (60:E8) [13:22:47:656]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:47:656]: Transforming table Error.
MSI (s) (60:E8) [13:22:47:656]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:52:203]: Transforming table Error.
MSI (s) (60:E8) [13:22:52:203]: Transforming table Error.
MSI (s) (60:E8) [13:22:52:203]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:52:203]: Transforming table Error.
MSI (s) (60:E8) [13:22:52:203]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:52:203]: Transforming table Error.
MSI (s) (60:E8) [13:22:52:203]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (60:E8) [13:22:52:203]: Product: Microsoft SQL Server 2005 Tools -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action SqlWbSetup.5F46584E_060D_4BCB_ADEE_BD15A7BFCC2A, location: C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe, command: /setup
The problem seems to be in setting up the workbench. Could this be because I already have Visual Studio SP1 installed?
View 1 Replies
View Related
Mar 17, 2007
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View 1 Replies
View Related
Apr 16, 2007
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio. When I choose new project the only template available is "Blank Solution". How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)?
Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?
View 4 Replies
View Related
Sep 4, 2007
I am new to visual studio and I am still not sure of all its components and features.
I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?
I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?
I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.
How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.
Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.
My goodness, it seems I still have so much to learn.
Thanks
View 1 Replies
View Related
May 13, 2008
I have created a database under management studio and i want it to be connected in visual studio but it failed
the error msgs said that the database can't be connected coz the database with same name exits but that is not true
View 2 Replies
View Related
Sep 12, 2007
How do i get the database that i am using in visual studio into my SQL server management studio?
i need to create some scripts to create stored procedures on a live server.
View 1 Replies
View Related
Feb 29, 2008
I have SSRS in Visual Studio. I created a query that works fine in SQL Server Management Studio, but when pasted into Visual Studio I get the error "An expression of non-boolean type specified in a context where a condition is expected, near '('.
Here is the query. Can anyone help on why this isn't working? Thanks.
SELECT CASE WHEN MONTH(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = MONTH(GETDATE()) AND YEAR(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = YEAR(GETDATE())
THEN dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount ELSE 0 END AS CurrentMonth,
CASE WHEN SubString(dbo.MAS_CCS_GL_Account.Account,1,3) = '400' THEN 'ALEDO' ELSE ' ' END AS Location,
dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate, dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber,
dbo.MAS_CCS_AR1_CustomerMaster.CustomerName, dbo.MAS_CCS_ARO_InvHistoryDetail.DetailSeqNumber,
dbo.MAS_CCS_ARO_InvHistoryDetail.LineType, dbo.MAS_CCS_GL_Account.Account, dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount
FROM dbo.MAS_CCS_AR1_CustomerMaster, dbo.MAS_CCS_ARN_InvHistoryHeader, dbo.MAS_CCS_ARO_InvHistoryDetail,
dbo.MAS_CCS_GL_Account
WHERE dbo.MAS_CCS_AR1_CustomerMaster.CustomerNumber = dbo.MAS_CCS_ARN_InvHistoryHeader.CustomerNumber AND
dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber = dbo.MAS_CCS_ARO_InvHistoryDetail.InvoiceNumber AND
dbo.MAS_CCS_ARO_InvHistoryDetail.SOGLSalesAcct = dbo.MAS_CCS_GL_Account.AccountKey
View 1 Replies
View Related
Sep 13, 2006
I have installed Visual Studio 2005 which includes SQL Server Express but not the Management Studio.
Can I install SQL Server Management Studio Express?
View 1 Replies
View Related
May 5, 2006
I'm very confused. I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express. Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express?
View 1 Replies
View Related
Jun 17, 2008
Hi,
I am new to this environment, Can Someone help me in how to write the SSIS Packages using the Visual Studio in STEPS or using any links.
Thanks in Advance.
View 2 Replies
View Related
Dec 22, 2006
Hi
Are there any (important?) advantages of using data mining through DMX instead of Visual Studio 2005 on the SQL server 2005?
/Dennis
View 1 Replies
View Related
Oct 11, 2006
error saying disk compressed or encryted, choose another drive?
how should i t-shoot !!!!!
View 1 Replies
View Related
Jan 13, 2007
When I try to create a database that will have fields for a date and a time the only data type option in visual studio is datetime. This stores data as dd/mm/yyyy-00.00.
how can I set it to store either a date dd/mm/yyy or a time 00.00 but not both.
As it is now I cant seem to store a time.
Thanks
jim
View 4 Replies
View Related
Nov 4, 2007
Hi all,
Have tried running a dts package but Im unable to add the reference Microsoft.Sql.managedDts.
Is there any other way that i can do tat from Visual studio code behind page? I need to let the user to
trigger the package from the web application. Thks in advance.
Wei
View 1 Replies
View Related
