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 am using SQL SERVER 2008.
Now I want to access the SQL SERVER 2008 DATABASE on the LAN.
So what was the Connection String and can u give me the Example of that.
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.
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.
View 7 RepliesHow 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).
View 1 RepliesWe have a cient we are stting up that has 2 separate physical servers, one that is the web server the other the database server. Using impersonation we have been able to get the website to connect and retrieve data from the sql server so that part is not an issue. The problem is I have a windows service application that must be installed on the web server (as it process files downloaded to an ftp site) and it must be able to connect and write to the sql server as well.We tried adding a system.web block with the impersonation stuff to the app.config file which of course did not work. Can anyone tell me what/how we need to configure this properly?
View 7 RepliesI am creating an insert statement in my c# code to insert records to an access database table. I am getting the error copied below using c# code. When I copy the generated insert statement from the console and run this on my access database, it succesfully appends a record in the table.Insert statement generated:
insert into [Pet Fish-log 2010] ([Specimen Type], Year, [Lab Number], [Last Name], [First Name], [Middle Initial], Gender, [Date of Birth], [Collection Date], [Date Received], Client, [Tissue Type], [Block Number],
[code]......
I am pulling a date from an Access Database and inserting into my Dataset. I am assigning it to "myDate" and then assigning it to my SQL parameter @StartDate.
When I run my ExecuteNonQuery I get a null value in my SQL database. There are no null values in my access database. I must have the syntax wrong.
[Code]....
In the development environment, in SSMSE > MyDatabase > Security > MyUser > Database role membership I have checked db_owner to allow me to build the database.
Now I am copying the database to the production environment I would like to lock the security down tightly. In the past (with classic ASP applications) I have only checked db_datawriter and db_datareader and, in Securables, checked Execute Grant on the stored procedures.
In Database > Securables I add my stored procedures and check Execute/Grant for each of them and click OK. When I return to the securables page the stored procedures are no longer listed.
I have noticed that nothing is listed in Effective Permissions and I think it should list Execute. If this is the problem, how do I add Execute to the Effective Permissions list?
In remote db, I can be able to connect ms sql db as localhost in my connection string like below,
<
add
name="ConnectionString"
connectionString="Data
Source=localhost;Initial Catalog=DBServer;Persist Security Info=True;User ID=sa;Password=*****"
providerName="System.Data.SqlClient"
/>
This is running in server and its working fine.
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 have only little knowledge in server.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI would like to access the database through the code behind in C#.
Looking how to do this in VWD specifically. Does it go in a onload function? onclick? How does it work specifically in ASP.NET 3.5?
Using:
Visual Web Developer 2008, ASP.NET 3.5 with SQL Server Express 2005.
i could write a query and i could debug forms using both sql server 2008 and visual studio 2008,but i could not connect to the sql server 2008 and test could not be succeded
View 2 RepliesMy asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..
View 7 RepliesFor a while I've used shopping cart software in classic ASP that could use Access database or MS SQL Server.
I am now using a asp.net shopping cart application by the same company
[URL]
However this program only supports MS SQL Server and not Access.
Would it be possible to export the SQL Server as an Access database (I've moved Access databases to MS SQL, so why not the other way)? Is there a way to support stored procedures in Access, and if not, any workarounds in ASP.net?
I have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI 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?
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 Replieshow to copy data from one SQL Server database to other SQL server database using two connection string...
View 4 RepliesI want access remote server data base for my asp.net application my connectin string is
<add
name ="Constr"
connectionString="Server=xxx.xxx.xx.xxx,xxxSQLEXPRESS;Database=ABC;Integrated
Security=True"/>
and Error is
Login failed for user ''. The user is not associated with a trusted SQL Server connection. there is not any user id and password for access data base i already tried Uid=sa;password=sa
While writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
I want to host my web site on an ISP hosting provider because my upload speed is not sufficient, however I want the database to be hosted locally.1) Is this possible?2) Does SQL server require good upload bandwidth?3) How much data (just an estimate) would it use to retrieve 20 rows of 10 columns?4) I realise this is not an ASP question so can you direct me to where I should post this if noone wants to answer it?
View 1 RepliesOn our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
View 2 RepliesI have built a website using Visual Studio 2008 asp.net 3.5, and data is retreive from a database that is made by SQL Server Management Studio 2008.
The question is: How can I upload the database files to the server? Can you give me a step by step description?!