Beginning VB... trying to connect to Oracle (UNIX-based)

[tsosiel]

Greetings....

I have the following problem. I have an account on a UNIX server that has SQL (SQL-PLUS); I created a front end using VB.net... But I cannot connect to the UNIX/SQL server to access the data!!!

I'm not sure what information I need in my connection string... but I'm open to suggestions!!! If possible, I'd like to know for DAO and ADO....

Thank you for your responses.

- Lorentz

 

[RiverGuy]

To make a connection string, what you should do is add an OleDBConnection to your project, then use the steps it prompts you to make your connection. You will then be able to see the code that it has generated for you with the string. That would be for ADO.Net.

 

[chiph]

You also need to make sure your machine has the Oracle client software on it. The OleDb classes just act as a wrapper around it.

You might also think about using the Oracle .NET provider (if you're on 9i), as it's much faster than the OleDb provider.

Chip H.

 

[tsosiel]

Thanks for the input. I will look into the suggestions.

- Lorentz