odbc system dsn changing

[domkop]

i need to change the system dsn in the odbc but i am a beginning programmer.
i need to change the information so i can use the workstation for multiple servers.
the connection to the servers are in the odbc
how do i change them, someone said with SQLConfigDataSource
does anyone has an solution/example

thanks

 

[dbomrrsm]

depends what OS but on XP its control panel - administrative tools - data sources (ODBC).

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[domkop]

i know but how do i change it programmaticly,
i want to change the definition of the database with delphi and not by hand

 

[jitter]

I have no experience with Delphi but have done it with VB. There are also sum undocumented stored procedures you can use with sql server to work for with the registry. Keep in mind these can change in the future releases. You can check this site out.

http://www.databasejournal.com/features/mssql/article.php/1441251

Hope this is sort of what you are looking for. I know it is not Delphi but may you can find it usefull.

jitter

Instead of shooting where I was, you should have shot where I was going to be. - Lrrr (Planet Nintendio64)