Direct Access Driver

[ddeegan]

Hello

I am trying to get use a "Direct Access Driver" rather than ODBC. How do I do it?

Where, in "Standard Report Creation Wizard", can I find Direct Access?

(Current Connections="No Items found",
Repository doesn't seem right,
"Create New Connection" - these seem like indirect connections)

I tried OLE DB, but if I am reading right, this is NOT direct access....correct?

I am a newbie, so if anyone could help answer these below, or provide some good links - I would be grateful.

Using...
Crystal 9.2.0.448
SQL 2000

Thanks
Dave

 

[synapsevampire]

Native connectivity is available through version 8.5 for SQL Server:

http://support.businessobjects.com/library/kbase/articles/c2014616.asp

-k

 

[ddeegan]

Thanks for the quick response. I am surprised by the answer.

Is there a difference between ODBC & OLE DB - OLE DB seems like it might be more stable.

I'm looking up the following on my own, but if anybody cares to answer...
What is Unicode and what is so great about it?
Is there that much of a performance issue between direct and indirect connection?

Who is in charge of updating the Ntwdblib.dll? Is it Microsoft or Crystal - and does this have anything to do with MS trying to push Crystal out of the picture?

Thanks again for the answer - I was going nuts looking for a direct connection.

Thanks
Dave

 

[synapsevampire]

OLE DB is the latest, and something MS is pushing. ODBC is open source now, so MS couldn't stand for that

Testing years ago showed ODBC as faster than OLE DB, but things have probably changed.

Unicode supports a larger character set, and most care about it, and it's the standard these days. Search the web and you'll find plenty of info on it.

The rest I can't help you with.

-k