SQL 6.5 and MDAC 2.6

SQL 6.5 and MDAC 2.6

Post by Pasca » Fri, 09 Mar 2001 03:00:37



Hello all

Does any one know of any negative issues related to MDAC 2.6 and SQL 6.5
installed on Win NT 4.0.  I am doing a fresh installation of NT and SQL for
a web development group and I would like to know if MDAC 2.6 is compatible
with SQL 6.5.

Pascal

 
 
 

SQL 6.5 and MDAC 2.6

Post by Omar » Fri, 09 Mar 2001 22:14:04


In my experience if you install mdac 2.6 you may have serious problem whith
old project
written with vb6 and mdac 2.5.
example: try to make a connection to a table in a sql 7.0 using the
dataenvironment with a simple query command (aduseserver,keyset, optimistic)
and the application fail with the error of vb6.exe etc.

 
 
 

SQL 6.5 and MDAC 2.6

Post by Omar » Fri, 09 Mar 2001 22:13:50


In my experience if you install mdac 2.6 you may have serious problem whith
old project
written with vb6 and mdac 2.5.
example: try to make a connection to a table in a sql 7.0 using the
dataenvironment with a simple query command (aduseserver,keyset, optimistic)
and the application fail with the error of vb6.exe etc.
 
 
 

SQL 6.5 and MDAC 2.6

Post by Omar » Fri, 09 Mar 2001 22:08:49


In my experience if you install mdac 2.6 you may have serious problem whith
old project
written with vb6 and mdac 2.5.
example: try to make a connection to sql 7.0 with a simple command
(aduseserver,
keyset, optimistic) and the application fail with error of vb6.exe etc.
 
 
 

SQL 6.5 and MDAC 2.6

Post by Neil Pik » Sat, 10 Mar 2001 02:30:36


 Pascal,

 Yes it is.  I install all my workstations with MDAC 2.6 and it seems to work fine.

 > Does any one know of any negative issues related to MDAC 2.6 and SQL 6.5

Quote:> installed on Win NT 4.0.  I am doing a fresh installation of NT and SQL for
> a web development group and I would like to know if MDAC 2.6 is compatible
> with SQL 6.5.

> Pascal

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq
 
 
 

SQL 6.5 and MDAC 2.6

Post by Taverna Paol » Sat, 10 Mar 2001 21:18:50


Hello Pascal
We are also running SQL 6.5 and have the access through MDAC 2.6. No Problem
experienced.
If you have Projects with a older ADO version, just recompile them with the
new ADO 2.6 Version.
This worked with several Project, no Problem experienced.

Regards
Paolo



Quote:> Hello all

> Does any one know of any negative issues related to MDAC 2.6 and SQL 6.5
> installed on Win NT 4.0.  I am doing a fresh installation of NT and SQL
for
> a web development group and I would like to know if MDAC 2.6 is compatible
> with SQL 6.5.

> Pascal

 
 
 

SQL 6.5 and MDAC 2.6

Post by Gert E.R. Draper » Sat, 10 Mar 2001 23:56:37


The only thing you should not forget is to run INSTCAT.SQL against your 6.5
server. Besides that it works fine for me.
-GertD


Quote:> Hello all

> Does any one know of any negative issues related to MDAC 2.6 and SQL 6.5
> installed on Win NT 4.0.  I am doing a fresh installation of NT and SQL
for
> a web development group and I would like to know if MDAC 2.6 is compatible
> with SQL 6.5.

> Pascal

 
 
 

SQL 6.5 and MDAC 2.6

Post by Fabricio Ferreir » Sat, 17 Mar 2001 00:37:10


If you use Crystal Reports with groups or use Access with linked tables, you
have a great problem!!!!



Quote:> Pascal,

>  Yes it is.  I install all my workstations with MDAC 2.6 and it seems to
work fine.

>  > Does any one know of any negative issues related to MDAC 2.6 and SQL
6.5
> > installed on Win NT 4.0.  I am doing a fresh installation of NT and SQL
for
> > a web development group and I would like to know if MDAC 2.6 is
compatible
> > with SQL 6.5.

> > Pascal

>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  Reply here - no email
>  SQL FAQ (484 entries) see
>  http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
>  (faqxxx.zip in lib 7)
>  or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>  or www.sqlserverfaq.com
>  or www.mssqlserver.com/faq

 
 
 

1. MDAC 2.6 and SQL Server 6.5

After having installed MDAC 2.6 I have problems
with the replication tasks of my SQL Server 6.5.
It always says:
28000[Microsoft][ODBC SQL Server Driver]
[SQL Server]Login failed- User: Reason: Not
associated with a trusted SQL Server connection

Any help is appreciated!

Rdiger

2. ADO MAP Database

3. tcp/ip prob mdac 2.6 -> sql 6.5

4. SQL 2000 Server installation failed on NT4 Server

5. MDAC 2.6 / SQL 6.5 connectivity problem

6. SQL2000 acting flacky

7. tcp/ip prob mdac 2.6 => sql 6.5

8. sql connection problem

9. MDAC 2.6 and SQL 6.5

10. MDAC 2.6 causes EXCEPTION_ACCESS_VIOLATION in SQL 6.5 SP4 Logs

11. MDAC 2.5 and MDAC 2.6

12. big issue between MDAC 2.6 and MDAC 2.5

13. CellSet Difference with MDAC 2.6 and MDAC 2.7