Re: VB6 pro & oracle express 10g

On Thu, 23 Mar 2006 16:14:29 -0600, Philippe Martin <pmartin_at_snakecard.com> wrote:

>PS: I'm about to purchase visual studio 2005 but did notice that VB .NET
>express did not offer any oracle option in the connection dialog.

Do you have the Oracle Client installed? I used this tutorial to get me started with VB.Net 2005 Express: http://www.oracle.com/technology/pub/articles/cook_dotnet.html

However, I also have an existing VB5 application which I have to decide whether to port to VB.Net or whether it will work with Oracle 10G XE. All I need to do is to read the data from the table. So, I interested in hearing that you managed to get VB6 to read Oracle 10G XE tables. Hopefully I will be able to do the same. I whipped up a quick VB5 project but got stuck. I have a working VB.Net connection string, but when I use the exact same connection string in VB5 (same computer, same Oracle database) I get an error: [ODBC Driver Manager] Data source name too long

So, I've temporarily given up there.

VB5 connection string is:

    oradb = "Data Source=(DESCRIPTION=" _

       + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" & IPAddress & ")(PORT=1521)))" _

       + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)));" _
       + "User Id=SYSTEM;Password=opswd;"

This exact string works perfectly under VB.Net Received on Thu Mar 23 2006 - 20:27:28 CST