Modify Command-Table-SQL not work in x64 Runtime

[Former Member]

Hello,

last week I tried the CRRuntime x64 SP3 for our project.

But I got a error message in

boDatabaseController.SetTableLocation(boCommandTable, boNewCommandTable)

"Failed to load database information."

I set the correct logon information, in 32 bit Runtime it works since 1 year.

I used this document as reference: http://scn.sap.com/docs/DOC-6014

My Report has just one Table (CommandTable) which I need to modify before printing.

Long time ago (Before .Net) we used to change teh whole SQL Command of the Report, but this dosn't work since .NET, but we could handle this with a Command Table.

Hope somebody can help. So long I use 32 Bit

Thank you

Steven

[former_member183750 · Accepted solution]

You don't mention what database you are using and what connection type(?). You also do not say if this works if you do not try to change the command table. In general when using 64 bit runtime, you need a 64 bit database client and if connecting via ODBC, the ODBC datasource must be 64 bit.

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

sorry about that.

I using MS SQL. I connecting via OLE DB a(native client 64 bit is installed). I change the commandtable command and using settablelocation.

I think I have a same problem as Peter Urban, just he use ODBC.

[former_member183750 · Accepted solution]

Yeah, I just noticed the similarity to Peter's thread also. Does make one wonder... Is your app win or web? And sorry - have to ask the same things I asked Peter; are you able to connect to the original datasource in the 64 bit app?

- Ludek

[Former Member · Accepted solution]

Hi Ludek,

my Application is Win. I can connect to the original Database with this Application, there is no problem.

Don Williams posted yesterday a solution (but this Message is lost...) to use databaseController.ReplaceConnection, but this still not works...

Steven

[Former Member]

Ok,

I am sure that I have same Problem as Peter Urban, so I will follow his thread.

I hope it is fast solved.

Regards

Steven