Viewing 15 posts - 16 through 30 (of 78 total)
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
Customer rebuild the .dsv and query expression within the model. Redeployed and the problem appeared to be solved.
April 5, 2024 at 12:30 pm
Thank you for this extensive reply. I think it does make a lot of sense.
Next friday I'm going to test through VPN to the clients server.
The really weird thing is ...
April 3, 2024 at 6:23 pm
Well, in this case customers are upgrading and expect old solutions to migrate seamlessly. We are trying to make the best of it 🙂
September 28, 2020 at 10:06 am
You are absolutely right. However, the missing DLL's are part of the MSFT 2008R2 operating system, which means that our predecessor never evaluated the chance future operating systems might work...
September 28, 2020 at 8:09 am
I took the following approach:
...
September 27, 2020 at 8:00 pm
Well sidebar or not, we live in a world crowded with legacy solutions inherited. My team inherited everthing developed based on SSIS from way back when. As much as I...
September 27, 2020 at 6:59 pm
I just checked. The rights on the specific package that is causing trouble is identical for all other packages for the user defined for SQL server Agent.
August 14, 2017 at 1:27 am
Viewing 15 posts - 16 through 30 (of 78 total)