Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-20
3
Medium Priority
?
548 Views
Last Modified: 2013-11-27
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
Comment
Question by:cmrnp
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
mirzas earned 750 total points
ID: 22755863
Do you have sufficient permissions ?

Try a different username/password.
0
 
LVL 1

Author Comment

by:cmrnp
ID: 22755894
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
 
LVL 6

Expert Comment

by:mirzas
ID: 22755903
This could be related to localization issues.

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question