connecting MAS90 via ODBC in ACCESS 2000
Posted on 2004-04-20
I am having difficulties connecting to MAS90. I have installed the server ProvideX drivers along with the local providex drivers. ODBC is ALL new to me! My goal is to have tables from MAS90 linked to my Access db. The tables I want in particular are related to sales orders and product listings.
Currently my company set up a test enviroment for me. The network drive is \\m90test\m90\mas90\ For the life of me I have no clue what to use for the database directory. It suggests that the directory should contain a file called PROVIDEX.DDF. I do not have any directories that show that file. For the definition file I am using
\\m90test\m90\mas90\home and for my views dll I am using \\m90test\m90\mas90\home also.
when i click "test connection" it says "connection succeeded, datasource includes  tables".
Obviously I am using this incorrectly and I would like some guidance. Please help ASAP!!!