|
Hi,
I'm making an OleDbConnection using the Sybase ASE OLE DB Provider with the following code:
_____________________________________________________________________
OleDbConnection oDbConn = new OleDbConnection(sConnectionString);
OleDbCommand oCmd = new OleDbCommand("SELECT * from master.table;", oDbConn);
OleDbDataAdapter oData = new OleDbDataAdapter(oCmd.CommandText, oConn);
DataTable oTable = new DataTable("master.table");
oData.Fill(oTable);
__________________________________________________________________
The database I'm connecting to -requires- a semi-colon at the end of the SELECT command. I've tried ending my SELECT with a semi-colon (see above) but one of my OleDb objects is removing it before it is sent to the database as I can see the following databas error when running my program:
SQL Parser: parse error at line 1.
Command: SELECT * from master.table
Issued by:
How do I control the SQL statements sent to the database via the OleDbConnection so I can add a semi-colon to my SELECTs??
TIA,
Matt
|
|
|
|
|
could you explain why you need a ';'
and also see if you can use a stored procedure to achieve the same.
Bhaskara
|
|
|
|
|
I'm sure we'll be more likely to help with your homework if you first learn how to type. Actually, on second thoughts, we probably won't. Do your own homework, and let us know when you get stuck. Once it looks like you've made some effort, I'm sure many people will be glad to help you if you get stuck.
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
wgdesigner wrote:
I think u don't have any knowledge
Well, for starters, I can spell. That puts me ahead of you. And I could care less what you think. Who the hell are you ?
wgdesigner wrote:
and u don't want help anybody without ur profit...
You're right. That's why I was reading the questions forum in the first place, why I write articles here, and why I suggested that I'd be happy to help you if you were willing first to try and do your own homework. Idiot.
wgdesigner wrote:
By the way if u don't want to help then it is not matter but don't try to be oversmart bzz ur not!!!!
bzz ur not ? Man, are you this stupid, or do you think that being unable to spell makes you cool ?
wgdesigner wrote:
I want to find out the two record in database first and last record without veiwing the database tell me
Why would I tell you ? Because I 'know nothing', or because you've just been insulting me ?
wgdesigner wrote:
iam a graduate in computer science understood...
You're a graduate but you can't spell and you can't string together a simple SQL query ? I doubt it.....
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
Would you like to be forcefully removed from the site? Based on the professionalism you've shown in your last post, I seriously doubt you have a degree in Computer Science. And if you do, I question the quality of the institution where it came from.
Oh! This is my one SQL statement to get me in the door here:
SELECT * FROM myTable WHERE myID LIKE 'WhoCares!'
Now, back to your question. I can't make heads or tails of what your asking. Ideas about what? All you said was you have a bank with a central server and a bunch of other banks that connect to it once a day. To do what?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
 He swears just fine in English, doesn't he?
