What a coincidence! I used to program in VB up to about 2 years ago and I have been programming in Java but I still like VB. I recently discovered Firebird...
... [snip] ... Javier, Let me know when you have something to upload and I'll organise a permanent repository for it. As a temporary thing, you can use the...
Well this is pretty cool. I've just discovered IBFirebird and it looks very promising. If this group can produce some kind of knowledge base regarding using it...
... Lesson no. 1 - IB is IB, and Firebird is Firebird. They are increasingly different animals since July 2000. :-) heLen ... See you at the First European...
6
Klerman Gutierrez
klerman@...
May 11, 2003 2:51 pm
Hello... My first question to the list... How can one retrieve the result of a FireBird stored procedure from Access 2000 (VBA) code, using ADO & ODBC ?. ...
Just wanted to let you know that I will soon upload files of the DLL I was talking about. I also opened a project in sourceforge where I will post updates and...
I'm very interested in using Firebird as a back end db for a VB 6 front end application that is currently using an Access db with DAO. This is fine for ...
Create a new VB project. Add the Microsoft Data Grid Control (OLEDB) component. Add a command button. Type this code for the command button On_Click event: ...
Hi Javier, Thanks for this. I get an error on the click. "Your username and password are not defined. Ask you database administrator to set up a Firebird...
Hi Javier, Okay I got the dll and ran the VB sample. It won't connect to a .gdb file but works fine with the fdb file. I did ensure the paths were correct as...
Can you access your database through other means (isql,IBconsole)? What is the admin user name & password? Is the server listening to the standard port of...
Hi Javier, I can access db through IBconsole. Username SYSDBA password masterkey. I don't know what port the server is listening to and don't know how to check...
Weird, it´s not dependant of the extension. Is the database you are trying to connect in a Dialect 3 format? The API (IBPP) can only connect to Dialect 3...
Weird, it´s not dependant of the extension. Is the database you are trying to connect in a Dialect 3 format? The API (IBPP) can only connect to Dialect 3...
Got the new file. Command1 and Command3 both succeed but 2 & 4 both fail. The db I've been trying to connect to is the employee example and hasn't been altered...
Command 1 will just test the DLL. Command 2 will create the database c:\test.fdb. It will fail if it already exists and is being used. If it is not being used...
Javier it works! I had wrongly assumed that the employee sample db would be in the right dialect as it came but checking with IBConsole it was set to 1. So...
I'm glad that it worked. ... Yes, these are the only function for now. ... Yes, check out the VB example 2 (project2), it parsed the XML and loads a...
** 2003/05/24 ** Enhanced ExecuteDDL, now supports multiple SQL statements separated by colon (;). This method is really for executing SQL statements that...
... Javier, I haven't been following this (been in Germany for the Firebird conference) but the term you want is "DML" (Data Manipulation Language)....
... Thanks Helen for your feedback. I think I will rename the methods (I already have an ExecuteDML). What I really want is a method that will execute in a...
** 2003/05/29 ** Changed method names to reflect what they do. Old name New name ... ExecuteDDL ExecuteBatch ExecuteDML ExecuteSelect New methods ... ...
Hi (Doesn't look like there's much traffic here...) I just read about the embedded version of FireBird that is part of the 1.5 RC... but no information about...
... No. Embedded applications work by accessing API-like functions via internal macro calls. You use a specialised form of SQL (called ESQL) to code static...
I haven't tried the embedded dll for FireBird yet. Checkout my DLL project in sourceforge (http://fbdll4vb.sourceforge.net) it connects to a FireBird database...
Here's a version of fbdll4vb.dll using the fbembed.dll (https://sourceforge.net/project/showfiles.php? group_id=80875&release_id=164311) Please note that the...
