Incorrect syntax near the keyword 'DEFAULT'

[Mark Findlay]

Hello Experts!

I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
ASP.NET C# web page to perform a simple validation, but receive the
following error:

"Incorrect syntax near the keyword 'DEFAULT'"

The form has 2 fields on it, called tb_username and tb_password. (see code
snippet below).
The SQL Server table is called _users and has a number of columns, 2 of
which I am reading: username and password.

I've searched the net for any clues on this but so far none of the items
I've found were relavent to what I was doing. Can anyone shed any light on
this?

Many thanks!

=== here is my code ====

private bool ValidateLogin()
{
// set the connection string
oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;

// add parameters to the query
oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text); oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text); oleDbCommand_lo gin.CommandText = "Select username from _users whereusername=? AND password=?"; // open the connection oleDbConnection _login.Open(); // execute the query oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults = oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here // close the connection oleDbConnection _login.Close(); if (objResults==nu ll) { return false; } return true;}

[Cor Ligthert [MVP]]

Re: Incorrect syntax near the keyword 'DEFAULT'

Mark,

I would set in your place your command statement in a try block than you get
probably more information.

I had once this behaviour as well and than there was asked for 3 parameters.

I added a dummy one at the end and my problem was gone.
Until now I don't know the reason for this behaviour.

Cor

[Steven Cheng[MSFT]]

Re: Incorrect syntax near the keyword 'DEFAULT'

Thanks for Cor's inputs.

Hi Mark, if it's the sql statement that cause the error, I'll suggest you
turn on the sql profiler at the sqlserver side to monitor the actually
executed sqlstatement. And you can compare it with the correct one (which
you can get executed correctly in SQL Query Analyzer).

Hope also helps. If still anything unclear or need any further assistance,
please feel free to post here.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "Cor Ligthert [MVP]" <notmyfirstname @planet.nl>
| References: <eU$FdPklFHA.35 44@TK2MSFTNGP15 .phx.gbl>
| Subject: Re: Incorrect syntax near the keyword 'DEFAULT'
| Date: Mon, 1 Aug 2005 06:58:11 +0200
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Response
| Message-ID: <utLNKXllFHA.35 68@TK2MSFTNGP10 .phx.gbl>
| Newsgroups:
microsoft.publi c.dotnet.framew ork.adonet,micr osoft.public.do tnet.languages. c
sharp
| NNTP-Posting-Host: ip3e830773.spee d.planet.nl 62.131.7.115
| Path: TK2MSFTNGXA01.p hx.gbl!TK2MSFTN GP08.phx.gbl!TK 2MSFTNGP10.phx. gbl
| Xref: TK2MSFTNGXA01.p hx.gbl
microsoft.publi c.dotnet.langua ges.csharp:1133 90
microsoft.publi c.dotnet.framew ork.adonet:3323 8
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
|
| Mark,
|
| I would set in your place your command statement in a try block than you
get
| probably more information.
|
| I had once this behaviour as well and than there was asked for 3
parameters.
|
| I added a dummy one at the end and my problem was gone.
| Until now I don't know the reason for this behaviour.
|
| Cor
|
|
|

[Ignacio Machin \( .NET/ C# MVP \)]

Re: Incorrect syntax near the keyword 'DEFAULT'

Hi,

Where is "DEFAULT" ? I see it nowhere in your code

Are you using a trigger?

what if you run this in the SQL query analyser?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation



"Mark Findlay" <mfindlay@speak easy.org> wrote in message
news:eU$FdPklFH A.3544@TK2MSFTN GP15.phx.gbl...[color=blue]
> Hello Experts!
>
> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
> ASP.NET C# web page to perform a simple validation, but receive the
> following error:
>
> "Incorrect syntax near the keyword 'DEFAULT'"
>
> The form has 2 fields on it, called tb_username and tb_password. (see code
> snippet below).
> The SQL Server table is called _users and has a number of columns, 2 of
> which I am reading: username and password.
>
> I've searched the net for any clues on this but so far none of the items
> I've found were relavent to what I was doing. Can anyone shed any light on
> this?
>
> Many thanks!
>
> === here is my code ====
>
> private bool ValidateLogin()
> {
> // set the connection string
> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>
> // add parameters to the query
> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text);
> oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text);
> oleDbCommand_lo gin.CommandText = "Select username from _users
> whereusername=? AND password=?"; // open the connection
> oleDbConnection _login.Open(); // execute the query
> oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults =
> oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
> close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
> { return false; } return true;}[/color]

