Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Source Name not found

Status
Not open for further replies.

Martin55

Programmer
Aug 26, 2000
8
US
When I install my VB program that reads an ACCESS table,
I get the message: &quot;Application c:\WINDOWS...\ODBCCONF.EXE is attempting to call the OCI FUNCTION <opinit> Which does not exist in ORA72.DLL&quot;. My program is not an Oracle program and it does not access an Oracle database.

The program runs fine on my computer it's just when
I try to Install/run it on another that I get problems.

When I try to run my program I get the message:
[Microsoft][ODBC DRIVER MANAGER] Data source name not found and no default driver specified. I specified the datasource in the program, do I have to specify it somewhere else? How do I specify a default driver?

Any help would surely be appreciated.
Marty
 
You need to copy the dsn if you are using one to Program Files\Common\ODBC\Data Sources Peter Meachem
peter@accuflight.com
 
Oh, you mean Data Source Name. Is this a parm I need to add to a file? Or do you mean I need to add my .mdb database file here?
 
How are you connecting to the data? Put your code in the message so we can see it. Peter Meachem
peter@accuflight.com
 
Im using the ADO control and I have my table listed in the ConnectionString property. There's no coding other then the Recordset.MoveNext method. and MovePrevious methods.
 
I am having the same problem currently. Did you ever figure this one out?
 

So, post what is in the ConnectionString!! [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top