If i want to make any changes in db structure or need to modify any data values, i have to login remotely to my server and has to open sql server management studio do db change or value editing stuffs. Its really getting iritating when the remote machine looks slow.
I just want to know how to configure the db hostname like dbname.domainname.com or mssql.domainname.com in server, so that we can open the server db in local using sql server management studio.
The application installed in windows server 2008 and using IIS 7.0 & SQL Server 2008
I use a calendar to pick a date that I want to store in my MSSQL Database. I use the form format, like 2010-01-27 (european date format) with no time info. What MS SQL Date-type should I store this date in?
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
I am wriyng an ASP website for my use on my local PC.
I have setup IIS and eveything works OK apart from accessing my SQL database. As I'm new to this I did not realise that you need to change the connnection string to reflect the place where the DB will be.
Having tried various options like http://localhost/ & db name, without succes I'm looking for some help.
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.
My hosting company provider MS SQL Express as part of my hosting package, they have provided me with both the name and IP address of the server running MS SQL Express.
I have created a database on this server via management studio and when I create a connection string like this (connectionString="Data Source=ServerName/IP;Persist Security Info=True;User ID=xxx;Password=xxx") my application works fine.
But if I create a local database file and try to attach this with a connection string like this (connectionString="Data SourceServerName/IP; AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance = True ; Trusted_Connection=Yes) my application doesn't work.
Therefore my questions are:-
Is there something wrong with my connection string? Can you use a local database file within a production environment?
I am about to get my sites hosted with a local host company. They are offering me their lowest cost MSSQL server, which is the web edition. So my question is what is the difference between that and 2008 express edition? Can express edition be used for a full fledge in production website? And does Web implies that I will be interacting with it via the web correct. Lastly, if the web version is not chosen what is the typical protocol for uploading and maintaining a site when you have a dedicated server. Do you normally have to go to the data center or is there like a web portal that can be used. I will be asking the guys at the company these questions as well, but I want to make sure I get another opinion on the issue.
I have a situation where I am accessing a database multiple times and I'm wondering if it is necessary.
I have a GridView with a template column with a hyperlink to "Get Results" and on the RowDataBound event I have it check the batch number against the database and see if results exist and then if they don't, hide the link.
So when viewing the page if there is 20 rows in the gridview it is effectively doing 20 queries.
I was wondering if it is a better idea to query the database once with all "batches" and load it into a datatable, then on the RowDataBound event query the datatable. The only issue I see with this is there is currently 40,000 batches and grows daily.
I asked plesk the following question:I've been through the documentation and scoured various forums, but I can't find a defintive guide to uploading an mssql db (contained in a app_data folder) to the server and conecting it via the Plesk control panel. I've created a db and user via the panel but how do I get the actual db to the server and get it to work?"and they replied:"For database restoration please upload your database backup file ( i.e. .bak ) under your hosting space and update us the exact path where you place this file + your database login details ( i.e. database name , database user name and password ). So we restore this database for you. "
Is it possible for an ASP.NET web application installed on a web server to connect to an Access database stored on a local PC (which is NOT the web server)? I would like the web application to allow the user to specify the path/complete file specification to the database. Or, based on login information specified by the user, the web application might determine the path to the database via an administrative database stored on the web server. The user/customer would be responsible for the storage of the Access database. If the answer to my first question is "YES", how do I programmatically specify/format the path to the Access database on the local PC so the web application can locate the database?
The path has to be something more than "C:foldernamesubfoldernamedatabase.mdb". When I use a path like this, the web application produces an error indicating that the database does not exist or cannot be found. So, I'm fairly sure that the web application is not starting with Drive C: on the local PC to find the database. For all I know, the web application may be interpreting Drive C: as Drive C: on the web server. I'm wondering if I need to specify a computer name before "C:" in the database path.
I was wondering what you guys thinks is the most efficient way to select data from a msSQL database.. I tend to use a sqldatareader, but is this really the best way? - It is particularly impractical if one also must take into account, that the table may be "Null"?:
On the internet we bought/hired a CRM product. When we enter a new project this datarecord (on their MSSQL DB) is transferd to our local MSSQL DB.
Internally we got a seperate application that uses the project information.
So after an insert project on the CRM side (on the internet) the data is transferred to our DB. When i check the internal application I see the project. All nice and sweet.
BUT when I alter (UPDATE) a project in the CRM internet application this data is pushed to our DB and i see the data in the table. But it doesnt show up in the internal webapplication. When i restart the website in IIS it still doesnt. Only when i restart the entire IIS the data is updated in my internal application.
Used techniques:
.NET 3.5MSSQL 2005LINQ to SQL The only thing i can imagine is that LINQ to SQL has a own cache or something. If so... how to disable it
How can I select a random row and then update or delete it? I've found how to get a random row, using SELECT TOP 1 column FROM table ORDER BY NEWID() do I have to make another select using this result in order to update the row, or it can be done more efficiently?
I have a ASP.Net website that interacts with Dynamic CRM. It's also uses a local ASPNETDB.MDF for forms authentication. For the CRM I need to impersonate the identity created on the domain for this purpose. When identity impersonate is enabled I no longer have access to the local Membership Database. How can I allow the domain user used for the impersonation access to the membership database?
using c#, i have an array where i want to test every single line of this array if it is already contained in a table of a database. if not, i do an insert. the test if the line is already in the table is performed using update, if update fails i insert the line. this works BUT the table contains 100000 entries, the arrays i want to compare/insert contain appr. 5000 entries. so, i is really slow and takes minutes.
i was trying to upload from an .xls file to microsoft sql server.What i did was i upload the file to a folder in server and pick the record from the folder. This work on development machine but on getting to a iis server to test the application i got an error that was saying the root folder for the www root for the folder was not found. Below is the code.
when a website is entered in a browser it should take to a login page (in localhost) and if the login succeed then the site should be loaded else an error page should be displayed. the login page will be connected to local database. how to do this?
I'm an experienced PHP programmer that is new to ASP.net (C#). I'm trying to figure out how to do a manual echo of a specific field from an SQL database and was wondering how you do an if condition in case the field would meet certain criteria ?
What I want the script to do is check in the database if a certain condition is activated, then the html page should echo a windows media player object with the source of the video coming from the database itself ( $line[Video], and if the condition isn't active then either don't echo the player or just echo an old video (in the script I'm just printing a message).
I want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
Im trying to import a semiolon seperated file into mssql db 2000 table and I need your help.I can read the file and present the content in a for loop, but I would like to extract values at certain possions.Like "Fel Beskrivning;Konktakt förare; and so on.
Now I'm developing web application with ASP.Net MVC but I have to use 3 databases. So I have no idea about this. I have to extract the data from 2 databases and I have to save the data to another 3rd database.
How can i connect my local project with the SQL server 2008 Database that is running on other server (This server is not on my network and i connect to it via remote desktop connection).
If I have the appropriate permission, is their a way to access a sql server database on two different servers?
For example if I have a Table A on server 1 and Table B on a different server. How would I join the two tables together, if they each have a column named "PonyId"
I created a website using VS2010. When I run the website using built-in web server, everything works fine. The website recognizes javascript and aurigma uploader. When I publish the website to local folder and tried to access using IIS 5.1 on local pc, the java scipt files did not work. I was getting yellow triangle sign at the bottom of the page indicating the object is expected. I tried to look online but i could not find any answer. I have included jquery and javascript file in the header section of master
