Question What is wrong with my connection string? [ORACLE]

[networkmancer]

"User Id= " + Options.unamebox.Text & ";Password= " + Options.pwordbox.Text & ";Data Source = " + Options.sourcebox.Text

The error says that I have an invalid username/password. Im sure I am correct because i tried showing them first in a message box before this line.

 

[jmcilhinney]

Have you checked that your format EXACTLY matches one of the examples at http://www.connectionstrings.com?

 

[cjard]

When i write an oracle conn string (every day) I write it like this:

User ID=usernameexample;Data Source=serverexample;Password=passwordexample

Not like this:

User ID= usernameexample;Data Source = serverexample;Password= passwordexample


Also, if youre using OracleCOmmand it's fine not to ahve a provider specifier, but if youre using some interim technology like ODBC/OleDb for Oracle you need a Provider string

If youre using VB Express edition, it cannot conenct to Oracle using the visual designer. If youre using full, proper visual studio you can get it to conenct to Oracle for you and then just look at its connection string: add a new dataset to your project and go throguh the wizard to connect to oracle