Using ODBCCONF.EXE

[Amit]

Can we register the database driver for ASA 9 using
ODBCConf.exe and then connect to the database by deploying
the runtime files?

Can anyone help me with the syntax?

[Roland Smith [TeamSybase]]

Here is the Microsoft documentation:
http://msdn.microsoft.com/en-us/library/ee388579(VS.85).aspx

You will need to run the program with my RunAndWait object:
http://www.topwizprogramming.com/freecode_runandwait.html

The built-in Run() function doesn't wait for the external program to finish.

If it were me, I would just use RegistrySet to set the values.

<Amit> wrote in message news:4a9fe37c.6c...@sybase.com...

[Amit]

What registry keys do I need to set? I can look at my
machines registry and then set them at my end users machine.

[Roland Smith [TeamSybase]]

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 9.0

There are two values under this key ( Driver & Setup ) that need the full
path of dbodbc9.dll

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

Add a value named "Adaptive Server Anywhere 9.0" with a value "Installed"

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

Add a value named "myprofilename" with a value "Adaptive Server Anywhere
9.0"

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\myprofilename

I think the only values under this key that are needed are DataBaseFile,
Driver and Start. You'd have to experiment to be sure.