SQL Server ODBC Drivers

I recently downloaded MDAC 2.1.2.4202.3 which installed a newer version of the SQL Server ODBC Driver (3.70.0690).  We are using SQL Server 7.0 which shipped with version 3.70.0623 of the ODBC Driver.

Do I need to load a new version of INSTCAT.SQL to use this newer version of the ODBC Driver?

How do I know when a new version of INSTCAT.SQL needs to be installed for newer ODBC Driver versions?
dwillerthAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chigrikCommented:
SQL Server ODBC Driver 3.70.0690 comes with SQL 7 SP1 and with MDAC 2.1 SP2. You can download and install only MDAC (it not necessary to install service pack 1 for work with ODBC Driver 3.70.0690, but it recommended). You may download MS SQL 7.0 SP1 from here:
http://support.microsoft.com/support/downloads/LNP500.asp
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dwillerthAuthor Commented:
Does a catalog of stored procedures (instcat.sql) go with a SQL Server Version or with an ODBC Version?  If a Catalog of Stored Procedures goes with a SQL Server Version, does a new catalog of stored procedures ever come out for a specific SQL Server Version?

Basically, I'm nervous about using a different version of the ODBC Driver without installing new service packs or new Catalogs of Stored Procedures on the SQL Server.  We have had problems with the SQL Server ODBC Driver version 3.60.0319.  We find that using that driver against SQL Server 6.5 or SQL Server 7.0 causes what looks like rounding problems.  You enter 100 and the server inserts 101 into the table.  

0
chigrikCommented:
Read about "How to upgrade the catalog stored procedures" from SQL Server Books online for more information. It therefrom: "...Instcat.sql script that comes with your new version of SQL Server...".

Look also at here:
INFO: ODBC Client Error After Connecting Using MDAC SQL Server Driver
http://support.microsoft.com/support/kb/articles/q178/1/32.asp?LNG=ENG&SA=PER

Q137636 INF: Relationship of the ODBC Driver to INSTCAT.SQL
http://support.microsoft.com/support/kb/articles/Q137/6/36.ASP

Why you don't want to download MS SQL 7.0 SP1 (service pack 1)? It contain near 40Mb and after its installation you will not have problems with the various versions.
0
dwillerthAuthor Commented:
It's not that I don't want to install SP1.  I'm trying to figure out how all this connection stuff works so that when the next new version of the ODBC Driver or an older verion gets installed on someones workstation, I'll know if I have to do something to make it work.  My worries stem from the fact that we have had trouble with the 3.60.0319 Driver, with both SQL Server 6.5 and 7.0.  I am beginning to think it may be a problem of Visual Foxpro not being compatible with the 3.6 driver.

The articles you mentioned and you're comments have helped.  
Thanks.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.