OraFAQ Forum: Windows » -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle]

Home » Infrastructure » Windows » -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

-2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101578]

Fri, 17 December 2004 18:32

Rachana Patrikar
Messages: 2
Registered: December 2004

Junior Member

Dear Sir,

I am using VB 6.0 to connect to Oracle and myconnection string is

str = "Provider=MSDASQL.1;Persist Security Info=False;User ID=time;pwd=time;Data Source=hours"

Earlier it was working properly but then, PC on which this application was running got formatted and i am getting this error

-2147467259 error [[Microsoft]][[ODBC driver for Oracle]][[Oracle]]

Can you please help me, its very urgent..............Please!!!

I would be very thankful if i get solution as early as possible.

Thanks and regards

Rachana Patrikar

Report message to a moderator

Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101589 is a reply to message #101578]

Fri, 24 December 2004 01:16

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

This may help:

Connectivity Issue with MDAC and Oracle8i -
http://support.microsoft.com/support/kb/articles/Q264/0/12.asp

If not, try to reinstall the latest version of MDAC.

Best regards.

Frank

Report message to a moderator

Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101593 is a reply to message #101589]

Mon, 27 December 2004 20:18

Rachana Patrikar
Messages: 2
Registered: December 2004

Junior Member

Hi,
Thanks for your kind cooperation. here i would like to extend my problem-- This program was running fine on a PC but then PC got formatted and we need to reinstall everything. now after reinstallation we are having 2-3 oracle homes in that PC like oracle 8i, oracle 9i......Now this program is accessing oracle 7.3 database which is on server.
I am using
str = "Provider=MSDASQL.1;Persist Security Info=False;User ID=timeoff;pwd=timeoff;Data Source=SAPHR"
this connection string......to connect to oracle database.

Also latest MDAC is installed there.

now tell me can you please help me?

thanks and regards.
Rachana.

Report message to a moderator

Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101605 is a reply to message #101578]

Wed, 05 January 2005 00:00

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

Have you confirmed the Oracle homes are correctly installed? eg. Can you sqlplus from each of the oracle homes to your target database?

Have you confirmed the Oracle com interfaces and MDAC has been correctly installed.

Have you created the "Data Source=SAPHR" entry with the MDAC data sources control panel applet, for the data source name linking to the correct Oracle COM driver?

Have you confirmed the TNS alias entry you have used within your Data Sources can be resolved? Test this using sqlplus from each oracle home.

Michael Hartley
Openfield Solutions Ltd.
michael.hartley@openfieldsolutions.co.uk

Report message to a moderator

Re: -2147467259 error [Microsoft][ODBC driver for Oracle][Oracle] [message #101606 is a reply to message #101589]

Wed, 05 January 2005 00:10

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

If you can use oracle 10g then you can use the ODBC instant client installation which involves downloading and installing a *few* files to you local system. See http://www.oracle.com/technology/tech/oci/instantclient/releasenotes/ODBC_IC_ReleaseNotes.html for the instant client release notes.

If you must use a version prior to 10g then you are required to install a full Oracle client to your local system.

Michael Hartley
Openfield Solutions Ltd
www.openfieldsolutions.co.uk

Report message to a moderator

Previous Topic:	problem with install oracle 8i
Next Topic:	DOWNLOAD OF ORACLE 9i PERSONAL EDITION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:04:50 CST 2024