.NET stand and Oracle 2

[amberlynn]

Hello,
I'm using VB.NET 2003 Standard edition. All my work has been with SQL Server in the past.
I now have to switch and use Oracle.
When I try to make a connection to Oracle, I'm told that I can only use SQL or Access with the Standard Version.
Is there any way around this?
I'm trying to find a cost to upgrading to VB.NET 2003 Professional, but I can only see Visual Studio 2003 Professional, which is a big leap in cost, and though I can see it is there, I can't actually find anywhere to buy anything other than 2005.
Any advice?
Cheers,
Amber

 

[earthandfire]

I may be wrong - I have never tried to connect to Oracle, but as far as I am aware you should not have any problems connecting.

The built in Wizards may not support Oracle, but there should be no problems if you use your own connection string.

Have a look here:

http://www.connectionstrings.com/?carrier=oracle

or here:

http://www.carlprothman.net/Default.aspx?tabid=81

Hope this helps.

 

[chrissie1]

Yep it is only the wizards that won't work for the rest there is no problem. So stop using the wizards.

Christiaan Baes
Belgium

"My old site" - Me