 |
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
May 23rd, 2007, 07:12 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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?
|
May 24th, 2007, 06:37 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
Let's see...
|
May 24th, 2007, 08:25 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
Ok. Done.
|
May 24th, 2007, 09:04 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
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
|
May 24th, 2007, 11:15 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
It's not clear to me. I use ColdFusion MX 7. How would I connect a database in XP, to use on my localhost?
|
May 24th, 2007, 12:12 PM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
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
|
May 24th, 2007, 01:47 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
I'll have to check from home.
|
May 31st, 2007, 09:13 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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).
|
June 1st, 2007, 06:38 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
What web server are you using to host the CF site?
mmcdonal
|
June 1st, 2007, 11:57 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2004
Location: , , .
Posts: 240
Thanks: 0
Thanked 1 Time in 1 Post
|
|
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.
|
|
Similar Threads
