OBDC setup using command line

[Karan Mundhra]

Hi,

I am trying to setup an OBDC Data source using a command line interface.
The command goes like
>odbcconf.exe /A {CONFIGDSN "MySQL ODBC 5.1 Driver" "DSN=test|Servername=sv1|Port=3306|user=abcd|pwd=xyz"}

I am using the MySQL ODBC 5.1 Driver.

The error pops up as :
CONFIGDSN: Unable to create a data source for the  "MySQL ODBC 5.1 Driver" driver:
Component not found in the registry with error code -2147467259

Any clues what is wrong? or any other way to set this up using a command line?

Thanks
Karan

[qwerty]

I guess you're better off asking that on StackOverflow.

q.

[Karan Mundhra]

Found my answer:

C:\Windows\SysWOW64>odbcconf.exe /A {CONFIGDSN "MySQL ODBC 5.1 Driver" "DSN=a2g_master|user=abcd|pwd=mnop|server=SV1|Port=3306|database=xyzl|BIG_PACKETS=8|FOUND_ROWS=2"}