Wiki Home

Odbc Phone


Namespace: B2B
Odbc Phone

Ever want to talk directly to an ODBC datasource? Well now you can. Just pick up the Odbc Phone and yac away.

It is basicaly a UI for VFP's Sql Connect() and SqlExec(). For kicks, I added Sql TablesOffsite link to http://www.news2news.com/vfp/?function=645
(), SqlColmns(), SqlGet/SetProp() and a bunch of COPY TO FOO TYPE this and that buttons.

The interface to the SqlProp functions is very raw. In a way, thats good because utilities that are too cooked often get in the way of function.


http://dev.personnelware.com/carl/pub/OdbcPhone.zip ( broken link )

Here is the Inno Setup script to install Odbc Phone.
#define SourceExePathName = "d:\dev\util\sql\OdbcPhone\exe\OdbcPhone.exe"
#define ExeName = "OdbcPhone.exe"
#define AppVersion GetFileVersion( SourceExePathName )
#define AppName "OdbcPhone"

[Setup]
AppName={#AppName}
AppVerName={#AppName} version {#AppVersion}
DefaultDirName={pf}\{#AppName}
OutputBaseFilename=OPSetup

[Tasks]
Name: desktopicon; Description: Create a &desktop icon; GroupDescription: Additional icons:

[Files]
Source: {#SourceExePathName}; DestDir: {app}

; Microsoft Visual FoxPro 9.0 Runtime Support Libraries
Source: C:\Program Files\Common Files\Microsoft Shared\VFP\gdiplus.dll; DestDir: {cf}\Microsoft Shared\VFP; Flags: sharedfile allowunsafefiles
Source: C:\Program Files\Common Files\Microsoft Shared\VFP\vfp9r.dll; DestDir: {cf}\Microsoft Shared\VFP; Flags: regserver sharedfile allowunsafefiles
Source: C:\Program Files\Common Files\Microsoft Shared\VFP\vfp9renu.dll; DestDir: {cf}\Microsoft Shared\VFP; Flags: sharedfile uninsneveruninstall allowunsafefiles
Source: C:\windows\System32\msvcr71.dll; DestDir: {sys}; Flags: uninsneveruninstall onlyifdoesntexist allowunsafefiles

; MDAC
Source: exe\mdac_typ.exe; DestDir: {tmp}; MinVersion: 4.1,4.0; OnlyBelowVersion: 0,5.0; Tasks: MDAC

[Icons]
Name: {group}\{#AppName}; Filename: {app}\{#ExeName}
Name: {group}\Uninstall {#AppName}; Filename: {uninstallexe}
Name: {userdesktop}\{#AppName}; Filename: {app}\{#ExeName}; Tasks: desktopicon


Another Util: http://dev.personnelware.com/carl/pub/SqlStats.zip ( broken link ) - shows how many rows and much space each table is taking up.

Maybe someday I will merge those two into one utility, then add the option of e-mailing the results.

Carl Karsten
Category Client / Server Category Third Party Tools
( Topic last updated: 2016.08.20 03:01:18 PM )