Webmaster Forum / ColdFusion / Database Access / April 2005

I am running CFMX 6.1 on RedHat Linux AS. I have an MS Access database on a
Windows server I want to access. CFMX does not come with a built-in Access ODBC
or JDBC driver. Is there any way to get this to work? I can not convert the
Access DB to MySQL as it is still used in Access ...

We are talking about CF Server 5.0.
CF5.0 Server 1 is based at one location on a WIN2K box. Data is written to a
MS SQL2000 server on this same box.
CF5.0 Server 2 is based at a totally separate location running on a Solaris

I'm capturing the value of wrong answers to question, i.e. 1,2,5,7, in a LIST.
I would like to use the  LIST with the WHERE to generate the question
incorrectly and then display the right answer. I got it to work by doing
X-amount data queries in a loop. I don't like that ...

Here's my code...
------------------------------------
<cfquery name="Recordset1" datasource="DB1">
SELECT *

Does anybody know how I can execute one of the system stored procedures from
master database.
for example this is throwing error:
<cfquery datasource="users">

I was wondering if someone can help me out with this issue.
1. We are pulling information from a struct/object in order to construct
queries.
2. These queries are dynamically constructed within loops - a query would be

I will soon have to move a complete table from one database to another (including the table structure and data in the table).
Is there an easy way to do this? Both are MSSQL databases.
Thanks!

Could anyone let me know  how I can get a list of tables  of an Access 2000 DB? Or is that impossible?  
Thanks, Liglin

I have one simple question,
this is my query:
 SELECT users.*, (SELECT TOP 1 Product_name FROM Products WHERE user_id =
users.user_id) AS Product

I'm having two problems.
Whenever I try to connect to an MS Access datasource with an ODBC socket or
the MS Access driver, I get the following error.
<pre>

I want to use a .txt as DB. The querying works with SELECT * FROM textfile.txt
and returns me the number of rows. The only problem i have is that I cant
figure out how to get multiple columns.
The textfile is ; delimited and the first row are the columnnames.

Hi,
I need a  WHERE statement that does the following:
WHERE  LEFT(name,1) IN 'abcdef'
i.e. I want to see if the first letter in name field is in the 'abcdef'

Want to connect Cach? DB from Linux. Cach? can be connected via ODBC but CF
does not deliver a driver for that DB. Linux does not have a Socket-ODBC, so
how can we establish a connection?
Thanks for a tip

Permits contains a string: 4,16,12,9,12,7,5 .....
cookie.userid is a number    
<cfquery name="rsTitols" datasource="gallery">
     SELECT * FROM Galleries

We are working on a new web server with CFMX6.1.  
I am having problems creating an ODBC datasource to an Access database on a
network drive.  I have mapped the drive on the web server, but cannot get it to
verify in the CF Administrator.