I read on MSDN that Ntext and Image will be removed from future version of SqlServer, but as I check my db the aspnet_Profiles uses ntext and image MSDN says replace them with nvarchar and varbinary
1. I tried to replace these column and got an error
2. When should I replace these datatypes?
3. Will Microsoft put out an update for this particular setup?
i am trying to do: Parameters.Add("@ProfileHtml", SqlDbType.Text, MAX_TEXT).Direction = ParameterDirection.Output but i keep getting this error. MAX_TEXT is integer = 2147483647 Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types instead.
View 4 Replieswe have a AutoGenerateColumns-enabled WmxDataGrid in which we are able to update table rows in a DataBase connected with a SqlDataSource.
Each time we clear a field an empty string is written to the database where we want to write DBNull values.
At the moment we generate the update string via UPDATE... SET.. and the SQL Server function NULLIF(value, '').
Works proper but when I want to add the values to e.NewValues in BeginUpdate event I'm not able to read the values from the auto generated text boxes. How do I do that? Is there an easier way to automatically convert empty strings to NULL values?
I've just started investigating the Microsoft Ajax Minifer 4.0 for use with a Visual Studio 2008 Web Application I work on. It's proven easy enough to hook it into the .csproj file so it produced .min.js files for all scripts, however I'm stumped as to how to integrate this with the Web Setup project & Source Control.
Essentially what I want to do is have the resultant .min.js files included in the Web Setup project without having them included in Source Control because:
Having to check them out prior to the build being executing is a pain (the minifier cannot modify them if they're not checked out).
As they're created as a "build artifact" it just seems wrong to have them stored under source control.
The only option I've managed to come across so far is to explicitly include the .min.js files as part of the Setup project by right clicking on the Web Setup project and choosing "Add > File", and then having the relevant folder hierarchy duplicated in "File System on Target Machine" so that I can force the file to the correct location. This is neither elegant or simple/robust as:
It requires me to manually add every minified js file to the Web Setup project by hand Maintain a copy of the relevant directory structure in both the Web Application project and the Web Setup projec Remember to add any new js files minified versions to the Web Setup project.
I have setup and SqlCacheDependency for my site and all is working well, but there is one requirement in my task that I dont' seem to be able to find the workaround for. Currently, my code relies on the following web.config settings to allow the SqlCacheDependency to know where to connect to. it is like this:
<connectionStrings>
<add name="connstring1" connectionString="......" />
</connectionStrings>
<caching>
<sqlCacheDependency enabled="true" pollTime="500">
<databases>
<add name="db1" connectionStringName="connstring1" pollTime="500" />
</databases>
</sqlCacheDependency>
</caching>
The problem is that we can't allow in our application the connectionstring to be on the web.config. I am asked to programmatically do all of that. I don't know how and I don't know if that is even possible, is it?
tblUsers (Primary db using conn1)
UserID
FirstName
LastName
Status
tblResponses (Secondary db using conn2)
UserID
ChoiceID
Status
[Code]....
This constraint cannot be enabled as not all values have corresponding parent values.
I would like to create a webform in asp.net that allows you add events to a overall application, anyone then can go search that event by a specific date and if that event falls under that recurrence day you will see it. This would be similar to Outlook where you can say it recurs every Monday, Tuesday, Wednesday,... or every third Monday, ...Specifc day of the month, etc. I have created the webform but now I have the problem of how the database works. I have been reading for the past couple days about this but I cannot figure this out. I found some posts that say you can create a seperate table aside from your main table that holds the eventid and the dates of the recurrenecs. The problem is this table could amount to thousands of lines from just a few events input. My question is, is there a formula out there that can do this without creating a crazy big recurrence table? .... If not, how many lines can a MS SQL database hold before it has performance problems?
Here's a link to another forum I found with my same question but I do not understand the answer:
[URL]
am writing a series of WSS/MOSS webparts amongst which one will need to detect the current SQL Server database connection, prompt the user to setup a new connectionstring, and fire appropriate stored procedures to create a new database if needed. The user needs to be presented a textbox or label control with the current database connection. I've never had to detect current database connection, what methods do I call for this? If the desirable connection is not present, the web application needs to prompt the user to make a new database. The user really won't make the database, they simply need to click the command button which will fire the stored procedure to create the database.
View 1 RepliesI have a SQL Server 2000 database. I am trying to ssetup a sqldatasource in Visual Web Developer 2008 Express. I get an error saying "Microsoft.SqlServer.Management.Sdk.Sfc cannot be loaded". Everything I can find says this is related to 2005 or 2008. Any ideas what I can look for?
View 2 RepliesI created and populated a database inside Visual Studio 2008 instead of using Management Studio.I need to run the script to create the schema for users and roles.The database does not show up in ASP.NET SQL Server Setup Wizard or in Management StudioThe only databases that do show up are master, model, msdb, and tempdb
Is there anything I can do to fix this or would it be easier for me to just create a new database starting in Management Studio and then connect to it from within Visual Studio?
I have a problem and I could not solve it. Hope you can write a sample code for me. I have a Microsoft Access database, and in asp.net website, i draw a grid view on the design page. I also configure the source data access. It works, but display all the data in the database. i want to display all the data which is related to John. sql = "select username, customer_name, phone from db where username = John" how do i configure the data grid view?
View 3 RepliesI have an error when visiting my page
The Microsoft Jet database engine cannot open the file 'E:""""""""datab.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
i have created a pluIn(setup) for IE. this plugin add in IE addOns.this pluIn(setup) installation and uninstallation is working perfect. now i want use a webservise that check version of my computer plugin and server computer plugIn(setup).if both version are different then ask for updation of PlugIn(setUp).if i click on yes then it update my end PlugIn(setup).
View 1 Replieshow to install microsoft sqlserver 2005 or 2008 on window 7 with x64 bit.It works perfectly on vista but on getting a new system which comes with window 7 and x64bit i was unable to load the software onit except my visual studio 2008.
View 1 RepliesI got the following error message on my web app and am trying to figure out what I need to do to fix it. :S
Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
I have the application running on the live server now, but we are migrating to a new server and they asked that I load this application on that server. I loaded the files and am working my way though the asembly errors (the new server is 64 bit so I had to tell the application pool to allow for 32 bit applications)
But then this happend and I got the error above and didn't know what to do.
I had this dll set to copy local, but after I got this I set that back to false. It works on both my dev server and my live server. Both running windows server 2008 and IIS7.
For my web application I need to allow the user to upload a word document to the database. I've searched the forums and I've only been able to find with uploading to a server. Can anyone one give me a link to a tutorial or step by step guide on how to do it? I'm not even sure what data type to set the attribute to in the database.
View 4 RepliesOn my local machine i read excel cell for it I used Microsoft.Office.Interop.Excel and there are microsoft office 2007 is installed on my system but when i host site at live server there are microsoft offie 2007 is not installed so that error comes that Microsoft.Office.Interop.Excel could not load.
For it i also try to install o2007pia.msi on server but it gives error install microsoft office 2007 before install this product.
So that iwants to read excel cell with out install MS Office.
I am using .net framework 4 and connecting to oracle 10 g via System.Data.OracleClient. It is working but it says it is deprecated and what else should I use instead of it?
View 2 RepliesIam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running
View 7 RepliesHere is the sqldatasource config code: <asp:SqlDataSource ID="SqlDataSource1" runat="server"
View 1 Repliesi want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
I hear HTTP endpoints are being deprecated in SQL Server. What takes its place in future?
View 1 Replies[code]....
Im trying to update my DB(DataBase) by using SQL UPDATE query ,but its not updating in the dataBase i receive confirmation(in testLabel) that one row is affected(dataReader = query.ExecuteReader(); return numbers of rows affected)...
I have given a HTML editortext control on a page,which generates HTML (i have to store it in my DB,that page is only for Admin) ,on pressing Update button , im receving in my testLabel that one row is affected(which shows DB is updated succesfully) but when i check my DB its in old state,it is not updating...
Here is my Event handler of Update Button which have to make updates in DB:
[Code]....
[Code]....
What's wrong with the following code?
[Code]....
After the SubmitChanges call, the Text field in data2 wasn't changed. According to the NerdDinner sample, I supposedly can just write to my data object and then call SubmitChanges.
I have a web application that has been using the System.Data.OracleClient.dll for the past 3 years. Recently we've been having some performance issues on the database server and it appears that this app is now causing problems when connecting to our Oracle database.I've found an updated client at the Oracle website: http://www.oracle.com/technetwork/topics/dotnet/index-085163.htmlMy question is: Is it necessary for me to update to this new client?We are running Oracle 11g on 64-bit servers in a cluster.The app is running on a Windows Server 2008 R2 64-bit machine using ASP.NET 4.0. The app was built using Visual Studio 2005 Team Suite on a 32-bit machine. It was re-compiled on a 64-bit machine and imported into Visual Studio 2010 Professional in order to switch the target framework to .NET 4.0. Then it was deployed to the server. This basically updated the Web.config file for us, the rest of the site remains the same as before.
View 2 Replies