Article View: borland.public.cppbuilder.database.ado
Article #3384Re: Oracle: Test connection does not work
From: Kim Hellan
Date: Fri, 06 Sep 2002 10:48
Date: Fri, 06 Sep 2002 10:48
75 lines
3329 bytes
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-mailReferences:
<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