DBBrowser and ODBC Error

More
3 years 2 days ago #22791 by SchiDie
Hi ther,

I'm using DBBrowser portable for many years and I find it a really great tool.
I worked with direct connections to Oracle and PostgreSQL and it worked fine so far.
Yesterday I tried to open an ODBC Connection to Oracle and I got errors:
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another"
A double crosscheck with excel (32bit) worked fine, another crosscheck with excel and Postgresql works fine, too
So does anybody have a hint for me what the problem could be with DBBrowser and odbc?

Thx in advance

Dieter

Please Log in or Create an account to join the conversation.

More
3 years 2 days ago #22792 by Peter.Jonson
Can you clarify this one please "I tried to open an ODBC Connection to Oracle"

Please also have a look at this list

learn.microsoft.com/en-us/sql/ado/guide/...iew=sql-server-ver16

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 11 months ago #22800 by SchiDie
Replied by SchiDie on topic DBBrowser and ODBC Error
Maybe it's because I'm no native speaker , so pls excuse my bad English.
I'll try once again:
I have an OBDC-Connection to a certain Oracle database on my computer. To this odbc-connection I added a connection within DBBrowser., testing connection works fine (pic1)
Clicking on the connection, the table list appears.
But then no sql-statement works.... the error message is always the same
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another"
A simple "select count(*) from "edms_config" doesn't work at all and be asured the table "edms_config" (1 row)  exists.(thx so far for the link)

Now I figured out, that is no specific oracle-problem; with postgresql it's the same, not even a connection to access database works, error message still the same

I hope, I could clarify my problem?

Thx

Dieter
 
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 11 months ago #22801 by Peter.Jonson
Here are my screenshots

Using Windows 10 and the language is English.




It might have something to do with the regional settings of your computer. (Default language, formats etc)

Can you post screenshots of regional settings, please?
Also, are you able to see the list of the tables on the right?
Please post more screenshots (jpegs) 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save