[Paul Clement]

Re: Incorrect syntax near the keyword 'DEFAULT'

On Sun, 31 Jul 2005 19:51:04 -0700, "Mark Findlay" <mfindlay@speak easy.org> wrote:

¤ Hello Experts!
¤
¤ I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
¤ ASP.NET C# web page to perform a simple validation, but receive the
¤ following error:
¤
¤ "Incorrect syntax near the keyword 'DEFAULT'"
¤
¤ The form has 2 fields on it, called tb_username and tb_password. (see code
¤ snippet below).
¤ The SQL Server table is called _users and has a number of columns, 2 of
¤ which I am reading: username and password.
¤
¤ I've searched the net for any clues on this but so far none of the items
¤ I've found were relavent to what I was doing. Can anyone shed any light on
¤ this?
¤
¤ Many thanks!
¤
¤ === here is my code ====
¤
¤ private bool ValidateLogin()
¤ {
¤ // set the connection string
¤ oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
¤
¤ // add parameters to the query
¤ oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text); oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text); oleDbCommand_lo gin.CommandText = "Select username from _users whereusername=? AND password=?"; // open the connection oleDbConnection _login.Open(); // execute the query oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults = oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here // close the connection oleDbConnection _login.Close(); if (objResults==nu ll) { return false; } return true;}

Unless that's a typo in your post, a blank space is omitted between the WHERE keyword and username
column name. I don't see the keyword DEFAULT in that statement.


Paul
~~~~
Microsoft MVP (Visual Basic)

[Franky]

RE: Incorrect syntax near the keyword 'DEFAULT'


username and password need single quotes around values, something like this:

oleDbCommand_lo gin.CommandText = "Select username from _users where
username='myuse rname' AND password='mypwd '"; // open the connection

"Mark Findlay" wrote:
[color=blue]
> Hello Experts!
>
> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
> ASP.NET C# web page to perform a simple validation, but receive the
> following error:
>
> "Incorrect syntax near the keyword 'DEFAULT'"
>
> The form has 2 fields on it, called tb_username and tb_password. (see code
> snippet below).
> The SQL Server table is called _users and has a number of columns, 2 of
> which I am reading: username and password.
>
> I've searched the net for any clues on this but so far none of the items
> I've found were relavent to what I was doing. Can anyone shed any light on
> this?
>
> Many thanks!
>
> === here is my code ====
>
> private bool ValidateLogin()
> {
> // set the connection string
> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>
> // add parameters to the query
> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text); oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text); oleDbCommand_lo gin.CommandText = "Select username from _users whereusername=? AND password=?"; // open the connection oleDbConnection _login.Open(); // execute the query oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults = oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here // close the connection oleDbConnection _login.Close(); if (objResults==nu ll) { return false; } return true;}
>[/color]

[Patrice]

Re: Incorrect syntax near the keyword 'DEFAULT'

AFAIK it uses the default keyword when it finds no mapping. Usually I set
the parameters after the commandtext. Are you sure it doesn't reset the
collection ?

Patrice

--

"Mark Findlay" <mfindlay@speak easy.org> a écrit dans le message de
news:eU$FdPklFH A.3544@TK2MSFTN GP15.phx.gbl...[color=blue]
> Hello Experts!
>
> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
> ASP.NET C# web page to perform a simple validation, but receive the
> following error:
>
> "Incorrect syntax near the keyword 'DEFAULT'"
>
> The form has 2 fields on it, called tb_username and tb_password. (see code
> snippet below).
> The SQL Server table is called _users and has a number of columns, 2 of
> which I am reading: username and password.
>
> I've searched the net for any clues on this but so far none of the items
> I've found were relavent to what I was doing. Can anyone shed any light on
> this?
>
> Many thanks!
>
> === here is my code ====
>
> private bool ValidateLogin()
> {
> // set the connection string
> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>
> // add parameters to the query
>[/color]
oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC h
ar,25,tb_userna me.Text);
oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC h
ar,25,tb_passwo rd.Text); oleDbCommand_lo gin.CommandText = "Select username
from _users whereusername=? AND password=?"; // open the connection
oleDbConnection _login.Open(); // execute the query
oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults =
oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
{ return false; } return true;}

[Mark Findlay]

