Hi Kevin, > -----Original Message----- > From: Kevin Smith [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 26, 2001 9:25 AM > To: [EMAIL PROTECTED] > Subject: MyODBC: DSN Creation > > > Hi All, > > I need to setup MyODBC DSN's for MySQL access. > > Does anyone know how to build a simple installer that will create > User/System DSN's from a file? ie. like the odbc.inf file included with the > MyODBC installer? > > Can odbcconf.exe be used to install a DSN? If so, what are the parameters > used to create a DSN, can you give me a good example. > > Many thanks, >
You can make use of 'myodbc.rsp' file that comes with the binary distribution, which configures MyODBC and the sample DSN using odbcconf.exe. The simple command for this is "odbcconf /f myodbc.rsp" Here is the myodbc.rsp that is included in the distribution for 2.50.40 version. INSTALLDRIVER "MySQL Driver|Driver=myodbc.dll|Setup=myodbc.dll||" CONFIGDRIVER "MySQL Driver" "APILevel=2" CONFIGDRIVER "MySQL Driver" "ConnectFunctions=YYN" CONFIGDRIVER "MySQL Driver" "DriverODBCVer=2.50.40" CONFIGDRIVER "MySQL Driver" "FileUsage=0" CONFIGDRIVER "MySQL Driver" "FileExtns=*.txt" CONFIGDRIVER "MySQL Driver" "SQLLevel=1" CONFIGDRIVER "MySQL Driver" "CPTimeout=60" CONFIGDSN "MySQL Driver" "DSN=sample-MySQL;Description=MySQL ODBC Driver;SERVER=database_server;User=odbc;DB=test;Port=3306||" Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php