November 19, 2008 01:20am pst

1. angelIII 70,974
2. capricorn1 40,760
3. LSMCons... 35,556
4. harfang 31,630
5. Dhaest 30,593
6. RobSamp... 23,300
7. DatabaseMX 21,600
8. Arthur_... 20,614
9. jpaulino 20,570
10. peter57r 18,229
11. emoreau 18,100
12. hielo 17,700
13. jimhorn 16,878
14. acperkins 16,498
15. ee_rlee 15,865
16. rorya 15,645
17. danaseaman 15,150
18. mlmcc 14,252
18. boag2000 14,252
20. frankytee 13,800
21. aiklamha 13,200
22. matthews... 11,400
23. MikeToole 11,000
24. saurabh726 10,900
25. zorvek 10,100

1. leonstryker 661,946
2. angelIII 316,140
3. emoreau 300,708
4. acperkins 265,782
5. Dhaest 196,907
6. TimCottee 160,377
7. Arthur_... 150,935
8. MYLim 135,434
9. Sethi 112,456
10. Dabas 109,981
11. mdougan 101,310
12. ryancys 97,083
13. leclairm 93,623
14. jimhorn 91,332
15. mlmcc 89,643
16. LSMCons... 88,068
17. capricorn1 85,338
18. aikimark 82,779
19. rockiroads 70,782
20. harfang 64,790
21. spongie 60,226
22. jkaios 46,350
23. Michael_D 42,870
24. CarlWarner 41,949
25. appari 39,853

07.13.2006 at 06:52AM PDT, ID: 21918082

	[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.4

Insert into statement using ado in vb6

Asked by abennett10 in VB Database Programming

Tags: insert, vb6, ado

Hello all!

When I try to insert values into sql in vb6 using ADO I receive an error of "Obeject variable or with block variable not set"

Here is my code :
Private Sub TestConnect_Click()
On Error GoTo bdconnection:
Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sql As String

conn.Open "Driver={SQL Server};Server=10.20.XX.XXX;Database=ENFN_Test;Uid=XX;Pwd=XX;"

sql = "Insert into Serialhistdetail VALUES('123456', '0', 'This is a Test', '100', '1')"

Set rst = Server.CreateObject("ADODB.Recordset")
rst.Open sql, conn
rst.MoveFirst
response.Write rst!serialhistdetail

conn.Close
Set conn = Nothing

bdconnection:
MsgBox ("No connection could be established")
End Sub

What am I doing wrong ?Start Free Trial

Keywords: Insert into statement using ado in vb6

	Title
1	ALL POSSIBLE PROPERTY AND/OR …
2	Could someone please help me out par…
3	VB6 + ADO + MYSQL
4	MSAccess RecordsetClone type Metho…
5	FASTER SPEED WITH SQL AND VB6 …
6	How do I access SqlServer 2005 w…

Loading Advertisement...

20081112-EE-VQP-43

Insert into statement using ado in vb6

Asked by abennett10 in VB Database Programming

Tags: insert, vb6, ado

About this solution