RE: ADO Help - please!
From: Mark (Mark_at_discussions.microsoft.com)
Date: 11/24/04
- Previous message: Riley DeWiley: "Re: Question involving OLE DB, recursion, and filtered views"
- In reply to: Bryan Delgado: "ADO Help - please!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 22:29:04 -0800
http://www.able-consulting.com/ADO_Conn.htm
"Bryan Delgado" wrote:
> Trying to build an application using VB6 Pro, on a Win98 machine, for use on
> a target machine running Win2k.
>
> The application is supposed to access specific information created/managed
> by a seperate application which uses the FoxPro type of databases.
>
> Using/building the ADO.ConnectionString, how do I know what is installed on
> the machines where it will be located. Specifically, the properties for....
> Provider
> DSN
> Driver
>
> Meaning, I do not know how/where to find the list of parameters to use for
> the ConnectionString property, or what might be appropriate for the specific
> machine where this application would be installed.
>
> The application will run on a PC in a factory that is networked to another
> PC that has database related stuff (that would be the FoxPro style
> databases). In that scenario, I presume that the SERVER setting for the
> ConnectionString property is the \\nameofthecomputer and the Database is
> the name of the data file.
>
> The Microsoft documentation presumes a lot, and (for me) omits a heck of a
> lot. I have yet to understand what the options are to set the PROVIDER,
> DSN, DRIVER. The popular Microsoft examples for ConnectionString are...
> DRIVER = {SQL SERVER} (as opposed to what... MSDASQL ? )
> PROVIDER = ???
> DSN = Pubs (???). Also, is the DSN the same as specifying DATA SOURCE ???
>
> Needless to say, without dinking with the built-in ConnectionString Build &
> Test utilities, this would be even more of a shot in the dark.
>
> Any help would be appreciated.
>
>
> Thanks!
>
>
>
>
- Previous message: Riley DeWiley: "Re: Question involving OLE DB, recursion, and filtered views"
- In reply to: Bryan Delgado: "ADO Help - please!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
