I succesfully connect to Oracle when the build option is win32.
When I change to WPF desktop and run the program, I get
"Connection error : Sql.ini missing win32client.dll"
I check my sql.ini which is in the appliction path and it has [win32client.dll] section.
My OS is windows 7 and I have Oracle 11g installed.
I also added my application path to the environment variables/path.
From sql.ini :
So, what is really missing?
I strongly need this to proceed.
I ran this command :
For me it is,
Then I created an empty file by notepad and named it "a.udl"
I opened the Properties of the udl file.
I chose "Oracle Provider for OLE DB" from the "Providers" tab.
Then from the "Connections" tab,
I defined the data source, user and password for my oracle database.
I saved the changes.
I opened an empty notepad file and dragged and dropped the a.udl into it
and I saw this :
; Everything after this line is an OLE DB initstring
Provider=OraOLEDB.Oracle.1;Password=myPassWord;Persist Security Info=True;User ID=myUser;Data Source=MyDataSource
I used this string as a connection string :
Set strSessionProperties = "Provider=OraOLEDB.Oracle.1;Password=myPassWord;Persist Security Info=True;User ID=myUser;Data Source=MyDataSource"
Call SqlCreateSession( hSession, strSessionProperties )
and the application now connects to Oracle in WPF Desktop mode.
I did all these after noticing these instructions from the DotNet.pdf book :
Connecting to Oracle
1. When developing WPF applications which go against an oracle database you
must use the Oracle 11gR2 32bit client.
2. The Oracle11gR2 32bit client can be used to go against an oracle10g or oracle11g
3. There is no need to configure an oracle .NET connection as that Team Developer
will automatically map your native and/or OLEDB connections to equivalent
How to configure an oracle OLEDB UDL file:
1. Open the command prompt and register the Oracle 11gR2 32bit OLEDB driver:
2. Launch the "Data Link Properties" dialog for the udl file you want to configure:
Files\System\OLEDB\oledb32.dll", OpenDSLFile "<path to udl
But now, I'm a bit confused
Does this mean that
oracle native connection is oracle ole db connection in .Net?
Or no, I'm just connecting via ole db, this is nothing to do with native connection.
Thanks for any idea.
I found out that
this nothing to do with Oracle.
I was usually connecting to Sql Server via OLEDB.
This time I developed an app to test connections, and I used Sql ODBC.
I got the same error : Connection error : Sql.ini missing win32client.dll
I actullay had that seciton in my sql.ini and I was sure I was accessing the right sql.ini.
I said a "Hmmmm"...
Thought, thought, thought...
Than a "hmmmm" again...
And a quiet voice echoed in my brain :
"Why don't you try it with English regional settings?"
My regional settings is Turkish. Changing it to English, I got rid of this terrible fault
And now I'm switching to the bug reports forum to report this.
Have a nice weekend!
yes, from Turkey
Who is online
Users browsing this forum: [Ccbot] and 0 guests