Re: How connect two server in the same Query - Database Discussion Boards

Mr. Candyman13-Nov-07 2:29

13-Nov-07 2:29

Thanks a lot, but I thought the dataset could do it, why is the ReadXml method for then, if you can open the xml like a XmlDocument?

Re: Update DataBase from xml file

Adeel Chaudhry13-Nov-07 17:09

Adeel Chaudhry

13-Nov-07 17:09

Hi,

For knowing that in detail, you may find the following useful:

http://msdn2.microsoft.com/en-us/library/system.data.dataset.readxml.aspx[^]

http://msdn2.microsoft.com/en-us/library/aa325639(VS.71).aspx[^]

Regards,

Adeel

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

ADO Recordset, How to use the paging facility?

followait10-Nov-07 21:56

followait

10-Nov-07 21:56

I want to calculate every 10 records.

How connect two server in the same Query

Rami Said Abd Alhalim10-Nov-07 0:58

Rami Said Abd Alhalim

10-Nov-07 0:58

i used sql server 2005
1- create new query on server 1
2- add exec sp_addlinkedserver server2,'Sql Server'
3- add exec sp_addlinkedsrvlogin 'Server2','false','domain\user','user','password'

4- after that execute for query
5- this Error:(Msg 18452, Level 14, State 1, Line 11
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
)

Rami Abdalhalim

Re: How connect two server in the same Query

Paul Conrad10-Nov-07 3:20

Paul Conrad

10-Nov-07 3:20

Rami Said Abd Alhalim wrote:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Sounds like you need to make the other server, Server2, allow trusted connections. Have you configured it to allow other connections outside of it's machine?

"If you divide your text into sentences, it might be possible to understand what you are trying to say." - Guffa

Re: How connect two server in the same Query

Rami Said Abd Alhalim10-Nov-07 3:52

Rami Said Abd Alhalim

10-Nov-07 3:52

how can that?

Re: How connect two server in the same Query

Paul Conrad10-Nov-07 3:59

Paul Conrad

10-Nov-07 3:59

Go into the Surface Area Configuration Manager and tweak with it.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: How connect two server in the same Query

Marek Grzenkowicz11-Nov-07 20:27

Marek Grzenkowicz

11-Nov-07 20:27

Isn't server2 configured to use only Windows Authentication?

How to get 5 th record of the table using stored procedure...

Sasmi9-Nov-07 21:01

Sasmi

9-Nov-07 21:01

Dear Bro,

I want to fetch 5 the record of the table or query using Stored Procedure it is possible but i dont know how? please help me.

I want to fetch the record of Employee whose Payment is Highest and on 5 th rank using Stored Procedure.

Using SQL 2000 database

Thanks in advanced Rose | [Rose]

Sasmi

Re: How to get 5 th record of the table using stored procedure...

pmarfleet9-Nov-07 22:11

pmarfleet

9-Nov-07 22:11

Use the TOP predicate. Select the TOP 1 record which is not in the set of TOP 4 records.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: How to get 5 th record of the table using stored procedure...

Vipin.d10-Nov-07 4:55

Vipin.d

10-Nov-07 4:55

try this,

<br />
  declare @n int<br />
 SET @n=5<br />
SELECT DISTINCT (a.salary) FROM Table1 a <br />
WHERE @n=(SELECT COUNT(DISTINCT(b.salary)) FROM Table1 b WHERE a.salary<=b.slaray) <br />

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Hi bro i dont know how to do this query..

Sasmi9-Nov-07 20:57

Sasmi

9-Nov-07 20:57

I want to create an query in which i want to show the data out put as show below is it possible?
Database: Northwind
Table : Products
ProductId CategoryID
1 1
1 2
1 3

Output should be coma delimited as shown below.
ProductID CategoryID
1 1,2,3

Thanks in advanced Rose | [Rose]

Sasmi

Re: Hi bro i dont know how to do this query..

pmarfleet9-Nov-07 22:08

pmarfleet

9-Nov-07 22:08

Did you search Google[^]?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Hi bro i dont know how to do this query..

Xmen Real 11-Nov-07 20:39

Xmen Real

11-Nov-07 20:39

try JOIN function

Becoming Programmer...

Re: Hi bro i dont know how to do this query..

Marek Grzenkowicz11-Nov-07 21:17

Marek Grzenkowicz

11-Nov-07 21:17

This[^] can help, if you are using SQL Server 2005.

And next time please give your message a more descriptive subject.

