C# Discussion Boards - CodeProject

8-Jul-09 23:00

Hi Please Help me i get this error when i connect to database

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

i use this coding

" SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;

private void login_Click(object sender, EventArgs e)
{
con = new SqlConnection("integrated security = true;Database=orcl8i;Password=creative;User ID=itehad");
cmd = new SqlCommand();
cmd.Connection = con;
cmd.Connection.Open();
cmd.CommandText = "Select * from users";
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (usr.Text == dr["userid"].ToString()) && pass.Text == dr["password"].ToString)
{
MessageBox.Show("User Login", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
else

MessageBox.Show("Login Fail")

Pete O'Hanlon8-Jul-09 23:16

Pete O'Hanlon

8-Jul-09 23:16

I assume that you have a direct link to Code Project on your desktop, and your browser has had the address bar physically torn off it and thrown away in the trash. After all, a quick search returns lots and lots of hits[^] for this. I know that it means you've got some reading to do, but you wouldn't want us to hold your hand for you, now would you?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Luc Pattyn9-Jul-09 9:42

Luc Pattyn

9-Jul-09 9:42

Pete O'Hanlon wrote:
you wouldn't want us to hold your hand for you, now would you?

is that a trick question?

Unsure | :~

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Blue_Boy8-Jul-09 23:26

Blue_Boy

8-Jul-09 23:26

Check if your connectionstring with DB is correct.

check this[^]

I Love T-SQL www.aktualiteti.com
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

mjawadkhatri9-Jul-09 0:00

9-Jul-09 0:00

Can't understand let me explain please Sigh | :sigh:

J4amieC9-Jul-09 0:47

J4amieC

9-Jul-09 0:47

I might be mistaken, but is:

mjawadkhatri wrote:
integrated security = true;Database=orcl8i;

really a SQL Server database?

mjawadkhatri9-Jul-09 0:54

9-Jul-09 0:54

no is a oracle database

Pete O'Hanlon9-Jul-09 1:01

Pete O'Hanlon

9-Jul-09 1:01

Then, supplying a SQL Server connection string isn't going to help you. Oracle connection strings typically look like:

Data Source=oracledb;User ID=userid;Password=password;Min Pool Size=2;Connection Lifetime=60;Connection Timeout=60; Incr Pool Size=5; Decr Pool Size=2

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

mjawadkhatri9-Jul-09 1:21

9-Jul-09 1:21

Thanks For Given b great response
bt when i use your given code i get this Error
Keyword not supported: 'incr pool size'
please help me Pete O'Hanlon.

Pete O'Hanlon9-Jul-09 1:25

Pete O'Hanlon

9-Jul-09 1:25

Where to start? First of all, you are connecting to Oracle but you are using Sql Server classes in your code. You need to use the appropriate Oracle drivers, rather than SQL Server, and use the Oracle classes such as OracleConnection. Download, and have a look at, the ODP.NET providers from Oracle.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

mjawadkhatri9-Jul-09 1:50

Help Please Email Text Box

9-Jul-09 1:50

okk.
thank u so much sir.

Danie de Kock8-Jul-09 22:21

Danie de Kock

8-Jul-09 22:21

Hi I'm looking for a textbox/richtextbox/something that can open a email body.
The Email can be in html/txt/office format.
Must also be editable. Example: The Textbox in outlook
In C#

Re: Help Please Email Text Box

Danie de Kock9-Jul-09 0:18

Danie de Kock

9-Jul-09 0:18

found it

Re: Help Please Email Text Box

K03069-Jul-09 1:56

K0306

9-Jul-09 1:56

If you found the solution for your problem, then Post the solution here, it will help to someone.

Regards,
Karthik K...

changing brightness in video player?

kukoc8-Jul-09 22:15

kukoc

8-Jul-09 22:15

hi
im workin for last few days on possibility to modify brightness or contrast in my video player (avi, mpeg, wmv)
i was tryin with
- DirectX.AudioVideoPlayer
- Direct Show and Video Mixing Renderer
- Windows Media Player Component

in every case im able to play, pouse, stop, mute video and so on. but i stuck with controlling of brightness.

in AVP i havent find anything to workout.
in DS i found DirectShowNet library and with its help i tried to use ProcAmp Control Processing. but i fall into two errors - first 80040273 (VFW_E_DDRAW_CAPS_NOT_SUITABLE) happened becouse im using pivot monitor in vertical mode, so when i come back to horizontal - error gone. Second error 0x80040299 (VFW_E_VMR_NO_PROCAMP_HW) showed me that my hardware doesnt support ProCamp - strange.
so i decided to try WMP component and again found nothing about brightness/contrast settings, well exactly i found that this component doesnt provide VideoSettings. there is something about IWmpVideoSettingsCtrl interface but nobody knows how to find it. after another few hours of googling i found comertial component named "WMPEx" which provide wide functionallity of WMP, but it cost $1600 (lol), there is a free version of WMPEx but it only supports changing of hue.

and now i have no more ideas how to solve this problem.
please take a look at this. i hope that someone figured out it and found the solution.

regards kukoc

Re: changing brightness in video player?

kukoc9-Jul-09 22:27

kukoc

9-Jul-09 22:27

bump

VC++

Satish Pai8-Jul-09 21:09

Satish Pai

8-Jul-09 21:09

Hi Experts

I want to Create a Virtual Dive same as M-files (http://www.m-files.com/eng/res/flashoverview/intro.swf[^])

My problem is i am new to this Hooking,Win32 Projects etc . I would like to know how can i get my Window
when i go to my virtual Drive & that window has my usercontrol

Thanks

stancrm8-Jul-09 21:19

stancrm

8-Jul-09 21:19

?? This is a C# forum..

Rajesh R Subramanian8-Jul-09 22:24

Rajesh R Subramanian

8-Jul-09 22:24

The correct answer is Liquid Nitrogen, buddy.

Not only have you posted a C++ query on the C# board, but your query is so awfully vague, so please DO NOT post it on the C++ forum before you read the guidelines[^] and rephrase your query accordingly.

It is a crappy thing, but it's life -^ Carlo Pallini

Huxley Stronghead9-Jul-09 4:45

Huxley Stronghead

9-Jul-09 4:45

Yeah, I have to wonder about things like that too. People doing such a funny are not really working for some software house, right?

Don't get me wrong! I just trying to understand my own market value here, before I actually apply myself for some position.

Rajesh R Subramanian9-Jul-09 5:16

Rajesh R Subramanian

9-Jul-09 5:16

Huxley Stronghead wrote:
Yeah, I have to wonder about things like that too. People doing such a funny are not really working for some software house, right?

Don't get me wrong! I just trying to understand my own market value here, before I actually apply myself for some position.

I'm afraid I didn't understand what you said.

It is a crappy thing, but it's life -^ Carlo Pallini