p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   how to connect in windows xp (http://p2p.wrox.com/showthread.php?t=58270)

gilgalbiblewheel May 23rd, 2007 07:12 PM

how to connect in windows xp
I know in Win98 MS access 2000 connects to ODBC (I think that's what it was called) but what about XP?

mmcdonal May 24th, 2007 06:37 AM

Let's see...

gilgalbiblewheel May 24th, 2007 08:25 AM

Ok. Done.

mmcdonal May 24th, 2007 09:04 AM

There are many options to connect Access to SQL Server (or any other DBMS) in all versions of Windows. So you can connect Access to Access, or Access to SQL Server, Access to MySSQL, etc using this method.

You can use an ODBC (DNS) in both versions of Windows. DNS's are slow, but very reliable. You also have to make sure that they are properly configured on all of your user's desktops. This can be a problem and require you to use installation software if you user base is large.

What are you doing with the front and back ends? I am assuming it is split, otherwise there is no need for a connection like this.

I do a lot of Access / SQL, and typically use a Provider statement instead of an ODBC, since I can control user credentials and the connection state.

Did any of that help?


gilgalbiblewheel May 24th, 2007 11:15 AM

It's not clear to me. I use ColdFusion MX 7. How would I connect a database in XP, to use on my localhost?

mmcdonal May 24th, 2007 12:12 PM

Okay, it looks like you have a local database on a local IIS server, using ColdFusion to connect to the local database.

I think this is managed through the IIS data connections. If not, go to the control panel, then Administrative Tools, then Data Sources (ODBC) and define a system DSN. (sorry, I was saying DNS before).

It seems to me that you define this in IIS though. Perhaps you have to create it in the system data sources first. I also recall that if you save the database file to the virtual folder, IIS will ask you if you want to create a data source.

Did any of this help?


gilgalbiblewheel May 24th, 2007 01:47 PM

I'll have to check from home.

gilgalbiblewheel May 31st, 2007 09:13 PM

IIS is found on the Windows XP Pro cd right?
And you go to control panel and Add/Remove programs then go components found on the left navigation. WHen I checked I saw no IIS there:
(does this forum allow images? Otherwise I would show you how it looks like).

mmcdonal June 1st, 2007 06:38 AM

What web server are you using to host the CF site?


gilgalbiblewheel June 1st, 2007 11:57 AM

On the web? I have tons of ASP files that I've used on my win98's PWS. But I can't modify them on my XP.

All times are GMT -4. The time now is 01:29 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.