ODBC and creating DSN's

Just starting out? Need help? Post your questions and find answers here.
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: ODBC and creating DSN's

Post 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
shire
User
User
Posts: 46
Joined: Mon Jul 25, 2011 5:24 am

Re: ODBC and creating DSN's

Post 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")
User avatar
captain_skank
Enthusiast
Enthusiast
Posts: 639
Joined: Fri Oct 06, 2006 3:57 pm
Location: England

Re: ODBC and creating DSN's

Post by captain_skank »

Thanks for this - it'll make life a whole lot easier :)
Post Reply