Re: Incorrect syntax near the keyword 'DEFAULT'

The "DEFAULT" is not part of my code, it is only contained in the error
message.

Thanks,
Mark

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us > wrote
in message news:O2t$z4plFH A.320@TK2MSFTNG P09.phx.gbl...[color=blue]
> Hi,
>
> Where is "DEFAULT" ? I see it nowhere in your code
>
> Are you using a trigger?
>
> what if you run this in the SQL query analyser?
>
> cheers,
>
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>
>
> "Mark Findlay" <mfindlay@speak easy.org> wrote in message
> news:eU$FdPklFH A.3544@TK2MSFTN GP15.phx.gbl...[color=green]
>> Hello Experts!
>>
>> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within
>> my ASP.NET C# web page to perform a simple validation, but receive the
>> following error:
>>
>> "Incorrect syntax near the keyword 'DEFAULT'"
>>
>> The form has 2 fields on it, called tb_username and tb_password. (see
>> code snippet below).
>> The SQL Server table is called _users and has a number of columns, 2 of
>> which I am reading: username and password.
>>
>> I've searched the net for any clues on this but so far none of the items
>> I've found were relavent to what I was doing. Can anyone shed any light
>> on this?
>>
>> Many thanks!
>>
>> === here is my code ====
>>
>> private bool ValidateLogin()
>> {
>> // set the connection string
>> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>>
>> // add parameters to the query
>> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text);
>> oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text);
>> oleDbCommand_lo gin.CommandText = "Select username from _users
>> whereusername=? AND password=?"; // open the connection
>> oleDbConnection _login.Open(); // execute the query
>> oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults
>> = oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
>> close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
>> { return false; } return true;}[/color]
>
>[/color]

[Mark Findlay]

Re: Incorrect syntax near the keyword 'DEFAULT'

Sorry Paul, that's just a typo in my message. There is in fact a space
between WHERE and the where clause.

Thanks,
Mark

"Paul Clement" <UseAdddressAtE ndofMessage@sws pectrum.com> wrote in message
news:lm9se1583f 0j62uvubo3ebflf dejqg28pr@4ax.c om...[color=blue]
> On Sun, 31 Jul 2005 19:51:04 -0700, "Mark Findlay"
> <mfindlay@speak easy.org> wrote:
>
> ¤ Hello Experts!
> ¤
> ¤ I am attempting to use the OleDbCommand.Ex ecuteScaler() function within
> my
> ¤ ASP.NET C# web page to perform a simple validation, but receive the
> ¤ following error:
> ¤
> ¤ "Incorrect syntax near the keyword 'DEFAULT'"
> ¤
> ¤ The form has 2 fields on it, called tb_username and tb_password. (see
> code
> ¤ snippet below).
> ¤ The SQL Server table is called _users and has a number of columns, 2 of
> ¤ which I am reading: username and password.
> ¤
> ¤ I've searched the net for any clues on this but so far none of the items
> ¤ I've found were relavent to what I was doing. Can anyone shed any light
> on
> ¤ this?
> ¤
> ¤ Many thanks!
> ¤
> ¤ === here is my code ====
> ¤
> ¤ private bool ValidateLogin()
> ¤ {
> ¤ // set the connection string
> ¤ oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
> ¤
> ¤ // add parameters to the query
> ¤
> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text);
> oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text);
> oleDbCommand_lo gin.CommandText = "Select username from _users
> whereusername=? AND password=?"; // open the connection
> oleDbConnection _login.Open(); // execute the query
> oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults =
> oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
> close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
> { return false; } return true;}
>
> Unless that's a typo in your post, a blank space is omitted between the
> WHERE keyword and username
> column name. I don't see the keyword DEFAULT in that statement.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)[/color]

[Mark Findlay]

Re: Incorrect syntax near the keyword 'DEFAULT'

I tried moving the parameters after the commandtext and still receive the
same error.

Thanks,
Mark

