DSNless Connection Help

[scorniglia]

Hi,
I can not get the syntax correct to establish a dsnless connection to Paradox tables. The string given to me by the web host is:

"DRIVER={Microsoft Paradox Driver (*.db)};
DBQ=c:\data\database\"

But it doesn't work. I want to use it with a query but when I do as such it fails with all kinds of errors:

<CFQUERY NAME=&quot;test&quot;
dbtype=&quot;__Dynamic__&quot;
&quot;DRIVER={Microsoft Paradox Driver (*.db)};
DBQ=c:\data\database\&quot;
>

SELECT etc, etc
</CFQUERY>

Does any one know what is wrong? Thanks a lot if you can help.

Regards,
Roy F.

 

[SidianConsulting]

Are you using CF 5.0? If not, you are out of luck -- prior versions and CFMX do not support DSNless connections.

If you are using CF 5.0, the syntax is not right. It should be:

<cfquery 
name=&quot;myquery&quot;
dbtype=&quot;dynamic&quot;
connectstring=&quot;DRIVER={Microsoft Paradox Driver (*.db)};DBQ=c:\data\database\&quot;>

...SQL QUERY...

</cfquery>

-Tek

 

[scorniglia]

Hi Tek,
Thanks for the reply. I am using CF5 and that is what my website is hosted with also. I tried the connection string you suggested and it still give and error. My code is:

<CFQUERY NAME=&quot;player&quot;
dbtype=&quot;dynamic&quot;
connectstring=&quot;DRIVER={Microsoft Paradox Driver (*.db)};DBQ=c:\PdoxData\2002Pool\&quot;>

............SQL

</CFQUERY>

CF give the error:

ODBC Error Code = IM002 (Data source not found and no default driver specified)

[Microsoft][ODBC Driver Manager] Data source '' not found and no default driver specified

Any other thoughts or ideas? Thanks again.

Regards,
Roy F.

 

[SidianConsulting]

Sorry I can't give you any more advice; I'm not familiar with Paradox. Maybe the connectstring is wrong? Check out the docs on CFQUERY and make sure there aren't any missing settings.

-Tek