🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3384

Re: Oracle: Test connection does not work

#3384
From: Kim Hellan
Date: Fri, 06 Sep 2002 10:48
75 lines
3329 bytes
The docs doesn't say much, other than "Use logging facilities to locate the
error".
Searching Google I found some posts mentioning, that if the path to the
application (thats calling up the OLE DB provider dialog) was too long or
the computer name of the server contained special characters, then this
error could occur ???

I tried moving my appl. to C:\myapp.exe, and then it worked.

Kim


"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
news:3d773a66@newsgroups.borland.com...
> I have no Oracle now but look for description of ORA-06413 error in Oracle
> documentation.
>
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to work with MS SQL Server and MS Jet databases.
>
> "Kim Hellan" <khe@NOSPAMdksign.dk> �������/�������� � �������� ���������:
> news:3d75f40a@newsgroups.borland.com...
> > I think I did set it all.
> > All you can set in the Microsoft OLE DB provider is:
> > - Database name (which I set to the Net8 service name)
> >   If I specify a non existing service name here, I get another error.
> > - User (set to 'scott')
> > - Password (set to 'tiger')
> >
> > I don't know what else to set?
> >
> > TIA,
> > Kim
> >
> >
> > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> > news:3d75e084@newsgroups.borland.com...
> > > You did not set all necessary properties such as database name, user
> name,
> > > password etc.
> > >
> > >
> >
> > >> "Kim Hellan"
> > > > I'm a newbie regarding ADO..
> > > >
> > > > I have made a simple BCB6 application using ADO.
> > > > The application is running on a Windows 2000 Server with an Oracle
> 8.0.5
> > > > client.
> > > > I use the PromptDataSource() function to call up the Data Link
> > Properties
> > > > dialog.
> > > >
> > > > When I try to create the connection string and test the connection
> > > (against
> > > > an Oracle 8.0.5 database) , I get a:
> > > > "Test connection failed because of an error in initializing
provider.
> > > > ORA-06413: Connection not open."
> > > >
> > > > What am I missing?
> > > >
> > > > TIA,
> > > > Kim
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <3d78880a$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3d751fc1@newsgroups.borland.com> <3d75e084@newsgroups.borland.com> <3d75f40a@newsgroups.borland.com> <3d773a66@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,a7d29c19d01f972b
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-06 05:28:09 PST
From: "Kim Hellan" <khe@NOSPAMdksign.dk>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d751fc1@newsgroups.borland.com> <3d75e084@newsgroups.borland.com> <3d75f40a@newsgroups.borland.com> <3d773a66@newsgroups.borland.com>
Subject: Re: Oracle: Test connection does not work
Date: Fri, 6 Sep 2002 12:48:41 +0200
Lines: 77
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 131.165.63.132
Message-ID: <3d78880a$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1031309322 131.165.63.132 (6 Sep 2002 03:48:42 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail