Viewing 15 posts - 1 through 15 (of 70 total)
That still wuld require install of all components on the client workstation. As the server mentioned is solely used for staging purposes during the early morning, then database activity is...
September 3, 2024 at 3:24 pm
Okay, let me rephrase the question: What in you opinion should then be installed on that client (the one RDP'ed against) to get a workable development setup?
And yes, in some...
September 3, 2024 at 8:53 am
Don't think so. The customer would be 100 miles around the block and the solution and data itself only existed on the customers server.
No other option than to set up...
September 3, 2024 at 7:34 am
I guess this indicates that if you change the account where the 2 services are running under AFTER getting them up or while installing, then the account that is used...
July 25, 2024 at 10:49 am
The error table contains 10.000 entries, but the following message seems the most relevant?:
Microsoft.SqlServer.DataWarehouse.Common.Security.MppSecurityException[107035:1]: 107035;Dms authorization failed due to [NOOT\nootbeheer] is not member of group [PdwDataMovementAccess]
at Microsoft.SqlServer.DataWarehouse.DataMovement.Common.Security.DMSSecurityProvider.RunSecurityRoutineGetNegotiateStream(Stream stream)
at Microsoft.SqlServer.DataWarehouse.DataMovement.Common.Security.DMSSecurityProvider.RunSecurityRoutine(Stream stream,...
July 25, 2024 at 10:26 am
The only thing in the logs is the message : Failed Stream Scan. The DSN is working when used in conjunction with a linked server query, so authentication should be...
July 24, 2024 at 6:10 pm
Pablo,
Following your syntax enabled me to define the external table.
But somehow is does not yet allow me to query it:
Msg 8680, Level 17, State 1, Line 1
Internal Query Processor Error:...
July 24, 2024 at 2:12 pm
The actual error message:
Msg 105082, Level 16, State 1, Line 21
105082;Generic ODBC error: NativeOdbcConnection.Open, error in OdbcConnectionCreate: SqlState: 08004, NativeError: 1, 'Error calling: SQLDriverConnect(this->_hdbc, NULL, (SQLWCHAR*)connectionString, SQL_NTS, NULL, 0, &cbConnStrOut,...
July 24, 2024 at 9:36 am
I have 3 seperate DSN's on the SQL server instance , each pointing to a database on the BBj server. So I would have expected to point to the DSN...
July 24, 2024 at 9:30 am
I guess you haven't met our customers. This is Microsoft Visual Basic 2010 and i'm stuck with it.
Passing the parameter is the cause of the delay it seems. Hard-coding provides...
April 25, 2024 at 6:14 am
I tried incorporating Jeffrey's suggestion, but the ancient VS version I have to work with keeps crashing in the expression builder.
So, I decided to use the hardcoded solution and some...
April 24, 2024 at 6:11 pm
@ Jeffrey Williams:
Yes, I responded to your input and I answered Jeff Moden in the same post.
Sorry, if that caused confusion.
All solutions work from a technical perspective, but passing the...
April 24, 2024 at 7:53 am
Well, hardcoding would be an option, though this would require some maintenance issues if customers decides to need to look further into the past.
The source system is an Axapta ERP...
April 23, 2024 at 7:56 am
select
a.dataareaid
,a.ledgerdimension
,a.inventtranspostingtype
,a.inventtransorigin
,a.voucher
,a.transdate
from
Inventtransposting a
where a.transdate >= ?
transdate is a datetime type
April 22, 2024 at 11:46 am
Adding the option (recompile) slows it down even further , taking an additional 30 seconds to start the dataflow
April 22, 2024 at 9:18 am
Viewing 15 posts - 1 through 15 (of 70 total)