| Author |
 Topic  |
|
|
Dave.
Senior Member
USA
1037 Posts |
 Posted - 07 November 2003 : 21:54:08
|
I just Installed SQL Server 2000 on Windows Server 2003 (This is unrelated to Snitz, I'm trying to get another DB set up first). I honestly don't know wht I'm doing, so feel free to tell me I screwed it all up  .
I installed SQL Server, then Created a Database called "Users" and a Login Name called "Dave".
I set "Dave" to have permissions to use the Database. From there, I went to another Network computer and used this to connect to the DB Provider=SQLOLEDB;Data Source=SERVER;database=Users;uid=Dave;pwd=xxxxxxx;
SERVER is the computer Name of the Database Server.
I ran this SQL:
SELECT * FROM Dave Dave is a Table in the Database.
And get this error:
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'Dave'.
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 07 November 2003 : 22:41:52
|
Are you 100% certain there is a table called "Dave" in your database ?
If so who is the owner of the database ?
you may need to SELECT * FROM dbo.Dave if the login isn't the owner of the database. |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 07 November 2003 22:42:16 |
 |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 07 November 2003 : 22:49:55
|
Well, I just upgraded to SP3a, and re-created the DB, I guess I screwed with something when I was trying to set it up.
Thanks, I'm sure I'll have more questions ;)
<- Edit: Oh and uh, it works well now =) /> |
Edited by - Dave. on 07 November 2003 23:22:35 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 07 November 2003 : 23:28:16
|
| Great :) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 08 November 2003 : 00:15:37
|
Might as well post here rather than start a new topic...
Heres my Code:
<%
strSQL = "SELECT USER_NAME FROM " & strTablePrefix & "USERS;"
RS = Conn.Execute (strSQL)
%>
<select name="User">
<% Do until RS.EOF or RS.BOF %>
<option value="<%= RS("USER_NAME") %>"><%= RS("USER_NAME") %></option>
<% RS.MoveNext
Loop
%>
</select>
I get:
object doesn't support this property or method: 'EOF'
I don't understand, it always worked with Access.
I've removed the non-important stuff, connection, close connection etc.
Any help would be great, TIA =) |
Edited by - Dave. on 08 November 2003 00:16:45 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 08 November 2003 : 00:27:01
|
Try
Set RS = Conn.Execute (strSQL) |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 08 November 2003 : 00:36:38
|
| Perfect! Thanks a bunch Gremlin :) |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 08 November 2003 : 00:46:20
|
 |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
