Problem with database request 64bit Windows Server

[Sergio Lopes]

Hi,
I created a project that work nice and smooth in ProjectMaker.exe,
but, when goes to ZennoPoster.exe database connection don't work and don't show any message error...
I tried with OleDB and ODBC and both i get the same problem (work in ProjectMaker but don't in ZennoPoster.


Windows Server 2008 R2 Enterprise - Service Pack 1
System Type: 64-Bit
Intel(R) Core(TM) i7-3770

//I used 'C# Code' component i this way:
var table = project.Tables["Table1"];
var rowCount = ZennoPoster.Db.ExecuteQuery("SELECT * FROM TABLE1", null,
ZennoLab.InterfacesLibrary.Enums.Db.DbProvider.Odbc,
"Dsn=dnsDAtabase;uid=userXXX;pwd=passWordXXX",
ref table);
return rowCount;

//Also Tried this Way:
var rowCount = ZennoPoster.Db.ExecuteQuery("SELECT * FROM TABLE1", null,
ZennoLab.InterfacesLibrary.Enums.Db.DbProvider.OleDb,
"Provider=MSDAORA.1;Data Source=oracleDataSource;Persist Security Info=True;Password=passWordXXX;User ID=userXXX");
return rowCount;

I Also tried with database Request, but get the same problem...
ZennoPoster Log:

Type Time Message
14:26:43 Precompiling project before running
14:26:43 ZennoPoster Project C:\zenno\project.xmlz was completed successfully!

 

[Sergio Lopes]

The report:

 

[rostonix]

ProjectMaker is 32 bit software, ZennoPoster is 64 bit.
Bew build has standard actions to work with DB

 

[Sergio Lopes]

And when will be released?
I currently using 5.9.8.0

 

[rostonix]

 

[Sergio Lopes]

Still happens the same problem....

 

[rostonix]

Do you use database on your server? Or local one?

 

[Sergio Lopes]

On my server
ZennoPoster and Maker is installed in a virtual server.

 

[rostonix]

Works fine by my side with these settings

 

[Sergio Lopes]

It was a problem with my oracle client...
I had to:

1: Uninstall the oracle client completely;
2: Remove oracle from windows enviroment paths;
3: Install Oracle Client x64 - Administrator mode;
4: Install Oracle Client x86 - Administrator mode; (both in diferente folders...)

And then worked with OleDB

Thanks for you attention

 

[rostonix]