Select and update selected data

Vipin.d9-Nov-07 20:18

Vipin.d

9-Nov-07 20:18

Hi,
I am using MSSQL 2000 and MS.NET 2.0

I have some doubt.My requirment is I need to select some data (ie status=3) from webserver's database and insert it into my local machine's Database.Table structure in both server are same.And at the same time i need to update the status of the selected rows to 4.

Now my idea is, a class contain two functions.One is for DownloadWeb and other is InsertLocal.
The DownloadWeb return a dataset(selected data) and InsertLocal insert the the table in dataset to local database.

My doubt is where i place "update status=4" query..
I write one sp in my webserver like

<br />
  BEGIN TRANSACTION<br />
      BEGIN<br />
         SELECT  data<br />
      END<br />
      BEGIN<br />
         UPDATE status=4<br />
      END<br />
     IF @@ERROR <> 0<br />
        BEGIN<br />
             -- Rollback the transaction<br />
         ROLLBACK  <br />
         RETURN -1<br />
       END<br />
COMMIT<br />

or any other idea????

Be very grateful for any advice.

Regards

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same
CrazySanker

Re: Select and update selected data

John-ph9-Nov-07 22:06

John-ph

9-Nov-07 22:06

what if the Sql Transaction (Insert) to Local Server fails? You can't Rollback the Update transaction happened on the other SQLServer.

what about this alternative(using ADO.NET SQLTransaction object)?

1. DownLoadWeb (select data from Server1)
2. InsertLocal (Insert data to Server2) - SQLTransaction object
3. UpdateStatus (update Status in Server1)

Use a SQLTransaction object for the Insert operation. make sure (2) and (3) are successfull and then commit the transaction otherwise Rollback.

Regards
- J O H N -

Re: Select and update selected data

Vipin.d10-Nov-07 3:44

Vipin.d

10-Nov-07 3:44

Thank you so much.. let me check the SQLTransaction object..

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Help - "Could not find installable ISAM"

oceanexplorer9-Nov-07 7:39

oceanexplorer

9-Nov-07 7:39

Hi,

I'm currently working on a project to read in an excel file and display it using a DataGrid.

However every time I try to open the connection I get the error - Could not find installable ISAM. I have Office 2007 installed and have also installed the Access Data Acces components.

This is the current code that opens the connection

OleDbConnection cnCSV = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\test.xlsx;Extended Properties=Excel 12.0;HDR=NO");
cnCSV.Open();

Does anyone know a work around for the ISAM? Do I need to re-install MDAC?

Paul

Cross Post

pmarfleet9-Nov-07 9:38

pmarfleet

9-Nov-07 9:38

Please don't cross post.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Cross Post

oceanexplorer10-Nov-07 7:33

oceanexplorer

10-Nov-07 7:33

I didn't. This particular issue falls under two topics, it may well be an ADO.NET issue, or a C Sharp issue, so hence my post in both forums.

Paul

Re: Cross Post

pmarfleet10-Nov-07 7:39

pmarfleet

10-Nov-07 7:39

oceanexplorer wrote:
I didn't. This particular issue falls under two topics, it may well be an ADO.NET issue, or a C Sharp issue, so hence my post in both forums.

Yes you did. You posted the same question in 2 forums. This is called cross-posting and is frowned upon because it makes it difficult for people to collaborate on a solution.

In future, try and be more considerate. Choose the most appropriate forum for your question and post there only.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Guaranteed stumper...truncating last 3 characters on a string...

new_phoenix9-Nov-07 7:14

new_phoenix

9-Nov-07 7:14

Hi, guys. I have a string that represents a path to a file. However, the file is the wrong type and needs to be converted to a different file type. I need the file to be a .CSV file instead of a .XLS file type.

If I had a string representing the entire path to the file, including the .XLS, how would I truncate the .XLS and replace it with .CSV?

Confused | :confused:

-- modified at 14:19 Friday 9th November, 2007

Re: Guaranteed stumper...truncating last 3 characters on a string...

andyharman9-Nov-07 8:40

andyharman

9-Nov-07 8:40

select reverse(substring(reverse('C://hello/world.txt'), 5, 100))

Re: Guaranteed stumper...truncating last 3 characters on a string...

Pete O'Hanlon9-Nov-07 10:52

Pete O'Hanlon

9-Nov-07 10:52

So - not stumped by the guaranteed stumper then.;)

Deja View - the feeling that you've seen this post before.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.