SQL Server 2000 - Open Internet Explorer ByStored Procedure?
Mar 4, 2008Can I open a Internet Explorer web page by Stored Procedure?
View 14 Replies
ADVERTISEMENT
Internet Explorer Is Block
Dec 17, 2007
Help! On my desktop some security warning came up and my friend clicked "ok" when it said "block". Apparently it was warning her that internet explorer was trying to contact the internet. So...now internet explorer cannot display anything and it is the only browser I have on my computer. I am so frustrated I can't figure out what on earth I can change to fix this. Please...someone help me figure out why I can't contact the internet? My internet connection is fine, and the troubleshooting feature in explorer keeps telling me so.
Thanks!
Internet Explorer Page Not Found
Jun 11, 2007Greetings All,
I installed SQL 2000 with SP4 on a 2003 Server. I added a NT Group to the Server and created 2 users exactly the same in the SQL Server Enterprise Manager.
My issuse is with the other user I created. When I go to a database in the Server Enterprise Manager and right click on tables, and select New Table with my user, the New Table window pops up with no problem. When the other user follows the exact same steps, Internet Explorer opens up and says page not found.
Is this an SQL Issue or maybe an IIS issue?
Thanks in advance.
Document Map Not Appears When Using Internet Explorer 7
Sep 4, 2007Hey,
I'm trying to enter reports using Internet Explorer 7, but it shows me an empty Document map.
When I'm trying to enter the same reports from other computer using Internet Explorer 6, the Document map is filled.
I compared the security options on both machines, and also added the URL of the server to the Trusted sites, but the problem still exists.
The server environment is:
WINDOWS 2003 R2 (SP2)
MSSQL 2000 (SP4) + REPORTING SERVICES
I'm trying to access the report using Windows XP (SP2)
Anyone ever handled this issue?
Any ideas how to solve it?
Thanks in advanced,
Ravid
Performance Issue On Internet Explorer 6.0....
Aug 3, 2006Dear Sir / Madam,
Sub: Performance Issue on Internet Explorer
6.0
System
Properties:
O/S: Windows XP 5.1
SP2
Browser: I.E 6.0 SP 2
My Name is Rajesh. I
have got an Issue on I.E 6.0. I need your assistance. I have Two Multiple
Selected Drop-Down List (DDL) on an HTML Page. One DDL contains around 3000
Rows(values). If I am transffering All values from one DDL to another DLL
through For-Loop by using Javascript it takes around 1 Minute in I.E 6.0 whereas same
Logic works not more than 1 Second in
Mozilla/FireFox.
Could you please guide me to solve the
above mentioned issue in I.E. Here below i have attached the functionality part
also...
strSelSource, strSelTarget are two Drop-Down List
for(var
i=0;i<document.getElementById(strSelSource).options.length;i++)
{
intTempLen =
document.getElementById(strSelTarget).options.length
document.getElementById(strSelTarget).options[intTempLen] = new
Option(document.getElementById(strSelSource).options.text,document.getElementById(strSelSource).options.value)
document.getElementById(strSelSource).options = null;
i--;
}
Above Loop takes around 1 Minute in I.E 6.0 but not more than 1 Second
in Mozilla/FireFox.
I am eagerly waiting for your
response.
Regards
Does Internet Explorer Generate Logs.
Jan 23, 2007Hi,
I have an query.
Does Internet Explorer generate logs files. If so where does the files get generated.
Thanks in advance.
Internet Explorer Script Error Message
Oct 10, 2000When I try to view a database information in the Enterprise Manager by just clicking on the database. I get an internet explorer script error:
" An error has occurred in the script on this page.
Line: 350
Char: 1
Error: 'CON_MENUPAGE' is undefined
Code: 0
URL: file://C:MSSQL7HTMLdatabase.htm ".
I try to replace the database.htm and when it didn't work, tried to install sql7.0 again but it also didn't work.
Any advise.
Hyperlink To New Window, Problems With Internet Explorer
Mar 28, 2008I have a report in which I have a link like:
Code Snippet
="javascript:void(window.open('<myURL>', '_blank'))"
Now I have two problems:
This link doesn't work in IE7, it does simply nothing... (In IE6 a new window is opened, it works as expected)
I've deployed the report on another reporting server and this time in IE6 a new window is opened but the URL is equals to "javascript:void....." so IE displays an error message ("unable to display page...."). Is there something to configure on the server?Thanks in advance
How Do I Hide Internet Explorer Menu And Tool Bar
Aug 21, 2007How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.
View 7 Replies View RelatedInternet Explorer Prompts For Password After 300 Seconds
Jan 5, 2008
I am running a report which takes a long time to render. It has 500K rows in it that need to be summed and grouped. After 5 minutes IE prompts for a password. I set the report time out to 15 min just to see if it would make a difference. I even set the IIS timeout to an to 15 min as well.
I know that its bad to run a report this big, but I'm just curious why it prompts for a password. In case a user runs the report. Report uses dates so its possible they could go way back and not realize its 500K rows. I am assuming it is an IE issue with the browser and found a registry edit, but I don't really want to edit registries on my users' computers.
SSRS And ASP.Net And Windows Integrated Authentication Failure In Internet Explorer
Jun 1, 2006I have a very confusing problem that I'm going to attempt to relay concisely:
I have a LAN on which I'm running an Intranet web site built in ASP.Net 2.0 and using SSRS / Sql Server 2005 on the same server.
The name of the box is "warehouse" or "warehouse.mydomain.us." When I ping "warehouse," I get a response from 137.86.166.8, as I should. Likewise, I get a response from 137.86.166.8 when I ping "warehouse.mydomain.us." If I do a "ping -a" on 137.86.166.8, it correctly resolves to "warehouse.mydomain.us." Based on the facts presented in this paragraph, I believe that my DNS is working as expected.
Using IE (6.0.2900.2180.xpsp_sp2_gdr.050301-1519) with "low" security settings, I navigate to http://warehouse.mydomain.us/lex/ (Lex is the name of the app) and it authenticates me to the index page (which calls the SSRS web service to get and display a list of available reports), except that I get the login prompt three times. If I hit F5 (refresh), I get three more login prompts and then I get a 401.1 error. From this point, no matter what I do, I can not see the index page again without closing and restarting IE.
I know that IE only passes credentials to certain sites, so I add my domain (http://warehouse.mydomain.us/) to the Local Intranet list ( Tools->Internet Options->Security->Local Intranet->Advanced) and then I can refresh and see my index page once, but I still get 3 login attempts and then the same thing happens -- I refresh and go through 3 logins and then get a 401.1.
If I now change my address bar to read http://137.86.166.8/lex, I get a single login and it works like a champ. This makes me think that there's a DNS problem, so I open up Mozilla Firefox and wouldn't you know it -- Firefox works like a champ all around -- one single sign-in, it keep credentials between Lex and SSRS, and it appears to use the DNS correctly. However, I can't use Firefox because I can't get any of the SSRS reports to look like they're supposed to in Mozilla-based browsers.
Argh.
I have set my IE securtiy settings to "Low." I have added the primary domain to the Local Intranet list and also to the Trusted Sites list (but you can't do both at the same time). I have even added the internal IP to my "hosts" file.
Does anyone know anything that might be a help to me in getting this figured out?
Other notes of interest:
My machine is an XP machine, but is not on the domain, but I do have a valid domain login that I use and it works in Firefox without problem.
Connect To Sql Server 2000 Via Internet
Jul 25, 2005I'm Building a windows application which updates an internet site's database.Is it possible to connect directly to the sql server through the internet?If so is it the most efficient way ? perhaps a web service or streaming is a better solution?Thanks.
View 1 Replies View RelatedHow To Link 2 Sql Server 2000 Via Internet ?
Jun 14, 2006Hi,
I've 2 SQL Server 2000 EE (A & B). Both are connected to internet but not in the same LAN. How do I insert a row triggered from A to a table in B ?
If I've both SQL Server 2005 Express in the same setup above, is it possible to setup as above ?
Advice pls...TIA !
Why I Cannot Create/edit Tables In VS.Net Server Explorer For SQL Server 2000 Developer Local Database?
Apr 7, 2006I found that when I install MSDE, then I can create/edit database objects for MSDE database in Visual Studio 2003 Server Explorer, but when I try to create/edit database objects under the default database created by the SQL Server 2000 installation, I cannot do these tasks as no option for these tasks appear when I right-click on the database object in Server Explorer. Anyone knows why this is happening?
View 3 Replies View RelatedConnect To SQL Server 2000 Trough Internet (adsl Connection )
Mar 29, 2007Hi guys,
Can somebody tell me where i can find ( or explain me ) the steps to
connect to sql server using the internet. I am using VB6 (SP6) and SQL SERVER 2000
I want to set up asql server on a central location ( PC ) so that 4 different sites can access the data stored
Thanks for all help
grtz Robert
Couldn't Debug SQL By Step Into Stored Procedure On Server Explorer Of VS2008 (or VS2005) On Remote Machine
Oct 21, 2007Hi all,
I couldn't debug SQL Server by "Step into Stored Procedure" on Server Explorer of VS2008 (or VS2005) to SQL 2005 Developer on remote Windows Server 2003 machine, it allway issue exception "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"
1) The environment:
The Client: Windows XP SP2 (WORKGROUP)
Visual Studio 2008 (or VS2005)
The SQL Server Machine: Windows 2003 Server Sp1 (DOMAIN)
SQL Server 2005 Developer
2) User account and Permission login:
I create the same user account for both Client and Domain Server with the same password, i also add that user to "Administrators" group in both machine.
At the SQL Server on Server machine, i added that account to ServerSecurityLogin with 'sysadmin' role already
3) Connection and authentication:
I used "Windows Authentication" for my connection to SQL server, and i checked sure my account of the connection by SQL command
SELECT SYSTEM_USER,
IS_SRVROLEMEMBER ('sysadmin')
4) Firewall:
I checked firewall like MSDN helping (i also tried to test by turn off firewall in both machine)
5) Visual Studio Remote Debugger:
I read "How to: Enable SQL Server 2005 Debugging" on MSDN with comment "The SQL Server can run on the same machine as the application or on a remote machine. If you are debugging T-SQL code only, then no remote setup is required."
so i didn't config Visual Studio Remote Debugger any thing.
Note: If i "Step Into Store Procedure" at Server locally, it works okey, so on at my PC client locally. But if i move debugging from my client to my Server, it occur error "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"???
If i execute store procedure on Server Explore, it works okey!
Please help me to find out what problem is???
Thanks,
Haiasc
How Can I Return A Database From The DataBase Explorer Of VB 2005 Express To The Object Explorer Of SQL Server Management Studio
Mar 3, 2008Hi all,
I just realized recently that a database "XYZ" in the Object Explorer of my SQL Server Management Studio Express (SSMSE) is put in the Database Explorer of my VB 2005 Express for processing a Stored Procedure in executing the SELECT statements (not by using Input and/or Output Parameters) during the ADO.NET 2.0-VB 2005 Express programming, then the content of the database "XYZ" is not in the SSMSE. How can I return the database "XYZ" from the DataBase Explorer of VB 2005 Express back to the Object Explorer of SQL Server Management Studio Express (SSMSE) safely? Please help and advise.
Thanks in advance,
Scott Chang
How To Open SQL Server 2000 Connection In ASP.NET
Apr 19, 2006Hi:
I am new to ASP.NET. I just started to learn ASP.NET. I am connecting SQL Server 2000 Database.
Can anybody help me why I am not getting data in browser?
Below is my code:
<%@ Page language="VB" Codebehind="Repeater.aspx.vb" AutoEventWireup="false" Inherits="WebApplication28.WebForm1" %>
<%@ Import Namespace ="System.Data.SqlClient"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<Script runat="server">
Sub Page_Load
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrAuthors As SqlDataReader
'Retrieve records from database
conPubs = New SqlConnection("Server=localhost;UID=sa;PWD=sa;Database=Pubs")
cmdSelect = New SqlCommand("Select * From Authors", conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
'Bind to Repeater
rptAuthors.DataSource = dtrAuthors
rptAuthors.DataBind()
dtrAuthors.Close()
conPubs.Close()
End Sub
</Script>
<html>
<head>
<title>Repeater.aspx</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="vb">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
</head>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:Repeater ID="rptAuthors" Runat="server">
<ItemTemplate><%# Container.DataItem("au_lname")%></ItemTemplate></asp:Repeater>
</form></body></html>
Thank you.
SQL 2000 Over The Internet
Jul 5, 2001I am trying to connect to SQL Server 2000 using the enterprise manager, and I want to do it over the Internet. My server is in another country and I am using SQL authentication. When I try to make the connection I get a message of server does not exists or access denied. If I ping the server the ping is successful, I am using TCP/IP as protocol for the client, I am not behind any firewall, and the port 1433 is enabled and is the default. I imagine it has to be something with permissions but since I am using SQL validation it should work. Is there something else I have to change?
View 2 Replies View RelatedApplication Insist Open SQL Server 2005 While The Host Still With SQL Server 2000
Mar 12, 2007I don't know why my application on the internet try to access the SQL Server 2005, when the host still having the 2000 edition. I put the following connection string:
Data Source=##DBSERVER##;Initial Catalog=##DBNAME##;User ID=##DBUSER##;Password=##DBPASSWORD##;
Isn’t everything fine with that? I created the table by host but dosen’t work. I’m wondering if can I conect straight with Data Base, without register in the server, like with mdb?
This is the error that I’m getting.
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)
Stored Procedure Won't List In 'Object Explorer' Window
Mar 25, 2008I saved a stored procedure (see below) and I'm not seeing listed within the 'Databases' / 'Remote_Serials' (DB name) / 'Programmability' / 'Stored Procedures' folder within the 'Object Explorer' window.
I'm trying to perform a simple add-info-from-form-into-DB process.
Is it because of the way I put together the procedure? I have a feeling that it is (was going off a video demo, which created it within VB.NET 2008 Express, but I'm not able to connect to the DB from there; it says the file is open, when I completely closed out of SQL Management Studio Express).
Code Snippet
ALTER PROCEDURE dbo.spInsertSerialInfo
@EmployeeID as nchar(10),
@First_Name as nvarchar(50),
@Last_Name as nvarchar(50),
@HAddress as nvarchar(50),
@City as nvarchar(30),
@HState as nvarchar(2),
@Zip as nvarchar(10),
@Phone_Home as nchar(15),
@Phone_Cell as nchar(15),
@Monitor1 as nvarchar(50),
@Monitor2 as nvarchar(50),
@PIX_ASA_Box as nvarchar(50),
@System_Case as nvarchar(50),
@Batt_APC as nvarchar(50),
@current_count as int OUTPUT
AS
INSERT RemSerials (EmployeeID,
First_Name,
Last_Name,
HAddress,
City,
HState,
Zip,
Phone_Home,
Phone_Cell,
Monitor1,
Monitor2,
PIX_ASA_Box,
System_Case,
Batt_APC)
VALUES (@EmployeeID,
@First_Name,
@Last_Name,
@HAddress,
@City,
@HState,
@Zip,
@Phone_Home,
@Phone_Cell,
@Monitor1,
@Monitor2,
@PIX_ASA_Box,
@System_Case,
@Batt_APC)
SELECT @current_count = Count(*) From RemSerials
When trying to access the stored procedure from VB.NET 2008 Express, it says, "Could not find stored procedure 'spInsertSerialInfo'."
I'm listing the code as below.
Code Snippet
cmd.CommandText = "spInsertSerialInfo"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = con
cmd.Parameters.Add("@EmployeeID", SqlDbType.NChar, 10).Value = txtEmployeeID.Text
If I change the 'CommandType.StoreProcedure' to 'CommandType.Text' it seems to find it, but then I get another error saying that the @EmployeeID variable has already been delcared and that I need to have a unique variable.
Any help would be greatly apreciated
Why User Defined Procedure Shows Under System Procedures In Object Explorer
Jan 17, 2008I have created a store procedure in sql server 2005.
At first, it shows up as a normal user defined store procedure in Object explorer.
Recently, I found I could not found the procedure in normal place. But the execution is fine.
Finally I found it stays under system procedure folder.
How this could happen?
SQL Server 2012 :: Modify Stored Procedure Opens Does Not Open For Modifications As Earlier
Jan 5, 2015when i click on the modify option on a stored procedure it is not opening for editing as earlier. it opens as if for scripting.for example i clicked modify procedure on stored proc. "text" and the result is as follows.
/****** Object: StoredProcedure [dbo].[test] Script Date: 05/01/2015 7:50:08 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[test]') AND type in (N'P', N'PC'))
[code]....
Connecting To Sql Server 2000 On Godaddy Error: (provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server)
Mar 5, 2007Facts:1. I am using my account on Godaddy trying to connect to my sql server db.2. I can get into my db using user id and password.3. Godaddy's help file shows this for a connection string: connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE="
&db_name & ";UID=" & db_username & ";PWD=" &
db_userpassword4. My connection string: "Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=***;database=DB_87972;" & _ "Trusted_Connection=False providerName=System.Data.SqlClient"{password **** out}5. Get error message 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 tried to email Godaddy's help desk with this information. There first response: We do not allow remote connections to our sql server database.There second response was to read the help file!Does anybody have any suggestions? Thanks in advance,bswanson
Can't See Server Explorer
Sep 18, 2007Hi,
I just installed 2005 Evaluation version (high spec laptop but running Windows XP Home edition).
Have opened SQL Server Management Studio then set up a dummy database with a table and a query then tried opening the Server Explorer.
I understand that Server Explorer should be on the 'View' tab with, say, Object Explorer but I can't see it.
Does the fact I am running this on XP Home edition have anything to do with it? Or do I need to run another SETUP.EXE or configure some options or is it something else?
When I installed SQL Server 2005 I got one error message saying:
quote:- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Does Server Explorer need IIS to be running in order to work?
Help will be very appreciated.
Thanks in advance.
Server Explorer Problem
Oct 12, 2005I am trying to establish a connection to a SQL server using server explorer. I have tried both the DNS name and the IP address and get this message: "Could not reconnect to "sqlserver". Make sure the machine name and path are valid.When I go to Enterprise Manager and enter the IP address, I can successfully establish a connection.What gives? Is this a VS problem?
View 4 Replies View RelatedMore Than Oneserver In Server Explorer
May 31, 2007Dear All,
Can I add more than one server in ServerExplorer bar.I wll use Client Server utility to add create a alias of a same server and add more than one server in SQL 2000. How can do this in SQL 2005
Thanks in Advance
Dana
SQL CE Mobile In VS.Net Server Explorer
Jul 10, 2006Hi,
I have a couple of MS SQL 2005 Mobile edition databases that I was using previously.
I am now not able to open them, I have not used them for about 3 weeks and do not recall doing anything 3 weeks ago to cause them to fail (Except maybe SQL Server 2005 install, not CE/Mobile).
There is no option for adding a connection to SQL Mobile 5 DB (or CE2.0 for that matter, which is also installed) when adding new data connection in VS.NET Server Explorer.
The databases seem to work fine when on the device, my probelm is accessing the database file .sdf from VS.NET.
I have tried uninstalling and reinstalling SQL Server Mobile 2005 several times with no luck.
I am developing on XP Prof with VS.net 2005 for Pocket PC Phone 2003 and 2005
If I click on the already existing connection I get message "The Provider was not found"
If I click on the file directly from VS.net get a message
"There is no editor available for 'C:lahb;ah.sdf' Make sure the application for the file type (.sdf) is installed"
I have been using these databases for some time and desperately need them back.
ANY assistance or comment would be appreciated.
Rod
Solution Explorer And SQL Server
Dec 12, 2005I am a Visual Studio .net developer and understand Solutions and Projects in VS.net. Nevertheless, it appears that the paradigm of using Solutions Explorer in SQL Server is not exactly the same. That is, in Visual Studio you can't get anything done without creating a solution first. In SQL Server, it is entirely possible to get a lot done without a solution and the ability to create and make use of a solution seems almost an after thought or an add-on.
I am particularly interested in using a solution in SQL Server to allow me to make use of SourceSafe. In the past, we jumped through all kinds of hoops to keep a running trail of changes we had made to (for example) stored procedures. It appears now that this can be managed more efficiently with the use of a Solution and SourceSafe and saving scripts or .sql files. I guess it is not possible to save a pristine copy of a stored procedure directly in SourceSafe, but you can save the code that makes up the stored procedure as a .SQL file which I suppose is about as good.
Anyway, what I would like to know is whether there is a good white paper (or chapter in a book) on the philosophy behind Solutions and projects in SQL Server and how MS intends us to use them; perhaps something other than the cold facts from the documentation. I would appreciate something more that gives me the big picture on just how MS sees them being used in SQL Server so I can get the most out of them. I have the feeling that if I "get the vision", they are meant to be an integral part of SQL Server now and in the future.
Woody
Why Need To Open CURSOR In The Procedure?
Nov 8, 2006Hi,everyone.
Why need to open CURSOR in the part in which a procedure is created?
The following codes are listed in the Microsoft SQL Server 2005 BOOKS ONLINE.
(1)
USE AdventureWorks;
GO
IF OBJECT_ID ( 'dbo.currency_cursor', 'P' ) IS NOT NULL
DROP PROCEDURE dbo.currency_cursor;
GO
CREATE PROCEDURE dbo.currency_cursor
@currency_cursor CURSOR VARYING OUTPUT
AS
SET @currency_cursor = CURSOR
FORWARD_ONLY STATIC FOR
SELECT CurrencyCode, Name
FROM Sales.Currency;
OPEN @currency_cursor;
GO
(2)
USE AdventureWorks;
GO
DECLARE @MyCursor CURSOR;
EXEC dbo.currency_cursor @currency_cursor = @MyCursor OUTPUT;
WHILE (@@FETCH_STATUS = 0)
BEGIN;
FETCH NEXT FROM @MyCursor;
END;
CLOSE @MyCursor;
DEALLOCATE @MyCursor;
GO
Please help me. Thank you in advance!
Cannot Open .bak File From Ms Sql Database. Either 2000 Or 2007
Sep 20, 2006Can not open mssql .bak file in ms_sql. File starts with "ti" and someweired charctor. Can some one help me on how to open this back up ofmssql database. I've tried to restore this file in mssql and it says itdoes not recognize this file. I understand that .bak file for mssqlshould start with "tape". But when i opened this file in ms excel itshow the file starting with "ti" not tape.Any help on this would be appreciated and please let me know if youneed access to file.Thanks
View 1 Replies View RelatedLost Ability To Manage SQL Server At Server Explorer In Visual Studio .NET
Dec 27, 2004Good day all,
I am no longer able to manage SQL Server at the server explorer in Visual studio. i.e. create, modify and delete for Diagrams, Tables, Views, Stored Procs & Functions. Further more, it missing Diagram and function folder. I can only view or read data.
But I can access local MSDE as usual.
Whats I have done wrong? Please Help. Thanks.
Sql Server Compact Edition Data Source Missing In Server Explorer
Apr 3, 2007Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
Ed Warren