Connecting Crystal to MS SQL Server Databases 1

[bpngo2]

I am a new user of Crystal reports. Can someone help me out with connecting Crystal XI with the databases in MS SQL Server?

 

[synapsevampire]

Set up an ODBC connection to the SQL Server, then select that as the data source from the Data Explorer.

Please post your software version for more tailored responses.

-k

 

[MSBrady]

K

intersting that you suggest to use ODBC. is there a reason one would choose that over the quicker OLE DB?

 

[synapsevampire]

OLE DB isn't quicker in my experience, it's similar or slower with some databases.

-k

 

[MSBrady]

just curious. I had a .net programmer tell me always use OLE DB when available b/c it's way faster.

 

[bmarks]

I'm curious about that as well as I had a VB/VB.Net programmer tell me the same thing - that OLE DB is much faster than ODBC.

 

[Turkbear]

Hi,
There has been research done on that issue:

http://www.4guysfromrolla.com/webtech/063099-1.shtml

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Looks promising, and my experiences are somewhat dated as I tested years ago.

I'll give it another test, thanks Turk.

-k