A client has an application written in Clipper (dbase IV) running on a Novell Netware and using Ext Systems Advantage XBase Server NLM. We are exploring the possibilities of rewriting a portion in OIWG.
I cannot seem to get a Connection Object to work. I want to 1) try and import the dbase data into oi tables. 2) try and connection directly
to the dbase files in share mode.
I am using a win95 machine and have read your knowledge base "Seeing 32-bit ODBC Data Sources in OI". I have tried numerous times to get a connection but have had no luck. I changed my odbc.ini and created a DataSource (dbase.dsn ), and System DSN (dbase) but still cannot get a connection. Am I missing a driver??
Any ideas??
How are you trying to make the connection? I use the ODBC admin tool from the Mirosoft SDK 2.10(16bit) and make a connection there first.I then use the C/S worspace and make the connection in OI.I have been able to get that to work using a dbase(IV) table that I created. I was able to use that dataset in an OI form. I hope this helps.
Bruce-
Although you can trick the system into thinking you have a 16-bit datasource by modifying your ODBC.INI, that doesn't guarantee that the 32-bit driver will work.
What is the error message that you get? You should be able to test the connection object by using the Query Tool in C/S workspace. It will try to connect to the database when you open it. does it complain about it being the wrong driver? Does it hang? Have you tried a 16-bit driver?
Tracy
Basicall I get nothing but I am using the MS 32bit odbc admin with win95.
Its almost as though I it can't find the driver file or any for that matter?!
PS. I have been out of my office for a wk aka the delay.