"Patrice" <nobody@nowhere .com> wrote in message
news:e0pZ8rqlFH A.2988@TK2MSFTN GP10.phx.gbl...[color=blue]
> AFAIK it uses the default keyword when it finds no mapping. Usually I set
> the parameters after the commandtext. Are you sure it doesn't reset the
> collection ?
>
> Patrice
>
> --
>
> "Mark Findlay" <mfindlay@speak easy.org> a écrit dans le message de
> news:eU$FdPklFH A.3544@TK2MSFTN GP15.phx.gbl...[color=green]
>> Hello Experts!
>>
>> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within
>> my
>> ASP.NET C# web page to perform a simple validation, but receive the
>> following error:
>>
>> "Incorrect syntax near the keyword 'DEFAULT'"
>>
>> The form has 2 fields on it, called tb_username and tb_password. (see
>> code
>> snippet below).
>> The SQL Server table is called _users and has a number of columns, 2 of
>> which I am reading: username and password.
>>
>> I've searched the net for any clues on this but so far none of the items
>> I've found were relavent to what I was doing. Can anyone shed any light
>> on
>> this?
>>
>> Many thanks!
>>
>> === here is my code ====
>>
>> private bool ValidateLogin()
>> {
>> // set the connection string
>> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>>
>> // add parameters to the query
>>[/color]
> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC h
> ar,25,tb_userna me.Text);
> oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC h
> ar,25,tb_passwo rd.Text); oleDbCommand_lo gin.CommandText = "Select username
> from _users whereusername=? AND password=?"; // open the connection
> oleDbConnection _login.Open(); // execute the query
> oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults =
> oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
> close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
> { return false; } return true;}
>
>[/color]

[zdrakec]

Re: Incorrect syntax near the keyword 'DEFAULT'

Try using the parameter names in your command, e.g. "where username =
@user AND password = @pass", rather than the placeholders, "where
username = ? AND password = ?". I have found that using the question
mark placeholders works for me with ODBC, not OLEDB, and that named
parameters have worked for me with OLEDB, but not ODBC.

Hope this is helpful...

zdrakec

[Mark Findlay]

Re: Incorrect syntax near the keyword 'DEFAULT'

I believe I found the solution:

For a select query, I am not allowed to use the format of the
Parameters.Add( ) function I am currently using:
oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text);

Instead, when I used the following format, it all worked fine:
oleDbCommand_lo gin.Parameters. Add("@user",tb_ username.Text);

I believe the explanation lies in the help screen for the Parameters.Add( )
function from the Dynamic Help in Visual Studio.NET. It states:
"Adds an OleDbParameter to the OleDbParameterC ollection given the
parameter name, data type, column length, and source column name."

Notice the end of the text: "source column name". In my usage, I am not
providing the source column name, I am providing the textbox from my webpage
where the parm value is to be read. I'm definitely no expert on VS.NET etc.,
but it would appear from the dynamic help text above that using this form of
Parameters.Add( ) is not appropriate for a select statement. Odd though,
since I pulled my usage out of a textbook.

Thanks for everyone's input. I hope this answer helps anyone else looking
in.

Mark



"Mark Findlay" <mfindlay@speak easy.org> wrote in message
news:eU$FdPklFH A.3544@TK2MSFTN GP15.phx.gbl...
[color=blue]
> Hello Experts!
>
> I am attempting to use the OleDbCommand.Ex ecuteScaler() function within my
> ASP.NET C# web page to perform a simple validation, but receive the
> following error:
>
> "Incorrect syntax near the keyword 'DEFAULT'"
>
> The form has 2 fields on it, called tb_username and tb_password. (see code
> snippet below).
> The SQL Server table is called _users and has a number of columns, 2 of
> which I am reading: username and password.
>
> I've searched the net for any clues on this but so far none of the items
> I've found were relavent to what I was doing. Can anyone shed any light on
> this?
>
> Many thanks!
>
> === here is my code ====
>
> private bool ValidateLogin()
> {
> // set the connection string
> oleDbConnection _login.Connecti onString = C_Constants.g_s DSN;
>
> // add parameters to the query
> oleDbCommand_lo gin.Parameters. Add("@user",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_usern ame.Text);
> oleDbCommand_lo gin.Parameters. Add("@pass",Sys tem.Data.OleDb. OleDbType.VarWC har,25,tb_passw ord.Text);
> oleDbCommand_lo gin.CommandText = "Select username from _users
> whereusername=? AND password=?"; // open the connection
> oleDbConnection _login.Open(); // execute the query
> oleDbCommand_lo gin.Connection = oleDbConnection _login; object objResults =
> oleDbCommand_lo gin.ExecuteScal ar(); <--- errormessage occurs here //
> close the connection oleDbConnection _login.Close(); if (objResults==nu ll)
> { return false; } return true;}[/color]