Please help, major deadline hanging over my head here...
Brand new NT Workstation, every ODBC driver I could possible need is listed in Control Panel-ODBC Icon-ODBC Drivers. I need to setup an ODBC connection between this workstation and my Database Server where my FoxPro 2.6 tables are stored.
What I need this connection for is xCase (Not Fox or VFP directly). I have to create a SQL Server model, and bring in my 100+ 2.6 tables through an ODBC connection. I've tried creating File DSN's, User DSN's, and System DSN's on both the server and workstation. I can get them created and see the ODBC Source from inside xCase, but it's not working. I keep getting this annoying error:
"No Tables Found in Source. STATE: S002 [M$][ODBC Fox Driver] The M$ Jet Database could not find object 'sysobjects'."
Plus, I dont see any place to specify a User Name and Password when I add a new ODBC connection. What am I doing wrong?
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos