Visual C++ 2005 (C++/CLI) - Newbie With ADO
Sep 13, 2006
Hi,
I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database.
For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine...
When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratch by resulting application. Considering this, is there any type of database that I can use and can be created/designed directly from within Visual Studio 2005?
My goal is that, if I distribute an application, I don't want my people to install anything else than simply install the resulting .exe file which should then be able to create by itself, when necessary, any database files it needs. Am I dreaming?
Thanks in advance,
Stéphane
View 27 Replies
ADVERTISEMENT
Mar 30, 2007
visual studio 2005
how will i know what edition of visual studio i have? i have seen in connection strings the .sqlexpress. does it mean that it is express edition? but the owner of my cd told me that it is not.
can u help me build my connection string?
when i uninstall visual studio, will my files be lost? or i can still access them when i reinstall it? because i'm planning to uninstall and reinstall it but i don't want my files to be lost. tnx
View 4 Replies
View Related
Nov 8, 2005
Hi,
I just downloaded Visual Web Developer Beta 2.0 and the club starter kit. I created a new web project using the kit and it worked fine. I can run the site locally without problems. Howevere, when I ftp my files over to my web hosting site and try to run the site there I get the error message shown below. Is there a configuration file that I missed updating or is this an issue on the web hosting site?
Thanks for your help. Server Error in '/' Application. --------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.WebControls.Repeater.GetData() +50 System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +232 System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53 System.Web.UI.WebControls.Repeater.DataBind() +72 System.Web.UI.WebControls.Repeater.EnsureDataBound() +55 System.Web.UI.WebControls.Repeater.OnPreRender(EventArgs e) +12 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
View 1 Replies
View Related
Apr 28, 2004
I am using the SQL Server 2000 query analyser to write stored procedures for an SQL Server 2000 database.
I would like to find a debugger to help me "look into" my stored procedures as they are executed (e.g. to watch a Cursor fill a table row by row, see the contents of temporary tables as a stored procedure progresses, etc.)
Could anybody, please, direct me to-
* Any debugger that does this
OR
* Simple instructions how to run stored procedures from Visual Basic. I suspect :) that VB's debugger may be able to look into the SQL as it is being executed, but I don't actually know how to use VB itself.
Thanks very much,
Angelos
View 3 Replies
View Related
Apr 11, 2006
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like the following:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools.
My configuration::
Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it.
IIS is installed and the service says its running
VSQL and VWD express versions installed (no errors on installation)
SQL server service indicates it is running
.Net 2.0 framework installed (no errors on installation)
Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental.
Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
View 3 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
Oct 22, 2007
I am trying to import Access reports using Visual Studio 2005 and Access 2007. SQL Server 2005 with Reporting Services is also installed. I select Reports in the Solution Explorer and then Import Reports... Microsoft Access and browse to my Access database. After I select the database I see it open briefly as if it is trying to import the reports but then Access quickly closes and a error pops up: "You already have the database open." I have checked and double checked and the database is not open. I have even tried several different databases and the same errror occurs. Any help would be greatly appreciated.
View 1 Replies
View Related
Jan 29, 2008
Hi,
I have created a database using VB Express 2005 express edition and I have created number of tables and SP's etc.
I am trying to use the database diagram tool but I get an error stating that the database doesn't have a valid dbo. I say yes to the prompt about making myself a valid dbo but I then get a message stating that I do not have permissions to imprersonate the dbo.
How do I overocome this issue?
Thanks
Bill
View 4 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
Aug 2, 2006
Hello,
we have a SQL server 2005 with Visual studio Prof. 2005 in the
employment.
The debuggers function only in Visual studio correctly, as long as no
code on the SQL server must be implemented.
If a BREAK POINT in a Stored Procedure is set, this is not activated,
since this cannot be bound.
Does someone know, what it lies and can like one it eliminate?
Thank you for your assistance in advance.
Yours sincerely
Big_Ben_31
This entry was translated automatically with the translation
service babel.altavista.com from the German into English.
View 1 Replies
View Related
Feb 10, 2008
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.
Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?
Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.
Thanks in advance to anyone who can help,
Abel
View 3 Replies
View Related
May 23, 2007
I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as:
select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table
There's also a CASE statement in there with some other data transformations.
Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005.
For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work.
I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!!
Can anyone help?
thanks,
Jon
View 6 Replies
View Related
May 26, 2008
Hi,
I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,
"
Required Component Missing (Dialog box heading)
Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
"
I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.
I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.
Thanks,
CLN
P.S.
I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
View 3 Replies
View Related
Jul 25, 2007
Hello, How are you?
I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?
I appreciate your help€¦
View 6 Replies
View Related
Mar 18, 2008
Hi,
I understand from previous threads that installing SQL Server 2005 Service Pack 2 on the desktop client can speed up the response rate of the Visual Studio 2005 Business Intelligence Tools.
However after logging on as an administrator and installing Service Pack 2, Service Pack 2 returned no errors. However after launching Visual Studio and clicking on the about dialog box the version reported was still €śRTM.050727-4200€? where I was expecting to see €śSP.050727-7600€?.
I understood that I applied the same service pack to my copy of SQL Server on my laptop and the upgrade worked successfully.
Can anyone help?
Thanks in advance,
Kieran.
View 9 Replies
View Related
Feb 15, 2008
Hi there,
Anyone know how I can replace (or download) the sqlexpr32.exe bootstrap package with the advanced services SP2 edition of SQL 2005 express ?
Pieter
View 9 Replies
View Related
Feb 26, 2008
I'm attempting to use RDA to synchronize a pocket pc emulator with SQL Server 2005 database by following tutorial http://msdn2.microsoft.com/en-us/library/aa454892.aspx, which uses AdvWorksMobile database that comes with SQL Server 2005.
When get to testing of "To test application features " ( step 4 of the merge replication setup lab ), I am receiving SQLCe Exception errors.
ORIGINALLY, I was able to deploy an application and view the local database on the emulator, but once I clicked "InitSinc" button, I received an error.
"Failure to connect to SQL Server with provided connection information. SQL Server does not" exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
Found this error listed in Server Agent Errors log http://technet.microsoft.com/en-us/library/ms172357.aspx, but it wasn't very helpful since it doesn't provide any suggestions on fixing the problems.
I am brand new to SQL CE Server , mobile programming and .NET framework in general so please bare with me
All the connections / security settings, etc that were set up were taken from a tutorial so I am not sure what SQLCeServer is complaining about. Reading up on the error on the web didn't help, it all pointed to making sure that the snapshot folder had correct permissions set up. I verified that MACHINENAMEUISR_MACHINENAME guest user had Read rights to the database so I don't think that piece is the problem. Otherwise ,Merge publication has been setup in Microsoft SQL Server Management Studio by following the tutorial.
I am trying to run this sync on my home pc so there should be no issues with any user permissions
I have IIS installed
I did NOT have SQL Server Agent running in management studio at this time
I am trying to run this tutorial on an XP machine, which is my regular home PC so I dont think there are any special networking settings to consider
I am able to hit http://localhost/AdvWorksMobile/sqlcesa30.dll from my pc OK, but when I try to hit it from a cradled emulator ( after replacing "localhost" with "MACHINE_NAME" ), Internet Explorer on the emulator gives me a "Cannot Connect With Current Settings" error message. This part wasn't part of tutorial but decided so not sure if I am supposed to be able to hit it from my emulator..so I am not sure if the fact that I can't hit it is related to the problem.
AFTER STARTING SQL SERVER AGENTin Microsoft SQL Server Management Studio, I killed the application, and after relaunching it, it hits "The Specified table does not exist [Vendor]" error. This time it doesn't even launch first - that is I dont even get to pressing "InitSinc" button. Debugger is showing that this error is hit on the following line in AdvWorksMobile.AddWorksDataSetTableAdapters
int returnValue = this.Adapter.Fill(dataTable);
I am not sure why the errors changed on me after starting SQL Server Agent.
What can I do to fix this connection problem?
Thank you so much for your help!
Irina
View 3 Replies
View Related
May 10, 2006
The program shortcut "Visual Studio 2005 Command Prompt" seems to be mising from the "Visual Studio 2005 Command Prompt" Start menu added by the current Microsoft SQL Server 2005 Express Edition Toolkit. Where is it? How to workaround?
I am trying to do Download details SQL Server 2005 Samples and Sample Databases (April 2006) -> GettingStartedWithSQLSamples.htm which says "a. Open a Microsoft Visual Studio 2005 command prompt. Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to Visual Studio Tools, and then click Visual Studio 2005 Command Prompt." but I can find no such command prompt within "Visual Studio Tools", only "Visual Studio 2005 Remote Debugger{, Configuration Wizard}".
What's wrong? How to fix or workaround? I'd install .NET SDK 2.0 to get it's Command Prompt but that's about 570MB merely for a command prompt!
Thanks for your help, -Mike Parker
View 1 Replies
View Related
Sep 18, 2006
I'm having some problems debugging SQL Server stored procedures on a SQL Server 2005 server. I have installed Visual Studio 2005 on a workstation running Windows XP, now I'm trying to debug a ASP.Net web application that has some code that executes the stored procedures on a Windows 2003 Server running SQL Server 2005.
I opened VS2005 ... created a connection to the SQL Server 2005 instance ... open the Stored procedure ... right click the stored procedure name and selected Step into Stored Procedure and the following message is displayed:
Unable to start T-SQL debugging.Could not attach to SQL Server process on 'ServerName'.
Any ideas.
Thanks,
View 2 Replies
View Related
Jul 9, 2006
Hi everyone,I am trying to connect to SQL Server 2005 Express with Advanced Services from Visual Studio 2005 Standard Edition. I have SQL Server 2005 Standard Edition but it took up so much space and resources on my computer that I didn't want to put it back on there. So I put the SQL Express on there and while the Management Studio application connects just fine, VS 2005 will not. Oddly enough, VS 2005 connected just fine to SQL 2005 Standard. I have enabled shared memory, named pipes and TCP/IP. I have set up SQL Express to accept remote connections on named pipes and TCP/IP. And I have tried running SQL Express as the Local System Account, as a Local Service and as a Network Service. Nothing. I have tried feeding the Server Name is the Data Connections dialog in Visual Studio my SQL Express instance as (local)/SQLEXPRESS, localhost/SQLEXPRESS, and {computername}/SQLEXPRESS where {computername} is the name of my local computer which SQL Express is (allegedly) running on. And I cannot get the list of databases on that server.There is probably something very simple that I have left out. Can anyone see what it is?Thanks!
View 2 Replies
View Related
Aug 20, 2006
Hello
Im pretty new to development so..... be nice guys.
I have VS2005 pro and SQL Server 2005 developer edition installed. When I open VS, in the server explorer i can connet to databases located on the SQL directory (SQL Server runs perfectly) But when i try to add an sql server to my project( add new item --> SQL database) it gives me an error saying "Connection to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component......"
HELP! donno what VS wants!
View 1 Replies
View Related
Nov 14, 2006
Hey
I need to know what shall i specify in this connection string in visual studio web.confug file inorder to connect to ma registered server (locally) not directly to my dedicated server ....cuz i am facing network connection problems ....
b4 i used to use this connection string :
<add key="conn" value="data source=IP addresseel,1433;initial catalog=xxx;user id=username on the dedicated server;Password=password on the dedicated server;timeout=60"></add>
So how can i change it ???? to be able to connect locally ????
Please Help ???!
Thanks in advance
Hiba
View 13 Replies
View Related
Dec 5, 2007
Hello
I'm having a problem with the server connection and my C# code. The code executes alright but no data is entered into the database behind it. I'm pasting the connection code over here as well. The sql commands are used in the code. I think I used the sql server mobile edition which is installed along with visual studio.net 2005. Anyone know what's wrong, and can help me out? Thanks in advance.public static void storeInDb(string trackName, string artist, string albumTitle, string year, string path, uint[] fp)
{
string connStr="Data Source=.\SQLEXPRESS;AttachDbFilename='"+path+"\Data\ACI.mdf';Integrated Security=True;User Instance=True";SqlConnection conn = new SqlConnection(connStr);
conn.Open();string sql = "INSERT INTO Clip(Song, Artist, Album, Year) VALUES('" + trackName;sql = sql + "','" + artist + "','" + albumTitle + "','" + year + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql="SELECT max(ClipID) FROM Clip";
cmd = new SqlCommand(sql, conn);int id = Int32.Parse(cmd.ExecuteScalar().ToString());for (int i = 0; i < fp.Length; i++)
{
sql="INSERT INTO Hash VALUES ("+id+","+(i+1)+","+(int)fp[i]+")";cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}
View 1 Replies
View Related
Sep 29, 2006
I had SQL Server Express Edition installed. I then uninstalled both it and Visual C#. I then installed SQL Server 2005 Developer's Edition and reinstalled Visual C# -- both on the same machine. I can connect to SQL Server 2005 using SQL Server Management Studio. However, Visual C# is a different story. When I try to add a new Data Connection, it defaults the data source to .SQLEXPRESS, which is no longer on my machine. I can select .MSSQLSERVER, but when I click on either OK or Test Connection, I time out with an error message -- error 25 - Connection string is not valid. The connection string that is shown at the bottom of the Advanced dialog box is -- Data Source=.MSSQLSERVER;AttachDbFilename=E:InventoryDataInventory_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True
View 12 Replies
View Related
Sep 23, 2006
I have windows XP box, installed MS Visual Studio 2005 without SQL 2005 express.After this I have installed SQL 2005 Express edition and then SQL 2005 client toolkit.
Now when I open "SQL Server Business Intelligence Development Studio", it gives message missing shortcut and searches for devenv.exe file. That is the problem, I dont know where is problem..??
Please anybody help me............???
Cheers,
Gurpreet
View 4 Replies
View Related
Apr 17, 2007
Dear All,
I am basically new as far as SQl server 2005 concern.
I want to try out reporting services provided by sql server 2005.
That is make report using sql server 2005 and call that report from web or window application.
Please guide me in doing so or give me some useful link.
Thanks
View 1 Replies
View Related
Apr 14, 2008
ok so i have set up SQL server 2005 on a Windows server 2003 machine. I am trying to connect to it via ODBC and/or Visual Studio 2005 on a computer running off the same switch. I have set SQL server to accept remote connections and named pipes as well as had the port unblocked. when i try and connect to it via Vista ODBC wizard or visual studio wizard it says that the server is not there or access is denied.
The server is set up for SQL authentication and i am 100% pos that the username/password i am using is correct. i am at a total loss as to what to do to get my vista machine to talk to that SQL server.
View 1 Replies
View Related
Mar 14, 2007
Hi,
for some reason, when I've installed visual studio 2005, I didn't install also SQL server.
Than I've updated VS with Service Pack 1 (thank god, I was trying unsucesfully for about 2 weeks :/ ).
Than I want to install MSSQL 2005 and an error came up:
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
SQL Server Setup has detected that the following required component is not installed: Microsoft Windows Installer 3.1. To proceed, download and install the Windows Installer 3.1 Redistributable from http://go.microsoft.com/fwlink/?LinkId=50380 , and then run SQL Server Setup again.
1. The http link leads to main page of MS Download Centre.
2. I have Installer 3.1. (version of file c:windowssystem32msiexec.exe said so)
3. I really do not have any beta version of any mentioned SW. I never had.
So I think the issue could be, that installer is checking for not updated version of Visual Studio.
(I was searching through net/msdn and seems no one had this problem (maybe wrong keywords, though) ).
I'm running setup.exe from CD1.
Uninstalling of VS Service Pack 1 is not an option. I really don't want to spent another week by installing it.
Please tell that there is some another way :) .
Thanks a lot.
Here are some logs:
SQLSetup0001_COMP_Datastore.xml
<Datastore>
<Scope Type="SetupBootstrapOptionsScope" Id="2336">
<Property Id="QuietSwitchPresent">0</Property>
<Property Id="LogSwitchPresent">0</Property>
<Property Id="ErrorReporting">0</Property>
<Property Id="DeleteManifestFileMode">1</Property>
<Property Id="MultiInstanceEnabled">0</Property>
<Property Id="ComponentUpdateOnly">0</Property>
<Property Id="ReducedUI">0</Property>
<Property Id="PatchedSetup">0</Property>
<Property Id="LocalSetup">0</Property>
<Property Id="InitiateReboot">0</Property>
<Property Id="HostSetup">1</Property>
<Property Id="RemoteMode">0</Property>
<Property Id="Remote">0</Property>
<Property Id="LoosenedSccChecks">{ }</Property>
<Property Id="DisabledSccChecks">{ }</Property>
<Property Id="LocalRebootPending">1</Property>
<Property Id="CmdLine">********</Property>
<Property Id="InstallMediaPath">Y:</Property>
</Scope>
<Scope Type="SetupStateScope" Id="">
<Property Id="machineName">COMP</Property>
<Property Id="logDirectory">C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG</Property>
<Property Id="logSummaryFilename">C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt</Property>
<Property Id="logSequenceNumber">1</Property>
<Property Id="primaryLogFiles">{ ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_COMP_Core.log"], ["C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt"] }</Property>
<Property Id="watsonFailedAction">PerformSCCAction2</Property>
<Property Id="watsonFailedActionErrorCode">87</Property>
<Property Id="watsonFailedFunction">sqls::PerformSCCAction::perform</Property>
<Property Id="watsonFailedFunctionErrorCode">87</Property>
<Property Id="watsonSourceFileAndLineNo">setupsqlsetupactions.cpp@1390</Property>
<Property Id="watsonModuleAndVersion">setup.exe@2005.90.1399.0</Property>
<Property Id="watsonMsi">None</Property>
<Property Id="watsonMsiAndVersion">None</Property>
<Property Id="watsonSourceFile">setupsqlsetupactions.cpp</Property>
</Scope>
</Datastore>
SQLSetup0001_COMP_Core.log
Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 18:23:08 2007
Process ID : 2336
Y:setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/2/14 18:23:8
Complete: LoadResourcesAction at: 2007/2/14 18:23:8, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/14 18:23:8
Loaded DLL:Y:xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/2/14 18:23:8, returned true
Running: ValidateWinNTAction at: 2007/2/14 18:23:8
Complete: ValidateWinNTAction at: 2007/2/14 18:23:8, returned true
Running: ValidateMinOSAction at: 2007/2/14 18:23:8
Complete: ValidateMinOSAction at: 2007/2/14 18:23:8, returned true
Running: PerformSCCAction at: 2007/2/14 18:23:8
Complete: PerformSCCAction at: 2007/2/14 18:23:8, returned true
Running: ActivateLoggingAction at: 2007/2/14 18:23:8
Complete: ActivateLoggingAction at: 2007/2/14 18:23:8, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2336" returned false.
Running: PerformSCCAction2 at: 2007/2/14 18:23:8
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 87
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
SQL Server Setup has detected that the following required component is not installed: Microsoft Windows Installer 3.1. To proceed, download and install the Windows Installer 3.1 Redistributable from http://go.microsoft.com/fwlink/?LinkId=50380 , and then run SQL Server Setup again.
Class not registered.
Running: UploadDrWatsonLogAction at: 2007/2/14 18:23:9
Message pump returning: 87
View 2 Replies
View Related
Aug 9, 2006
Visual Studio .NET 2005 includes SQL Server 2005
May I ask you a question ?
Is the SQL Server 2005 a fully SQL Server that I can use like SQL Server 2000 ?
Thanks for your responses :-)
View 1 Replies
View Related
May 20, 2007
Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.
Regards,
Anson
View 3 Replies
View Related
Jul 10, 2006
I have two tables "Inventory" and "Product". User creates a product then assignes inventory to that product.
The product table and the inventory table both have the same two fields, "GDS" and "prodID" and both share the same field and value of ProductID.
I'm trying to create a trigger for the Inventory table so when the Inventory table has an update or insert,
the values from Product.GDS and Product.prodID values go into the Inventory's record for Inventory.GDS and Inventory.prodID
I an having problems with the trigger as this is my first attempt in creating a trigger.
I have the trigger on the Inventory table and this is what I so far which does not seem to be working, any suggestions (thanks0:
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [inv]
ON [dbo].[Inventory]
AFTER INSERT,UPDATE
AS
BEGIN
SET NOCOUNT ON;
Update Inventory
Set GDS = i.GDS, prodID = i.prodId
From Inserted i
Inner Join Inventory inv ON i.ProductID = inv.ProductID
END
View 3 Replies
View Related
