getting the list of connection strings to display in the SqlDataSource Wizard

I've added an SqlDataSource control to my web page and selected "Configure Data Source" on it. This brings up a "Choose Your Data Connection" wizard, and it asks you to select from a dropdown list of presumably pre-existing connection strings in my web.config file. However none of my connection strings will display in that dropdown list. The only thing i can do is hit the "Create New Connection" button and this adds yet another connection string to my web.config file.

I've already ran through the wizard once, created a new connection string, but when i run through the wizard again, even the new connection string - the one created by the last wizard will not appear in the dropdown list.

Any suggestions?

Jason

Hi Jason,

Are the connection strings actually appearing in the web.config file? Are they actually working - that is, if you call one of the connection strings, does it actually do what you expect? I can't offer any actual solutions to this one, but have you tried creating a new web.config file and checking if this fixes the problem? Personally, I would set up a new application just to test this, and if it works OK in the new application then perhaps something in your current application has caused the issue.

Hope this helps.

Paul

|||

Hi Paul - yes i've tried your suggestions before but nothing works. In fact, even after already running "Choose Your Data Connection" wizard (and selecting the new datasource option) to let it generate a datasource for me, and then running the wizard again to see if the previously created datasource will appear, and it doesn't.

Not a big deal i guess but a bit of a pain. I wonder if its a bug...

Jason

|||

Hi Jason,

Please be sure that you have saved the string (a checkbox for you to select) the first time you use it.

Thanks.

sql

Getting Started - What do I need to use SSIS?

OK. I am new to SSIS. I do not have control over the servers, so I have to provide a list of what features we need installed and such.

In order to use SSIS to import data files (from multiple flat file sources), what do I need installed?

I have SQL Server 2005 installed on a server. But the Business Intelligence Development Studio isn't present. Do I need to install that on the server? How about any services?

Also, can I/Should I install Business Intelligence Development Studio on my local development machine? What about licensing requirements for it?

Thank you for your help in this matter. Usually I have full control over the server and I can just poke through the install to get what I need.

Wow -- this is a big question, and you're going to get a lot of answers from different people.

The "Business Intelligence Development Studio" (BIDS) does not have to be installed on the server. The output from BIDS is a mangled XML file with a .DTSX extension. This file is processed by either the DTExec or DTExecui utility on the server. These utilities are installed along with SQL Server by default (in the Binn folder, I believe).

As a minimum, you'll need BIDS installed on your development machine. Because of licensing issues, DTExec and DTExecui only run on licensed servers. This means that, although you can create and run DTSX packages from your development machine from within BIDS, you won't be able to emulate server behavior on your local machine unless you've got a licensed copy of DTExec/DTExecui on your machine. IOW, you won't be able to run your packages at the Windows level without DTExec and DTExecui licensed on your development machine (this has hung up a lot of people -- the "insufficient product level" issue has been posted dozens of times on this forum)

Most of the SSIS tutorials you'll find on the Internet are laughably simplistic, and ignore real-world situations. You'll find dozens of brain-dead examples that import a well behaved 2- or 3-column flat file into an existing SQL Server table. While these examples are good for getting started, it'll take you 10 minutes of working with your own data to encounter a real-world situation such as permissions, ill-behaved data (missing delimiters, for instance), and issues with non-compliant data (such as column that look like dates, but aren't acceptable to SQL Server).

That's what this forum is all about. Lots of good help here.

|||

Thank you for the response. That answers a lot of my questions. I couldn't find anything that talked about getting started with this.

I'll go find the CD's to install BIDS locally. I think I can test everything well enough through BIDS before deploying to the server. This is also a new app, so we will have a full testing phase on the server to catch anything I miss.

I'll definately be back if I get stuck on writing the SSIS packages. I have 15+ file formats to massage all into the same table... :)

|||

That's precisely the sort of situation where the majority of examples you'll find will be of little help. Stuffing 15 or more formats into a single table will be challenging, depending on what you have to deal with.

Obviously, as with anything else, start with something you expect will be easy, such as plain text to a varchar or char column, and work up to the more challenging issues. In my case, I had some trouble with date values -- some of the columns I import are given as numbers (20070104), while others are text "01042007", and some include punctuation (01/03/2007 or 1-3-07). Cooercing these values into a format that's acceptable to SQL Server can be a challenge, sometimes.

