unix and ms access

[jewelzaro]

I do not have access to the coldfusion administartor at work.
The person in charge said they set up a Microsoft Access Database connection
on the UNIX box. They said the datasource verfiies.

My problem is that I can not use that datasource, it fails. I receivce an
error on my coldfusion pages. Do I need to add something such as dbtype to my
cfquery statement?

Or can MS Access and Unix not really work and this person is pulling my leg.

Any help would be great

[Dan Bracuk]

For the most part, if you are using MS Access, the mdb file has to be on your application server. Assuming that it is, what exactly are you trying to do and what is the error?

[jewelzaro]

Thank you so much for responding. The .mdb file is on the application server.
I'm trying to select from my Microsoft Access database from a UNIX box.
I do not have rights to the ColdFusion Admin and the CF Admin is stating that
the datasource is verifying.
The datasource is suppose to be connected to a Microsoft Access database.

Below is the error:

ODBC Error Code = S1000 (General error)

[MERANT] [ODBC dBase driver] Error on input or output to a file.No such file
or directory Additional Information
/server/db.mdb/Accounts.DBF.

SQL = "Select * From Accounts Where UserName = "JUL" and Password="JUL"

Whatever the table name is, that is what appears at the end of the error.

Do I need to specify a DBTYPE?
Is it because my table name is upper case? Is that a problem with UNIX?

Thank you again

[paross1]

Unix is case sensitive, so you would have to match.

Phil