I am currently working on a 3.5 .NET C# Project. it uses an external program that takes an argument when I build and run it. The external program goes to index a structured or an unstructured source of data.
The C# project is a simple .dll that override some of the external program methods. At the initialization part, I do request a connection to my postgreSQL DB in order to get back a unique ID.
WARNING : Indexer and my DB have no link, Indexer can index folder with .xls files, or mysql DB. My PostgreSQL is here just to bring a unique ID and store some important informations
My problem is when I launch as an external program the DBConnector which is a 32 bit indexer, everything goes well.
Whereas when I launch the AlfrescoConnector which is a 64 bit indexer, I can't open my postgreSQL database.
I put the x86 & x64 type of connector but I don't know if the problem comes from there.
I'm working on Visual 2012, my debug is set to produce a x86 compatible program (changing it to "any CPU" or "x64" doesn't solve the problem)
The db object I use is DbClient which is a specific method that you won't find on the internet because it comes from the external program reference, but it works as a classic DbConnector.
My DbClient object looks like this :
- dbClient = {Sinequa.Common.DbClient}
- _CurrentTransaction = null
- ConnectionString = "Server=localhost;Port=5444;User Id=USERSAMPLE;Database=DBSAMPLE;Password=PWDSAMPLE;"
- DbCn = null
- DbCnSubSelect = null
- DbFactory = null
- DbIsolationLevel = Unspecified
- DefaultCommandBehavior = SequentialAccess
- Engine = Postgres
- Error = 0
- ErrorText = null
- LastRowAffected = 0
- LOBFetchSize = 0
- Provider = "Npgsql"
- RefreshCount = 0
- RefreshCurrent = 0
- Schema = null
The error comes when I do myDbClient.Open() with the Alfresco one
Any suggestions ? Need more details ? I'm ready to solve this painful error with you my fellows !
