View Full Version : retrieving data not working

04-02-2007, 07:28 PM
Hey guys, how to retrieve data from sql server 2000 using asp.net and adodb?

cmd = Server.CreateObject("ADODB.Command")

cmd.ActiveConnection = conn
If conn.errors.count = 0 Then

'Response.Write("Connected OK")
cmd.CommandText = "SELECT * FROM Test"

End If

04-02-2007, 09:36 PM
Are you using .net 2.0?
This is old Classic ASP here; .NET is a bit different, and 1.1 and 2.0 are different enough that the version is important.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum