SQL SQLExpress: studio

Showing posts with label studio. Show all posts

Sunday, March 25, 2012

Data transfer Pocket PC <> Desktop PC?

Hi,everyone!

I'm new to this forum and also new to Visual Studio 2005 .NET.

I'm going to develop a pocket pc(windows mobile 2005) application which needs to save some data introduced by the user.Later that data should be syncronized with MS SQL Server database.

The application is going to be developed using Visual Studio 2005 with c#.

So I'm doubting wich is the best way of syncronising the data between Pocket Pc and a Desktop PC.Should i use MS SQL Server Mobile(RDA,Merge Replication) or XML(Xml Web Services) would help me better?Or is there any other better way of data syncronization/storage?

Could anyone help me,or post some links + code samples,please?

Thanks!

You'll need to provide more information ... how much data? What sort of data? Will it need to be wrapped in a transaction and/or have other potential for rollback? How critical is it/how reliable does the synchronization need to be? Have you looked into the Service Broker? (I'm exploring this for a project myself.)

Thursday, March 22, 2012

Errors in Connecting to SQL Server Compact 3.4 ?

Hi everyone,
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:

> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>

Errors in Connecting to SQL Server Compact 3.4 ?

cannot view existing database in management studio !!!

? have sharepoint 2007 server and everthing is ok

it is working

? can view database name in sharepoint central administration

but ? cannot view same database in sql management studio

what is the problem

how can i view it

Thanks

Are you connecting to the correct server instance? It should be <computername>\SharePoint. If you are connecting to another instance, this might explain your problem.|||

no no

? m sure it is correct instance computername\sharepoint

|||SQL Server 2005 is security sensitive which means that you will only able to see those database which you have access to.
Jens K. Suessmeyer.

http://www.sqlserver2005.de
--

Monday, March 19, 2012

.SQL file type not recognized by SSMS

Good morning,

For some reason, I can no longer open .sql files in SQL Server Management Studio. I have checked the Windows file association, which still associates these files with SSMS. I also tried adding a static extension under Tools -> Options -> Text Editor -> File Extension, but still no luck.

Each time I try to open a .sql file, I receive the following error:

There is no editor available for <my file>. Make sure the application for the file type (.sql) is installed.

There have been no major changes on my system recently. Any help would be appreciated.

Thanks
Tim

It happened to me once whatI did is, re-associated those .SQL files to open in NOTEPAD and then again associated to SSMS to open, that worked.

HTH

.sql control string

My development environment includes Visual Web Developer, SQL Server 2005 Express and SQL Server Management Studio Express. I have a .sql control string that creates a database. The control string is in my App_Data folder within my web site. When I use SQL Server Managment Studio Express to run the .sql control string and create the tables etc. it does it in my SQLEXPRESS folder and not in the web.

How do I run the .sql file so it will create the database in my App_Data folder within the web site?

Thanks,

Kyleq

Hi Kyleq,

Please make sure that your SQL Server Management Studio Express has connected to the correct database.

A simple .mdf file cannot be working properly, we must

1. Attach it to a SQL Server instance.
2. Connection the SQL Server Management Studio Express to that instance and to that database.
3. Run the .sql scripts.
4. Detach the database.

Please read the following for more information:

http://msdn2.microsoft.com/en-us/library/ms228037.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

Thursday, March 8, 2012

.NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

Hi,

I have followed the steps from the .NET FW SDK QuickStart Configuration (C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Samples\Setup\html\ConfigDetails.htm), and have got an error message trying to grant the ASP.NET User account access to the databases by the command sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin LEONEW\ASPNET" where LEONEW is my local machine name, and the ASPNET account exists in the Users group.

I am getting the error message: Msg 102, Level 15, State 1, Server LEONEW\SQLEXPRESS, Line 1
Incorrect syntax near '\'.

Please help if you know how to resolve this. Thanks in advance.

Alex.

Did you try putting apostrophes around the login name:

'LEONEW\ASPNET'

|||I have tried with no success sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin N' LEONEW\ASPNET'".|||

Do you get the same error?

What about

sqlcmd -E -S (local)\SQLExpress -Q "sp_grantlogin 'LEONEW\ASPNET'"

