{"id":68,"date":"2007-05-11T21:24:58","date_gmt":"2007-05-11T19:24:58","guid":{"rendered":" http:\/\/www.nsonic.de\/blog\/2007\/05\/adding-odbc-treiberdsn-with-delphi\/"},"modified":"2007-05-11T21:24:59","modified_gmt":"2007-05-11T19:24:59","slug":"adding-odbc-treiberdsn-with-delphi","status":"publish","type":"post","link":"https:\/\/www.nsonic.de\/blog\/2007\/05\/adding-odbc-treiberdsn-with-delphi\/","title":{"rendered":"Adding ODBC-Treiber\/DSN with Delphi"},"content":{"rendered":"

> Hi!
\n>
\n> I have to check if some ODBC data source is created and if not create
\n> it in runtime. APIs for this are in odbc32.dll but there seem to be no
\n> help nor function prototypes for that in Delphi. If someone know’s how
\n> to do that or have done it already I would appreciate to get some code
\n> example and odbc32.dll interface unit.
\n>
\n> tomi.<\/em><\/p>\n

A simple example I seem to re-post regularly is as follows.
\nFor non-MSAccess databases you only need a single call
\nand can ignore the DBQ stuff.<\/p>\n

For future reference, you’d probably get more\/better response
\nin the borland.public.delphi.database.desktop ng. to this sort
\nof question…<\/p>\n

HTH.<\/p>\n

[code lang=”delphi”](* NOTE: THIS EXAMPLE IS NOT COMPLETE !!! *)<\/p>\n

(*
\n This example shows one way to load the ODBC
\n Administrator’s DLL (ODBCCP32.DLL) to create
\n an Access MDB file and ODBC DSN pointing at
\n it. Note that it assumes current directory
\n for both the DLL and the MDB, but the DLL
\n will be found if in the WinSys directory which
\n is where it normally is anyway.<\/p>\n

Similar operation applies to most driver types,
\n with some modifications. eg: Access requires
\n the MDB file to exist so you can hook the DSN
\n to it.<\/p>\n

Note also that the “CREATE_DB” call is an Access
\n special (MS Jet Engine) and has other variants
\n like COMPACT_DB and REPAIR_DB. For a full list
\n see either the Jet Engine Programmers Guide or
\n the MSDN and search for “CREATE_DB”.<\/p>\n

This was originally written in MSVC6 and was
\n ported to Delphi 5.<\/p>\n

Full documentation can be found in the MSDN
\n at http:\/\/msdn.microsoft.com\/.
\n*)<\/p>\n

const
\n ODBC_ADD_DSN = 1; \/\/ Add data source
\n ODBC_CONFIG_DSN = 2; \/\/ Configure (edit) data source
\n ODBC_REMOVE_DSN = 3; \/\/ Remove data source
\n ODBC_ADD_SYS_DSN = 4; \/\/ add a system DSN
\n ODBC_CONFIG_SYS_DSN = 5; \/\/ Configure a system DSN
\n ODBC_REMOVE_SYS_DSN = 6; \/\/ remove a system DSN<\/p>\n

type
\n TSQLConfigDataSource = function( hwndParent: HWND;
\n fRequest: WORD;
\n lpszDriver: LPCSTR;
\n lpszAttributes: LPCSTR ) : BOOL; stdcall;<\/p>\n

procedure Form1.FormCreate(Sender: TObject);
\nvar
\n pFn: TSQLConfigDataSource;
\n hLib: LongWord;
\n strDriver: string;
\n strHome: string;
\n strAttr: string;
\n strFile: string;
\n fResult: BOOL;
\n ModName: array[0..MAX_PATH] of Char;
\n srInfo : TSearchRec;
\n hRegLib: HMODULE;
\nbegin
\n Windows.GetModuleFileName( HInstance, ModName, SizeOf(ModName) );
\n strHome := ModName;
\n while ( strHome[length(strHome)] <> ‘\\’ ) do
\n Delete( strHome, length(strHome), 1 );
\n strFile := strHome + ‘TestData.MDB’; \/\/ Test Access Rights (Axes =
\nAccess)
\n hLib := LoadLibrary( ‘ODBCCP32’ ); \/\/ load from default path
\n if( hLib <> NULL ) then
\n begin
\n @pFn := GetProcAddress( hLib, ‘SQLConfigDataSource’ );
\n if( @pFn <> nil ) then
\n begin
\n \/\/ force (re-)create DSN
\n strDriver := ‘Microsoft Access Driver (*.mdb)’;
\n strAttr := Format( ‘DSN=TestDSN’+#0+
\n ‘DBQ=%s’+#0+
\n ‘Exclusive=1’+#0+
\n ‘Description=Test Data’+#0+#0,
\n [strFile] );
\n fResult := pFn( 0, ODBC_ADD_SYS_DSN, @strDriver[1], @strAttr[1] );
\n if( fResult = false ) then ShowMessage( ‘Create DSN (Datasource)
\nfailed!’ );<\/p>\n

\/\/ test\/create MDB file associated with DSN
\n if( FindFirst( strFile, 0, srInfo ) <> 0 ) then
\n begin
\n strDriver := ‘Microsoft Access Driver (*.mdb)’;
\n strAttr := Format( ‘DSN=TestDSN’+#0+
\n ‘DBQ=%s’+#0+
\n ‘Exclusive=1’+#0+
\n ‘Description=Test Data’+#0+
\n ‘CREATE_DB=”%s”‘#0+#0,
\n [strFile,strFile] );
\n fResult := pFn( 0, ODBC_ADD_SYS_DSN, @strDriver[1], @strAttr[1] );
\n if( fResult = false ) then ShowMessage( ‘Create MDB (Database file)
\nfailed!’ );
\n end;
\n FindClose( srInfo );<\/p>\n

end;<\/p>\n

(* MASSIVE SNIP *)<\/p>\n

FreeLibrary( hLib );
\n end
\n else
\n begin
\n ShowMessage( ‘Unable to load ODBCCP32.DLL’ );
\n end;
\n StatusClockTimer.Enabled := true;
\nend;[\/code]<\/p>\n

[tags]Delphi, API, ODBC[\/tags]<\/p>\n","protected":false},"excerpt":{"rendered":"

> Hi! > > I have to check if some ODBC data source is created and if not create > it in runtime.…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[11],"tags":[84,75,85],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p71Tml-16","_links":{"self":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts\/68"}],"collection":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":0,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nsonic.de\/blog\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}