books on odbc

At one point I had the odbc 3.5 developers guide but I had to leave that
behind as a result of a layoff.
Now after several years I find I'm getting back into odbc but when I
search I find that all books on odbc are out of print. Some are still
available like the 3.5 developers guide but hard to get.
is there a good book on odbc programming that is current?
Only thing I know of that is current is online at msdn. You
can use the ODBC Programmer's Reference which is at:
http://msdn.microsoft.com/library/en...his_manual.asp
-Sue
On Wed, 31 Mar 2004 09:31:12 -0700, William Kossack
<kossackw@.njc.org> wrote:

>At one point I had the odbc 3.5 developers guide but I had to leave that
>behind as a result of a layoff.
>Now after several years I find I'm getting back into odbc but when I
>search I find that all books on odbc are out of print. Some are still
>available like the 3.5 developers guide but hard to get.
>is there a good book on odbc programming that is current?
>

books on odbc

At one point I had the odbc 3.5 developers guide but I had to leave that
behind as a result of a layoff.
Now after several years I find I'm getting back into odbc but when I
search I find that all books on odbc are out of print. Some are still
available like the 3.5 developers guide but hard to get.
is there a good book on odbc programming that is current?Only thing I know of that is current is online at msdn. You
can use the ODBC Programmer's Reference which is at:
http://msdn.microsoft.com/library/e...this_manual.asp
-Sue
On Wed, 31 Mar 2004 09:31:12 -0700, William Kossack
<kossackw@.njc.org> wrote:

>At one point I had the odbc 3.5 developers guide but I had to leave that
>behind as a result of a layoff.
>Now after several years I find I'm getting back into odbc but when I
>search I find that all books on odbc are out of print. Some are still
>available like the 3.5 developers guide but hard to get.
>is there a good book on odbc programming that is current?
>sql

bol tutorial help: browse cube hangs every time

Hey I'm working my way through the tutorials... and every time I get to the point where I get to "browse the deployed cube" in lesson 2 -- Biz Intelligence Studio hangs. The browser tab is selected, it says "Loading...", and I have an hour glass. Management Studio shows that the cube was deployed. I've tried with two different servers... I'm admin on both. Almost no CPU util on client and server. I've let it run for days with no result.

Any ideas on what's wrong or how to diagnose this?

Thanks,
Fred

Try reinstalling Office Web Components(OWC).

sql

Blocking

Hi
I have lot of blocking issues in my DB and complaining to my vendor did not
yield any results.They point that DB is the bottleneck.I have a application
running 4 cpu box with 4 GB RAM.I get blocking every hour.
I am thiniking of writing a script which would run continuosly and kill the
blocking header thread spid if in case it happens to be only 'select'.This
would take an input parameter of seconds which can be max execution time tha
t
killer sql can take.
Awaiting cooments and help on writing this scripts.
Recthttp://www.sqlservercentral.com/col...m/deadlocks.asp
You need to clean up the code.. or figure out the cause...
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:89D494F7-8B6A-49C3-B36B-FC4AB3120CDF@.microsoft.com...
> Hi
> I have lot of blocking issues in my DB and complaining to my vendor did
not
> yield any results.They point that DB is the bottleneck.I have a
application
> running 4 cpu box with 4 GB RAM.I get blocking every hour.
> I am thiniking of writing a script which would run continuosly and kill
the
> blocking header thread spid if in case it happens to be only 'select'.This
> would take an input parameter of seconds which can be max execution time
that
> killer sql can take.
> Awaiting cooments and help on writing this scripts.
> Rect|||Hi Sloan,
We are killing only the spid if they block and do only 'select' right?
Do you think it will harm my application anyway?
The problem is, blocking happeing only during heavy load.
We are considering this only as short term solution
Rect
"sloan" wrote:

> http://www.sqlservercentral.com/col...m/deadlocks.asp
> You need to clean up the code.. or figure out the cause...
>
>
> "Rect" <Rect@.discussions.microsoft.com> wrote in message
> news:89D494F7-8B6A-49C3-B36B-FC4AB3120CDF@.microsoft.com...
> not
> application
> the
> that
>
>|||On Thu, 27 Apr 2006 10:41:02 -0700, Rect wrote:

>Hi
>I have lot of blocking issues in my DB and complaining to my vendor did not
>yield any results.They point that DB is the bottleneck.I have a application
>running 4 cpu box with 4 GB RAM.I get blocking every hour.
>I am thiniking of writing a script which would run continuosly and kill the
>blocking header thread spid if in case it happens to be only 'select'.This
>would take an input parameter of seconds which can be max execution time th
at
>killer sql can take.
>Awaiting cooments and help on writing this scripts.
>Rect
Hi Rect,
You gave no details on the size of the DB and the number of concurrent
transactions - but the most probable cause is an application that has
not been optimized for concurrency. Instead of killing transactions, I'd
suggest you talk to the vendor again and instruct them to fix the
problem.

> They point that DB is the bottleneck.
Yeah - but if they designed the DB and built the application that uses
the DB, then who's to blame for the DB being the botlleneck?
Hugo Kornelis, SQL Server MVP

blank query window- how to get?

