Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 23rd, 2007, 07:12 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default 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?
Reply With Quote
  #2 (permalink)  
Old May 24th, 2007, 06:37 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Let's see...
Reply With Quote
  #3 (permalink)  
Old May 24th, 2007, 08:25 AM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

Ok. Done.
Reply With Quote
  #4 (permalink)  
Old May 24th, 2007, 09:04 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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?

mmcdonal
Reply With Quote
  #5 (permalink)  
Old May 24th, 2007, 11:15 AM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

Reply With Quote
  #6 (permalink)  
Old May 24th, 2007, 12:12 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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?

mmcdonal
Reply With Quote
  #7 (permalink)  
Old May 24th, 2007, 01:47 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

I'll have to check from home.

Reply With Quote
  #8 (permalink)  
Old May 31st, 2007, 09:13 PM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

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).

Reply With Quote
  #9 (permalink)  
Old June 1st, 2007, 06:38 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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


mmcdonal
Reply With Quote
  #10 (permalink)  
Old June 1st, 2007, 11:57 AM
Friend of Wrox
Points: 1,107, Level: 13
Points: 1,107, Level: 13 Points: 1,107, Level: 13 Points: 1,107, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Threads In Windows XP selorm Windows Server 1 December 7th, 2006 11:10 PM
Server for Windows XP LiamUk PHP How-To 2 July 30th, 2004 09:20 AM
Windows XP btls Wrox Book Feedback 1 July 13th, 2004 02:41 PM
Windows 98 OCX control issues vs Windows XP benoyraj VB How-To 0 May 5th, 2004 08:10 AM
Windows XP controls sangata VS.NET 2002/2003 8 April 12th, 2004 11:31 AM



All times are GMT -4. The time now is 03:52 PM.


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