Friday, March 30, 2012
I fixed it but want to confirm my solution
I installed MSDE and created some VB.Net apps that worked. However,
when I tried to access them over a peer to peer LAN, I kept getting ..
"Server does not exist or access denied."
I researched the newsgroups and learned about ...
SVRNETCN.exe - Server Network configuration utility.
I launched the tool and saw that nothing was enabled. I enabled TCP/IP,
then stopped and restarted the SQL services and it now seems to work.
Questions:
- I read about 'named pipes' too and I'm wondering if I have to enable
them too (I have no idea what named pipes are)
- I enabled just the TCP/IP protocol and didn't poke around anywhere
else. Is this sufficient? Or should I verify anything else?
(I might have to ask this in another newsgroup but I'll try...)
In my search to fix the problem, I came across many messages about "Code
Access Security Policy" and I started reading about .Net Configuration
utility with its runtime security policies (code groups, permission
sets, policy assemblies) and I was trying things in there. Is there
anything that MSDE or VB.Net apps need changed in there?
Thanks for your help
Richard
You would only need to enable named pipes if you had clients connecting to
your MSDE instance that had named pipes as the default protocol.
Having only TCP/IP enabled is ok as long as any client connections are also
using TCP/IP.
Jim
"Richard Fagen" <no_spam@.my_isp.com> wrote in message
news:uaP0NIPGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> Hi Everyone,
> I installed MSDE and created some VB.Net apps that worked. However,
> when I tried to access them over a peer to peer LAN, I kept getting ..
> "Server does not exist or access denied."
> I researched the newsgroups and learned about ...
> SVRNETCN.exe - Server Network configuration utility.
> I launched the tool and saw that nothing was enabled. I enabled TCP/IP,
> then stopped and restarted the SQL services and it now seems to work.
> Questions:
> - I read about 'named pipes' too and I'm wondering if I have to enable
> them too (I have no idea what named pipes are)
> - I enabled just the TCP/IP protocol and didn't poke around anywhere
> else. Is this sufficient? Or should I verify anything else?
>
> (I might have to ask this in another newsgroup but I'll try...)
> In my search to fix the problem, I came across many messages about "Code
> Access Security Policy" and I started reading about .Net Configuration
> utility with its runtime security policies (code groups, permission
> sets, policy assemblies) and I was trying things in there. Is there
> anything that MSDE or VB.Net apps need changed in there?
> Thanks for your help
> Richard
sql
I encountered problem after .NET framework upgraded to 2.0 in the server
I posted the question below to this website 6 hours ago, the subject was "SQL server registration failed". I couldn't find this question just now. This is my first time to post a question to microsoft website. Please let me know the related website if the question shouldn't be posted here.(I think it 's related to this site)
URGENT, I need help, thanks.
I installed .Net framework 2.0 in a Window 2003 Server and VS2005 in my PC a few days ago (.NET framework 1.1 is still in the server and VS.NET2003 is still in my PC), SQL server 2000 is with web server together. there is no problem to run ASP.net 2.0 application, the application also can query the database in SQL server.
But I encounter a problem that I can't create new SQL server registration from my PC to the above server. the error msg is "SQL Server registration failed. SQL Server does not exist or access denied ConnectionOpen(Connect())"
There is no problem to connect SQL server remotely before I upgraded .net framework to 2.0 and VS.NET2003 to VS2005.
I checked the SQL service (started), TCP/IP(enabled). I also installed SQL server SP4 in the server, but I still encounter the same problem.
Anybody can help? Thanks
moving to SQL forum.
|||I guess the firewall on the Windows 2003 server doesn′t allow incoming communication on port 1433. Change that and as a stateful firewall Windows will open the outgoing ports for communication.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Wednesday, March 28, 2012
I dont know how to connect with Ms Sql
Hello,
I am new at asp.net. I want to design a website using asp.net as frontend and sql database as backend. I am able to connect and add,update as well delete records when I use MsAcess and Asp.net using the following connection strings...
**********
sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("db1.mdb"))
dbconn.Open()
sql="SELECT * FROM table1"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
data1.DataSource=dbread
data1.DataBind()
dbread.Close()
dbconn.Close()
end sub
**********
But I don't know how to connect with Ms Sql.
I have MS SQL Server 2003 in my computer aleady Installed.
Please Tell me the exact code or procedure to make connection with MS SQL Server.
HELP ME!!!!
The equivelent code for connecting to SQL server is:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim dbconn As SqlConnection = Nothing
Dim dbread As SqlDataReader = Nothing
Try
dbconn = New SqlConnection("server=;uid=;password=;database=;")
Dim sql As String = "SELECT * FROM table1"
Dim dbcomm As New SqlCommand(sql, dbconn)
dbconn.Open()
dbread = dbcomm.ExecuteReader()
data1.DataBind()
Finally
If Not dbconn Is Nothing Then
If dbconn.State = ConnectionState.Open Then
dbconn.Close()
End If
End If
If Not dbread Is Nothing Then
If Not dbread.IsClosed Then
dbread.Close()
End If
End If
End Try
End Sub
HTH,
Ryan
Monday, March 26, 2012
I can't seem to access my fulltext data
This was set up a couple of weeks ago and ran fine. I came in today and was
looking at some of my asp.net pages and started to get the error:
Execution of a full-text operation failed. The catalog does not exist or is
currently unavailable
I tried just a simple query:
select * from position where Contains(jobDescription,'sales')
and got the same error.
What causes the problem? When I right-click on the table and go the
fulltext menu and wizard, it says it is already set up for FullText
indexing.
Thanks,
Tom
Can you check for any messages in the event log from MSSearch or MSSCI?
You might also want to use the gthrlog.vbs to examine your gatherer logs for
this catalog.
Go to c:\program files\Common files\system\mssearch\bin copy the gthrlog.vbs
to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there.
these logs have time stamps on them, look for a date relevant one to
examine.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> I am running on Sql Server 2000.
> This was set up a couple of weeks ago and ran fine. I came in today and
was
> looking at some of my asp.net pages and started to get the error:
> Execution of a full-text operation failed. The catalog does not exist or
is
> currently unavailable
> I tried just a simple query:
> select * from position where Contains(jobDescription,'sales')
> and got the same error.
> What causes the problem? When I right-click on the table and go the
> fulltext menu and wizard, it says it is already set up for FullText
> indexing.
> Thanks,
> Tom
>
>
|||> Can you check for any messages in the event log from MSSearch or MSSCI?
> You might also want to use the gthrlog.vbs to examine your gatherer logs
> for
> this catalog.
> Go to c:\program files\Common files\system\mssearch\bin copy the
> gthrlog.vbs
> to c:\winnt\system32 directory or add the above path to your
> path (control panel - system - Environment - user and in the path variable
> append the above path in the path value (separate it from the entry before
> with a ;).
> Click on set, apply and OK. Run path from the command prompt to ensure you
> did this correctly. You may have to close down all dos boxes to get this
> to
> update
> correctly, if not a log off log on normally works.
> Now navigate to your gather log location. On my machine it is at
>
> C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
>
> then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
> there.
> these logs have time stamps on them, look for a date relevant one to
> examine.
We don't have cscript.vbs on our server which is a "Windows 2003 Server".
But the date of the only file in the GatherLogs folder is 3/15/05 and this
happened today.
There is no entry in the Event log or the Sql Server Logs about this
either - the last entry was 2:00 am this morning for our backups.
However, I did look at the FullTextCatalogs in the Databases folder on EM
and saw that the JobDescriptions Catalog is idle. Is this normal?
Thanks,
Tom
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> was
> is
>
|||Possibly, can you try to run a full population.
Btw its cscript gthrlog SQL0000600006.7.gthr
My mistake
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
> We don't have cscript.vbs on our server which is a "Windows 2003 Server".
> But the date of the only file in the GatherLogs folder is 3/15/05 and this
> happened today.
> There is no entry in the Event log or the Sql Server Logs about this
> either - the last entry was 2:00 am this morning for our backups.
> However, I did look at the FullTextCatalogs in the Databases folder on EM
> and saw that the JobDescriptions Catalog is idle. Is this normal?
> Thanks,
> Tom
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> Possibly, can you try to run a full population.
I did try the full population, but that didn't seem to help. But when I did
a rebuild catalog and then full population it worked fine.
Why would it do that and how would I get around that?
I can't have people trying to use our site and finding that their searches
won't work.
Thanks,
Tom
> Btw its cscript gthrlog SQL0000600006.7.gthr
> My mistake
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
>
|||Its hard to say - their may have been some catalog corruption, but there
should have been error messages logged in the event log, or in the gatherer
logs.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> I did try the full population, but that didn't seem to help. But when I
did[vbcol=seagreen]
> a rebuild catalog and then full population it worked fine.
> Why would it do that and how would I get around that?
> I can't have people trying to use our site and finding that their searches
> won't work.
> Thanks,
> Tom
MSSCI?[vbcol=seagreen]
logs[vbcol=seagreen]
find[vbcol=seagreen]
Server".[vbcol=seagreen]
EM
>
|||Hilary,
I have had a similiar issue; I cannot read any of my data from a simple
query or returning all rows from SQL. I tried to reinstal my *.dll files for
MSSearch, to no avail.
I am running Server 2003, SQL 2000 sp3.
Any help would be appreciated.
Derek
"Hilary Cotter" wrote:
> Its hard to say - their may have been some catalog corruption, but there
> should have been error messages logged in the event log, or in the gatherer
> logs.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> did
> MSSCI?
> logs
> find
> Server".
> EM
>
>
|||Its difficult to assess what the problem could be. Could you check the event
log from messages coming from MSSearch or MSSCi? This might refer to your
gatherer logs, which can be accessed by using the gthrlog.vbs utility.
go to c:\program files\Common files\system\mssearch\bin, copy the
gthrlog.vbs to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at C:\Program
Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there. these logs have time stamps on them, look for a date relevant one
to examine.
The most common reason for such a failure is the the SQL Server Service
account was changed through control panel as opposed to through EM. Refer to
this kb article for more information.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"dkoz" <dkoz@.discussions.microsoft.com> wrote in message
news:D0FA563F-B9B0-4ABF-887B-DEA64EE7DDE9@.microsoft.com...
> Hilary,
> I have had a similiar issue; I cannot read any of my data from a simple
> query or returning all rows from SQL. I tried to reinstal my *.dll files
for[vbcol=seagreen]
> MSSearch, to no avail.
> I am running Server 2003, SQL 2000 sp3.
> Any help would be appreciated.
> Derek
> "Hilary Cotter" wrote:
gatherer[vbcol=seagreen]
I[vbcol=seagreen]
searches[vbcol=seagreen]
gatherer[vbcol=seagreen]
entry[vbcol=seagreen]
ensure[vbcol=seagreen]
get[vbcol=seagreen]
to[vbcol=seagreen]
and[vbcol=seagreen]
this[vbcol=seagreen]
on[vbcol=seagreen]
today[vbcol=seagreen]
exist[vbcol=seagreen]
the[vbcol=seagreen]
FullText[vbcol=seagreen]
Friday, March 23, 2012
I cant execute my asp.net application with IIS 5.0
Hi, please i have a problem, i can't execute my asp.net application with IIS 5.0? i have a message indicating that MYSERVER\ASPNET can't connect, and that arrive when trying connect to the database under SQL Server 2000. you have to know that my application work very well with webserver of WebMatrix. Web Matrix Project : version 0.6 .Net Framework 1.1 Thank you. |
Wednesday, March 21, 2012
I cant connect to a domain account! HELP!
Doing webforms in ASP.NET and i have a connection string in the webconfig that connects to a locally created SQL Server user account.
This is fine however when i try to connect to a domain account created by the IT administrator for me, it wont work.
The User name and password he supplied are correct as i logged into my PC (Win 2000) using it to test it. However when i try to connect to this remote network domain account by changing my connection string it fails... anyone any ideas, or am i missing a subtlety of ASP.NET and SQL connectionstrings?
Heres the connection string that works...
ConnectionString = value="Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;User ID=MrLocalUser;Password=password;"
Heres the connection string that fails...
ConnectionString = value="Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;User ID=DOMAIN\MrDomainUser;Password=password;"
??I'm not convinved that you can connect to a Sql Server using a windows account without using integrated security. Basically there are two type of authentication for SQL Server, "SQL Server" where you pass a username and password & "Window Integrated" where it passes the identity that the application is running. A connection string for this would be something like this:
ConectionString = "Server=MY-SERVER;Network Library=DBMSSOCN;Initial Catalog=MYDATABASE2;Integrated Security=SSPI"
So if you are running your ASP.NET application under the default user, the credentials passed would be:
[localmachine]\ASPNET
If you want to get it connect to the database using that specific account, you have a couple of options.
1) Change the identity that the asp.net application runs under. You can do this in the web.config file (i.e. to allow you to specify the specific user that the application runs under)
2) Switch on Impersonation, and have it run under the identity of the person logged into the application.
These both start to get a bit more involved, as it means you will need to ensure that the user that the process is running under has the appropriate permissions throughout the application, and also within the Framework folders.
Here's some info on Impersonation:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetimpersonation.asp
Here's some further reading on changig the Asp.Net identity:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconApplicationIdentity.asp
Hope this helps
Regards
Darren
MCSD.net
i cant activate the report
I set up a enviroment of report services:
windows 2000+mssql 2000+vs.net 2003+report service.
after finished installing the report ,it told me cant activate
automatically,
i should activate the report service by hand,
so i fount the command in help file: rsacivate command
so
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>reac
tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report
Server\rsreportserver.config" -t
and it shows:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548)
0x80004002 -->
System.Exception: 0x80004002
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
any1 can help me out.
thank youHi Asher!
Did you find a solution?
I have the same problem too and i noticed other users with this problem,
nobody has found a solution til now...
I'd appreciate help from microsoft staff on this topic.
I'm on Windows 2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
--
ErrorMessage when executing rsactivate -c"C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
Error Message when executing rskeymgmt -d -t:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thx for any help
yara
"Asher Wu" wrote:
> Hi all
> I set up a enviroment of report services:
> windows 2000+mssql 2000+vs.net 2003+report service.
> after finished installing the report ,it told me cant activate
> automatically,
> i should activate the report service by hand,
> so i fount the command in help file: rsacivate command
> so
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>reac
> tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Report
> Server\rsreportserver.config" -t
> and it shows:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548)
> 0x80004002 -->
> System.Exception: 0x80004002
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> any1 can help me out.
> thank you
>
>
Monday, March 19, 2012
i cannot run express after i have installed it
my system meets the requirements and I have installed .net framework 2.0,
why can't i run sql express?
I tried running it from command prompt but nothing happens?
hi,
how did you "run" the SQLEXPR.EXE boostrap installer? please have a look at http://msdn2.microsoft.com/en-us/library/ms144259.aspx for command prompt required and supported parameters...
as regards "system requirements", be sure they are satisfied as exposed in http://msdn2.microsoft.com/en-us/library/ms143680.aspx
and just to be sure () you can have a look at http://msdn2.microsoft.com/en-us/library/ms143441.aspx as well
...
regards
I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net
Hi
I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .
The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .
This is my code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.AnalysisServices.AdomdClient;
namespace ado2000
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
AdomdConnection adomd= new AdomdConnection();
adomd.ConnectionString = this.textBox1.Text;
adomd.Open();
}
}
}
I cann't establish the connection always get the same error .
How can i fix this error?
Can I use another tool to make the connection ?
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. > System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154.
at Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor()
End of inner exception stack trace
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at ado2000.Form1.button1_Click(Object sender, EventArgs e) in L:\ComponentesNet\ado2000\ado2000\Form1.cs:line 43
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
-
ado2000
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/Desarrollo/ComponentesNet/ado2000/ado2000/bin/Debug/ado2000.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
hello,
from the error message above it looks likes you don't have IXMLA component (msadomdx.dll) properly installed/registered on your box. I suggest you either try to manually register this dll and see if this maybe helps, or perhaps re-run the setup for adomd.net on your box. (normally the dll would be located somewhere in %ProgramFiles%\Microsoft.Net\Adomd.Net\90\)
Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.
as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:
using System.Data.OleDb;
using(OleDbConnection connection=new OleDbConnection())
{
connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here
connection.Open();
// working with opened connection
}
hope this helps,
I cann't connect to Analysisi Server 2000 from IA64 server with 2003 using adomd.net
Hi
I have tried to connect an application developed with c# and adomd.net v9.0 to AS 2000 installed on other server .
The server where my application is installed is a IA64 with win 2003 , the analysis server is installed on another server .
This is my code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.AnalysisServices.AdomdClient;
namespace ado2000
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
AdomdConnection adomd= new AdomdConnection();
adomd.ConnectionString = this.textBox1.Text;
adomd.Open();
}
}
}
I cann't establish the connection always get the same error .
How can i fix this error?
Can I use another tool to make the connection ?
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. > System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154.
at Microsoft.AnalysisServices.AdomdClient.IXMLAStream..ctor()
End of inner exception stack trace
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenIXMLAConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectIXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at ado2000.Form1.button1_Click(Object sender, EventArgs e) in L:\ComponentesNet\ado2000\ado2000\Form1.cs:line 43
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
-
ado2000
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///E:/Desarrollo/ComponentesNet/ado2000/ado2000/bin/Debug/ado2000.exe
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
-
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
-
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
hello,
from the error message above it looks likes you don't have IXMLA component (msadomdx.dll) properly installed/registered on your box. I suggest you either try to manually register this dll and see if this maybe helps, or perhaps re-run the setup for adomd.net on your box. (normally the dll would be located somewhere in %ProgramFiles%\Microsoft.Net\Adomd.Net\90\)
Also, note that you also need to have an msolap80 provider installed on your box as well to connect to AS2000.
as to the other ways to connect - you can also try using ole db perhaps. code might look something like below:
using System.Data.OleDb;
using(OleDbConnection connection=new OleDbConnection())
{
connection.ConnectionString = "Provider=MSOLAP.3;Data Source=localhost;"; // your connection string here
connection.Open();
// working with opened connection
}
hope this helps,
I can't find the setting.
Ensure you are really connected to the same SQL Server instance, you could have multiple instances. Ensure you are connecting using the same credentials, your Windows Authenication account may have different permissions than the account used to by Web Developer Express.
Let me know if this does not help
Peter Saddow
|||Thank you for the feedback. I eventually found out what the problem was: by default, Web Developer Express creates SQL databases which are visible only to the current User Instance. To disable this, you have to set "User Instance = FALSE" on the database connection string. For example, my original connection string was:
Data Source=.\SQLEXPRESS;AttachDbFilename="S:\My Documents\Visual Studio 2005\WebSites\Db1\App_Data\Database.mdf";Integrated Security=True;User Instance=True
By setting User Instance = False, I can now see the database from SQL Server MSE.
|||I came across the same answer you did the only problem is that I may not find the settings file or some way to edit it.Monday, March 12, 2012
I am viewing reports through a .Net interface. I want to hide
check out the new webform controls that ship with VS 2005. The other option
is to use web services instead of URL integration URL integration is easier
but it really is not suitable if you are trying to hide things from the
user.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:F77A8831-CD45-4431-8DF6-E89D487C3F80@.microsoft.com...
> the URL when the report is rendered. How can I do this?
Friday, March 9, 2012
I am new to this SQL Server Reporting Services. HELP
Hi Friends,
I am working on .Net tech with SQL Server 2000.
I want to update my technical skills to DW.
I mean, i planning to learn SQL Server Reporting Services and i am new this topic.
Please help me........
thanks
babu
my dear friend ,
i am also new to ssrs ... check this link
http://www.crystalreportsbook.com/SSRSandCR_Overview.asp
http://safari.oreilly.com/0596529414
atleast this will give little bit idea abt ssrs... if u get any resources...plz update here.......so that every one will know
u can also use microsoft virtual lab ...But as a beginneer still i am finding a resource for good foundation in ssrs......
I am new to this OLAP & OLTP - Analysis Services.
Hi,
I am working on .Net tech with SQL Server 2000.
I want to update my technical skills to DW.
I mean, i planning to learn Analysis Services and i am new this topic.
Please help me........
thanks
babu
http://www.databasejournal.com/features/mssql/article.php/1429671
maybe this will be a good start
I am new this SSIS, Please help me.
Hi,
I am working on .Net tech with SQL Server 2000.
I want to update my technical skills to DW.
I mean, i planning to learn SSIS and i am new this topic.
Please help me........
thanks
babu
Two options-
Pay for Books and/or Training
or
Teach yourself, perhaps get hold of SQL Server 2005, perhaps try the free documentation and tutorials? Have you you even looked on the MS site for this?
http://msdn2.microsoft.com/en-us/library/ms167031.aspx ?
|||thanks for reply. I am asking is there any free documents and tutorials are available in any free sites.
thanks
Babu
|||There are tutorials in SQL Server Books Online.
Also, try the followink searches:
http://search.live.com/results.aspx?q=ssis+tutorials&mkt=en-us&FORM=OPNSCH
http://search.live.com/results.aspx?q=ssis+examples&form=QBRE
|||Sridhar,
Apart from msdn and latest downloadable samples from microsoft site, There are lots of online resources.
1) www.sqlis.com by Darren Green and Allan Mitchell
2) Download Free Samples at Wrox official site
2) Blogs by Jamie Thomson,Rafael Salas, Brian Knight, Donald Farmer, Kirk Haselden, Scott Barret, John welch, Ashwin Sharma, Phil Brammer, Michael Entin, Alberto Ferari
Many Thanks
Subhash Subramanyam
|||I suggest you download tutorial from www.microsoft.com/downloads/It's great for the begining.
Wednesday, March 7, 2012
Hyperthetical
Hi,
I am a noob and i have a hyperthetical question
I used to work with C-ASP and am moving to C# - asp.net with ms-SQL server
I have VS 2K5 pro with sql server developer
Just say I have a 30 or 40 table database with 80 colums in each table with various data types for each column
now is there anyway with t-sql to have the program create a "template" or installation file of the database (after i have created teh database in vs2k5 server explorer database connection) ?
What i mean by that is there a way that the probrams a
"create table <<tablename>>"
and builds the SQL for me for the table? if this does not make sense then please tell me and I will try and explain futher..
===
see what i did in the past was create a asp page with the design of the database in SQL and then when i FTP'd it to the server i could just run the page and it would install(create the tables) into the database and i would be able to uninstall(drop) the tables all the same way...
im looking for something similar..i have done it with an XML file, but it was the old way ,,where i had to manually write out the design of the database myself
Hi, fortunately in Management Studio we have a 'Template Explorer' (in the View Menu) which provides various templates including create database/table. You can download Management Studio Express from here:
http://msdn.microsoft.com/vstudio/express/sql/download
|||Perhaps the use of the word template - i have been sick and my use of words inthe last 48 hours has not been as good as they have been...let me try and explain again.
You have designed a database and normalised this database on paper.
Then you create the database in ms-sql to the design on paper, but the database only exists locally
You would like the database schema in a file so that you can execute the design on the server and it is created exactly the same as locally(similar to a installation file but for the way database is for that solution)
I hope this makes more sense.
|||
pwpaust:
Perhaps the use of the word template **was wrong** - i have been sick and my use of words inthe last 48 hours has not been as good as they have been...let me try and explain again.
small correction
|||Ok that's goodhahahaha i just tried that...thats great
I could almost say i love you for answering this post...thanks :)
i appreciate it alot...
|||if i was to "accidently drop the table" i made the script from
would you be able to point out how i might be able to restore it?
|||If you have dropped a table, I can't find the way to get it back unless there is a backup of the database which was made when the table have not been dropped. However, restore from the backup will bring the entire database to the 'status' when the backup was made.|||
no not a back up..i understand that i meant via that script method you mentioned
Sunday, February 19, 2012
Hurry! Query needs help
Hello Fellow Developers,
I am very new to SQL and ASP.net and in the learning process. I have to do a small web application that handles documents stored on a sql database. The requirements of the functionality of the application are below. I am just having trouble setting my query to work correctly.
Problem:
I want to be able to pull documents and folders that have the same ClientID. However, here is the catch, the query should take two inputs - ClientID and ParentID (which is an ID representing FolderID from the Folder Table; the document/folder does not belong to another folder then the system will enter ZERO as the ParentID). I hope this is clear? Can this even be done?
Any help is greatly appreciated, as life is a learning experience.
Database Structure:
Table Name: Client
Fields:
ClientID primary key autonumber
Name nvarchar 255
Table Name: ClientDocs
Fields:
DocID primary key autonumber
Document image (the actually file in bytes)
FriendlyName nvarchar 255
ClientID foreign key -> [Table Client]
ClientFolderID foreign key -> [Table ClientFolders]
Table Name: Folders
Fields:
FolderID primarykey autonumber
FolderName nvarchar 255
Table Name: ClientFolder
Fields:
ClientFolderID primarykey autonumber
FolderID foreign key -> [Table Folders]
ParentID int
ClientID foreign key -> [Table Clients]
saeapu:
Problem:
I want to be able to pull documents and folders that have the same ClientID. However, here is the catch, the query should take two inputs - ClientID and ParentID (which is an ID representing FolderID from the Folder Table; the document/folder does not belong to another folder then the system will enter ZERO as the ParentID).
What's the exact thing will the query do? To me it seems an insert to some table (may be ClientFolders?). Then where do the 2 input valuesClientID and ParentIDcome from? You mentioned when will the ParentID be set to 0, so what's the value of ParentID if it dose not satisfy the condition to be 0? And how do you want to deal with FolderID in your query, as there is a FolderID column in ClientFolders?
|||Not sure if i understand the question, is it just to return the data using a sql statement or stored procedure?If it is, using a stored procedure you could:
Declare 2 parameters, @.ClientId and @.ParentId.
In the Where clause of your statement have something like
WHERE
ClientId = @.ClientId
AND (ParentId = @.ParentId
OR @.ParentId = 0)|||
Iori_Jay:
What's the exact thing will the query do? To me it seems an insert to some table (may be ClientFolders?). Then where do the 2 input values ClientID and ParentID come from? You mentioned when will the ParentID be set to 0, so what's the value of ParentID if it dose not satisfy the condition to be 0? And how do you want to deal with FolderID in your query, as there is a FolderID column in ClientFolders?
Thanks Lori_jay for the input and questions. Hopefully below I can explain the problem better.
Basically I am creating a small web application. Currently what my app can do is upload files to a sql database and associate the file(s) to a clientID. So there is 1 Client to many documents.
This works fine and dandy, but what I am trying to do is give the capability to create folders in the application. And let users insert a document into a particular folder which that folder is associated to a client and those documents inside the folder is also associated to the same ClientID. But they do not have to put the document inside a folder. They can just upload the document and just associate it to the ClientID. The reason I did parentID is that if they wanted to create a folder inside another folder. So the queries I will be needing help with is the 'Select' query to retrieve all documents and folders that have a two paremetersPartentID andClientID.
ParentID = a integer representing the folder that document/folder belongs too. If the folder /document is at the root level of the client then the value will be "0".
ClientID = a integer representing a Client.
Maybe my table structures are incorrect. What do you think?
Here is a small tree like structure I have in mind.
ClientID
|
|__ Folders
| |
| |__________Folder
| |
| |__Documents
|
|__ Documents
|||
DrGonzo:
Not sure if i understand the question, is it just to return the data using a sql statement or stored procedure?
If it is, using a stored procedure you could:
Declare 2 parameters, @.ClientId and @.ParentId.
In the Where clause of your statement have something like
WHERE
ClientId = @.ClientId
AND (ParentId = @.ParentId
OR @.ParentId = 0)
Hey Thanks DrGonzo, I have tried that already and no luck Can you give me an example on how you would use the tables I have given above and JOIN them to make this query work.
Thanks.
|||
saeapu:
So the queries I will be needing help with is the 'Select' query to retrieve all documents and folders that have a two paremetersPartentID andClientID.
ParentID = a integer representing the folder that document/folder belongs too. If the folder /document is at the root level of the client then the value will be "0".
ClientID = a integer representing a Client.
Then how do you konw the folder/document is at the root level? Can I say a row in ClientFolders table which has 0 for ParentID column represents a top level entity? If so we do not need to consider the @.ParentID with value 0 as a particular issue, we can just treat @.ParentID as it is other value (1,2,3...ect.). The top level entity logic is implemented when you insert the row into ClientFolders table, right? Let's try such query:
declare @.ClientID int,@.ParentID int
select @.ClientID=1,@.ParentID=1
select c.ClientID,c.Name,cf.ClientFolderID,cf.ParentID,
f.FolderID,f.FolderName,cd.FriendlyName
from ClientFolders cf join Folders f on cf.FolderID = f.FolderID
join ClientDocs cd on cf.ClientFolderID=cd.ClientFolderID
join Clients c on cf.ClientID = c.ClientID
wherecf.ClientID=@.ClientID
andcf.ParentID=@.ParentID