Viewing 15 posts - 361 through 375 (of 7,168 total)
tshad (1/30/2016)
In most of the samples on line that is not even mentioned. But I did see a few that...
January 30, 2016 at 1:14 pm
cortech (1/30/2016)
I opened 1433 in my SQL firewall - I created a SQL ODBC connection and it worked!!
I then ran Linked Tables Manager in Access and entered...
January 30, 2016 at 1:10 pm
TheSQLGuru (1/30/2016)
Such a shame too. But it wasn't fully baked when it was released and it has never gotten the attention it needed/deserved from the product team.
I could not agree...
January 30, 2016 at 1:05 pm
cortech (1/30/2016)
They double click the db2 file and then it opens in Access. Forms then run.
Trying non-intrusive changes first...keeping modifying Access (what Ed suggested) as a last resort...
From what I...
January 30, 2016 at 12:44 pm
I wanted to do this with only native SSIS objects but am not seeing a way. Pivot was promising but the source data does not have a grouping attribute, e.g....
January 30, 2016 at 10:41 am
cortech (1/30/2016)
1. What or whom is trying to use the Access database when you get this error? Is it a Windows service (something unattended) or an interactive user...
January 30, 2016 at 10:04 am
cortech (1/29/2016)
Using a DSN file[ODBC]
DRIVER=SQL Server
UID=username
PWD=password
DATABASE=db2
WSID=workstation
APP=Microsoft Data Access Components
SERVER=192.168.1.200\data
Trusted_Connection=Yes
The DSN settings makes no sense. If you are providing a username and password then why are you also saying it is...
January 30, 2016 at 9:23 am
Current shop has everything in one domain but issues admins a second Windows account for use in the prod region. I basically did the same as you, created a shortcut...
January 29, 2016 at 9:11 pm
If you can initiate the process from outside the database engine I would recommend SSIS or BCP. If using only T-SQL is a requirement I would recommend using the BULK...
January 29, 2016 at 2:52 pm
PHXHoward (1/29/2016)
Is the size of the variable specified in the prepare statement or somewhere else? Who needs to fix this? SQL developer or Middleware admins in Websphere?
Sounds like maybe...
January 29, 2016 at 2:27 pm
suryahanuma (1/29/2016)
January 29, 2016 at 1:38 pm
Thank you for trying to post test data and your desired output. Next time it would be ideal if you could provide the test data in the form of a...
January 29, 2016 at 1:01 pm
mbatchelor (1/29/2016)
.
.
.
I am only getting the current CUR_YR data. I need to extract seven years of...
January 29, 2016 at 12:55 pm
reformatted code:
SELECT REG_CONFIG.CUR_YR_DFLT,
SECTION_MASTER.YR_CDE,
CAST(ROUND(REG_CONFIG.CUR_YR_DFLT - 1, 0) AS INT) AS NEWYEAR,
...
January 29, 2016 at 12:53 pm
tshad (1/29/2016)
I tried to do...
January 29, 2016 at 12:50 pm
Viewing 15 posts - 361 through 375 (of 7,168 total)