In Sql Server Query Analyzer, to get a blank query window, it seems that I
must first edit an existing stored procedure, at which point the "New
window" button is enabled.
Is there a way to get an empty window without first having to edit another
query? If I launch Query Analyzer, I have an empty instance of the app..how
do I get a blank query window?
thx1. You must be connected to an instance of sqlserver.
2. [ctrl]+[N] should open a new window/connection to the connected instance.
-oj
"mrmagoo" <-> wrote in message news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> In Sql Server Query Analyzer, to get a blank query window, it seems that I
> must first edit an existing stored procedure, at which point the "New
> window" button is enabled.
> Is there a way to get an empty window without first having to edit another
> query? If I launch Query Analyzer, I have an empty instance of the
> app..how
> do I get a blank query window?
> thx
>|||that's my point...it doesn't.
I launch query analyzer, and pick the server. It connects.
By default it does open an empty query window. If I close that, there's no
way that I can see to get another one unless I edit another stored
procedure. THEN I can Ctrl + N to get as many new windows as I want.
"oj" <nospam_ojngo@.home.com> wrote in message
news:udqvtV6TGHA.224@.TK2MSFTNGP10.phx.gbl...
> 1. You must be connected to an instance of sqlserver.
> 2. [ctrl]+[N] should open a new window/connection to the connected
instance.
> --
> -oj
>
> "mrmagoo" <-> wrote in message
news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
I
another
>|||When you close the last window, there is nothing left in "query window"
cache to use to reinitiate a new connection for another query window. This
is by design and would not be enhanced - QA is now replaced with Management
Studio (sqlwb) in sql2k5.
-oj
"mrmagoo" <-> wrote in message news:eGUfXo6TGHA.4740@.TK2MSFTNGP14.phx.gbl...
> that's my point...it doesn't.
> I launch query analyzer, and pick the server. It connects.
> By default it does open an empty query window. If I close that, there's no
> way that I can see to get another one unless I edit another stored
> procedure. THEN I can Ctrl + N to get as many new windows as I want.
>
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:udqvtV6TGHA.224@.TK2MSFTNGP10.phx.gbl...
> instance.
> news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> I
> another
>|||ok..thanks...
"oj" <nospam_ojngo@.home.com> wrote in message
news:eGk2Jk8TGHA.4900@.TK2MSFTNGP12.phx.gbl...
> When you close the last window, there is nothing left in "query window"
> cache to use to reinitiate a new connection for another query window. This
> is by design and would not be enhanced - QA is now replaced with
Management
> Studio (sqlwb) in sql2k5.
> --
> -oj
>
> "mrmagoo" <-> wrote in message
news:eGUfXo6TGHA.4740@.TK2MSFTNGP14.phx.gbl...
no
>|||"mrmagoo" <-> wrote in message news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
> In Sql Server Query Analyzer, to get a blank query window, it seems that I
> must first edit an existing stored procedure, at which point the "New
> window" button is enabled.
> Is there a way to get an empty window without first having to edit another
> query? If I launch Query Analyzer, I have an empty instance of the
> app..how
> do I get a blank query window?
> thx
>
CTRL+O
or
Select File / Connect...
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||thanks!
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:eYLv$gEUGHA.2444@.TK2MSFTNGP14.phx.gbl...
> "mrmagoo" <-> wrote in message
news:eO$AWA6TGHA.4956@.TK2MSFTNGP09.phx.gbl...
I
another
> CTRL+O
> or
> Select File / Connect...
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

Bizzarre SSIS Configuration behavior

I have an SSIS package, (actually many packages at this point because I can duplicate this problem each and every time) with an FTP Task and three connection managers (one for FTP, one for a file share, one OLEDB).

The package in its simplest form, grabs a file from an FTP site and transfers it to the file share. When there are no files found on the FTP site, the FTP task fails as expected.

Here is where it gets strange...I turned on a package configuration, with all variables / properties saved to a SQL table; all except for the OLEDB connection which I am leaving hardcoded in the package for the time being.

The problems I am seeing as soon as I activate the package configuration are twofold: The first occurs with the property "FileUsageType" defined to the file share connection. I have it set to "existing folder" in the SSIS tool, the SQL config table also has a row for this item defined with a value of 2. I have even tried manually changing this value in the SQL config table and the result is always the same error when I run the package:

Error: 0xC002F314 at FTP Task, FTP Task: File usage type of connection "Z:\" should be "FolderExists" for operation "Receive".

If I remove this entry totally from the SQL config table, and leave that property hardcoded in the package then I am able to continue execution in the package and that particular error goes away. But then I come to weird problem #2: I stated above that when there are no files in the FTP directory to retrieve, then the FTP task fails, as I would expect. However, as soon as I activate the package configuration, even when there are no files at the FTP site, the FTP task doesnt fail anymore, it marks itself as successful instead. This is wreaking havoc on my precedence constraints that follow the FTP task naturally. As soon as I deactivate the package configuration, the FTP task behaves normally again.

The problems only seem to happen with config packages stored in SQL. I tested this also with XML file config instead and everything seemed to behave as it should. Unfortunately, I need to store these configs in SQL, not XML.

Does anyone have any ideas on what I need to look at to fix these weird issues?

When you say you have "all variables / properties" saved to a SQL table, what do you mean? Do you really have ALL of them? I'd suggest only storing what you need, if that's the case.|||

Phil,

I have tried it both ways, storing all variables / properties in the SQL table, and just storing only the ones I need (i.e connection strings, file paths, etc). In both cases the outcome is the same as far as the issue with the FTP Task reporting success when it shouldnt. Of course when I store only what I need in the table then the first problem with the "FileUsageType" property, goes away; I can live with keeping that property setting hardcoded in the package. But the success reporting on a task that should fail, and ignoring all my precedence constraints is one I cant so easily work around.

|||

The only thing I can suggest is starting with a configuration-free package that works as desired, and then start configuring one property at a time, testing each step of the way. When you can pinpoint "taking this specific step makes it stop working in this speific way" you'll likely see what's going wrong.

If not, this will make it a lot easier for the folks here to help troubleshoot...