December 4, 2008 10:55pm pst

1. DanielWilson 37,682
2. angelIII 11,002
3. mwvisa1 7,800
4. Ha11y 7,200
5. it-dept 6,100
6. chapmandew 5,672
7. BrandonG... 4,100
8. dbaduck 4,000
8. Binuth 4,000
10. matrixnz 3,200
11. frankytee 3,000
11. dqmq 3,000
11. Joe_Woo... 3,000
14. BillBach 2,750
15. grant300 2,500
15. b0lsc0tt 2,500
15. TechSoEasy 2,500
15. jimpen 2,500
19. tedbilly 2,250
20. leew 2,200
21. ScottPletc... 2,064
22. mlmcc 2,000
22. EugeneZ 2,000
22. matty1stop 2,000
22. devshb 2,000
22. ee_rlee 2,000
22. tntmax 2,000
22. wmeerza 2,000
22. Mr-Madc... 2,000
22. KICUSek 2,000
22. hielo 2,000
22. routinet 2,000
22. ushastry 2,000
22. drequinox 2,000
22. Yiogi 2,000
22. dchan17 2,000
22. IdoMillet 2,000
22. jjardine 2,000
22. ragi0017 2,000
22. JezWalters 2,000
22. Rrooter 2,000
22. graye 2,000

1. DanielWilson 56,557
2. angelIII 26,102
3. it-dept 8,100
4. mwvisa1 7,800
5. Ha11y 7,200
6. dqmq 6,000
7. chapmandew 5,672
8. TechSoEasy 4,500
8. jimpen 4,500
10. BrandonG... 4,100
11. appari 4,000
11. sujith80 4,000
11. Binuth 4,000
11. dbaduck 4,000
15. grant300 3,250
16. matrixnz 3,200
17. frankytee 3,000
17. acperkins 3,000
17. routinet 3,000
17. Joe_Woo... 3,000
17. xDJR1875 3,000
17. samtran0... 3,000
23. mlmcc 2,750
23. BillBach 2,750
25. ptjcb 2,500
25. b0lsc0tt 2,500

10.12.2008 at 02:24AM PDT, ID: 23807480

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

ADO Recordset Delete Error SQL 2005 DB

Asked by StevebData in SQL Server 2005, Visual Basic Programming, SQLBase

Tags: VB6, ADO, SQL 2005, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'WINXP-TEST-V\SQLEXPRESS' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored proce

Hi,

Any help on the following would be appreciated:

We have a VB6 application which uses ADO (MDAC 2.7) to connect to a SQL database. Recently we have been testing it using a SQL 2005 database and have come across a problem.

It would seem that if you try and issue a delete on a server side recordset you get the following error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'WINXP-TEST-V\SQLEXPRESS' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

If you change the recordset to client side it works fine. Unfortunately changing the recordsets to client side is not really an option as it is a huge program and to change all the cursors would be a massive task. An example of the code which creates this problem is shown below.

Has anyone got an idea why this does not work with a server side recordset?

Many ThanksStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

           
           
             Dim cConnstr As String
    Dim oConn As New ADODB.Connection
    Dim rs As New ADODB.Recordset
    Dim cSql As String
    
    cConnstr = "Driver=SQL Server;Server=WINXP-TEST-V\SQLEXPRESS;UID=sa;PWD=sa1234;database=aa_jobdata"
    Set oConn = New ADODB.Connection
    With oConn
        .CursorLocation = adUseServer
        .Mode = adModeShareDenyNone
        .Open cConnstr
    End With
    
    cSql = "Select * From Costtype WHere Code = 'ZZZZ'"
    
    With rs
        .CursorLocation = adUseServer
        
        .Open cSql, oConn, adOpenKeyset, adLockOptimistic, adCmdText
        
        .Delete
        
        .Close
    End With

           
         

Keywords: ADO Recordset Delete Error SQL 20…

	Title
1	Proper ado syntax for Open recordset
2	MSAccess RecordsetClone type Metho…
3	Exporting an ADODB recordset to an e…
4	ADO Recordset paging repeating some…
5	ADO.NET and ADO Recordsets
6	256 Char limit on ADO Recordset Field.

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628

ADO Recordset Delete Error SQL 2005 DB

Asked by StevebData in SQL Server 2005, Visual Basic Programming, SQLBase

Tags: VB6, ADO, SQL 2005, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'WINXP-TEST-V\SQLEXPRESS' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored proce

About this solution