Quite big of an problem with DBX4 (d2007) (pretty urgent if I may add)

[Tommi Prami]

Hello,

I don't know the hear of this problem, but I try to get information
where we go wrong (or is this an bug).

Our software seems to work quite well with Firebird (with IB driver
trough GDS32.dll) and MsSql with select and insert statements.

Problem is that Now we would need desperately to use few Stored procs,
but it does not work at all.

Seemd that new DBX try to load DBs metadata to make some kind of cache
for stored procedures.

Seems that this is not working at all.

If I go to the DataExplorer->Interbase->IBCONNECTION->Modify Connection

give Datanase Name adn credentials and click Test Connection, gives
message "Test connection succeeded"

Then I click OK and try to see tables or any DB's structure, i'll get
error: No Metadata could be loaded for: InterBase

Same error to MsSQL with my coworker's computer.

We are bit lost here, any ideas????

-TP-

[Tommi Prami]

More info if helps:

Data source:
"dbExpress (dbExpress Provider)"

Connection string:

drivername=Interbase;database=c:\data\ecomond.fdb;rolename=RoleName;user_name=sysdba;
sqldialect=3;localecode=0000;blobsize=-1;commitretain=False;waitonlocks=True;interbase
transisolation=ReadCommited;trim char=False;hostname=127.0.0.1


Tried to load same DB trough BlackFishSQL, with same result (don't know
if I did set it up right tough)

-TP-

[Tommi Prami]

Yet more info:

Found message:

"Hi,

take a look into into the bin directory of D2007. There is a file
bin\dataexplore.exe.config that is corrupted on some installations. On my
system there was a file bin\dataexplore.exe.config.backup (or was it
.bak??)
After renaming the backup file the connections worked on my system.
Maybe it
is the same situation on your system.

Ciao,
Ralf
"

and this seemed to make wonders with MsSQL, but seems that Firebird does
not work, tables seems to open but stored procs don't.

Can someone confirm this:

We would need DBX4 driver for Firebird 1.5.x (& 2.x). Any suggestions,
which drivers are good and which not???

-TP-

[Martijn Tonies]

Post by Tommi Prami
We would need DBX4 driver for Firebird 1.5.x (& 2.x). Any suggestions,
which drivers are good and which not???

There is no DBX4 driver for Firebird yet.

There's a third party DBX3 driver that can be used om D2007, but I'm not
sure if this fixes your problem. Download a trial copy at www.upscene.com
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

[Tommi Prami]

Post by Martijn Tonies
There is no DBX4 driver for Firebird yet.
There's a third party DBX3 driver that can be used om D2007, but I'm not
sure if this fixes your problem. Download a trial copy at www.upscene.com

Thanks, we coudl try that, but as I say in other post, MsSQL did not
work with Stored procedure params...

We are in quite a trouble here...

Ofcource we could go around this by making generator code with some
table and some handler around that on MsSQL, our plan was to use stored
procs as generators in there, any ideas???

-TP-

[Thiago Borges]

Try this to FB:

http://www.tbosystems.bluehosting.com.br/dbx4/
--
Thiago Borges

Post by Martijn Tonies

Post by Tommi Prami
We would need DBX4 driver for Firebird 1.5.x (& 2.x). Any suggestions,
which drivers are good and which not???

There is no DBX4 driver for Firebird yet.
There's a third party DBX3 driver that can be used om D2007, but I'm not
sure if this fixes your problem. Download a trial copy at www.upscene.com

[Tommi Prami]

Seems that I was too optimistic before.

MsSQL don't work, can't read stored proc params...

Where to look next, we could live for some time if we could get MsSQL
server to work, with stored procs with DBX...

-TP-

Post by Tommi Prami
"Hi,
take a look into into the bin directory of D2007. There is a file
bin\dataexplore.exe.config that is corrupted on some installations. On my
system there was a file bin\dataexplore.exe.config.backup (or was it
..bak??)
After renaming the backup file the connections worked on my system.
Maybe it
is the same situation on your system.
Ciao,
Ralf
"
and this seemed to make wonders with MsSQL, but seems that Firebird does
not work, tables seems to open but stored procs don't.
We would need DBX4 driver for Firebird 1.5.x (& 2.x). Any suggestions,
which drivers are good and which not???
-TP-

[Bill Todd]

Post by Tommi Prami
If I go to the DataExplorer->Interbase->IBCONNECTION->Modify
Connection
give Datanase Name adn credentials and click Test Connection, gives
message "Test connection succeeded"
Then I click OK and try to see tables or any DB's structure, i'll get
error: No Metadata could be loaded for: InterBase

I followed your instructions using RAD Studio 2007, InterBase 2007 and
SQL Server Express 2005 and everything works perfectly. Note that the
InterBase driver is not tested against and does not officially support
Firebird.

Are you using RAD Studio 2007 or Delphi for Win32 2007?

Which version of Firebird are you using?

Which version of SQL Server are you using?

[Tommi Prami]

Post by Bill Todd
Are you using RAD Studio 2007 or Delphi for Win32 2007?

RAD studio 2007 with December update

Post by Bill Todd
Which version of Firebird are you using?

1.5.5.

Post by Bill Todd
Which version of SQL Server are you using?

Not sure... I'll try to find out.

But it was quite clear that there was some problems with installer(s)
because config fikles where completely wrong (there was other reports in
the net, and my and Co workers computer had totally different situation
I had 2 kb config with 4kb backup, and he has 1kb size in both files)

-TP-

[Bill Todd]

Post by Tommi Prami
RAD studio 2007 with December update

What is the build number in Help | Abount?

Post by Tommi Prami
But it was quite clear that there was some problems with installer(s)
because config fikles where completely wrong (there was other reports
in the net, and my and Co workers computer had totally different
situation I had 2 kb config with 4kb backup, and he has 1kb size in
both files)

By "fikles" do you mean files? If so, specifically what file(s) are you
talking about?

[Tommi Prami]

Post by Bill Todd
What is the build number in Help | Abount?

CodeGear™ Delphi® 2007 for Win32® R2 Version 11.0.2902.10471 Copyright ©
2007 CodeGear™. All Rights Reserved.

Post by Bill Todd

Post by Tommi Prami
But it was quite clear that there was some problems with installer(s)
because config fikles where completely wrong (there was other reports
in the net, and my and Co workers computer had totally different
situation I had 2 kb config with 4kb backup, and he has 1kb size in
both files)

By "fikles" do you mean files? If so, specifically what file(s) are you
talking about?

Files yes, sorry about typoos...

C:\Program Files\CodeGear\RAD Studio\5.0\bin\

DataExplore.exe.config
DataExplore.exe.config.backup (I think I renamed it as config and it
helped a lot)

-TP-

[Bill Todd]

CodeGear™ Delphi® 2007 for Win32® R2 Version 11.0.2902.10471
Copyright © 2007 CodeGear™. All Rights Reserved.

That is exactly the same version I am using. Since it works for me and
not for you my best guess is that there is something wrong with your
installation.