Dennis,
Yes, you can connect CF to a remote MSDE database. Use the SQL Server ODBC
connector to do so, not MS Access. MSDE is basically SQL Server 7 with a 2gb
size limitation minus the enterprise manager. Access 2k has it's own
"enterprise manager" for MSDE, but you'll need to create a project (.adp)
and then associate it with the DB file.
Regards,
Chris
-----Original Message-----
From: Dennis Powers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 5:29 PM
To: CF-Talk
Subject: RE: Connecting to MSDE on Another Server
The only thing on the network that resembles a Server is the MSDE server,
everything else is run from Access 97 (ugh!), but to their credit it is
serving the company well.
I have been trying to convince them to purchase an SQL server, but I don't
see that anytime soon. I was hoping to connect the CF Server to the Box
with the MSDE database, I just can't figure out how, or IF it can be done.
I guess I'll have to go there.
Best Regards,
Dennis Powers
UXB Internet
(203) 879-2844
http://www.uxbinfo.com/
-----Original Message-----
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 5:37 PM
To: CF-Talk
Subject: Re: Connecting to MSDE on Another Server
----- Original Message -----
From: "Dennis Powers" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 9:55 PM
> Good day,
>
> I am hoping that someone can clue me in on the steps needed to connect to
an
> MDSE database that is residing on a separate server from the Cold Fusion
> server.
If you have a server on the network running SQL Server Enterprise Manager,
you
should be able to connect to MSDE server through that, and use it as just
another SQL Server installation.
Disclaimer: I have never tried it!
Adrian Cooper.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
