selection formula results from two unrelated databases

[Helen]

vb .net 200
crystal reports
Oracl
Acces

Hi, I have all selection formula results needed from the main crystal report, called in the vb form (Oracle db)

I now need to build in the logic in the vb form selection formula to obtain results also from the subreport (Access db)

The two databases are totally unrelated

How do I do this, please

Do I need to dim a second database, with all connection info, in the vb form
Do I then need to add the subreport table/column info to the FillDataset Sub? Is that how it's done

Thanks for any help on this

-Helen


Inappropriate post
If so, Red Flag it
Check out the FA
area for this forum

You

[steve]

don't do it in code...either:

create an oracle tsn for your access db and create a view in oracle that
joins your two "un-related" tables

or,

create a dsn for oracle (sqlnet* required), link your oracle table in
access, then create a query that joins the two (either via your code or
natively in access).

hth,

steve

let db's do what they were designed to do...much less work for you.

"Helen" <an*******@discussions.microsoft.com> wrote in message
news:C9**********************************@microsof t.com...
| vb .net 2002
| crystal reports 9
| Oracle
| Access
|
| Hi, I have all selection formula results needed from the main crystal
report, called in the vb form (Oracle db).
|
| I now need to build in the logic in the vb form selection formula to
obtain results also from the subreport (Access db).
|
| The two databases are totally unrelated.
|
| How do I do this, please?
|
| Do I need to dim a second database, with all connection info, in the vb
form?
| Do I then need to add the subreport table/column info to the FillDataset
Sub? Is that how it's done?
|
| Thanks for any help on this.
|
| -Helen
|
|
|
|
|
| Inappropriate post?
| If so, Red Flag it!
|
|
| Check out the FAQ
| area for this forum!
|
|
|
| You
|

[Cor Ligthert]

Hi Helen,

When I read your message well than Oracle and Access are two unrelated
databases.

So you retrieve the data from your Oracle database and as well from the
Access database for which you use OleDb.

I never tried it, however I think that you can even use the same dataset for
that (however only when needed of course when you have to set relations
between the two).

I cannot see with this what would be the problem.

Cor

[steve]

i mean...open access. then click on the "tables" tab. next, right click the
whitespace and select "link table". choose odbc datasource, then choose your
oracle/sqlnet dsn. all that s/b left is to select the oracle tables to which
you'd like to link.

if you don't have rights to do that then you would create a new mdb project,
link your currently used access tables in the new project as well as the
oracle tables (all as described above). then all you'd need to do in .net is
to change your connection string to point to the consolidated mdb.
so...there's the trouble w/ access "security"

hth,

steve

btw, hacking access and giving yourself godlike privilages is brutally easy
and there are a gazillion examples on the net...if you want to take the
"sledge hammer" approach.

;^)
"Helen" <an*******@discussions.microsoft.com> wrote in message
news:E1**********************************@microsof t.com...
| Hi, Steve:
|
| It IS a pain, but getting closer!
|
| I'd like to try your way at least during down time so I know. When you
say link to Access, do you mean link it to the physical access mdb used in
the subreport, or just any Access new project? 'Cause I don't have rights
to the .mdb other than read, YET.
|
| -H :)

[Cor Ligthert]

Hi Helen,

Maybe I miss something what you want, to read an access database in a
dataset in ADONET is this
\\\
Dim conn as new OleDB.OleDBconnection _
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=SWINVENTORY.MDB;"
Dim da as new OleDB.OleDbDataadapter("MySQLSelectString",conn)
Dim ds as new dataset
da.fill(ds)
////

I typed it in above so watch typos.

(I did not forgot the open close, command etc those are all not needed,
however nicer is to set the da.fill in a try catch block.)

What do I miss?

Cor

[Helen]

Thanks, Steve and Cor

I see, Steve, this would be easy to do linking in access. Searched oracle for correct sqlnet* for 7, haven't come up with it yet. Will keep looking

Cor, tks for the code

I have the connections working for both dbs now, crystal 9 quirky for calling selection from sureport, able to call if not subreport, no problemo ... almost there ...

[steve]

try:

http://otn.oracle.com/software/tech/...dbc/index.html

this page has oracle 7 through 9 odbc drivers. that s/b all you need.

post you later,

me
"Helen" <an*******@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...
| Thanks, Steve and Cor:
|
| I see, Steve, this would be easy to do linking in access. Searched oracle
for correct sqlnet* for 7, haven't come up with it yet. Will keep looking.
|
| Cor, tks for the code.
|
| I have the connections working for both dbs now, crystal 9 quirky for
calling selection from sureport, able to call if not subreport, no problemo
.... almost there ...

[Helen]

much appreciated!

-H

"steve" wrote:

try:

http://otn.oracle.com/software/tech/...dbc/index.html

this page has oracle 7 through 9 odbc drivers. that s/b all you need.

post you later,

me
"Helen" <an*******@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...
| Thanks, Steve and Cor:
|
| I see, Steve, this would be easy to do linking in access. Searched oracle
for correct sqlnet* for 7, haven't come up with it yet. Will keep looking.
|
| Cor, tks for the code.
|
| I have the connections working for both dbs now, crystal 9 quirky for
calling selection from sureport, able to call if not subreport, no problemo
.... almost there ...