|
|
I'm using Visual Studio.NET 2003 Professional and I seem to be unable to right click the stored proceedure (in the server explorer) and get 'New Stored Procedure' in the drop down menu. Is this only available in the the Enterprise Edition of VS.NET2003?
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
At the file menu you will see a database option, there you will be able to create a new stored procedure.
Hope it helps!
Illegal Operation
WannaBe and GonnaBe Systems Developer
|
|
|
|
|
Maybe I'm not explaining myself well.
As this image shows there is no selection in the drop dowm menu.
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|
|
This is cross posted in the Visual Basic / VB.NET and SQL / ADO / ADO.NET since I am not sure exactly where it goes. So... lets give this a shot. Background: I am using Access 2000 with extensive Visual Basic coding to handle much of the legwork and raw data manipulation. In the project I have a table with several columns (Say [Info1], [Info2], [Amount1], and [Amount2]). When I open the form it selects all the entries from the table where [Amount1] is less than [Amount2] (I call this a sub set of the table but I am sure there is some big word or funny acronym that is normally used). In the VB code for the form I use Form_FormName.RecordSet.Movefirst / Movenext / Movelast to move around the subset of data and modify it as needed based on what is in [Info1] and [Info2]. This all works fine, but I would like to take all of this data from the subset and put it into a new table in the same database. The new table already exist and has data in it, what I can’t figure out is how to open two different tables in a single form and place data from one table into the other table. It sounds simple, and probably is, but I just can’t seem to figure it out. If anyone could give me a hand or at least get me pointed in the right direction I would greatly appreciate it.
Thanks,
Mark
|
|
|
|
|
We have four systems, which I will designate as follows:
MySvr1 - Windows Server 2003 - MSDE 2000 SP3
MySvr2 - Windows Server 2003 - MSDE 2000 SP3
DbSvr1 - Windows Server 2000 - SQL Server 2000 SP3
DbSvr2 - Windows Server 2003 - SQL Server 2000 SP3
All of these systems are members of a domain that I'll call DOMAIN.
MySvr2 has a service running under the local system account. This service
wants to access a database using its domain computer account. We've created
a security group (call it SecGroup) that includes DOMAIN\MySvr2$ among its
members. We've created a database login for SecGroup on all four servers.
The service running on MySvr2 attempts to connect to the database using the
connect string:
Provider=sqloledb;Integrated Security=sspi;Initial Catalog=MyDatabase;Data
Source=servername
If the service attempts to connect to the database on MySvr2 or MySvr1 it
succeeds. Furthermore, if I remove the SecGroup login on MySvr1 and try to
connect, I get a login error message that indicates login failure for
"DOMAIN\MySvr2$". This is exactly what I would expect and hope for.
If we attempt to connect to the database on DbSvr1 we get a login failure:
IDispatch error #3149
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
If we attempt to connect to the database on DbSvr2 we get a login failure:
Unspecified error
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
As one more test, we created a share on DbSvr1 with a file in it. We put an
ACL on the share, the underlying folder, and the file, that granted access
only to members of SecGroup. When I tried to access the file from MySvr2,
while logged in as myself, I got access denied (as expected). When the
service tried to access the file it was able to do so, and we could verify
that it had authenticated to DbSvr1 as DOMAIN\MySvr2$.
The TCP/IP transport is enabled on all four servers.
Anyone have any ideas as to what could be causing this? Any remedies?
--------
There are 10 types of people in this world. Those who know binary and those who don't.
|
|
|
|
|
If TCP is enable, why don't you use this connection string:
<add key="ConnectionString" value="server=192.168.1.1;user id=sa;password=yourpassword;database=databasename"/>
|
|
|
|
|
I want to zero-fill and right justify the display of an int field in a select statement using SQL Server 2000.
Anyone know an easy way?
|
|
|
|
|
I usually handle this on the front end but, as and exercise, here is something that works:
SELECT
REPLACE(ISNULL(SPACE(10 - LEN(CAST([MyIntField] AS VARCHAR(10)))),''),' ',0) +
CAST([MyIntField] AS VARCHAR(10)) AS ZeroPaddedNumber
FROM
[MyTable]
Just replace [MyIntField] & [MyTable] as appropriate and it should work. The number 10 represents the length of the resultant string (padded with zeros).
|
|
|
|
|
I want to list the tables of the selected access database and to view the data stored in this table I am using windows applicaiton (using c# language)
|
|
|
|
|
to get a list of tables from Acces DB try SELECT NAME FROM MSYSOBJECTS WHERE TYPE =6;
|
|
|
|
|
Use an OracleCommandBuilder .
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
The method OracleCommandBuilder.DeriveParameters does'nt exist in ODP.Net 9.2 ,
I found it in ODT (Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3) ,but i use ODP.Net 9.2 .
I think that i hav to use odp 10.1.
thnx
ENSI TUNISIA
|
|
|
|
|
Creating a mysql-based application the user that use my application needs mysql server installed on its pc?
|
|
|
|
|
no need . but your user should install the driver or client browser.
So you can connect to a mysql server in the network.
Your code is cool as your are
Your work is cool as Your code
So be a cool code worker
|
|
|
|
|
i tried to install SQL Server 2000 on my Windows 2000 Advanced Server and i got error when the setup was configuring the server... it told to check the sqlstp.log file which has the following lines at the end...
i could not get the error...
can anyone help me ???
thnkx
*************************************************************
00:20:03 End Action: Locked Connectivity Files Check
00:20:03 Setup is installing Microsoft Data Access Components (MDAC) ...
00:20:03 G:\x86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
00:20:35 ExitCode: 0
00:20:35 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
00:20:35 D:\WINNT\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir "D:\WINNT\TEMP\SqlSetup\Bin" -DTCPkg "G:\x86\Other\dtcsetup.exe" -LogFile "D:\WINNT\sqlstp.log"
00:20:35 Process Exit Code: (0)
00:20:35 InstallMSSearch instance: MSSQLSERVER
00:20:35 Software\Microsoft\Search\Install:Version not present
00:20:35 MSSearch 2.0 or greater version check returned -1
00:20:35 Setup is installing the Microsoft Full-Text Search Engine ...
00:20:35 "G:\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer
00:20:44 Process Exit Code: (0)
00:20:44 /Q:A /T :\WINNT\TEMP\ixp001.tmp
00:20:44 Setup is installing HTML Help ...
00:20:45 HTML Help installer exit code: 0
00:21:07 End Action InstallPkgs
00:21:07 Begin Action MoveFileData:
00:21:07 Enabled SELFREGISTERBATCH
00:21:07 Enabled CORECOMPONENTHANDLING
00:22:07 Begin Action: MoveFileDataSpecial
00:22:07 End Action: MoveFileDataSpecial
00:22:07 End Action MoveFileData
00:22:07 Begin Action ProcessAfterDataMove:
00:22:07 G:\x86\Binn\hhcol.exe D:\Program Files\Microsoft SQL Server\80\Tools\Books
00:22:08 End Action ProcessAfterDataMove
00:22:08 Begin Action BuildServer:
00:22:08 D:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -ExePath "D:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
00:22:08 Process Exit Code: (0)
00:22:08 Begin Action: CreateRegistrySetSQL
00:22:08 End Action: CreateRegistrySetSQL
00:22:08 Begin Action: RegWriteSetupEntry
00:22:08 End Action: RegWriteSetupEntry
00:22:09 Begin Action: CreateSer
00:22:09 End Action: CreateSer
00:22:09 Begin Action: SkuIt
00:22:09 End Action: SkuIt
00:22:09 SetFileSecuritySQLAndAdmin for D:\Program Files\Microsoft SQL Server\MSSQL returned: 1350, 1350
00:22:09 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
00:22:09 Begin Action: UpdateSystemPath
00:22:09 Path successfully updated.
00:22:09 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\Program Files\Microsoft SQL Server\80\Tools\BINN
00:22:09 End Action: UpdateSystemPath
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:09 Grant Right for V2RS\Administrator returned : 1, 0
00:22:10 D:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "D:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 524698 -U sa -P
###############################################################################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
driver={sql server};server=VISHUCOOL;UID=saWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (ReadFile()).
SQL Server configuration failed.
***********************************************************
|
|
|
|
|
This user[^] had the same problem.
A question that occurs to me is why it's using the Named Pipes driver. I can't recall whether Named Pipes is enabled by default on a new installation - I didn't think it was. I would have expected it to select Shared Memory. You could try checking to see whether there are any aliases configured in the Client Configuration tool (cliconfg.exe).
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
if any one know the code to view the tables in access database and display the data from any table plz send it quickly
|
|
|
|
|
What are you trying to accomplish and what language do you want to use?
|
|
|
|
|
to view tables try SELECT NAME FROM MSYSOBJECTS WHERE TYPE = 6
then run through the recordset one by one and use SELECT * FROM RECORDSET.Fields(0).Value
|
|
|
|
|
in a project i need some data for reporting, when i use same sentence in SQL server 2000 there is no problem, but in access i get "join clause error"
Select Sentence is here.
SELECT USR.USER_FULLNAME, CMP.C_COMPANYNAME, CMP.C_COUNTRY, CLRS.*,ORD.* FROM ORDERS ORD <br />
INNER JOIN COMPANIES CMP ON ORD.O_CUSTOMERID = CMP.C_COMPANYID <br />
INNER JOIN COLORS CLRS ON CLRS.C.ORDERID = O.O_ORDERID <br />
INNER JOIN USERS USR ON USR.USER_ID = ORD.O_WHOGET <br />
<br />
WHERE 1=1 ORDER BY ORD.O_ORDERDATE
What s wrong ? ? ?
|
|
|
|
|
in Access SQL you have to set opening brackets after the from and closing after each join, when you have more than one join in the select.
you can also set the access mdb to ANSI 92 syntax (SQL Server) in extras/options/tables,querys then you dont have to set the INNER or the brackets.
Thomas
SELECT USR.USER_FULLNAME, CMP.C_COMPANYNAME, CMP.C_COUNTRY, CLRS.*,ORD.*
FROM (((ORDERS ORD
INNER JOIN COMPANIES CMP ON ORD.O_CUSTOMERID = CMP.C_COMPANYID)
INNER JOIN COLORS CLRS ON CLRS.C.ORDERID = O.O_ORDERID)
INNER JOIN USERS USR ON USR.USER_ID = ORD.O_WHOGET)
WHERE 1=1 ORDER BY ORD.O_ORDERDATE
thomas
|
|
|
|
|
thank u thomas for replaying,
i solved this problem, as writing a query (access stored procedure)
|
|
|
|
|
I have posted this problem a few times now in other areas. I have received some repsoinses but all suggestions fail. I have placed many statments in the code to verify that the data is being read. IT is. The only issue is the dataBind statement. I'm getting very frustrated!
I have many examples of how to bind a dropdownlist but NONE match the code that is generated in VS .NET. Since I am new to .NET and web programming I am having difficulty following the gerneated code. I am convinced my problem is in the way I am binding the data. The eror I get is
"Index 0 is not non-negative and below total rows count."
and it ocurs in the following line
DropDownList1.DataBind();
Here is some of the code. If you are intereseted in helping me I can post all of it.
<br />
private void Page_Load(object sender, System.EventArgs e)<br />
{<br />
if (!Page.IsPostBack) <br />
{<br />
BindListToDropDown();<br />
}<br />
}<br />
<br />
#region Web Form Designer generated code<br />
override protected void OnInit(EventArgs e)<br />
{<br />
InitializeComponent();<br />
base.OnInit(e);<br />
}<br />
<br />
private void InitializeComponent()<br />
{ <br />
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
this.dbListOfAirports1 = new dbListOfAirports();<br />
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).BeginInit();<br />
this.DropDownList1.DataBinding += new System.EventHandler(this.Page_Load);<br />
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {<br />
new System.Data.Common.DataTableMapping("Table", "tblAirport", new System.Data.Common.DataColumnMapping[] {<br />
new System.Data.Common.DataColumnMapping("AirportCode", "AirportCode"),<br />
new System.Data.Common.DataColumnMapping("AirportID", "AirportID"),<br />
new System.Data.Common.DataColumnMapping("AirportName", "AirportName"),<br />
new System.Data.Common.DataColumnMapping("City", "City"),<br />
new System.Data.Common.DataColumnMapping("Latitude", "Latitude"),<br />
new System.Data.Common.DataColumnMapping("Longitude", "Longitude"),<br />
new System.Data.Common.DataColumnMapping("State", "State")})});<br />
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5rovider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
this.dbListOfAirports1.DataSetName = "dbListOfAirports"; <br />
this.dbListOfAirports1.Locale = new System.Globalization.CultureInfo("en-US");<br />
this.oleDbSelectCommand1.CommandText = "SELECT AirportCode, AirportID, AirportName, City, Latitude, Longitude, State FROM" +<br />
" tblAirport";<br />
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
((System.ComponentModel.ISupportInitialize)(this.dbListOfAirports1)).EndInit();<br />
<br />
}<br />
#endregion<br />
<br />
private void BindListToDropDown()<br />
{<br />
try <br />
{<br />
oleDbConnection1.Open();<br />
OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader();<br />
<br />
oleDbConnection1.Close();<br />
DropDownList1.DataSource=OleDbReader;<br />
DropDownList1.DataTextField = "AirportName";<br />
DropDownList1.DataValueField="AirportID";<br />
DropDownList1.DataBind();<br />
<br />
}<br />
catch(OleDbException ex) <br />
{<br />
|
|
|
|
|
Just a shot in the dark as I'm a sleft-taught hobbiest, but I would write your try catch like this:
private void BindListToDropDown()
{
try
{
oleDbConnection1.Open();
OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader();
DropDownList1.DataSource=OleDbReader;
DropDownList1.DataTextField = "AirportName";
DropDownList1.DataValueField="AirportID";
DropDownList1.DataBind();
oleDbConnection1.Close();
}
catch(OleDbException ex)
{
Notice I don't close the connection until after the DataBind.
Let me know if that works.
Jerry
Most people are willing to pay more to be amused than to be educated--Robert C. Savage, Life Lessons
Toasty0.com
Ladder League (beta)
|
|
|
|