Sounds like the trailer-trash I live next to.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yeah, I got an autoreply on an abusive post he made to me, he seems since to have packed up his trailer and moved on 
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
We currently use the .net SQL Server managed data provider for database access, but we are looking at possibly extending our app support to Oracle. The .net Oracle managed data provider looks like a good solution, but it brought up some questions. What support does Oracle provide for a GUID data type? What versions of Oracle support this? We notice that the Oracle data reader has the same GetGuid() SetGuid() that SQL Server provides, but are not sure how it is implemented in an actual Oracle table.
So if anyone has any info on this (or can give us a juicy link with this info) us non-Oracle guys would appreciate it!
Michael
Developer, Author, Chef
|
|
|
|
|
We are having a bit of a problem with a remote client using our software to access a JET database via ado.
I've got a few hunches on what the problem might be but I need to test this on a machine with an older MDAC and JET provider setup.
Does anyone know if Microsoft still have download sites for older service packs of the JET 4.0 files?
I Dream of Absolute Zero
|
|
|
|
|
You can't get just the JET stuff, you have to install the entire MDAC. You can do to http://download.microsoft.com[^] and search for the keyword MDAC to get the eariler versions.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
Hi there,
Have an app which uses SQLXML to provide a webservice interface to my SQLServer DB.
Have a stored procedure declared:
<br />
CREATE PROCEDURE GetSurveyCompanies<br />
<br />
@SurveyCompanyID integer = 1<br />
<br />
AS<br />
<br />
Declare @SQL NVARCHAR (4000)<br />
<br />
set @SQL = 'SELECT * FROM SurveyorCompany WHERE IDSurveyorCompany='<br />
<br />
set @sql = @sql + CAST (@SurveyCompanyID as VARCHAR(2)) + ' FOR XML AUTO'<br />
<br />
exec sp_executesql @sql<br />
<br />
And am calling it using the SOAP toolkit from VB6 using the following...
<br />
oClient.GetSurveyCompanies(1)<br />
(Have omitted the rest of the setup - sure it's OK)
When calling speciying the param, everything is OK (apart from the XML coming back garbled, but think that's a different issue!), but when I attempt to use the default param value specified in the sproc, am getting Invalid procedure call - the SOAP CLient is reporting that "incorrect number of parameters supplied" (predictably!)
Question is, how do I use the default value - have tried passing in NULL (type mismatch), Nothing (same error), and even 'NULL', but nothing seems to work - any ideas anyone?
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Hi,
I have an application running on a server. I have ported this application to other server but it gives me the above error Sql Server does not exists or access denied error.I would like to know if i have to make any changes to the connection string.
Can any one help.
Thanks in advance,
Nitin.
|
|
|
|
|
You posted this in the asp.net section as well. Gave you an answer there.
|
|
|
|
|
Greeting from Malaysia
i am a beginner in VB.NET. Please how do I check the duplicate records in the database? For example, I have a table called category in SQL server. This table
contains with CategoryID and Category.
In the front end I created a form that contains only 2 textbox. One is for the category ID that the ID is auto generated and the other textbox is for the user to enter the categoris(ed. adult, kids, comedy,.......) . So, how do I check if the user enters the category that already exists in the category table in the SQL Server. Please help!
Have a nice day!
Thanks and regards,
Vivian 
|
|
|
|
|
this should solve ur problem.
the value of ExecuteScalar should be checked.
Dim strCheck = "Select Count(*) from Employeemaster where Name = '" & txtEmpName.Text.Trim & "'"
Dim sqlINQry As String
Dim sqlINcmd As SqlCommand
Dim varSiteAdmin As Int32
If chkSiteAdmin.Checked = True Then
varSiteAdmin = 1
Else
varSiteAdmin = 0
End If
Try
Sqlcon = New SqlConnection(ConfigurationSettings.AppSettings("conString2"))
Sqlcon.Open()
sqlINcmd = New SqlCommand(strCheck, Sqlcon)
If sqlINcmd.ExecuteScalar() = 0 Then
sqlINQry = "Insert into EmployeeMaster " & _
"(DepartmentID,UserType,Name,Password,Moth_Maid_Name,Designation,Email, " & _
"Mobile,Phone,Fax,SiteAdmin,Status)Values (23,1," & _
"'" & txtEmpName.Text.Trim & "', " & _
"'" & txtPassword.Text.Trim & "'," & _
"'" & txtMotMaidName.Text.Trim & "'," & _
"'" & txtDesignation.Text.Trim & "'," & _
"'" & txtEmail.Text.Trim & "'," & _
"'" & txtMobile.Text.Trim & "'," & _
"'" & txtPhone.Text.Trim & "'," & _
"'" & txtFax.Text.Trim & "'," & _
"'" & varSiteAdmin & "'," & "0)"
sqlINcmd = New SqlCommand(sqlINQry, Sqlcon)
sqlINcmd.ExecuteNonQuery()
Response.Redirect("SelectEmployee.aspx")
Else
lblAddNew.Text = "Record already exists"
Exit Sub
|
|
|
|
|
Am sure this would solve the problem. But, moving all this to a stored procedure would be a good thing future enhancements. For example, if the record exists, what if we have to delete the existing record and then insert a new record. or what if we just have to update. Moving all the DB related activities would simply enhancements or modifications in future. Would suggest to use SP's wherever possible.
Bhaskara
|
|
|
|
|
I have a problem that's an extension of one I was helped with before -hope someone can help!
A table (wm7_raw_spl_data)
Fields;
propertyID
date_2016_all (date field)
day_reading
night_reading
This table contains loads of readings for all properties. Each day/night reading is a separate record. The only way to separate records for a property is by the date the readings were calculated on.
So.. I want to choose the latest rundata for all properties. Properties are run off and rerun ad hoc, i.e. NOT all at the same time.
I did this like so:
SELECT *
FROM dbo.wm7_raw_spl_data INNER JOIN
(SELECT propertyID AS property_id2, MAX(date_2016_all) AS assessmentdate
FROM dbo.wm7_raw_spl_data
GROUP BY propertyID) wm7_raw_spl_data_1 ON dbo.wm7_raw_spl_data.date_2016_all = wm7_raw_spl_data_1.assessmentdate AND
dbo.wm7_raw_spl_data.propertyID = wm7_raw_spl_data_1.property_id2
OK! I now have a view I can use this to get the latest readings for all properties.
Now I want create a view to choose the 2nd latest run data for all properties...
Any help would VERY gratefully received. I'm having to do a big comparison of data and this is a basic requirement for the process.....
Patrick
Everything & Nothing
http://www.lostsheep.com
|
|
|
|
|
I think I would add an Identity to wm7_raw_spl_data to ease the query development but, given the original query try:
SELECT
*
FROM
dbo.wm7_raw_spl_data
INNER JOIN
(SELECT
propertyID AS property_id2,
MAX(date_2016_all) AS assessmentdate
FROM
dbo.wm7_raw_spl_data
WHERE
date_2016_all < (SELECT
MAX(date_2016_all)
FROM
wm7_raw_spl_data
WHERE propertyID = property_id2)
GROUP BY
propertyID) wm7_raw_spl_data_1
ON
(dbo.wm7_raw_spl_data.date_2016_all = wm7_raw_spl_data_1.assessmentdate AND
dbo.wm7_raw_spl_data.propertyID = wm7_raw_spl_data_1.property_id2)
|
|
|
|
|
I have an Access MDB file with a password on it, but I cannot access it via ADO.NET. I know its my connection string, but I've searched the web far and wide and I cannot get the correct connection string.
static public DataTable MDBPasswordQuery(string MDBPath,string Query,string Table,string Password)
{
try
{
DataTable dTable = new DataTable(Table);
string ConnText;
ConnText="Provider=Microsoft.Jet.OLEDB.4.0;";
ConnText+="Data Source="+MDBPath+";";
ConnText+="Jet OLEDB:Database Password="+Password+";";
System.Data.OleDb.OleDbDataAdapter HL7db = new OleDbDataAdapter(Query,ConnText);
HL7db.Fill(dTable);
return dTable;
}
catch(Exception Err)
{
throw new Exception("MDBQuery: "+Err.Message);
}
}
I get the following error: No value given for one or more required parameters.
Can anyone help ?
|
|
|
|
|
Hi there. Which line is triggering the exception? is it on the creation of the OleDbDataAdapter, or is it on the .Fill(dTable) statement?
|
|
|
|
|
|
Unbelieveable, it was my Query statement the whole time. Thanks for making me take a step back from the problem.
|
|
|
|
|
I'm glad you got it figured out.
|
|
|
|
|
I am connecting to an MSACCESS DB. I would like to loop through the database and return which records are different. I cannot get the statement to work. When I hardcode the vars the statement works, when I reference the loop counter var it does not -HELP PLZ!!!
FOR j = 1 TO 10
k = j + 1
SQL_query = "SELECT ["&k&"].id, ["&k&"].x, ["&k&"].y FROM "&k&" LEFT JOIN "&j&" ON ["&k&"].x = ["&j&"].x WHERE (((["&j&"].x) Is Null));"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
