[AccessD] DSNs

jwcolby jwcolby at colbyconsulting.com
Wed Jul 18 12:00:38 CDT 2007


>Hopefully I'm not being condescending.

Not at all.  I don't know this stuff

>Control Panel > Data Sources (ODBC)

I don't have that.  Windows XP Profession SP2

>HKLM\Software\ODBC\ODBC.INI

I don't understand this one.  Is this a directory path?  A registry key?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bruce H. Johnson
Sent: Wednesday, July 18, 2007 12:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] DSNs

Hopefully I'm not being condescending.

If this is for your machine only:

Control Panel > Data Sources (ODBC)

If you need it programmable:
HKLM\Software\ODBC\ODBC.INI

HTH 


Bruce H. Johnson
Sylmar, CA
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, July 18, 2007 7:24 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] DSNs

I am working with Access as the FE to processing orders where I need to
export to a fixed width file because Access stores the format, which is
convenient until I come up to speed on how to do something similar in SQL
Server.  The issue is that the DSN is specific to a database name.  How can
I edit that to point to a different database?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.8/906 - Release Date: 7/17/2007
6:30 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.8/906 - Release Date: 7/17/2007
6:30 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list