NT Deployment problem with System DSN ODBC

[dhstraayer]

I am trying to deploy a student grade status system on an NT server. I have developed and tested the system on my Win 98SE workstation, and I can do the access there. But when I try to deploy the project to the NT system, the Conn.Open fails.

I suspect it has to do with NT permissions, but I thought setting up the database as an ODBC system DSN dataset, and having my app logon with userid and password should get around it.

Debugging is very difficult, because every time install and test my app, even though I next un-install it, I seem to have to re-boot the server before I can re-install for my next test.

Can anybody recommend a next step?

Response.Write "A<br>"
Set Conn = New ADODB.Connection
Response.Write "b<br>"
Set Rs = New ADODB.Recordset
Response.Write "b.5<br>"
'this one works, but no further...
On Error GoTo CantOpen
Conn.Open "SpringStats", "MyUID", "MyPass"
If False Then
CantOpen:
Response.Write "open failure."
Exit Sub
End If
Response.Write "c<br>"
Rs.Open "Students", Conn
Rs.MoveFirst
Response.Write "d<br>"

[Jasper XAFAX]

Hi,

I have a question, what error message do you get. And if I am correct, this is visual basic but I do not recognise the Response command. If it is visual basic, do a search on the conn.open command in the VB section. There are a lot of forrums like these going on there and you might get more lucky there.

Greetz,

Jasper