Adding crystal to VB 6 code?

[mpodlesny]

CR Version 8.5
VB 6 sp 5

I know this may seem like a trivial question to most.
I want to set the database to connect to at run time in VB 6. How do I do that?

 

[vidru]

See faq768-5374

-dave

 

[mpodlesny]

I looked at and tried the code in the FAQ however I continue to get the error "Server has not yet been opened". I am trying to connect to an Oracle 10 database.

 

[vidru]

You might need to try the ConnectionProperties approach. I've never connected CR to Oracle, so the best I can do is point you to some required reading:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_rdc9_connectionproperties.pdf.asp

-dave

 

[synapsevampire]

When connecting Crystal to Oracle, make sure that you're either using the Crystal Native connectivity, or the Crystal supplied ODBC for Oracle, not the Oracle supplied ODBC.

Otherwise as long as you have the Oracle client installed, it's very common and should go smoothly.

-k

 

[mpodlesny]

I am fairly new to this, so i am not sure what you mean

RE:
When connecting Crystal to Oracle, make sure that you're either using the Crystal Native connectivity, or the Crystal supplied ODBC for Oracle, not the Oracle supplied ODBC.

Otherwise as long as you have the Oracle client installed, it's very common and should go smoothly.

 

[mpodlesny]

This one is for Crystal 9, unfortunately I am useing 8.5 and the version I am using does not have the connection properties.