Very Basic MS SQL Server Deployment Question
Jan 29, 2008
My site is hosted by Fasthosts(.co.uk), which means I cannot put an MS SQL database on my site: they don't support that sort of thing. I have to pay for a seperate SQL database on a seperate server (also hosted by fasthosts).
They have given me an IP, a server name, a database name, login and password. They tell me that the server require SQL authentication. I have managed to contect to the database using MS VWD 2005 through the database explorer. I cannot however make changes to the database.
I have therefore downloaded SQL Server Management Express. This is where I am stuck. I can't seem to get the software to find my database. One thing I have tried is i've set up a database on my system and then run replication. When I do this I get stuch at to the "enter the name of the computer running IIS" part of the wizard, I've tried entering in the IP of the server and the ip of my website.
I have also tried connecting to the database direct (not using replication) but this fails when it tries, despite all the combinations of IP, server name and database name I try!
Any ideas?
Regards,
Howard
View 5 Replies
ADVERTISEMENT
Oct 31, 2007
Hi!
We have SQL 2005 x64 installed on a 64 bit server.
We have 32 bit XP systems that we'd like to develop SSIS packages on and then deploy them to the 64 bit server to run in 64 bit mode.
Is this possible?
Note: We only have 64 bit SQL 2005 media right now.
Thanks!
View 12 Replies
View Related
Aug 15, 2007
Hi,
Please can you let me know which of the following 2 is a better method to deploy SSIS packages
File System deplyment OR SQL Server deployment
What are the advantages of one over the other?
Thanks,
Mrinali
View 4 Replies
View Related
Jul 3, 2007
I have probably missed this somewhere... but...
I am doing SQL Server deployment of multiple SSIS projects. 2 of the projects have dtsx files that are named the same. Is there anyway to deploy to SQL Server to put these in different projects so that they dont conflict?
Thanks
BobP
View 5 Replies
View Related
May 18, 1999
Hi,
I'm new to SQL server so I hope somebody is willing to lend a hand...
I installed the server without a problem, and the service is showing as running OK.
However, when I open SQL enterprise manager, no server names can be selected.
But, when i go in via DOS and enter
SELECT @@SERVERNAME
GO
I get the correct name back - "andrewp"
I don't understand how I cannot connect to the server via Enterprise Manager...
I'm running on NT4.0 Workstation, SQL server 6.5, if that makes a difference.
Thanks for any help you can give,
Andy
View 2 Replies
View Related
Jan 3, 2004
Hi experts I am new to SQL Server and have got to do a project using VB & SQL Server. right now i got to prepare case study document wherein i got to mention the pros & cons of using VB+sql server... kindly help me. Thanks in advance.
View 1 Replies
View Related
Oct 23, 2006
Hi, I have no idea about SQL Server.my first question is,SQL server usually mean "MS" sql server. right?Also, my second question is,I made a webpage with PHP to connect My SQL.However, if i want to change from My sql to MS sql server, then how cani change the webpage? can I do it with PHP or should I totally changeit to ASP? If I have to change it, the format could be similar ortotally different?Thank you.
View 4 Replies
View Related
Nov 7, 2007
A series of articles examining some basic concepts in Sql Server.Basic Anatomy of Sql Server, part IWhat is a stored procedure?http://beyondsql.blogspot.com/2007/...ver-part-i.htmlBasic Anatomy of Sql Server, part IIThe unit test as part of the database.http://beyondsql.blogspot.com/2007/...er-part-ii.htmlBasic Anatomy of Sql Server, part IIIWhat does deferred name resolution really mean?http://beyondsql.blogspot.com/2007/...r-part-iii.html
View 1 Replies
View Related
Jul 20, 2005
After creating database in SQL Server , it generates .mdf , .ndfdatafiles .Generally if we get those datafiles then we can create the databasewith tables/data on another machine by using those datafiles.I want to know, if we can we protect this? I don't want another userto take those files and create database on another SQL Server. Isthere any option available in SQL server while creating database toprotect this file with password or any darn thing for protection thatwould not allow to create the database by using those file or anyworkaround.Thanks in advance for your help.
View 1 Replies
View Related
Dec 14, 2006
Hello,
I am having trouble just starting SQL Server 2005. When I try to use Management Studio, I do not see any server name. I just need to be able to start it up!
Thanks,
pagates
View 1 Replies
View Related
Oct 9, 2007
I have integrated Share Point server 2007 with Reports Server to publish the reports on share point site. I did all steps involved for integration
I have share point server, reports server and database server on three different machines configured and when I am trying to publish the reports from my local Dev box, setting the below project properties,
target datasource folder: http://vstsvr:168/sites/wsL/ReportsLibrary/
target report folder: http://vstsvr:168/sites/wsL/ReportsLibrary/
target Server url: http://vstsvr:168/sites/wsL/
I am getting the following error:
TITLE: Microsoft Report Designer
------------------------------
A connection could not be made to the report server http://vstsvr:168/sites/wsL/.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
Error
</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script>
<meta name="Robots" content="NOINDEX " />
<meta name="SharePointError" content=""/>
</HEAD>
<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
<form name="aspnetForm" method="post" action="../../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkRs1mjkyJL3hiHYWlWaZqxb1RHhI=" />
<TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
<tr><td>
<table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
<tr>
<td colspan=4 class="ms-globalbreadcrumb" align="right">
<a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a>
</td>
</tr>
</table>
</td></tr>
<tr>
<td class="ms-globalTitleArea">
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr>
<td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif" alt="" /></td>
<td class="ms-sitetitle" width=100%>
</td>
<td style="padding-top:8px;" valign=top>
</td>
</tr>
</table>
</td>
</tr>
<TR>
<TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">
</TD>
</TR>
<TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
<td class="ms-titleareaframe" id="TitleAreaFrameClass">
<table cellpadding=0 height=100% width=100% cellspacing=0>
<tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
</table>
</td>
<td valign=top id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
<table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
<tr>
<td valign="top" class="ms-titlearea">
<a href="http://vstsvr:168/sites/wsL" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>
</td>
</tr>
<tr>
<td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
<h2 class="ms-pagetitle">
Error
</h2>
</td>
</tr>
</table>
</td>
<td class="ms-titlearearight">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</tr>
<TR>
<TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
<table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
<tr>
<td>
<TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
<tr valign="top">
<td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
<td valign="top" width="100%">
</td>
</tr>
<tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
</TABLE>
</td>
<td></td>
</tr>
</table>
</TD>
<td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
<td class='ms-formareaframe' valign="top">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
<TR valign="top" >
<TD class="ms-descriptiontext" width="100%">
</TD>
<TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
</TR>
<TR >
<TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
</TR>
<tr>
<td valign="top" height="100%">
<A name="mainContent"></A>
<table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
<TR>
<TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span>
<P><span class="ms-descriptiontext">
<span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>
</span>
</TD>
</TR>
</table>
<script type="text/javascript" language="JavaScript">
var gearPage = document.getElementById('GearPage');
if(null != gearPage)
{
gearPage.parentNode.removeChild(gearPage);
document.title = "Error";
}
</script>
</td>
</tr>
</table>
</td>
<td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
</TR>
<tr>
<td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
<td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
</tr>
</TABLE></TD></TR>
</TABLE>
<input type="text" name="__spDummyText1" style="display:none;" size=1/>
<input type="text" name="__spDummyText2" style="display:none;" size=1/>
</form>
</BODY>
</HTML>
--. (Microsoft.ReportingServices.Designer)
------------------------------
BUTTONS:
OK
------------------------------
THanks in Advance for any help.
Devanand
View 5 Replies
View Related
Nov 9, 2006
Hello,I am currently creating a web app that I am creating using the Visual Web Developer Express IDE to create. I was planning on using a SQL Server Express database for the database backend. My problem is this...The web server i will deploying the app too does not have SQL Server, or Server Exress installed...can I still use the Server Express Database? Excuse my ignorance on this subject as I have is the passed used MS Access databases (my employer has never wanted to shell out the $$$ for SQL Server on our web server). Thanks in Advance for your help.-Dan
View 1 Replies
View Related
Dec 12, 2004
I'm hoping that someone here can help me.
I've written an app in C# with ASP.NET in VS. I can connect from my development computer (laptop - XP) to MY server (Win 2003) running MS SQL just fine.
However, when I try to deploy it on the server that it is supposed to run on, I can't connect. I can connect through the network to the SQL server, but I just can't do it with the app. This tells me that my connection string must be wrong... Of course, suggestions would be great...
The SQL server (7.0) is on Windows NT. The app is on a windows 2000 server, and yes, .NET Framework is installed. The Windows NT server is the web server, and the 2000 has been set up as www2. I can see the app from the net, but when I try to log in (requiring connection to the SQL server to verify user and pword), no go.
These are my connection strings, please correct me if I'm wrong...
(username and password are declared)
protected string myConnectionString = "Data Source=192.168.1.98;Initial Catalog=PIM;User ID=" + userName + ";Password=" + password + ";trusted_connection=false;";
protected string myAdminConnectionString = "Data Source=192.168.1.98;Initial Catalog=PIM;User ID=actualUsernameHere;Password=actualPasswordHere;trusted_connection=false;";
I've also tried them without the trusted connection, and with the server name... Same result (or lack thereof).
There's two connection strings, because one is used for the select statements for the public, and the other has all permissions for the back-end. I know it's redundant, but it's just one more safety feature I built in for the paranoid 'client'.
I have also tried to run the SQL server off of the 2000 box, but there's an error with the MMC... Does anyone know how to fix that, if it's a better solution???
Thanks very much for any and all help...
rob
View 2 Replies
View Related
Apr 28, 2006
Our workstations (XP SP2) and development servers (2003 R2) are all
32-bit. Our Staging and Production SQL
Servers are 64-bit (2003 R2 x64). We
have some VB SQLCLR assemblies we've developed.
My question is: Do we have to do anything special when deploying a CLR
Assembly to a 64-bit box when it has been compiled on a 32-bit box? Are there any advantages to setting the
Target CPU from "AnyCPU" to "x64"? Documentation and testing seems to indicate that the
assembly will run in 64-bit mode if compiled to "AnyCPU".
Will it run "better" in 64-bit mode
with the "x64" Target CPU type?
Thanks!
View 3 Replies
View Related
May 26, 2007
I have a multiple report server deployment, and we removed one of the servers from the farm, however the name still appears in the list on the initialize screen in report server configurator.
We removed reporting services from this box, but the name still appears in the list.
Where is this server name being stored?
Thanks!!
BobP
View 1 Replies
View Related
Mar 11, 2004
I'm new to using SQL server and have a few setup questions.
I'm setting up a database for the company I work for. Should I setup a different database for each division in our company (e.g. accounting, project management, estimating, etc.), or should I use just one database? It seems like it would be easier to use one database so I only have to use one connection, but is this ideal? I want all the info from the different divisions to be used together, but at this point I'm confused as to how to connect different databases together, if I were to go this way.
Thanks for any input or ideas!
View 1 Replies
View Related
Nov 10, 2000
I'm wanting to start to understand SQL Server. I've got the Beta Version of MS SQL Server 2000 and was wondering whether I could install this on my Windows Me box and start developing? Is this wise, or should i not use the Beta version? Is there a time when the Beta version "runs out"?
Are there any good basic SQL web sites out there? I know all about Access developement and i know some SQL, but i know nothing about SQL server. Which is the best site for me?
Thanks.
View 1 Replies
View Related
Aug 3, 2001
is there any way to use Visual Basic and MSSQL without using ODBC?
please let me know.
View 1 Replies
View Related
May 18, 1999
Hi,
I'm new to SQL server so I hope somebody is willing to lend a hand...
I installed the server without a problem, and the service is showing as running OK.
However, when I open SQL enterprise manager, no server names can be selected.
But, when i go in via DOS and enter
SELECT @@SERVERNAME
GO
I get the correct name back - "andrewp"
I don't understand how I cannot connect to the server via Enterprise Manager...
I'm running on NT4.0 Workstation, SQL server 6.5, if that makes a difference.
Thanks for any help you can give,
Andy
View 2 Replies
View Related
Aug 4, 2005
I've been using databases for twenty years now and have just started using SQL Server 2000. I've used dbase III+, FoxPro and FileMaker Pro mostly and have a pretty good generally knowledge of databases. However, I'm constantly scratching my head over a few SQL Server foundational issues and would appreciate some help.
Probably the biggest question is this:
In FileMaker Pro (and FoxPro if I remember correctly), I would set the relationship once and then never have to think about it much again. Then I could create virtual tables and sub forms which contained data from several tables and view/update them with ease. However, in SQL Server I've noticed that while I can define the relationships in a database diagram, every query has to recreate the joines. If I try to use a view I can only update one table at a time which seesm whacky to me. So what on earth is the point of having relationships if you have to redefine them with each query? I've read that referrential integrity is the reason but that only baffles me further as I don't understand the point. Sure I get cascading deletes but there has to be more to the feature than that.
Also, when I want to insert data in multiple related tables I'm used to utilizing the existing relationship, mentioning the primary key once and then simply filling in the data. It seems in SQL Server that I have to also insert on the foreign key. This doesn't make sense as the database should know which record I'm talking about in the foreign key table(s) as they're related. Again though, I'm not only recreating the relationship in the insert but I'm also having to specify the foreign key. I guess it just makes me wonder why it's not simply checking the relationships which already exist.
So I'm a bit baffled and any help would be most appreciated.
Thanks in advance!
Kelly
View 7 Replies
View Related
Nov 26, 2005
I'm a long time user of SQL Server 2000 but no knowledge of 2005 Express.
View 5 Replies
View Related
May 9, 2007
I am currently deploying my website.
I cannot establish a link with the SQL sever express database. I followed the instructions of my web host (covered in this thread):
http://forums.asp.net/thread/1698700.aspx
and finally I received the currently unresolved error:
"An attempt to attach an auto-named database for file d:hostingmembersharpeeuksite1App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I told my webhost I have followed their instructions and they came back with the answer:
"I would suggest you to upgrade the db's to use mssql 2005.
This is because, sql express is built for development environment. When you are in development environment, you are accessing everything with administrator permission. However, in live hosting environment (when there are differnet kind of permission restrictions), sql express often failed on attaching database. Any kind of change to the database would require re-attaching database. Personally, I do not feel sql express is ready for the live hosting environment. We can try to fix the attaching problem for you, however, even if we do it for free for you, you might encounter attaching db problem the next time you make any kind of update to the database schema. "
Is this correct? Is SQL server Express really unsuitable for deployment?
I am using webhost4life.com - Does someone know a webhost that can host SQL server Express reliably? (that would seem a lot cheaper than upgrading to mssql 2005)
Thanks for any advice
View 3 Replies
View Related
Jan 9, 2004
I'm going to be starting a web application this week. I have quite a bit of experience with Access Databases, and I've also used MySQL (back in my PHP days, thank GOD for ASP.NET).
The server we use to host our websites allows us to use SQL Server databases, so I want to move in that direction, but I'm not really sure where to start.
If I download MSDE, and start a database with it on a site I will be developing locally (on my XP box), will it be difficult for me to transfer the database (or layout of the database) to a production server running SQL Server. I know they're basically the same database, but I'm just afraid to start with an MSDE database and then get the site nearly complete, and then not know how to transfer it to a SQL Server DB.
I'm particularly interested to know if the majority of the database creation will be done through queries (similar to MySQL) because I figure if it is, then I can use the same queries to create the database on both the local and production server.
I just want to make sure that downloading MSDE will be a step in the right direction.
Perhaps links or tutorials or some information on things to watch out for as I take on this process would be so greatly appreciated.
Thanks very much.
View 2 Replies
View Related
Mar 28, 2008
Hi everyone,
I would like to know how I can deploy Microsoft SQL 2000 Server Personal edition using SMS 2003 Sp2.
When I map a drive and I execute my batch file it install SQL 2000 correctly but when I try to deploy SQL 2000 server personal edition using SMS 2003, It said that I deployed successfully sql 2000 server but when I look into my client computer, it didn't install SQL so this is the problem I have.
anyone can help me?
Best regards
View 1 Replies
View Related
Apr 9, 2006
This is probably a dumb question. But if I embed a SQL Server Express database into my project and then attempt to deploy it via ClickOnce, will I be able to access that database using the SQL Server Management Studio Express CTP if it is installed on the same machine as the client that my app would be installed?
View 3 Replies
View Related
Dec 26, 2006
Hi,my problem is the following
I can not completely understand how to deploy sse with my application
To some degree I understand the explaning in Mikes Documentation
Things I don't get:
1)Do I not check the prerequisite server express because when I did and run the setup.exe that I build the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.
A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but it doesn't work at all. I had no problem with the other prerequisites (Framework, installer)
Back to the first question: if so do I manually add the SQLEXP.EXE (downloaded from the internet) or is it the sqlexpr32.exe in the same folder as the setup.exe for the application?
2) How is the wrapper invoked? I don't see that mentioned. I thought when you start the application itself, but that hardly seems logical.
Please anyone, give me some clear directions or additional expanatory
Thanks,
Richard
View 6 Replies
View Related
Oct 24, 2007
hello,
i got this error when i tried to build my project prior to deployment. S.O.S.
Error 1 System.ApplicationException: Could not copy file "D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutionPackageConfig.dtsConfig" to the deployment utility output directory "D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutioninDeployment". ---> System.IO.IOException: The file 'D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutioninDeploymentPackageConfig.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow)
0 0
View 3 Replies
View Related
Sep 13, 2007
Hello All,
I had VS2005 in my machine and was working with a mobile device using Sql Server CE. While compiling and deploying device application to my mobile device it used to deploy the Sql Server CE cab files also.
But now i have migrated to another machine ( Vista OS ) and installed VS2005 newly etc., Now when i try out the deployment of device application to my mobile device it is not deploying the Sql Server CE cab files but just copies the SqlServerCe dll file.
So when my application launches in the mobile device i get an error can't PInvoke sqlceme30.dll etc.,
I know that i can manually copy the cab files to my device and work. Its little tedious. Can anyone tell me how to achieve the behavior of my old VS2005 wherein it automatically deploys the SqlServer CE cab files? Is there a setting in VS2005 to enable this. I read in one of the posts that we can go modify the option Tools->Options->Smart device and enable an option to deploy the latest updates etc., But i couldn't find such an option in my VS2005.
P.S: I have installed my SqlServer Mobile edition 3.0 SDK to the default path under program files. Should i install it under VS2005 smartdevices SDK or something like that? I tried that also but still no success.
View 2 Replies
View Related
Jan 31, 2006
I'm building a app for a sprint pocket pc: ppc-6700. I've been able to
install the .NET cf 2.0 and run an app with little problem. I've
created a new app that uses the sqlerverce namespace and from what I've
read that will push the sql server mobile onto my device what i deploy
it. When I do that it gives me an error saying:
Installation error. Stop all applications and processes,maximize
available storage space, and run installation again. Support info 2.
When I hit ok it then finishes and then gives me an error in VS 2005 saying:
Error 1 Deployment and/or
registration failed with error: 0x8973190e. Error writing file
'%CSIDL_PROGRAM_FILES%ppctestppctest.exe'. Error 0x80070020: The
process cannot access the file because it is being used by another
process.
Device Connectivity Component
Not sure what to do from here. Any help would be appreciated. TIA!
View 5 Replies
View Related
Jul 31, 2006
Hi
Do we need to perform any special checks when we deploy SQL Server application developed using 32 bit SQL 2005 Edition in 64 bit SQL 2005 Edition?
To my understanding, 64 bit SQL Server 2005 provides better memory management and provides high performance when compared to 32 bit and it should not be an issue in deploying the application developed in 32 bit SQL Server 2005 in 64 bit environment.
Any help/hints on deploying in 64 bit SQL Server (for a product[SPs, TSQL Stmts] developed using 32 bit SQL Server) is appreciated.
Thanks
Kart
View 1 Replies
View Related
Nov 15, 2005
I am in the process of designing a Windows Forms 2.0 app, and need advice on the recommended deployment/creation of the database for my customers.
View 1 Replies
View Related
Jan 26, 2008
Whenever I try to install SQLServer 2005SP2 (downloaded from Microsoft Page) there is always an error message.
A recently applied update, KB921896, failed to install..
I tried downloading all the types of setup for SQLServer 2005 (x86, x64, IA) and the same error occurs..
I am using WinXP SP2, what's behind this stupid errors? I really want to start using SQL Server because i am using VWD 2008 Express. Somebody help me for this please. I need complete details. Thank You very much..
View 1 Replies
View Related
May 3, 2006
How do I insert a record into a field where I want to display a unicode value.
The unciode # is: u2265 . It is for the greater than or equals sign.
I want to write in the field: sample [is greater than or equal to] test
Thanks
View 2 Replies
View Related
