Data Extraction Program within SQL Reporting Svcs

I have installed SQL Reporting Services and have been trying to implement the
Report Pack for SharePoint Portal Server that was recently released. Part of
the VERY limited instructions that comes with the Report Pack states that you
can import your existing SPS log files using the Data Extraction Program
(DEP).
I have tried this a number of times now and the SPS logs will import into
dbSPSReportingStaging with no errors. However, when the application attempts
to move those logs from dbSPSReportingStaging to dbSPSReporting I get an
error message "String or binary data would be truncated" and the statement
terminates without moving the data into dbSPSReporting.
Obviously (to me anyway) there is a field that is not of sufficient length
(or perhaps the wrong type) in dbSPSReporting. Given the fact that this DB is
created using a .sql script written and included in the Report Pack how can I
identify which field is causing the problem and fix it?
Any help is appreciated!
TIAMark Harrison pointed me to the link below which should fix the issue
http://blogs.msdn.com/dinod/archive/2005/08/19/453724.aspx
"Jay" wrote:
> I have installed SQL Reporting Services and have been trying to implement the
> Report Pack for SharePoint Portal Server that was recently released. Part of
> the VERY limited instructions that comes with the Report Pack states that you
> can import your existing SPS log files using the Data Extraction Program
> (DEP).
> I have tried this a number of times now and the SPS logs will import into
> dbSPSReportingStaging with no errors. However, when the application attempts
> to move those logs from dbSPSReportingStaging to dbSPSReporting I get an
> error message "String or binary data would be truncated" and the statement
> terminates without moving the data into dbSPSReporting.
> Obviously (to me anyway) there is a field that is not of sufficient length
> (or perhaps the wrong type) in dbSPSReporting. Given the fact that this DB is
> created using a .sql script written and included in the Report Pack how can I
> identify which field is causing the problem and fix it?
> Any help is appreciated!
> TIA

Data designer

Does you know a data design program' I use dbdesign. and heard about
erwin... does you know any other?Hi,
I have used the below tools for DB Design
1. Erwin
2. Power designer
3. MS Visio
Thanks
Hari
MCDBA
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>|||In addition to what Hari Prasad mentioned, a very popular choice is
Embarcadero ER/Studio ( http://www.embarcadero.com )
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>|||Also, I just found this page when I was searching around for the product
mentioned called Power Designer... Huge list of CASE tools:
http://is.twi.tudelft.nl/~hommes/tools.html
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>

Data designer

Does you know a data design program? I use dbdesign. and heard about
erwin... does you know any other?
Hi,
I have used the below tools for DB Design
1. Erwin
2. Power designer
3. MS Visio
Thanks
Hari
MCDBA
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program? I use dbdesign. and heard about
> erwin... does you know any other?
>
|||In addition to what Hari Prasad mentioned, a very popular choice is
Embarcadero ER/Studio ( http://www.embarcadero.com )
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program? I use dbdesign. and heard about
> erwin... does you know any other?
>
|||Also, I just found this page when I was searching around for the product
mentioned called Power Designer... Huge list of CASE tools:
http://is.twi.tudelft.nl/~hommes/tools.html
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program? I use dbdesign. and heard about
> erwin... does you know any other?
>
sql

Data designer

Does you know a data design program' I use dbdesign. and heard about
erwin... does you know any other?Hi,
I have used the below tools for DB Design
1. Erwin
2. Power designer
3. MS Visio
Thanks
Hari
MCDBA
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>|||In addition to what Hari Prasad mentioned, a very popular choice is
Embarcadero ER/Studio ( http://www.embarcadero.com )
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>|||Also, I just found this page when I was searching around for the product
mentioned called Power Designer... Huge list of CASE tools:
http://is.twi.tudelft.nl/~hommes/tools.html
"Ricardo" <nomail@.terra.com.br> wrote in message
news:udU0Ev$hEHA.3264@.tk2msftngp13.phx.gbl...
> Does you know a data design program' I use dbdesign. and heard about
> erwin... does you know any other?
>

Data Access to SQL Server 2005 from remote computer.

We have a program (Hindsite) that we're using on our LAN. It uses ODBC to access data on the server from client PC. Hindsite directory on the server is mapped drive on each client in the office.

We would really like to be able to access the same program database on the server from the remote PC over the internet.

Can SQL Native Client do that?

What would be the best way to accomplish it?

How to make this application to be able to access it's directory on the server over the Internet like it was a mapped drive on the remote PC?

Thank you very much in advance.

SQL native can do that.

You need to make sure your server is accessible from remote site, either via direct internet connection or via "middlebox", such as NAT. As long as you can ping and telnet to your server machine from the remote site, you can use SQL native client to connect to your sql server.

|||

thank you very much for your advice.

I'll try that, hopefully it works.

one thing I don't understand - when the program asks for a directory on server what do I need to direct it to when I install it on the remote computer?

thank you again.

|||Can you be more specific.

Damn! Can not have it to work!

I am a noob toSQL server. I need it to create a database that should work along with my program. Firts time I have installed Microsoft SQL Server 2005 with all components (because I was not shure which components may appear necessary later). It does not work. I could create a database in SQL Server management Studio, but as soon as I tried to add a new table to the database an error message appeared: "Object reference not set to an instance of an object. (SQLEditors)". All the same happened in Visual Studio (they call it Business development studio or something like that). As I tried to connect a database an error message displayed: "can not make connection.... Object reference not set to an instance of an object". I formatted my hard drive, reinstalled windows (Windows Server 2003 R2), Installed SQL Server (this time, only database services an workstation components), downloaded and installed SP2. and it is all the same, damn thing does not work. Whatever i do - trying to add a new table or new view to existing database - I get the same damn ansver. And there is not an error number, why?
I would appreciate any advise.

pls refer this,

http://www.mcse.ms/message2008943.html they have solved reinstalling the workstation components

http://fabdata.wordpress.com/2007/03/24/object-reference-not-set-to-an-instance-of-an-object-sqleditors/ also this one

|||Deepak Rangarajan,
Unfortunately, that didn't work for me. I uninstalled workstation components, even nativeclient. restarted an installed them again. All the same - can not cerate table, can not create view, can not connection to databese in VS.

Damn Newbie

I am looking to make a program using express edition Visual C#. I want my
application to interact with Microsoft SQL server, create tables, inserts,
lookups, the normal.

First I would like to read the documentation,and now to the point of my
post. Due to the (recently pointed out) ineptitude of my googling skills I
cannot find what I am looking for.

I presume this is an obvious and easy request so all comments on that front
will be directed to the bit bucket :-)

TIAShane (shane@.weasel.is-a-geek.net) writes:

Quote:

Originally Posted by

I am looking to make a program using express edition Visual C#. I want my
application to interact with Microsoft SQL server, create tables, inserts,
lookups, the normal.
>
First I would like to read the documentation,and now to the point of my
post. Due to the (recently pointed out) ineptitude of my googling
skills I cannot find what I am looking for.
>
I presume this is an obvious and easy request so all comments on that
front will be directed to the bit bucket :-)

Not sure what documentation you are asking for. But SQL Server comes with
Books Online, see also links below.

I don't know what Visual C# Express comes with, but you should find MSDN
Library on msdn.microsoft.com.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx