Database

Re: Get following Error when Loading the SSIS Package using C# Code

11-Jul-17 1:28

If you're referencing a 32-bit assembly, you don't have a choice; you have to target x86.

A 64-bit OS won't have any problems running a 32-bit application.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

indian14312-Jul-17 7:38

indian143

12-Jul-17 7:38

Thanks my friend

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

I am not able to view my data in my oracle forms 6i database is 11g

Member 128515166-Jul-17 0:59

Member 12851516

6-Jul-17 0:59

i wish to actually view my data in a oracle form developed on 6i based on date parameter but if i try to work on my oracle forms it dosent give me data acoordingly here is the query whcih i am using

SELECT e."Deal_No" deal_no, e."Remarks" Counterparty, m."MaturityDate" Maturity_Date, m."PriRedem" Principal, 


(m."MaturityDate" - To_date) Days_to_Mat

FROM MM_T_BORROWING e, MM_T_BORROWING_PM_DETAIL m

Where e."DeskCode" in ('10','11','12','13') and e."Value_Date" <= to_date and e."Maturity_Date" > to_date and e."Status" not in ('C', 'D', 'Z', '0','X') 
and e."Deal_No" = m."Deal_No" and "PriRedem" > '0' and m."MaturityDate" > to_date ;

Re: I am not able to view my data in my oracle forms 6i database is 11g

CHill606-Jul-17 1:35

CHill60

6-Jul-17 1:35

And if you just run that query do you get any data returned?

Re: I am not able to view my data in my oracle forms 6i database is 11g

ChuckIsThatYou26-Jul-17 18:59

ChuckIsThatYou

26-Jul-17 18:59

You probably are not getting any results because you have not defined the parameter to pass to the to_date function.

to_date (string_to_convert_to_date, [optional parameters if required]).

If you are trying to pull from "today" then use to_date(sysdate)

ms access 2016 database

Mayank Kumar2-Jul-17 21:22

2-Jul-17 21:22

how can we connect to ms access 2016 using oledb ..what would be the connection string for that

Richard MacCutchan2-Jul-17 22:03

ConnectionStrings.com - Forgot that connection string? Get it here![^].

2-Jul-17 22:03

Mayank Kumar2-Jul-17 22:25

2-Jul-17 22:25

i went through the ink that u provided but if it comes to connect access 2016 its not working

Mayank Kumar2-Jul-17 22:25

2-Jul-17 22:25

m trying to import excel 2016 file to gridview in vb 2005 and i have installed access database of 2016 while importing m getting the oledb exception called couldn't find install able isam ...in this wazy the problem is only with connection string ,hence what connection string should be used when connecting with acces 2016 in order to import excell 2016 file..i have gone through ur suhhested link but dint work out for access 2016

Richard MacCutchan2-Jul-17 22:35

2-Jul-17 22:35

That is a bit different from your original question. You need to install the ACE driver for oledb. See Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^].

Mayank Kumar2-Jul-17 22:41

2-Jul-17 22:41

the link that you provided is not downlowding the driver

Richard MacCutchan2-Jul-17 22:44

2-Jul-17 22:44

Yes it will, you just need to click your mouse to the left of the item you want to download. If it still does not work, then you need to complain to Microsoft.

jschell5-Jul-17 6:40

5-Jul-17 6:40

To be fair, I tried that link myself, and it failed for me, presumably in the same way as for the OP. (I was wondering how it could be so hard.)

Turns out there is a hidden check box or button just to the left of the files.

Richard MacCutchan5-Jul-17 7:51

5-Jul-17 7:51

Yes it took me a while to figure out the how to do it. But it is Microsoft of course.

Mayank Kumar2-Jul-17 22:46

2-Jul-17 22:46

by clicking on the link that u provided m taking to the download page and when i click on download then it takes me to file selection option but m not able to slelec any file there

jschell5-Jul-17 6:43

5-Jul-17 6:43

I just tried it. It didn't seem to work for me either.

It is a really weird screen.

If you click just to the left of the two files listed a 'box' will appear. It is just white space until you click on it. The box will disappear once your mouse moves away. However once selected the text box to the right will say that you have selected a file (or two) and the 'Next' button at the bottom of the screen will be highlighted.

Richard Deeming5-Jul-17 7:54

5-Jul-17 7:54

It must be your browser. The checkboxes appear and work fine for me in Firefox 54. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Richard MacCutchan5-Jul-17 21:56

5-Jul-17 21:56

I tried this (and another similar Microsoft page) in both Chrome and Edge, and the checkboxes did not show up in either.

Richard Deeming6-Jul-17 0:58

6-Jul-17 0:58

That's very odd. The checkboxes show up fine for me in Firefox, Chrome (v59), Chrome Canary (v61), Edge (v40.15063.0.0), IE11 (v11.413.15063.0), and Opera (v46).

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Richard MacCutchan6-Jul-17 1:19

6-Jul-17 1:19

Even odder, they now show up for me on both the pages I was trying the other day. I suspect a recent web update.

jschell10-Jul-17 4:18

10-Jul-17 4:18

They now show up for me also.

jschell10-Jul-17 4:16

10-Jul-17 4:16

Richard Deeming wrote:
The checkboxes appear and work fine for me in Firefox 54

Mine is Firefox 54.0.1

Something odd I just noted however - it says 32 bit. My box is 64 bit.

Richard Deeming10-Jul-17 4:39