[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== RE: ODBC DataSources and sharing files (OpenInsight Specific) ====
=== At 22 OCT 1997 04:23:21PM b cameron wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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??
</QUOTE>
----

=== At 24 OCT 1997 09:23AM DaveRevelation wrote:  ===

<QUOTE>       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.

                                 -DaveRevelation

</QUOTE>

----

=== At 27 OCT 1997 11:27AM Tracy Revelation wrote:  ===

<QUOTE>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

</QUOTE>

----

=== At 04 NOV 1997 12:06PM B Cameron wrote:  ===

<QUOTE>Basicall I get nothing but I am using the MS 32bit odbc admin with win95.

</QUOTE>

----

=== At 04 NOV 1997 12:09PM B Cameron wrote:  ===

<QUOTE>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.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2E72076FCBD1D5B78525653800700099|View this thread on the  forum...]]