If you install MSSQL7 on the machine you will need to get that latest MDAC
drivers from MS to use Access. Something in the MDAC drivers shipped with
MSSQL7 breaks Access97 (and likely Access2000 too). You get all kinds of odd
errors especially if you are using SQL concatenation functions.
Also I don't believe the MDAC drivers that shipped with 4.0x supported
Access2k but I could be wrong on this.
Duane
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 3:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Requirements for Access 2000
ColdFusion actually ships with the MDAC, which will allow you to connect to
msoft access after installing. Check your $CFUSION\MDAC directory.
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 12:34 PM
To: [EMAIL PROTECTED]
Subject: RE: Requirements for Access 2000
I have three dev machines (CF 4.01 on NT4 SP5, CF4.5 on WinNT4 SP5 and CF4.5
on Win2k - all with MDAC 2.5).
All three have MSSQL7 installed and are connecting to Access97, Access2000
and SQLServer7 datasources without any problems, without having Access 97 or
Access2k installed.
To run Access2k all you should need is the latest and greatest MDAC drivers.
I haven't seen any problems with any conflicts between Access 97 or 2k, and
MSSQL7 (other than the fact the Access doesn't seem to handle multiple query
statements in a single cfquery call)
Duane
-----Original Message-----
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 12:14 PM
To: [EMAIL PROTECTED]
Subject: Re: Requirements for Access 2000
At 11:50 AM 5/4/00 -0500, you wrote:
>You need to actually have Access 2000 on the machine. From that point,
>the ODBC drivers will show up in the CF Administrator and
>bang - you're in!
And you cannot run SQL Server 7 on the same machine (I'm told)
Which is why I don't offer Access 2000.
best, paul
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
