Tom,
Thank you. It works fine with CF 5 for windows, but not on linux.
The following works on windows:
<CFQUERY NAME="test"
DBTYPE="dynamic"
CONNECTSTRING="driver=
{mysql};database=sw;server=209.206.185.132;uid=username;pwd=password;option
=16386;">
SELECT id from stores
</CFQUERY>
That doesn't work from a linux machine and neither does the following
(changed the driver string):
<CFQUERY NAME="test"
DBTYPE="dynamic"
CONNECTSTRING="driver={MERANT mySQL
Driver};database=sw;server=209.206.185.132;uid=username;pwd=password;option
=16386;">
SELECT id from stores
</CFQUERY>
What is the option # on the end of the connect string?
The linux machine doesn't seem to recognize that it is a dynamic
datasource and throws the "ODBC Error Code = IM002 (Data source not found
and no default driver specified)" error.
Dynamic datasources are turned on in the admin. Any other suggestions?
Thanks.
-Erik
>
> http://www.basic-ultradev.com/articles/dsnlesscoldfusion/index.asp
>
> tom
>
> "Erik Retz" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> Hello,
>>
>> Anyone know the correct syntax for setting the connectstring to create
>> a dynamic db connection for MySql? I found info on access, MsSql and
>> Oracle, but no MySql. I'm trying to do some testing on a remote box
>> that I don't have cfadmin privileges on.
>>
>> Thanks.
>>
>> -Erik
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
