daverk Posted July 26, 2000 Share Posted July 26, 2000 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8673 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now