|
i write this code in my sqlserver does anybody know why it doesnt work. it has error in inner join. plz help 
UPDATE [servername1].[WebSite].[dbo].[Table_1] INNER JOIN [servername2].[website1].[dbo].[Table_2] ON Table_1.id = Table_2.id SET Table_1.name1 = [Table_1].[name2]
|
|
|
|
|
This is ASP.NET Forum , please post it in SQL Forum.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Do not Post SQL Questions here. I hope its the Last time you do this. You need to use a "from" like this
UPDATE [servername1].[WebSite].[dbo].[Table_1]
SET Table_1.name1 = [Table_1].[name2]
FROM [servername1].[WebSite].[dbo].[Table_1]
INNER JOIN [servername2].[website1].[dbo].[Table_2]
ON Table_1.id = Table_2.id
pre>
Check the your Statement from the Bolded and what ever follows
Hope this Helps
Vuyiswa Maseko
<div class="ForumSig">Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http:
vuyiswa@its.co.za
www.ITS.co.za
</div>
|
|
|
|
|
thanks for ur help, yes is it work now but if my tables be in diffrent server it has error i have problem when i have 2 server
and thats error is : Could not find server 'SPSERVER16' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
|
|
|
|
|
Check your Permissions in the Link Servers
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
i run this:
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO
and then run this:
EXEC sp_addlinkedsrvlogin spserver16, FALSE, sa, 1234
and its succses
and then run:
EXEC sp_tables_ex spserver16
GO
and it has this error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
|
|
|
|
|
Why don't you add a link Server manually not from T-SQL, supplies the credentials there , and in your Code you call the name of the Link server. Doing it in T-SQl you might encounter credentials Problem
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
both of them is equal, when i manually create linked server i has this problem too
|
|
|
|
|
Talk to your DBA about the Problem , remember again not everyone can create a Link server, sometimes you might Create a link server and not have permissions to access data on the Other side. Your have a permission Issue.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
heyyy finally i can solve the problem this form with 3 procdure:
///////
1.
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO
////////
2.
EXEC sp_addlinkedsrvlogin spserver16, FALSE,SADAFIT-9D6E926\administrator,sa ,1234
////////
3.
EXEC sp_tables_ex spserver16
GO
thanks for ur help Vuyiswa Maseko![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
am Glad you Solved it ,
Welcome 
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
Hi,
What's the attribute for showing a custom event of a usercontrol in properties window of Visual Studio?
Best wishes
|
|
|
|
|
Hi.
How can I handle Print event of Microsft ReportViewer control?
There is no explicit event for it, but I need to do something when print is fired.
Best wishes
|
|
|
|
|
Any Luck with this? I am trying to achieve the same thing.
|
|
|
|
|
Actually No!
Aware me if you find a way, please
Best wishes
|
|
|
|
|
Didnt really find how to do it in Native Report Viewer (MS Control) so far.
therefore, we are looking into third party controls.
So far, the reportViewer in ComponentOne
(Link) looks promising, and it supports SSRS. Also, AJAX is a prerequisite for this, which might be benifitial.
Another one was Telerik which allows you to monitor Client Side Events on server, but the only problem with that is, you have to design reports in their designer only, and thus, no support for ".rdl" files.
i am going to look further for about another week, if i find any solution, would definitely let you know.
Best
SD
|
|
|
|
|
|
Hi,
I am developing web app and:
I have a text box and a drop down list.If i enter a data into the text box i've to show the new entry in the dropdown list at that time itself.If i refresh the page i could see the change ,but is there any other way?
Help me.
|
|
|
|
|
Subin Alex wrote: .If i enter a data into the text box i've to show the new entry in the dropdown list at that time itself.If i refresh the page i could see the change ,but is there any other way?
I didn't get your question.
My understanding is that,You have one textbox and a dropdown list, You are entering some data in textbox and you want some data will be populated to dropdown list. Is it correct?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
|
Then why you are not using AJAX.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
is the data u enter go in database.
If yes Ajax is the way
If no use javascript or ne client side scripting.
|
|
|
|
|
What a strange reply. Why is AJAX required ? If the data was not going into a database, how would his question make sense ? How is AJAX different to javascript ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Not sure why no-one else was able to answer this. page_load fires before events, page_prerender fires after. Sounds like your events update the data source, but you load the data to your drop down list in page load, so the old data is loaded, then the data gets updated. Move your code to page_prerender so you load it AFTER you update it. AJAX has nothing to do with it.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
You should use AJAX to call data from your database. Javascript to trigger the call to a servlet that talks to your DB. If you don't have too much data it will be fast enough as is. If you havea large database and it's too slow, you can use an external DB indexing server of some sort. Example:
[^]
Good luck,
Dan - rastaquere AATT gmail DOOTT com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
