Copying Personalization Settings To Another Field
Feb 24, 2006
Im trying to store default page layouts for the different Roles created in my membership provider. Depending on the job code of my employee, they get different default formats of the website. What I thought at first would be easy, is proving to be a bit of a pain. I guess what I need to know are two things:
1) How can I create an image field in my aspnet_Roles table, and set the length = 6000 to match the 'PageSettings' field in the aspnet_PersonalizationPerUser table? By default the image is set to 16, and wont allow me to change it. (this might not make a difference, Im not sure)
2) How do I copy this binary data back and forth from one table to another? I realize its actually a pointer, but why cant I copy the pointer to another field?
I appreciate any help available.
View 2 Replies
ADVERTISEMENT
Feb 26, 2006
It appears that when you use the import/export wizard from within Microsoft SQL Server Managment Studio, the identity attributes of the table being copied are not transferred. For example, say the source table has a column
[ref] [int] IDENTITY ( 1 , 1 ) NOT NULL,
When the import wizard is done the destination table will have a column named ref, but will not be an identity column. The column definition will be
[ref] [int] NOT NULL,
instead. Is there a way to change this behavior somewhere in the gui? When doing the import, the only options seems to be 'Enable Identity Insert', but checking this does not affect the definition of the column.
-Eric
View 7 Replies
View Related
Oct 7, 2004
I am working with a homecare application that stores nursing notes into a text field in the database. The database is growing exponentially and I want to create a procedure that select all notes older than six months, write it to an OS file, then deletes the record in the database. I am doing the writing using a cursor, however this is very slow.
Has anyone done anything similar? Let me know..
Thanks
View 2 Replies
View Related
Aug 17, 2007
i am using web parts with drag and drop feature , i did not use aspnetdb for user membership
while it is published it gives eror as follows
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. SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Please give me ur valuable advice , thanks in advance
View 2 Replies
View Related
May 14, 2007
I'm trying to figure out how to build a personalization engine.
If my structure is built with users as case, and products as nested - I€™d like to predict best products per user (rather than associated products), and If possible, ignoring products he already bought.
How do I do it?
View 7 Replies
View Related
Jun 26, 2015
I need to have a table that has a primary key
CREATE TABLE [dbo].[testing](
[tid] [int] IDENTITY(1,1) NOT NULL,
[sometext] [varchar](150) NOT NULL,
[idcopied] [varchar](50) NULL,
CONSTRAINT [testing_PrimaryKey] PRIMARY KEY CLUSTERED
..and eveytime I add 'sometext' as another row, the tid # needs to be duplicated to idcopied field
insert into [testing] (sometext,idcopied) values ('some junk',@@identity)
???
View 4 Replies
View Related
Jan 30, 2008
Hello friends! Actually we are using personalization concept in our application. We got the below error while running our application from remote server. We have uses ASP.Net 2.0 framework and MySQL server 2005. If anybody knows solution about this, please give us reply. The error is 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:
Line 58: }Line 59: set {Line 60: this.SetPropertyValue("firstname", value);Line 61: }Line 62: }
Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesproflick1590573e66ec62App_Code.nudj4ngy.13.cs Line: 60
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) +735203 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.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766 System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428 System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +410 System.Configuration.SettingsBase.SetPropertyValueByName(String propertyName, Object propertyValue) +170 System.Configuration.SettingsBase.set_Item(String propertyName, Object value) +89 System.Web.Profile.ProfileBase.SetInternal(String propertyName, Object value) +139 System.Web.Profile.ProfileBase.set_Item(String propertyName, Object value) +71 System.Web.Profile.ProfileGroupBase.SetPropertyValue(String propertyName, Object propertyValue) +27 ProfileGroupUserRegPersonalDetails.set_firstname(String value) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesproflick1590573e66ec62App_Code.nudj4ngy.13.cs:60 UserRegPersInf.RegisterPersInf_Click(Object sender, EventArgs e) in e:hostingannasgroupProflickUserRegPersInf.aspx.cs:25 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 Thanks in advance.By,Pavani
View 1 Replies
View Related
May 6, 2002
I am running AWE on SQL 2000 (the server has 8 gig of RAM). I have the SQL Server set to use a max of 6 gig. The server hung unexpectedly (SQL showed no errors or signs). Has anyone had any problems with using AWE, and or any suggestions or changes I might need to do?
Thanks
View 1 Replies
View Related
Aug 25, 2015
I'm new to SQL and I'm trying to write a statement to satisfy the following:
If [Field1] contains text from [Field2] then return [Field3] as [Field4].
I had two tables where there were no matching keys. I did a cross apply and am now trying to parse out the description to build the key.
View 8 Replies
View Related
May 4, 2006
Good morning...
I begin with SQL, I would like to add a field that will be date like 21/01/2000.
Actually i find just "datetime" format but give me the format 21/01/2000 01:01:20.
How to do for having date and time in two different field.
Sorry for my english....
Cordially
A newbie
View 3 Replies
View Related
Jul 26, 2000
Hi,
Can i check installation settings for SQL Server 6.5 ... like what sort order id. has been choosen etc. ? by any query ?
Thanks
View 1 Replies
View Related
Jul 16, 2002
New SQL2000 installation into which I've copied data from multiple SQL7 installations. Some of the databases I've copied over from a SQL7 server with code page 850, sort order/collation 42, using the detach-copy mdf/ldf-attach procedure outlined elsewhere on this site (thank you). Other databases have been DTS'd from another SQL7 server with code page 850, sort order/collation 44.
In the end I want all databases to be in the default Latin1_General_CI_AI collation I've chosen for my installation.
I'm off to immerse myself in collation papers and alter database documentation from BOL, but was hoping someone could enlighten me in a less painful way.
Thanks,
Al
View 2 Replies
View Related
Mar 27, 2008
Hi all
I've got a problem with an American software vendor, who's asked me to check and adjust the regional settings within SQL Express 2005, installed on an XP SP2 pc
I'm scanning meta data into this database
If I enter a date field with a UK date format, I get an error in the SQL logs
If I enter a date field with a US date format, everything is fine
The XP box is setup with all UK region settings
I've been told that my SQL install should automatically use the region settings from whatever OS that it's installed on
I've checked everywhere within SQL, and it all looks to be setup with UK region settings
I suggested to the software vendor that the problem lies with their software
Can anyone suggest if I've missed anything, or where I should be checking my region settings within SQL?
Kind Regards
Tonasis
View 2 Replies
View Related
Apr 14, 2008
From the sql server management studio i cannot see database properties
logical file name of mdf, location of the mdf
logical file name of ldf, location of the ldf
what setup should i change to see the properties.
View 5 Replies
View Related
Sep 9, 2006
When SQL Server and Web site are both on same machine,
it runs fine, can get data and display in web page.
but when trying to get data from remote SQL Server, it gives error.
What's the setting for SQL server configure and security settings
in different versions?
MS SQL 2000 | MS SQL 2005
==============================================
Framework 1.x ? | ?
Framework 2.0 ? | ?
Thanks alot.
Please provide some setting help for the ?
View 4 Replies
View Related
Jun 26, 2007
is there a simple manual how to setup RS.
with the administrators group im able to view my reports. but normal users are not able to view anything. they can enter reporting services, but not open a report.
View 1 Replies
View Related
Sep 13, 2006
I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time).
I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK.
That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally).
Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this.
Now I'm focussing on using SQL Package Configurations to try and drive this. As I see it, just like XML configurations, if you change a value in the configuration source, then when the package runs, it get's that value, and uses it.
I have change the configuration value (outside of the package). I confirm it is actually changed by running a SQL Task that gets the value from the configuration table, and view the value assigned to the variable in watches. The value returned is a different value (in my case I changed it to an invalid servername), and yet the task still runs through successfully, using the previous SMTP servername.
huh?
View 4 Replies
View Related
Sep 29, 2006
I wanted to know if there is a way to enforce security settings on SQL 8 Server. Specifically password lengths, expiration,e tc. These servers run on a Windows Platform, so if it is not possible to enforce passwords at the database level can the windows passwords parameters be enforced for the server.
Also, how would I be able to find the last changes made to the tables within the database.
View 1 Replies
View Related
Oct 16, 2006
I need to place some site settings in my Report Manger.But in my Report Manager there is no Site Settings Icon.Is this installation problem please help me.
View 3 Replies
View Related
Nov 6, 2006
I have a page that uses an SQLDataSource web control to populate a GridView control. The SQLDataSource control uses three parameters, one of which is a text string (varchar(50)). I get timeout expired exceptions when I run the page with two specific string values, yet when I run the stored procedure in SqlSvr Management Studio, the procedure runs in 5 seconds and under 1 seconds. Being rnew to ASP.NET 2.0 and .Net in general, I have no idea where this lag is occurring. I would like to know two things:
1. What is causing the lag that causes the timeout in ASP.NET 2.0.
2. What can be done to adjust the timeout period SQLSVR, IIS, ASP.NET).
The underlying query is running as desired (considering the data it has to chew on). For all other values, data is returned almost instantanious. I can provide a copy of the query id need be.
Truly appreciate any insight you can give me!
View 2 Replies
View Related
Dec 3, 2007
INSERT [DELETE] failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
On local dev machine with SQL Express DB everything works fine. Once moved to shared hosting environment (with adjustments to web.config), insert and delete stored procedures produce the above error.
Made sure that stored procedures SET ARITHABORT ON at the beginning and OFF at the end, without success. Even SET ARITHABORT ON at DB level without success.
Suggestions appreciated
View 2 Replies
View Related
Dec 11, 2003
Hi all,
I am a newbie to .NET and MS SQL server. I am trying to connect to sql server d/b from my application files.
How should i open a connection from my system pc5 (where application/proj being developed) to SQL serevr which is installed on my server(server1). Both are in network.
I have installed sql client on my system(pc5) and created my d/b (MyDB) thru EM, now how can i create username & password for MyDB datbase.
I had installed ASP.NET Commerce server(from ASP.NEt site) on my system pc5 its working fine with accessing Commerce d/b from server1. I observed the string in web.config file of commerce application it is as follows.
<add key="ConnectionString" value="server=server1;database=Commerce;uid=CommerceUser;pwd=CommerceUser;" />
In the same way can i create Username and passsword for MyDB database, if so how should i do that. that should look like some thing like this..
<add key="ConnectionString" value="server=server1;database=MyDB;uid=MyDBUser;pwd=MyDBpass;" />
to do in this way i need to create username and pw for MyDB . How should i create username ansd pw for MYDB datase.
Pls help me out.
Thanks in adv
Kumar
View 3 Replies
View Related
Jun 5, 2006
Hello all. I created an app locally with VWD Express and moved it to to our server but I am getting the following error...
An attempt to attach an auto-named database for file D:WebApp_DataSurvey.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
This is the connectionstring from the web.config file used on the server. I did not change anything from the local copy.
<connectionStrings>
<add name="SurveyConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Survey.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
What settings do I need to change in order for this to work? Any advice is appreciated. Thanks.
View 1 Replies
View Related
Jan 23, 2004
Hi,
I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.
Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?
Thank you for any input
Marman
View 1 Replies
View Related
May 12, 2014
Using the Agentpress theme I have put together a client site that is fully functional, however the client has asked that the search query is altered slightly and i'm having trouble working out how to do it.Basically they want the search facility provide the following options:
1. Bedrooms searched for as 1+, 2+, 3+ and 4 or more.
2. Property availability to provide just 2 options - Available and Include Let Properties.
how to change the search settings to return this information.
View 2 Replies
View Related
Apr 5, 2006
Hi all,
I need to change the Language Settings from my query analyser. Is it Possible???
If so, how ??
Thanks in advance
Regards,
satish.r
"Known is a drop, Unknown is an Ocean"
View 1 Replies
View Related
Dec 23, 2006
hi guys :( ive searched on all the topics here about replication. but now i am wondering what windows xp settings do i have to edit? i read something about dcom settings and changing permissions. what is the RIGHT way to share a file or whatever because the schema cannot be accessed for some reason. i need a whole list of things to do because things are not working out after i read the tutorials on other sites. please someone help me.
basically i need to have two servers that need to be replicating each other. i realized that the instances have to be named so i am just totally confused. ill even let anyone connect remotely to help me out if they want. or explaining will do fine. please! thanks guys!
happy holidays!
View 3 Replies
View Related
Jan 15, 2008
Hi All - sorry for dumb question.
I changed a log-file growth from 10% to 10MB in November. Then had to do the same again today.
Is there anyway it could have (somehow) changed-back by itself?
View 3 Replies
View Related
Feb 26, 2006
I will doing an installation of MS SQL 2000 that will be used by multilanguage web sites.The languages are Japanese, German and of course English.Currently I'm planning to install MS SQL 2000 standard version butafter reading some articles I'm considering the Enterprise version.Can someone shed some light on the advantages of using Enterprise vsStandard strictly from a language support perspective?Also, is there any caveats or other considerations that I should keepin mind to make sure that the developers have all they need to developthese multi language sites?Thanks in advance.
View 1 Replies
View Related
May 10, 2006
I am creating an image gallery system, where there is an admin andmultiple users upload images. Each user is restricted to uploading 8images. Currently, I have this hard coded into a trigger. I wouldlike it to use a table field instead... one that the admin can changeon the fly. I want to call this table Settings, but I want to createinsert 1 record, and then block all subsequent INSERT statements(there's only going to be 1 setting) so that the Settings table willonly have 1 record in it for its entire lifetime. What's the best wayto do this?
View 2 Replies
View Related
Jul 20, 2005
Hi,In the Web application I am working on, data is read from a SQL Serverdatabase. At any time, there are about 15 people browsing the web.The SQL Server database is updated with new information once everyhour. The update takes a couple of minutes. The isolation level duringthe update is so to Serialazable so that the front-end does not getany incorrect data.Now, here is my problem. When the web page is being loaded, the serverside ASP.NET code uses several SELECT statements at multiple places.For various design reasons, these SELECT statements cannot be combinedinto a single statement. As a result, it may happen that during thepage load, we get some data before an update and some data after anupdate.I am wondering if I must used a transactional lock even for the Webapplication although technically it is not updating the database.Also, after playing with various transactional settings, I noticed thefollowing behavior for the readers when a writer enters a transaction:1. If the reader app has not yet executed the query, the call to queryexecution blocks until the writer has done its job.2. If the reader app has already begun executing the query, the callis not blocked and SQL Server provides the needed isolation.I do not wish to block the readers while the update is going on.Ideally, I would like it to be such that even if the writer isupdating, the readers must continue to get the old data, that is,until the writer commits the update. However, I did not find anyisolation settings that would let me achieve this non-blockingbehavior. Am I missing something?Thank you in advance for enlightening me.Pradeep
View 1 Replies
View Related
May 25, 2007
ok im trying to set up an odbc connection to my database.
i am using MS SQL SERVER 2005 Express on my labtop that is running windows xp.
on the labtop i went into control panel - admin tools - data sources (odbc) and then under the user dns tab i added a sql server with these values in the fields
name: MyFoxData
Description: [i left empty]
Server: TESTINGSQLEXPRESS
then i hit next
then i have checked With Sql Server authentication using a login id and password entered by users.
i enter in my login id and password.
i then uncheck connect to sql server to obtain default settings.
i hit next and change default database to DNN445
and i leave everything else the way it is, before i save it i test the connection and it works fine.
I do the same exact steps on my desktop to try and connect to the SQL database on the labtop but for some reason i keep getting this message
Microsoft SQL Server ODBC Driver Version 03.85.1117
Running connectivity tests...
Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
TESTS FAILED!
any ideas?
View 4 Replies
View Related
