Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11020 > unrolled thread

OT: ODBC DBF remote connection

Started by"Jamal" <nospam@example.com>
First post2017-09-28 12:26 -0400
Last post2017-10-03 10:33 +0100
Articles 4 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  OT: ODBC DBF remote connection "Jamal" <nospam@example.com> - 2017-09-28 12:26 -0400
    Re: OT: ODBC DBF remote connection "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-09-29 06:03 +0200
      Re: ODBC DBF remote connection "Jamal" <noooospam@example.com> - 2017-09-29 12:32 -0400
    Re: OT: ODBC DBF remote connection Martin <Martin@spam.spam> - 2017-10-03 10:33 +0100

#11020 — OT: ODBC DBF remote connection

From"Jamal" <nospam@example.com>
Date2017-09-28 12:26 -0400
SubjectOT: ODBC DBF remote connection
Message-ID<oqj7rb$1607$1@gioia.aioe.org>
Hello,

I wrote a small test in C# to connect to a DBF file locally and this works 
fine and I can browse the file

Has anyone been able to connect "remotely" to a dbf file (on web server) via 
ODBC? What is the connection string?

Here my connection string:

"Driver={Microsoft dBase Driver (*.dbf)};Server=" + server + 
";SourceType=DBF;SourceDB = " + FilePath + ";Exclusive=No; 
NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;Trusted_Connection=True";

server is the website url.
FilePath is path relative to the server URL.


Jamal 

[toc] | [next] | [standalone]


#11021

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-09-29 06:03 +0200
Message-ID<f35v1fFtk3rU1@mid.individual.net>
In reply to#11020
Hi Jamal,

> I wrote a small test in C# to connect to a DBF file locally and this
> works fine and I can browse the file
> 
> Has anyone been able to connect "remotely" to a dbf file (on web
> server) via ODBC? What is the connection string?

this cannot work, since there is no server process for DBF files.

And with http, you cannot open a file read-write, and AFAIK you cannot
skip forward or backward in a file, and both is needed for browsing.

Wolfgang

-- 

[toc] | [prev] | [next] | [standalone]


#11022 — Re: ODBC DBF remote connection

From"Jamal" <noooospam@example.com>
Date2017-09-29 12:32 -0400
SubjectRe: ODBC DBF remote connection
Message-ID<oqlsih$njg$1@news.albasani.net>
In reply to#11021
Hi Wolfgang,

That's what I suspected.

Jamal

"Wolfgang Riedmann"  wrote in message 
news:f35v1fFtk3rU1@mid.individual.net...

Hi Jamal,

> I wrote a small test in C# to connect to a DBF file locally and this
> works fine and I can browse the file
>
> Has anyone been able to connect "remotely" to a dbf file (on web
> server) via ODBC? What is the connection string?

this cannot work, since there is no server process for DBF files.

And with http, you cannot open a file read-write, and AFAIK you cannot
skip forward or backward in a file, and both is needed for browsing.

Wolfgang

--  

[toc] | [prev] | [next] | [standalone]


#11027

FromMartin <Martin@spam.spam>
Date2017-10-03 10:33 +0100
Message-ID<oqvlhf$krg$1@dont-email.me>
In reply to#11020
Advantage Internet Server, part of Advantage Database Server

On 28/09/2017 17:26, Jamal wrote:
> Hello,
> 
> I wrote a small test in C# to connect to a DBF file locally and this 
> works fine and I can browse the file
> 
> Has anyone been able to connect "remotely" to a dbf file (on web server) 
> via ODBC? What is the connection string?
> 
> Here my connection string:
> 
> "Driver={Microsoft dBase Driver (*.dbf)};Server=" + server + 
> ";SourceType=DBF;SourceDB = " + FilePath + ";Exclusive=No; 
> NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;Trusted_Connection=True";
> 
> server is the website url.
> FilePath is path relative to the server URL.
> 
> 
> Jamal

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web