Adding Access DB Errors

[bwhitla]

trying to add an access db, but it only offers me Microsoft SQL Server, SQL 3.x
and "other" as options for db types to add - i'm not used to this new server,
how do i add an MS Access db, when it's not an option? i'm sort of a newbie, i
used mostly back around version 4.0.. here's some server info:

rver Details
Server Product ColdFusion MX
Version 7,0,1,116466
Edition Standard
Serial Number CPD700-00250-87220-27545
Operating System Mac OS X
OS Version 10.4.4


JVM Details
Java Version 1.4.2_09
Java Vendor Apple Computer, Inc.
Java Vendor URL [url]http://apple.com/[/url]
Java Home /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home
Java File Encoding MacRoman
Java Default Locale en_US
File Separator /
Path Separator :
Line Separator Chr(10)
User Name admin
User Home /Users/admin
User Dir /Applications/ColdFusionMX7/runtime/bin
Java VM Specification Version 1.0
Java VM Specification Vendor Sun Microsystems Inc.
Java VM Specification Name Java Virtual Machine Specification
Java VM Version 1.4.2-54
Java VM Vendor "Apple Computer, Inc."
Java VM Name Java HotSpot(TM) Client VM
Java Specification Version 1.4
Java Specification Vendor Sun Microsystems Inc.
Java Specification Name Java Platform API Specification
Java Class Version 48.0

[paross1]

You can use ODBC socket if you have already created an ODBC system DSN on your CF server for your Access database.

Phil

[bwhitla]

that sounds like it would work - how do i create an ODBC system DSN on my CF server, though?

[LL@Work]

ODBC Socket:
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0 0001745.htm[/url]

[bwhitla]

ah right, but when i'm adding a data source, it doesn't ask me to choose ODBC
DSN, only Microsoft SQL, SQL 3.x and "other".. can i do this through "other"?

sorry for being a little thickheaded, like i said, i was last adding
datasources in version 4.0 on windows nt, where all i had to do was point CF to
an access DB..

[paross1]

Don't you see ODBC Socket in your dropdown Driver list under Add New Datasource
in ColdFusion Administrator? You would be able to select any ODBC datasources
here that you may have created through the Settings-->Control
Panel-->Administrative Tools-->Data Sources (ODBC)-->System DSN ADD process on
your CF server.

Phil

[bwhitla]

here's the other thing making this hard.. i'm doing this over VNC on a macosX
server.. so "Settings-->Control Panel-->Administrative Tools-->Data Sources
(ODBC)-->System DSN ADD" doesn't exist on the mac.. any idea where that same
thing is located?? i've been hunting for DSN stuff on this mac for hours..

[paross1]

Oh, sorry, I neglected to notice that you are using a Mac (dang!). You can disregard my previous posts, as they would apply to a Windows server.

Phil

[bwhitla]

no worries, thanks for everything so far... so who can tell me how to get ODBC working and accessable on a mac server?? or even a good resource for mac/cf integration would be sweet..

[paross1]

Not being a Mac person, the best that I could do was a quick Google, and this is one site that looked interesting to me.

[url]http://support.openlinksw.com/support/mac-faq.html#7[/url]

Phil