Thanks for your supply of this query tool. It is a good tool for us to use. But I get a problem about ODBC connect listed below.
In ODBC connect string tab, I input text => "Provider=IBMDADB2.1;Password=sitst2;User ID=sitst2;Data Source=T2MM" and push connect button. But system show error:Unable to connect:Error [IM002][Microsoft][ODBC driver...]can't find data source name and not define default driver. (Sorry, I use Chinese language and do my best to translate to English).
So, what is the problem ? Is the format error or else? Thanks for your help.
PS:I have already setup in ODBC user data source.
Best regards,
Wood.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I find the format and test is ok. It should like "DSN={ODBC Name};UID={user};PWD={password}".
And I have a suggestion. For easy to use, please add a simple example or format in the blank of ODBC tab. This will help users to setup connection string. Thanks.
Best regards,
Wood.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, Sir,
Thanks for your supply of this query tool. It is a good tool for us to use. But I get a problem about ODBC connect listed below.
In ODBC connect string tab, I input text => "Provider=IBMDADB2.1;Password=sitst2;User ID=sitst2;Data Source=T2MM" and push connect button. But system show error:Unable to connect:Error [IM002][Microsoft][ODBC driver...]can't find data source name and not define default driver. (Sorry, I use Chinese language and do my best to translate to English).
So, what is the problem ? Is the format error or else? Thanks for your help.
PS:I have already setup in ODBC user data source.
Best regards,
Wood.
Hi, Sir,
I find the format and test is ok. It should like "DSN={ODBC Name};UID={user};PWD={password}".
And I have a suggestion. For easy to use, please add a simple example or format in the blank of ODBC tab. This will help users to setup connection string. Thanks.
Best regards,
Wood.
I am still havong trouble connecting with ODBC string.
In Quesry Express I used this line:
Provider=SLXOLEDB.1;Password=password;Persist Security Info=True;User ID=Admin;Initial Catalog=PASHSLX;Data Source=SERVERNAME;Extended Properties="PORT=1706;LOG=ON;CASEINSENSITIVEFIND=ON;AUTOINCBATCHSIZE=1"
It does not work in QueryExpress Plus
This is a simple string that I use. It refers to a DSN already set up.
This works. No quotes or braces.
DSN=indepLocal;Uid=;Pwd=;