Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?

Easysoft ODBC-ODBC Bridge

Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?

Article :	00105
Last Reviewed :	19th July 2005
Revision :	1

isql and DataManager (in unixODBC 1.8.8 and prior versions at least) call SQLConnect passing a database username and password even if you do not specify them. isql, takes two optional arguments after the DSN which are the database username and database password. If you omit them then isql passes empty strings to OOB which believes a username and password were specified and hence does not pull the TargetUser and TargetAuth out of the DSN.

If your ODBC driver requires a username and password and you are using isql or DataManager you must specify them either on the command line or in the dialogue DataManager pops up.

Applies To

Products
- Easysoft ODBC-ODBC Bridge
Interfaces
- ODBC

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-ODBC Bridge

Why do I get ODBC driver authentication denied when using unixODBC's isql and DataManager?

Applies To

Knowledge Base Feedback