Re: ODBC error - what does it mean?
Posted in 1997
Lance, The filename not found is probably the mdb file. Look in the registry to find out what your mdb file is. You can get alot more detail about your problem using a logging facillity. One called ODBC Spy comes with the Microsoft ODBC SDK, so you need only find it and turn it on. If you don't have a copy, or would like to use even more powerful ODBC development/support tools, please consider the Dr. DeeBee ODBC tools from my company, SYWARE. Details are available on our websit (http://www.syware.com). Best Regards, Frank Yacano Lance wrote: > > i am trying to access SOMETHING from JDBC using the JDBC-ODBC bridge(although > JDBC should have nothing to do with the ODBC errors i get). I successfully read > from an MS Access DB(this is on win95), however on NT531 i cannot do this > either on an Access DB or using the ODBC text file driver. > > The error i get is this: > > S1000 > [Microsoft][ODBC MIcrosoft Access 7.0 Driver] Not a valid file name > -1044 > > Does anyone know what any of this stuff means? I cant figure out what > "filename" it is referring to. The DB that the ODBC driver is pointing to is > C:\\lance\\testdb.mdb > > I used the same ODBC variables and setup on my NT351 machine that i used on my > win95 machine(the win95 machine worked). Software-wise, the win95 machine has > Access7.0 installed (w/ODBC driver) and my NT351 machine only has the ODBC > driver for Access7.0. (i dont need to install Access on NT do i?) > > thanks for any ideas. > Lance. -- .__________________________________________________________. | | | Frank Yacano | | frank@syware.com | | http://www.syware.com | | | | SYWARE, Inc. P.O. Box 91 Kendall, Cambridge, MA 02142 ( \\ / ) Phone:617-497-1375 Fax:617-497-8729 \\ \\ ( (|__________________________________________________________|) ) (((\\ \\) /,) / ) / //)) (\\\\\\\\ \\_/ / \\ \\_/ ///// \\ / \\ / \\ _/ \\_ /