CF and paradox db

[ryan010101]

I was using ASP to connect to a paradox table and it was working fine, but I decided I'd rather do it in ColdFusion. In ASP here is how I connected to the db:

RS.open SQL, "DSN=mvdParadox;DBQ=i:\"

I couldn't connect with ASP until I found out I had to add "DBQ=i:\" (i:\ being the directory where the table is)\ but I don't really know what DBQ is or what it's equivelent is in CF. Doing this:
<cfquery name=&quot;vendor&quot; datasource=&quot;mvdParadox&quot; dbtype=&quot;ODBC&quot; dbq=&quot;i:\&quot;>
surely doesn't work.

Any suggestions?
thanks
Ryan

 

[strantheman]

Hi Ryan

Cold Fusion works better when using a datasource for the database. But, if youd like to use a DSN less connection like you did in ASP it will be a little more complicated than a simple <CFQUERY> tag.

If you want to see one method for DSN less, see here. I don't know how it will work with your DB software however.

thread232-49003

I would recommend finding compatible database drivers for NT for Paradox, and after Paradox is installed, creating a Datasource directly through CF administrator. That way, accessing the database is as easy as:

<CFQUERY name=&quot;getstuff&quot; datasource=&quot;newdatasource&quot; debug>
select * from stuff
</CFQUERY>

good luck