Good luck! Jamie Thomsons blog (SSIS Junkie at http://blogs.conchango.com/jamiethomson/) is an invaluable source. By and large the support you'll get on this forum is top-notch and you shouldn't have too much trouble getting over the initial humps.

BTW: SSIS continues to surprise me an obvious paradox: while it's very powerful, it's got some of the quirkiest quirks I've ever seen in a Microsoft product. For instance, although the Script Task editor looks a lot like the standard Visual Studio editor, many of the menu commands do nothing -- you can't, for instance, "build" your script to check for errors. The only way I've found to validate my VB code is to actually run the package, or, at least, run the Script Task (right-click on a task in the Control Flow tab and select "Execute Task" from the shortcut menu) by itself to see if it's working.

Just a few of those "oh, so that's how it works" surprises now and then, but basically a good development platform. Much, much more powerful and flexible than DTS, to be sure.

sql

Getting rid of DOUBLE SPACING!

I just took over admin control of a website at http://www.lyricster.com and
I am having a hell of a time trying to pin down the problem of double
spacing when I add new lyrics to the database.

The thing is, most all of the db items (lyrics) on the website are single
spaced, and yet when I try to post new lyrics, it comes out double-spaced.
I even tried to log in as a normal user and post lyrics that way...same
problem.

If you need example of the problem go to the site, click on "Runnin' With
The Devil - Van Halen" and then click on a few other of the song
titles...all of the ones that have double spaced text are mine.

HELP!!!!I should add that the double spacing problem is not on the input side, but
how the database info is parsed out to the screen. Hope this clears it up
a bit more.

"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message
news:oy8Mb.13906$6y6.377982@.bgtnsc05-news.ops.worldnet.att.net...
> I just took over admin control of a website at http://www.lyricster.com
and
> I am having a hell of a time trying to pin down the problem of double
> spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.
> HELP!!!!|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> I just took over admin control of a website at http://www.lyricster.com
> and I am having a hell of a time trying to pin down the problem of
> double spacing when I add new lyrics to the database.
> The thing is, most all of the db items (lyrics) on the website are single
> spaced, and yet when I try to post new lyrics, it comes out double-spaced.
> I even tried to log in as a normal user and post lyrics that way...same
> problem.
> If you need example of the problem go to the site, click on "Runnin' With
> The Devil - Van Halen" and then click on a few other of the song
> titles...all of the ones that have double spaced text are mine.

The HTML for the Van Halen thing looks like this:

So tell me why can't this be love <br />
<BR><br />
Straight from my heart oh tell me why <br />
<BR><br /
The extra <BR><br /> explains the double spacing. But neither the
single-spaced are OK:

you\'re always there <br />
<br />
\'Cause you\'re everywhere to me <br />
And when I close my eyes it\'s you I see <br /
What is that backslash doing before the single quotes?

Now, if you believe that this is a problem with SQL Server, then you
really have to provide your information. When you perform a SELECT
on the tables from Query Analyzer what do you see?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > I just took over admin control of a website at http://www.lyricster.com
> > and I am having a hell of a time trying to pin down the problem of
> > double spacing when I add new lyrics to the database.
> > The thing is, most all of the db items (lyrics) on the website are
single
> > spaced, and yet when I try to post new lyrics, it comes out
double-spaced.
> > I even tried to log in as a normal user and post lyrics that way...same
> > problem.
> > If you need example of the problem go to the site, click on "Runnin'
With
> > The Devil - Van Halen" and then click on a few other of the song
> > titles...all of the ones that have double spaced text are mine.
> The HTML for the Van Halen thing looks like this:
> So tell me why can't this be love <br />
> <BR><br />
> Straight from my heart oh tell me why <br />
> <BR><br />
> The extra <BR><br /> explains the double spacing. But neither the
> single-spaced are OK:
> you\'re always there <br />
> <br />
> \'Cause you\'re everywhere to me <br />
> And when I close my eyes it\'s you I see <br />
> What is that backslash doing before the single quotes?
> Now, if you believe that this is a problem with SQL Server, then you
> really have to provide your information. When you perform a SELECT
> on the tables from Query Analyzer what do you see?
>
No idea, dude...I'm just a hack trying to figure out why the single-spaced
text I'm inputting into the myPHPserver interface with the SQL server is
parsing out as double spaced text when the request is made for a database
item.

In other words, I have no idea what a query analyzer is or where I could
find it. The myPHP documentation is definitely written for those already in
the know.

Also, I am not inputting any markup tags on the text...the server is doing
that on it's own.|||Moviesounds.com (aarrowstar@.yahoo.com) writes:
> No idea, dude...I'm just a hack trying to figure out why the
> single-spaced text I'm inputting into the myPHPserver interface with the
> SQL server is parsing out as double spaced text when the request is made
> for a database item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those
> already in the know.

Query Analyzer is a tool that comes with SQL Server, unless you only have
MSDE, in which case it is not included. I believe that with MSDE you may
still have OSQL, a command-line tool with which you can submit queries.

PHP I don't know anything about.

> Also, I am not inputting any markup tags on the text...the server is
> doing that on it's own.

Maybe the myPHPserver thing does. SQL Server does not, unless they are
part of the queries.

I'm afraid that you will not get much help here. If you don't know what
your system is doing, don't exepect people who don't have access to it
to find out.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Moviesounds.com" <aarrowstar@.yahoo.com> wrote in message news:<GrmMb.4866$VS4.160767@.bgtnsc04-news.ops.worldnet.att.net>...
> "Erland Sommarskog" <sommar@.algonet.se> wrote in message
> news:Xns946DA89388BC0Yazorman@.127.0.0.1...
> > Moviesounds.com (aarrowstar@.yahoo.com) writes:
> > > I just took over admin control of a website at http://www.lyricster.com
> > > and I am having a hell of a time trying to pin down the problem of
> > > double spacing when I add new lyrics to the database.
> > > > The thing is, most all of the db items (lyrics) on the website are
> single
> > > spaced, and yet when I try to post new lyrics, it comes out
> double-spaced.
> > > I even tried to log in as a normal user and post lyrics that way...same
> > > problem.
> > > > If you need example of the problem go to the site, click on "Runnin'
> With
> > > The Devil - Van Halen" and then click on a few other of the song
> > > titles...all of the ones that have double spaced text are mine.
> > The HTML for the Van Halen thing looks like this:
> > So tell me why can't this be love <br />
> > <BR><br />
> > Straight from my heart oh tell me why <br />
> > <BR><br />
> > The extra <BR><br /> explains the double spacing. But neither the
> > single-spaced are OK:
> > you\'re always there <br />
> > <br />
> > \'Cause you\'re everywhere to me <br />
> > And when I close my eyes it\'s you I see <br />
> > What is that backslash doing before the single quotes?
> > Now, if you believe that this is a problem with SQL Server, then you
> > really have to provide your information. When you perform a SELECT
> > on the tables from Query Analyzer what do you see?
> No idea, dude...I'm just a hack trying to figure out why the single-spaced
> text I'm inputting into the myPHPserver interface with the SQL server is
> parsing out as double spaced text when the request is made for a database
> item.
> In other words, I have no idea what a query analyzer is or where I could
> find it. The myPHP documentation is definitely written for those already in
> the know.
> Also, I am not inputting any markup tags on the text...the server is doing
> that on it's own.

I believe that MyPHP is used to link PHP to MySQL, not to MSSQL
(Microsoft SQL Server). So you will probably get a better response in
a newsgroup for MySQL and/or PHP than for MSSQL.

If I had to guess (and I do, since I know nothing about PHP or MySQL),
I would say that the problem is more likely to be in the PHP code, not
in the database.

Simon

Getting Error code from SqlServer to FrontEnd Application

Hi,

Frndz, Asume that we have some error in stored procedure. We shall control that error by using transactions in Backend(Sql Server). But how z t possible to give the information to the front end application that error has occured in backend ? Will anyone plz help me.

If u cant able to understand plz mail me at mneduu@.gmail.com

Thankz in Advance.

Thanks & Regards
(M. Nedu)You could have a variable as an integer, you can set the varaible with @.@.ERROR. The variable will assign a number in the varaible if an error occurs.

Then before you commit your transaction you can have an if stment, so

If @.Variable <> 0
Begin
@.Reason = 'what ever you want to put in'
End
Else
Commit

Somthing like that

Getting error 0x80004005

Hi Everybody,

Iam a sql server developer,iam on a migration project,iam encountering an error when iam editing the control flow task.it says the sql server doesnot exist or access denied,pls can anyone help me on this.

Thanks and Regards,

sg

Just out of curiosity, are you sure that you have access to the SQL Server that you are trying to connect to? Can you connect through SQL Server Management Studio?|||

Hey i have access.thanks for ur reply.

i found out the cause of the error.

Thanks,

sg

|||What was the cause so that others may be able to solve similar issues?. Please post it here.

Thanks,
Phil|||

I didnot indicate the path for connection manager correctly.

Regards,

sg