SQL ODBC Driver Version 3.+ - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL ODBC Driver Version 3.+

Author

Topic

cfuller
Starting Member

3 Posts

Posted - 2006-04-13 : 15:47:29

I'm attempting to extract data from notes databases using crystal reports xi and having problems. The people at crystal are telling me I need SQL Server ODBC Driver Version 3 or above. I looked on the Microsoft website and could only find version 2.8. Anyone know where I can find it?

TimS
Posting Yak Master

198 Posts

Posted - 2006-04-13 : 16:13:35

I guessing they are talking about the version of file odbc32.dll with MDAC 2.5 SP1 this is version 3.520.5303.2

I would make sure you are MDAC 2.6 or above if on windows 2000. Use mdac 2.5 newest SP if NT 4.0
On XP, you don't have a choice the OS SP sets the MDAC level.

Ask them what MDAC version and service pack is required.

Tim S

Edit: Have you look at these:
http://www.businessobjects.com/products/downloadcenter/crystalreportsxi.asp

cfuller
Starting Member

3 Posts

Posted - 2006-04-18 : 13:53:28

Thanks for the Link. Unfortunately it didn't do it. When I run sqlcon32 I get the following:

ODBC Version is : 03

SQL Driver Name is : NSQLV32
SQL Driver Version is : 3.02.2004.1214
SQL Driver Supported ODBC Version is : 02
SQL DBMS Name is : Lotus Notes
SQL DBMS Version is : 5.0.0000 Build 198

The SQL Driver Supported ODBC Version is what I need to upgrade to 03.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources