Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server) -- Visual FoxPro : Using Win32 (WinAPI) Functions


	Using Win32 functions in Visual FoxPro	Image Gallery




functions • examples • solutions • updates • about •	links • articles •	login •


	Code examples:

	How to suspend or hibernate your system



	Printing text on the main VFP window



	Using IsChild() for testing ThisForm.ShowWindow property



	Creating a clipping region from the path selected into the device context of a form



	Disabling drawing in the VFP form



	Establishing connection using the SQLDriverConnect



	Exporting DLL icon resources as .ICO files



	How to block the PrintScreen key



	How to delete all print jobs for a printer



	How to extract frames from AVI files



	Obtaining MAC address through Address Resolution Protocol (ARP) request



	Reading security permissions for NTFS files and folders



	Accessing examples contained in this reference from a VFP application



	Configuring DEVMODE structure for a printer



	How to generate UUID values



	Retrieving statistics for the TCP protocol running on the local computer



	Running a regular FoxPro form while main VFP window is minimized



	Setting the date and time that a file was created



	Using custom Simple MapiSendMail class



	Adding an ODBC data source with the SQLConfigDataSource; use automatic or interactive mode



	Encapsulating access to the Windows Services in a class



	Retrieving the names of all sections in an initialization file



	Simple Window Viewer



	Using FillMemory



	Other pages with examples: << >> 1 2 3 4 5 6 7 [8] 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Using SQLBrowseConnect to connect to a data source through a number of iterative calls (SQL Server)

User rating: 0/10 (0 votes)

Rate this code sample:

More code examples Listed functions Add comment W32 Constants Translate this page

Before you begin:

Actually this code presents just a first step. Hopefully I will add more lines to it soon.


	Members area. Log in to view this example.

		Sign up for the Membership

User rating: 0/10 (0 votes)

Rate this code sample:

1378 bytes
Created: 2002-03-20 21:17:09
Modified: 2011-12-10 09:20:22
Visits in 7 days: 37

Listed functions:

SQLAllocEnv
SQLAllocHandle
SQLBrowseConnect
SQLFreeEnv
SQLFreeHandle

My comment:

Not all ODBC drivers support this functionality: SQL Server, Oracle, you name more.
Unsupported by ODBC drivers for MS Access, Visual FoxPro, MySQL.

Typical return from this function:
SERVER:Server={Server1,Server2,Server3};UID:Login ID=?;PWD:Password=?;*APP:AppName=?;*WSID:WorkStation ID=?

Word Index links for this example:

Spanish

Portuguese

German

French

Italian

FreeTranslation.com offers instant, free translations of text or web pages.


	User Contributed Notes:



	There are no notes on this subject.




functions • examples • solutions • updates • about •	links • articles •	login •




	Copyright © 2001-2013 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. Privacy policy

	Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.1.55-log), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice. Hosted by Korax Online Inc.

Last Topics Visited (107.20.7.65)
1.55 hrs.	Function: 'CeOidGetInfoEx' Function group: 'Remote Application Programming (RAPI)'



	Example: 'Using FillMemory'



1.77 hrs.	Function: 'WTSCloseServer' Function group: 'Terminal Services'



	Function: 'ClosePrinter'



	Function: 'DeleteDC'



4.64 hrs.	Example: 'How to print FoxPro form -- II'



4.85 hrs.	Function: 'StrFormatByteSize' Function group: 'String'



	Function: 'SetupOpenInfFile'



4.95 hrs.	Example: 'Using Common Controls: the Header Control'



4.96 hrs.	Example: 'Attaching menu to a top-level form'