I'm new to advanced installer and I have not figured out how to get the odbc connection setup to work. I try to import an exisiting System DSN ODBC connection and when I run my installer, it always fails with error 8 regarding invalid keyword pairs. Any one have a set of instructions to follow to setup a simple SQL Server ODBC link in advanced installer?
Thanks.
Suggested Articles
Re: ODBC Setup
Hi,
Please note that the Windows Installer ODBC engine cannot use attributes like UID and PWD because they are considered security risks. Try removing this type of attributes from your project and let me know if the problem persists.
Regards,
Cosmin
Please note that the Windows Installer ODBC engine cannot use attributes like UID and PWD because they are considered security risks. Try removing this type of attributes from your project and let me know if the problem persists.
Regards,
Cosmin
Re: ODBC Setup
I'm still having the same problem. I removed the UID and the fields I'm left with are app, database, network, trusted_connection. What am I missing?
Re: ODBC Setup
Hi,
Please note that the "trusted_connection" attribute is related to authentication (like UID and PWD), so it should be removed. If the problem persists, try removing other attributes until you find the ones which cause the problem.
Regards,
Cosmin
Please note that the "trusted_connection" attribute is related to authentication (like UID and PWD), so it should be removed. If the problem persists, try removing other attributes until you find the ones which cause the problem.
Regards,
Cosmin