ODBC tutorial supplement for use with FireBird

[tomkane]

While working through Iczellion's tutorials, I felt fortunate to discover a supplemental tutorial on ODBC access between Masm and SQL databases. I have had prior experience working with ODBC connectivity and can also appreciate the power of a good SQL database system.

When I first reviewed Iczellion's ODBC tutorial I was convinced that it was just what the doctor ordered for helping me set up a MASM program to work through ODBC. But I faced a problem in that Iczellion's ODBC tutorial relied on MS Access, which I don't have installed on my machine.

I was aware of free SQL systems like MySQL, so I began my research. I discovered FireBird, which is available as a free download. An added bonus for FireBird is that is that it is also freely distributable, and that includes along with commercial products.

So I downloaded it and installed it on my system and rewrote the tutorial to work with it.

I have greatly appreciated all that I have learned from Iczellion. I hope this is a little bit of a payback. Please feel free to give any feedback or suggestions. Thanks.

Tom Kane

[attachment deleted by admin]

[PBrennick]

Ah, which tutorial are you referring to?  I have a JAVA applet that allows me to search all 35 html files.  It reports no hits for ODBC or MS ACCESS.

Paul

[jdoe]

Ah, which tutorial are you referring to?  I have a JAVA applet that allows me to search all 35 html files.  It reports no hits for ODBC or MS ACCESS.

Paul

Must be this one in the "ODBC Tutorials" section - http://win32assembly.online.fr/tutorials.html

[tomkane]

That's right. There were more tutorials than the 35 numbered tutes.

[PBrennick]

jdoe,
I will look at these other tutorials.  Thank you for pointing this out.

Paul

[Mark Jones]

Hello Tom, thanks for making the tutorial, excellent stuff... but I have yet to get it working. My Windows XP has no "ODBC" in the control panel, however Run --> odbcad32.exe starts the ODBC administrator. I tried setting up all types of Firebird server, all of which complained of no existing .fdb file (and wouldn't create one.) Also, the tut's close button seems to be malfunctioning (however the File --> Close menu works.) To fix the close button behavior, you need to add a WM_CLOSE handler to the DlgProc, something like:

Code Select Expand


    .elseif uMsg==WM_CLOSE
        ; perform cleanup routines here...
        invoke ExitProcess,0


Also here is a quick makeit.bat:

Code Select Expand


@echo off
ml /c /coff /Cp ODBCTest_tab.asm
if errorlevel 1 pause
rc ODBCTest_tab.rc
if errorlevel 1 pause
link /SUBSYSTEM:WINDOWS /LIBPATH:\masm32\lib ODBCTest_tab.obj ODBCTest_tab.res
if errorlevel 1 pause

del *.obj
del *.res


[tomkane]

Mark, thanks for the feedback. Yes, I noticed the funny thing about the close button not working, but I zoomed on to other of the myriad areas I want to learn about. I'll try your suggestion. It looks right and I feel dumb for not catching it myself. Also, I did not need the ODBC control panel applet as it was already there from previous incarnations (I guess). Anyway, the FireBird website has one, which I have attached here. Let me know if you are still having problems.

Tom

P.S. Whoops! It's too big to upload. It's up there, though, under the filename:

>>>   control panel applet - fbmgr-setup.exe  <<<

[tomkane]

It just dawned on me that the name is "fbmgr-setup.exe". The "control panel applet" part is what I tacked on in my directory to give added mnemonic value. Sorry.

[BasilYercin]

hi all !

a nice link that provide connection strings syntax for a lot's of odbc source...

http://www.connectionstrings.com/    :U

it may help whose who plan to play with the odbc tutorial.