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:

	Creating a mailslot



	How to create MD-5 and SHA-1 hash values from a string



	How to print a bitmap file



	Retrieving configuration information for the specified server (Win2000/XP)



	Adding user-defined items to the Control Menu of VFP form (requires VFP9)



	Extensible Storage Engine class library



	Getting a bit more than the _CLIPTEXT offers



	How to retrieve network parameters for the local computer (including Host name, Domain name, and DNS Server)



	HOWTO: Use the Win32 API to Access File Dates and Times



	Pocket PC: custom RAPI class for operating with files and folders on mobile device



	Storing screen shot of a form to bitmap file



	The original LoadPicture() function in VFP returns valid handles to bitmaps, icons, cursors, and metafiles



	Time in milliseconds represented as string (e.g. 1 hour 24 min 36 sec)



	Retrieveing general information about the driver and data source associated with an ODBC connection



	Retrieving names for the registered clipboard formats



	Adding a background image to VFP report (VFP9, ReportListener)



	Storing content of the Clipboard to a bitmap file



	Using the IsWindowEnabled function



	Adding and deleting User Accounts



	Changing pitch and speed of a wave file



	Accessing Adobe Reader 7.0 main menu from VFP application



	Creating a window using CreateWindowEx function



	Form Magnifier



	Creating an Open dialog box to specify the drive, directory, and name of a file to open (Shell32 version)



	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: 76

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.22.127.92)
48.82 min.	Example: 'Printing text on the main VFP window'



48.88 min.	Function: 'CreateEnhMetaFile'



3.56 hrs.	Function: 'ReadConsole' Function group: 'Console'



13.48 hrs.	Example: 'How to save registry key including its subkeys and values to a file'



	Function: 'SetEnvironmentVariable'



13.71 hrs.	Function: 'CopyFileTransacted' Function group: 'File Management'



	Example: 'Uploading file to the FTP server using InternetWriteFile'



15.9 hrs.	Example: 'Storing registration key in the resources of an executable file'



15.91 hrs.	Example: 'Hiding mouse cursor'



22.67 hrs.	Example: 'How to save registry key including its subkeys and values to a file'