[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

Input string not in correct format in server explorer when expanding tables

Hi
I have setup Oracle ODBC connection.
I can get to it in Data connections via Server explorer in Visual Studio and can see all the tables but,
When I try to expand individual tables to see columns etc. I get the following

Input string not in correct format.

Can someone please tell me why this is occurring and how to fix?

PS. - I tried using the Oracle provider and could not see any tables under this at all.
0
cmrnp
Asked:
cmrnp
  • 2
1 Solution
 
mirzasCommented:
Do you have sufficient permissions ?

Try a different username/password.
0
 
cmrnpAuthor Commented:
I am able to do Select statements against the tables and retrieve data back.
From this, I have been able to get the column names.

I have been given Read access to the database.
0
 
mirzasCommented:
This could be related to localization issues.

0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now