Re: Novice ODBC Remote Views access Goldmine (dBase) tables
- From: "Dan Freeman" <spam@xxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 09:58:17 -0700
WARNING! Opening a dBase file directly from Foxpro can be hazardous. If the
dBase dbf has a memo field, it will be converted to Foxpro format and
unreadable by dBase (or in this case, Goldmine). If it uses MDX indexes,
they will be converted to Foxpro CDX format, again unreadable by
dBase/Goldmine.
Dan
Anders wrote:
> That connection string seems to use the ODBC driver 'dBase Files'. If
> Omnis data tables are the same as dBase files you would be able to
> open them straightaway in FoxPro without an ODBC driver.
>
> -Anders
>
> Den 05-07-26 01.50, i artikeln
> hfuae1ho8fuqt9e1mh504a07c71sl6srvk@xxxxxxx, skrev "JJ"
> <jjyg@xxxxxxxxxxxx>:
>
>> This is new to me & over my head.
>>
>> I think I need to study some ODBC examples, the Connection Designer,
>> etc.
>>
>> I created a database
>>
>> C:\FoxGold\foxgold.DBC
>>
>> One of the GoldMine tables I want to work with is
>>
>> C:\Program Files\GoldMine\Common\Contact1.DBF
>>
>> I am a throw back to older versions of FoxPro and have not kept pace.
>> I'm comfortable in the command window with xBase syntax, but I think
>> the best approach here is to learn how to use some wizards like the
>> Connection Designer.
>>
>> I found an old UseNet post for older version of GoldMine and am not
>> even sure if it applies, but here is some of it (which is worse than
>> Greek to me):
>>
>> *********************************************
>> nHandle = sqlstringconnect([DSN=dBASE
>>
Files;DBQ=]+[G:\GM40\COMMON]+[;DefaultDir=]+[G:\GM40\COMMON]+[;DriverId=53
3;
>> ;MaxBufferSize=2048;PageTimeout=5;])
>>
>> Once you have done this you can use SQLExec() function with this
>> handle to extract any Information that you require.
>> *********************************************
>>
>>>> a File, User or System DSN...
>>
>> Ideally I would want the connection so I can access any GoldMine /
>> dBase table I want in the GoldMine path
>>
>> C:\Program Files\GoldMine\...
>>
>> e.g.
>>
>> C:\Program Files\GoldMine\Common\Contact1.DBF
>>
>> and be able to browse just like it was a FoxPro table with the
>> ability to edit fields, run some macro's I've written to cut & paste
>> info from web pages in to the proper field of a contact.
>>
>> Leemi@xxxxxxxxxxxxxxxxxxxx (Lee Mitchell) wrote:
>>
>>> Hi John:
>>>
>>> Basically, you need a Goldmine compatible (or Dbase) ODBC driver
>>> and create a File, User or System DSN. They use the View Designer
>>> or write VFP code to create an updatable remote view using the
>>> above mentioned ODBC driver. Once you have an updateable remote
>>> view, you can use the REPLACE command to edit data or perform a
>>> bulk update of records.
>>>
>>>
>>> See the VFP Help topics for Remote View, Remote View Designer and
>>> REPALCE command.
>>>
>>> Here are some articles that may be useful.
>>>
>>> http://support.microsoft.com/default.aspx?scid=KB;EN-US;138094
>>> http://support.microsoft.com/default.aspx?scid=KB;EN-US;137944
>>> http://support.microsoft.com/default.aspx?scid=KB;EN-US;164387
>>>
>>> I hope this helps.
>>>
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>> Sincerely,
>>> Microsoft FoxPro Technical Support
>>> Lee Mitchell
>>>
>>> *-- VFP9 HAS ARRIVED!! --*
>>> Read about all the new features of VFP9 here:
>>> http://msdn.microsoft.com/vfoxpro/
>>>
>>> *--Purchase VFP 9.0 here:
>>>
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
>>> 69-4500-8bf2-3f06689f4ab3&type=ovr
>>>
>>> Keep an eye on the product lifecycle for Visual FoxPro here:
>>> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
>>> - VFP5 Mainstream Support retired June 30th, 2003
>>> - VFP6 Mainstream Support retired Sept. 30th, 2003
>>>
>>>
>>>> Novice ODBC Remote Views access Goldmine (dBase) tables
>>>
>>>> New to ODBC, Remote Views, and want to access GoldMine data
>>>> (dBase... dBase IV? [memo file incompatibility]) with Visual
>>>> FoxPro 6 command window, browse, run macros against browse windows
>>>> from keyboard.
>>>
>>>> Have book marked some websites, and will study help file.
>>>
>>> Where to start? What's the basic deal I need to understand. Need to
>>>> view and in some cases edit data interactively or through small
>>>> program code for batch replace etc.
>>>
>>>> Goldmine installed BDE (Borland Database Engine).
>>>
>>>
>>>> John "J.J." Jackson
>>>
>>
>> John "J.J." Jackson
.
- Follow-Ups:
- References:
- Prev by Date: Re: Is it just me?
- Next by Date: Re: Novice ODBC Remote Views access Goldmine (dBase) tables
- Previous by thread: SV: Novice ODBC Remote Views access Goldmine (dBase) tables
- Next by thread: SV: Novice ODBC Remote Views access Goldmine (dBase) tables
- Index(es):
Relevant Pages
|
