Short answer: yes, there is a way to set it up programatically. Also, by
specify the driver, server, connect paramters, etc, you ca sometimes do a
DSN-less connection. I do that with an ODBCDirect connection under Access.
It doesn't work, however, when I try to attach tables.
Look on http://msdn.microsoft.com/library/default.asp and look for their ODBC
API reference. There should be something under there that will be helpful.
I used to have a link to a command call SQLConfigDataSource, but the link is
broken now.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/dasdkodbcoverview.asp
Should get you started. Sorry if it wrapped.
HTH.
j----- k-----
On Wednesday 27 June 2001 01:34, Amanda wrote:
> Hi,
>
> I am trying to access a mysql unix database from Clarion.
> Setting up the database throgh ODBC Administrator and then accessing
> through Clarion is Fine. However depending on selections mad by the User we
> need to connect to a different MySQL database. Claion suggessted creating a
> file DSN to get the parameter settings. However whenever i try to create a
> file DSN a get "file not saved". Where else can i get the names of the
> attibutes to set up the ODBC srouce programatically. Is there a windows API
> function to change/setup DSN? Any advice would be greatfully accepted,
> Thanks,
> Amanda Weddell.
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
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