If I use it without the apostrophes I get the same error as you:

Msg 102, Level 15, State 1, Server <...>, Line 1
Incorrect syntax near '\'.

If I add the apostrophes the command succeeds.

|||You are absolutely right. Thanks.

.Net Framework error message when starting SQL 2005 Management Studio

Has anyone ever recieved an error when starting the Management Studio?

"Unhandled excpetion has occurred in a component in your application.

"Input String was not in a correct format"

I click continue and I can still use the manager;however, it gets annoying. The details of the error are very long and too much to add to this thread.

Any ideas?

never had that but I would probably start by repairing the .NET Framework and see how that goes?

would be nice if you could post the error message, even if it is long

|||

I did repair the .NET Framework and same issue. I also reinstalled the SQL 05 components. Here is the error message.

Thank you for your help.

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.FormatException: Input string was not in a correct format.

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()

at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()

at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs e)

at Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs e)

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(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/Framework/v2.0.50727/mscorlib.dll

AppIDPackage

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.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

Microsoft.SqlServer.SqlTools.VSIntegration

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

Microsoft.VisualStudio.Shell.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

Microsoft.VisualStudio.OLE.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

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.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

Microsoft.SqlServer.SqlTDiagM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

Microsoft.DataWarehouse.SQM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL

Microsoft.SqlServer.Instapi

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

ObjectExplorer

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

ConnectionDlg

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

Microsoft.SqlServer.CustomControls

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll

SqlWorkbench.Interfaces

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

SqlMgmt

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

Microsoft.SqlServer.RegSvrEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

EnvDTE

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll

Microsoft.NetEnterpriseServers.ExceptionMessageBox

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

Microsoft.SqlServer.ConnectionInfo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.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:

<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.

.NET DiffGram

I am running VS Studio 2003 and a VB.NET web application. I have installed
SQLXML 3 SP3 on both my .NET machine and my SQL server machine, and SOAP 3 on
db Server machine.
I have created a Diffgram from a dataset with writexml to stream and xsd
with SQL relations mapped. Yet when it tries to execute the SQLXMLcommand, I
continually get an Invalid Authorization Specification error.
I have not found anything about it online. Please let me know what I can do
to help the situation. I would love to use Diff gram instead of hand writing
the same XML consuming code into SQL server.
thanks
Hello,
Could you please send the repro so I can take a look ?
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
|||This is an interesting error. Do you get this error while you are executing
the SqlXmlcommand? It would help a lot, if you can send your diffgram and
the managed code to execute it.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"gehrigsranch" <gehrigsranch@.discussions.microsoft.com> wrote in message
news:6BDCC7A7-0E15-46FD-810B-46558F0CB035@.microsoft.com...
>I am running VS Studio 2003 and a VB.NET web application. I have installed
> SQLXML 3 SP3 on both my .NET machine and my SQL server machine, and SOAP 3
> on
> db Server machine.
> I have created a Diffgram from a dataset with writexml to stream and xsd
> with SQL relations mapped. Yet when it tries to execute the
> SQLXMLcommand, I
> continually get an Invalid Authorization Specification error.
> I have not found anything about it online. Please let me know what I can
> do
> to help the situation. I would love to use Diff gram instead of hand
> writing
> the same XML consuming code into SQL server.
> thanks

Tuesday, March 6, 2012

.NET 3rd Party Graphical Controls Extension for RS?

Hi Everyone,
Are there third party .NET controls that can be added to the RS Visual
studio environment and that can be used in reprts , where these controls
would extend the graphical library already currently shipped with RS? I am
looking for guages, cones, pyramid type controls where I can drag and drop
into the report and link to the data set fields in order to get more
graphical results.
Thanks.
--
Message posted via http://www.sqlmonster.comNo, this is not possible. Not sure if this will change with Version 2 or
not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:55d25826a3cf4727abfaa309f3b80c56@.SQLMonster.com...
> Hi Everyone,
> Are there third party .NET controls that can be added to the RS Visual
> studio environment and that can be used in reprts , where these controls
> would extend the graphical library already currently shipped with RS? I
am
> looking for guages, cones, pyramid type controls where I can drag and drop
> into the report and link to the data set fields in order to get more
> graphical results.
> Thanks.
> --
> Message posted via http://www.sqlmonster.com

Saturday, February 11, 2012

* An error has occurred during report processing.

Created Report using SQL Server Business Intelligence 2005 using Visual studio 2005
MSSQL Server 2005
datasource is a filteredAppointment dbo from MS CRM 3
Shared Datasource
Report runs in visual studio 2005

deployed to ReportServer no errors
Report showing on home page in Report Server
Data source folder also on report server page

go to run report on the report server via internet explorer

getting following message

An error has occurred during report processing.

Cannot create a connection to data source 'FilteredAppointments'.

For more information about this error navigate to the report server on the local server machine, or enable remote errorsPlease can any one help!!!!!!

I am a novice to reporting services, can any one recommend a good basic to intermediate book.
have been on the Microsoft 2030A MSSQL server 2000 reporting services 4 months ago and not had a chance to use it until know

Thank you for all your time
ralph

Have you passed credentials to login in to datasource(database)..

May be it was using windows authentication previously.

Now to access it from IE you need to pass credentials to login to database.

You can store them on report manager also. even in vs2005 go to data view select (...) for data set than select (...) for dat source then go to credentials tab and set user name and password for that and re deploy that report.

|||

I have found the following book a good introduction/reference on SQL 2005 Reporting Services:

SQL Server 2005 Reporting Services Step-by-Step.

http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=pd_bbs_1/105-2708315-8436407?ie=UTF8&s=books&qid=1189784803&sr=8-1

Gary.

Thursday, February 9, 2012

(SQL Mobile)Can SELECT, but cannot INSERT/UPDATE. Why not?

I'm just getting started with using SQL Server Mobile while creating a handheld app using Visual Studio 2005. So far, I have succeeded in RETRIEVING data from the mobile database, but I don't understand why my INSERT nor UPDATE statements will not work. (I'm assuming they don't work, because after I run my code via the debugger, I oddly get no error message, but when I "open" the table in the Server Explorer, I do not see my expected results. Do I need to do some kind of "commit" or something? Here's my code. Thanks for any help! - Sue

'Create SQL statement:
Dim strSQL As String
strSQL = "INSERT INTO MyTable (col1, col2) VALUES ('yucky', 'poo')"

'Create DB connection:
Dim connDB As New System.Data.SqlServerCe.SqlCeConnection
connDB.ConnectionString = ("Data Source =" _
+ (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly.GetName.CodeBase) + "\SueUWM.sdf;"))

'Create DB command:
Dim cmndDB As New System.Data.SqlServerCe.SqlCeCommand(strSQL, connDB)

'Open the connection:
connDB.Open()

'Execute the command:
Dim intRecordsAffected As Integer
Try
intRecordsAffected = cmndDB.ExecuteNonQuery()

If intRecordsAffected <> 1 Then
MessageBox.Show("Unable to insert into database.")
End If
Catch ex As Exception
MessageBox.Show(ex.ToString, "Insert Error")
End Try

'close the DB connection:

connDB.Close()

I am so dumb! I just learned that the insert & update modifications are made on the .sdf file on the emulator, and therefore will *not* be visible to me in Visual Studio's Server Explorer (on the desktop)! - Sue

Sunday, March 25, 2012

Data transfer Pocket PC <> Desktop PC?

Thursday, March 22, 2012

Errors in Connecting to SQL Server Compact 3.4 ?

Errors in Connecting to SQL Server Compact 3.4 ?

cannot view existing database in management studio !!!

Monday, March 19, 2012

.SQL file type not recognized by SSMS

.sql control string

Thursday, March 8, 2012

.NET FW SDK QuickStart SQL-Express Error: Msg 102 ... Incorrect syntax.

.Net Framework error message when starting SQL 2005 Management Studio

.NET DiffGram

Tuesday, March 6, 2012

.NET 3rd Party Graphical Controls Extension for RS?

Saturday, February 11, 2012

* An error has occurred during report processing.

Thursday, February 9, 2012

(SQL Mobile)Can SELECT, but cannot INSERT/UPDATE. Why not?

SQL SQLExpress

Blog Archive

About Me