...

View Full Version : retrieving data not working



cgibie
04-02-2007, 08: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"
Response.Write(cmd.CommandText)

End If
]

nikkiH
04-02-2007, 10: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