Hi,
I got to the point where with both SQL Express and Oracle Express 10g I
could see my data in VB6 but it was read only.
As I was about to give up, I decided to rewrite my application 100 in Python
and found this link:
http://www.time-travellers.org/shane/howtos/MS-SQL-Express-Python-HOWTO.html
It worked right away with python so I decided to try again with VB6, but
using that driver: got it to work with SQL Express then Oracle Express 10g.
Hope that helps,
Philippe
Dave Baker wrote:
> 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 Fri Mar 24 2006 - 06:57:02 CST
