... I don't use InterBase 2007 or ADO or Excel but, as an educated guess, I'd suggest the Easysoft or Datadirect drivers that come with InterBase 2007. ... ...
Hi, I have the Interbase driver installed, and have been using it to run queries from Excel.. But I'd like to start running them in VBA for Excel.. But I can't...
check out http://www.connectionstrings.com/ Marc Miron. ... Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. [Non-text...
Hi.. I'm creating some spreadsheets that will live in a shared folder on a server. When a user opens the file from their client machine, I would like for the...
David, Your scheme will not work because once you open the spreadsheet on the client, all the macros , VBA etc run in the context of the CLIENT not the server....
David, Sorry for the delay,... If you had already started with ADO then you are halfway there already. All you need is to install any of the firebird ODBC...
Hey Anthony, Thanks a ton.. What I was originally hoping for, and I apologize if I didn't spell it out correctly, was to avoid installing local ODBC drivers on...
Im developing an aplication that need create users on the firebird server and grant access. I read that the only way to create or modify users is with the API,...
I'm using classic ASP and querying data from a Firebird 1.5.4 server using Firebird ODBC 2.0. Problem: When querying from Crystal Reports or from within...
Hi, My first thought is that you are using the CURRENCY VB datatype somewhere,and VB is not able to convert properly.The currency datatype is actually an 64...
Hi, Is it possible to connect into other database in one connection? In MSSQL sql you can connect to other database if you have link. Example I have EMPLOYEE...
... Firebird doesn't support schema namespaces, which allows you to perform cross-database queries. It does support multi-database transactions, allowing you...
How can I use the two phase commit using VB6? Right now I'm using ADODB.Connection, How can I apply or use this two phase commit? Thanks. Best Regards, Raf ......
... I can't help with that. I'm not an ADODB or VB user at all. But what determines it is a) whether ADODB supports multi-db transactions and b) whether your...
Hi, In a word NO. You need to open each database with its own connection. For you to use two phase commit protocol you need one of the databases to supply the...
Ok thanks a lot.... ... I can't help with that. I'm not an ADODB or VB user at all. But what determines it is a) whether ADODB supports multi-db transactions...
... [snip] Lin ... You need to add the Set keywordd, as in: Set myCommand.ActiveConnection = myConnection Since myConnection is an object, and ActiveConnection...
Can anyone help? I have written a Microsoft Access 2003 database that links into a Firebird database (used by a program called QuickEasy, developed by others...
... I think it's telling you the opposite. You have applied numbers for the PKs of your ad hoc records that you pulled out of your thumb, and then... ... ...
Dear HeLen Thank you for your response, but I could do with specifics on using the ODBC driver via Access/Visual Basic. When I get Access to link to Firebird...
Hello to all, I'm joining this group confident that some of you guys out there with more experience out there can help me out. I am running firebird on a...
