Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amir
Starting Member
12 Posts |
 Posted - 2001-02-18 : 04:52:11
|
| I have this code<%@ Language=VBScript %><HTML><HEAD><META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"></HEAD><% set con = server.CreateObject("adodb.connection") con.Open "dsn=forum" sql = "SELECT * FROM users" set rs = server.CreateObject("adodb.recordset") rs.Open sql,con,3,3 Response.Write "<table border=1><TR>" do until rs.EOF Response.Write "<TD>"& rs.Fields(0)& "</td>" Response.Write "<td>"& rs.Fields(1) & "</td>" rs.MoveNext loop Response.Write "</table>"%></BODY></HTML>and when I run it I get 500 error with the title page cannot be displayed.is the connection alright? and what is the syntax for dsn-less for sql server version 7.0?thank's |
|
|
|
|
|
sql server connection problem