Check if a DSN is there or not

Hi All,

Is there any way to get VB to test whether there is a DSN already created?

I am using rdoEngine.rdoRegisterDataSource to create one, but I only want it to run if there is no DSN, as I don't want it to overwrite the existing one (because it may be using a different driver).

Thanks in advance

At your program startup, browse thru all DSNs on the computer (use function in "ODBC32.DLL"), compare your DSN name with these DSNs then you can tell whether the DSN is created already or not.

Regards,
TheBao