> 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
> What I meant to say is you cannot run the SQL Server clone
> in Access 2000 and SQL Server 7 on the same box (I'm told)
What do you mean by "the SQL Server clone"? If you mean MSDE, you're
probably right that you can't run it and SQL Server 7 on the same box. MSDE
isn't run in Access 2000, thou
-Original Message-
From: Ric Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, 5 May 2000 1:37 AM
To: [EMAIL PROTECTED]
Subject: Requirements for Access 2000
Anyone know what needs to be installed on a server
so Access 2000 databases will verify with CF Server?
Thanks
-- Ric Smith
Er...ah...my bad.
What I meant to say is you cannot run the SQL Server clone
in Access 2000 and SQL Server 7 on the same box (I'm told)
I hope I'm wrong!
best, paul
At 12:34 PM 5/4/00 -0400, you wrote:
>And you cannot run SQL Server 7 on the same machine (I'm told)
>Which is why I don't offer
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
: 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
OK - I stand corrected. It isn't like it's the first time that's ever happened!!! LOL
- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 12:42 PM
Subject: RE: Requirem
> And you cannot run SQL Server 7 on the same machine (I'm told)
> Which is why I don't offer Access 2000.
This is incorrect. Both will coexist without any problems.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
-
> 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!
This isn't correct. As long as you have MDAC 2.1 or higher installed, you
can create new Access databases and/or create ODBC datasources to Acc
> 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 Acc
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 s
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.
bes
iversity
[EMAIL PROTECTED]
(740) 597-2524
- Original Message -
From: Ric Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 10:37 AM
Subject: Requirements for Access 2000
Anyone know what needs to be installed on a server
so Access 2000 databases will ver
Anyone know what needs to be installed on a server
so Access 2000 databases will verify with CF Server?
Thanks
-- Ric Smith
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffus
14 matches
Mail list logo