odbc, how?

[daverk]

I have a FMP db on a mac volume on an NT 4.0 server. Am trying to connect to it from VB 5.0. (yeah, I know 6.0 is better, tell my boss). This is the code I'm using

ConnectMast= "ODBC;DSN=SemDB;database=S:MacSpaceSem Central DBStudent_Info"

Set MyWs1 = Workspaces(0)

Set StdntDB = MyWs1.OpenDatabase("", dbDriverNoPrompt, False, ConnectMast)

selstmt = "select * from Student_Info"

Set StdntRS = StdntDB.OpenRecordset(selstmt)

StdntRS.MoveLast

StdntRS.MoveFirst

The errors come on the 'Set StdntRS=...' line.

I get three errors. a -151 'connect failed' then a 0 'error has occurred while trying to gather a list of available tables' and finally the basic 3146 'odbc failed' error.

I haven't done much odbc (obviously). would appreciate any help I can get.

Dave