Page 2 of 2

Re: ODBC and creating DSN's

Posted: Thu Mar 17, 2011 4:17 pm
by captain_skank
It still does exactly the same using either srods code which replaces the ; with a null or using chr(0). ;)

As I said earlier I only used chr(0) just to try something else.

Is there any reason not to use the 3.5.1 ODBC connector ??

Having looked through mysql bug reports it looks like his hasn't been fixed and was first raised some time ago.

cheers

Re: ODBC and creating DSN's

Posted: Fri Jan 06, 2012 11:52 am
by shire
This works fine.

Code: Select all

#ODBC_ADD_DSN    = 1   
#ODBC_CONFIG_DSN = 2
#ODBC_REMOVE_DSN = 3

Result = SQLConfigDataSource_(0, #ODBC_ADD_DSN, "MySQL ODBC 5.1 driver", "DSN=mydsn;DESCRIPTION=MyDescription;SERVER=;PORT=3306;USER=root;PASSWORD=password;DATABASE=sample")

Re: ODBC and creating DSN's

Posted: Mon Jan 09, 2012 10:31 am
by captain_skank
Thanks for this - it'll make life a whole lot easier :)