Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help Setting up ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Need Help Setting up ODBC
Miscellaneous
Thread ID:
00078465
Message ID:
00078465
Views:
59
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
Next
Reply
Map
View

Click here to load this message in the networking platform