how can i connect to sqlserver2005 express by ado

hr = m_pConnection.CreateInstance("ADODB.Connection");
if (SUCCEEDED(hr))
{
if (FAILED(m_pConnection->Open("Provider = sqloledb;Server=(local);Database=c863;Trusted_Connection=yes","","",-1)))
{
AfxMessageBox("Can not open Database!");
m_pConnection.Release();
return FALSE;
}

}
when i debug ,there is an exception at "m_pConnection->Open("Provider = sqloledb;Server=(local);Database=c863;Trusted_Connection=yes","","",-1)))"
the exception is
'Book.exe': Loaded 'C:\Program Files\Common Files\System\Ole DB\sqloledb.rll', Binary was not built with debug information.
First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4..
how should i do?

Try

Server=(local)\SQLEXPRESS

SQL Express is installed as a "named" instance by default, an drequires the instance name specification when making a connection (as opposed to a "default" instance).|||Sorry,it dont still work.the exception is
"First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4.."|||It looks like the failure may be unrelated to your connection string.

>> First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4.

Try running your application with a debugger attached and breaking at the point the exception occurs. This will likely give you more insight into the cause of the problem.

Hope this helps,
Vaughn

how can i connect to sqlserver2005 express by ado

hr = m_pConnection.CreateInstance("ADODB.Connection");
if (SUCCEEDED(hr))
{
if (FAILED(m_pConnection->Open("Provider = sqloledb;Server=(local);Database=c863;Trusted_Connection=yes","","",-1)))
{
AfxMessageBox("Can not open Database!");
m_pConnection.Release();
return FALSE;
}

}
when i debug ,there is an exception at "m_pConnection->Open("Provider = sqloledb;Server=(local);Database=c863;Trusted_Connection=yes","","",-1)))"
the exception is
'Book.exe': Loaded 'C:\Program Files\Common Files\System\Ole DB\sqloledb.rll', Binary was not built with debug information.
First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4..
how should i do?Try

Server=(local)\SQLEXPRESS

SQL Express is installed as a "named" instance by default, an drequires the instance name specification when making a connection (as opposed to a "default" instance).|||Sorry,it dont still work.the exception is
"First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4.."
|||It looks like the failure may be unrelated to your connection string.

>> First-chance exception at 0x7c81eb33 in Book.exe: Microsoft C++ exception: _com_error at memory location 0x0013fba4.

Try running your application with a debugger attached and breaking at the point the exception occurs. This will likely give you more insight into the cause of the problem.

Hope this helps,
Vaughnsql

How can I clear active connections without disabling the database?

To better explain the question let me build a scenario.
If someone is connected to the database there is an active connection, which does appear in Management Studio. If we try to do a restore of the database, SQL gives us a message saying that it cannot gain exclusive access to the database and the restore fails. To gain exclusive access to the database we need to clear the active connections.
Currently in Management Studio the only ways that I have found to clear the connections are to take the database offline or detach the database completely. What I would like to know is if there is another way to clear the active connections without have to take the database offline or detach it?
In SQL 2000 I could right-click the database, select all tasks, and then select detach database and click clear connections. Of course I would then have to make sure I clicked cancel otherwise I would mistakenly detach the database. This would clear the connections without taking the database offline.
If the only option in Management Studio to clear the connections is to disable the database I would like to request an option under tasks called clear connections. This way the server administrator could click on this to see the current active connections and clear them, either individually, or all of them without having to take the database offline or detach it.
Thanks in advance!

There are several ways you can do this without having to detach the database.
1. run sp_who2 to see all the SPIDs connected to your database. For each SPID, execute kill <spid #>

2. In Object Explorer, Click on Management -> Activity Monitor. RIght-click, select View Processes. From there, you can filter the proccesses any way you want, even by database. After that, you can right-click on each process and select Kill Process.
While it's not a one-shot command, you do have much more control over who gets disconnected.
|||I tried what you suggested and it works. I was curious still though if there are any plans to add a clear connections options that will allow us to clear all connections to a database with one click of a button, similar to SQL 2000.
sql

How can I change “Language” setting using “Locale Identifier” of DBPromptInitialize dialog?

Hi,

I use pIDBPromptInitialize interface for establish a connection to MS SQL Server 2005.

SQL Server has “us_english” (LCID=1033) language as default setting.

I use the following part of code to charge LCID (from 1033 to 1049):

CDBPropSet ps3;

ps3.SetGUID(DBPROPSET_DBINIT );

ps3.AddProperty(DBPROP_INIT_LCID, (long)1049);

hr= pIDBProperties->SetProperties(1, &ps3);

hr= pIDBPromptInitialize->PromptDataSource(NULL, GetActiveWindow(),

DBPROMPTOPTIONS_PROPERTYSHEET,

0, NULL, (LPOLESTR)szFilter,

IID_IDBProperties, (IUnknown **)(&pIDBProperties));

...

hr = FDS->Connection->m_spInit->Initialize();

Then I connect to SQL Server successfully.

But SQL Server has LCID=1033 anyway!! Way I didn’t change it by my code? What is wrong?

But later I try to use some feature of LCID=1049 (date conversation)

How can I change “Language” setting to, for example, Russian (LCID=1049) using pIDBPromptInitialize

G.Can you elaborate on what do you do exactly? Which actions are you expecting to be affected by LCID setting?|||

Hi Anton,

I have MS SQL Server 2005 with LCID = 1033 (english).

As result the datetime format is mdy.

I have the table t1 with the following structure:

create table t1 ([Date] datetime not null, [d1] int);

which has the following data:

[Date] [d1]

--

2007-05-12 00:00:00.000 100

2007-05-13 00:00:00.000 200

2007-05-14 00:00:00.000 300

2007-05-15 00:00:00.000 400

Next, I have a OLEDB C++ client application, which makes and executes the following command:

CString cmd;

COleDateTime dt;

dt= COleDateTime::GetCurrentTime();

cmd.Format(L”select * from [t1] where [Date]= ‘%s’”, dt.Format(VAR_DATEVALUEONLY, LOCALE_USER_DEFAULT)

...

For me, the LOCALE_USER_DEFAULT value is 1049.

It is important to pay attention that LCID of MSSQL Server is 1033 and LCID of client application is 1049.

Next...

After formatting, my oledb command looks like this:

select * from [t1] where [Date]= ’14.05.2007’

and result of execution I get SQL Server error: convert is not possible. It is because MS SQL Server parse the ’14.05.2007’ date using not appropriate datetime formar.

My goal is to set LCID of SQL Server oledb connection as I need (in example above to 1049).

PS

I can’t use the ‘set dateformat dmy’ command.

PS2

Of cause, I could use the following command:

FLCID= 1033;

...

cmd.Format(L”select * from [t1] where [Date]= ‘%s’”, dt.Format(VAR_DATEVALUEONLY, FLCID);

...

But it isn’t my goal.

Best regards,

SGN

|||Could you try using a parameterized query? I think in that case the data will be passed to the server in a binary form if you provide a corresponding binding, so you could avoid a conversion to string.|||

Take a look at GetDateFormat function - http://msdn2.microsoft.com/en-us/library/ms776293.aspx

Hope this helps

|||

Hi,

Thank you for your replay!

Regarding usage of the GetDateFormat function I have another question.

It concern not only SQL Server but ALL OLEDB datasources.

How can I know the LCID of OLEDB datasource which I can use as datastorage?

Is it possible to get current LCID of OLEDB datasource using OLEDB functionality only?

Thank you for your help!

Best regards,

SGN

|||

I'm not sure if there is a generic OLEDB way.

Session language for the SQL Server is a provider specific property SSPROP_INIT_CURRENTLANGUAGE.

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

For sqlserver you can also change the language by executing sp_configure, and the list of supported languages can be produced by sp_helplanguage. Default language for the login can alos be overriden at hte session level by executing SET LANGUAGE.

How can I change “Language” setting using “Locale Identifier” of DBPromptInitialize dialog?

Hi,

I use pIDBPromptInitialize interface for establish a connection to MS SQL Server 2005.

SQL Server has “us_english” (LCID=1033) language as default setting.

I use the following part of code to charge LCID (from 1033 to 1049):

CDBPropSet ps3;

ps3.SetGUID(DBPROPSET_DBINIT );

ps3.AddProperty(DBPROP_INIT_LCID, (long)1049);

hr= pIDBProperties->SetProperties(1, &ps3);

hr= pIDBPromptInitialize->PromptDataSource(NULL, GetActiveWindow(),

DBPROMPTOPTIONS_PROPERTYSHEET,

0, NULL, (LPOLESTR)szFilter,

IID_IDBProperties, (IUnknown **)(&pIDBProperties));

...

hr = FDS->Connection->m_spInit->Initialize();

Then I connect to SQL Server successfully.

But SQL Server has LCID=1033 anyway!! Way I didn’t change it by my code? What is wrong?

But later I try to use some feature of LCID=1049 (date conversation)

How can I change “Language” setting to, for example, Russian (LCID=1049) using pIDBPromptInitialize

G.Can you elaborate on what do you do exactly? Which actions are you expecting to be affected by LCID setting?|||

Hi Anton,

I have MS SQL Server 2005 with LCID = 1033 (english).

As result the datetime format is mdy.

I have the table t1 with the following structure:

create table t1 ([Date] datetime not null, [d1] int);

which has the following data:

[Date] [d1]

--

2007-05-12 00:00:00.000 100

2007-05-13 00:00:00.000 200

2007-05-14 00:00:00.000 300

2007-05-15 00:00:00.000 400

Next, I have a OLEDB C++ client application, which makes and executes the following command:

CString cmd;

COleDateTime dt;

dt= COleDateTime::GetCurrentTime();

cmd.Format(L”select * from [t1] where [Date]= ‘%s’”, dt.Format(VAR_DATEVALUEONLY, LOCALE_USER_DEFAULT)

...

For me, the LOCALE_USER_DEFAULT value is 1049.

It is important to pay attention that LCID of MSSQL Server is 1033 and LCID of client application is 1049.

Next...

After formatting, my oledb command looks like this:

select * from [t1] where [Date]= ’14.05.2007’

and result of execution I get SQL Server error: convert is not possible. It is because MS SQL Server parse the ’14.05.2007’ date using not appropriate datetime formar.

My goal is to set LCID of SQL Server oledb connection as I need (in example above to 1049).

PS

I can’t use the ‘set dateformat dmy’ command.

PS2

Of cause, I could use the following command:

FLCID= 1033;

...

cmd.Format(L”select * from [t1] where [Date]= ‘%s’”, dt.Format(VAR_DATEVALUEONLY, FLCID);

...

But it isn’t my goal.

Best regards,

SGN

|||Could you try using a parameterized query? I think in that case the data will be passed to the server in a binary form if you provide a corresponding binding, so you could avoid a conversion to string.|||

Take a look at GetDateFormat function - http://msdn2.microsoft.com/en-us/library/ms776293.aspx

Hope this helps

|||

Hi,

Thank you for your replay!

Regarding usage of the GetDateFormat function I have another question.

It concern not only SQL Server but ALL OLEDB datasources.

How can I know the LCID of OLEDB datasource which I can use as datastorage?

Is it possible to get current LCID of OLEDB datasource using OLEDB functionality only?

Thank you for your help!

Best regards,

SGN

|||

I'm not sure if there is a generic OLEDB way.

Session language for the SQL Server is a provider specific property SSPROP_INIT_CURRENTLANGUAGE.

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

For sqlserver you can also change the language by executing sp_configure, and the list of supported languages can be produced by sp_helplanguage. Default language for the login can alos be overriden at hte session level by executing SET LANGUAGE.

sql

How can connect SSAS w/o domain trusted connection?

I got error: An existing connection was forcibly closed by the remote host!!

string connstr = "Provider=MSOLAP.3;Data Source=amsserver;Password=;User ID=administrator;Initial Catalog=MIP2ASProject";

Client in XP, with AS9.0 provider installed, server is sqlserver 2005 in win2003 xp1.

Both machines are not under domain controller...

Moving to SQL Server Analysis Services forum.|||

Analysis Services does not support non-Windows authentication when connecting through TCP/IP.

You should be able to setup HTTP connectivity to SSAS.
See following:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

And then use different type of authentication avaliable in IIS to connect to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

how can associated sa with a trusted SQL Server connection in sql server 2005?

I want to use sa user login sql server 2005 to visit my database "dotnet20" but when I set the user property in User Mapping, It Report
when I set it, An Error Occur like follow
Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)
and also when I want to Login sql server use 'sa' user, It Report
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
how can associated 'sa' with a trusted SQL Server connection?

I'm having this exact same problem.

When I login using Windows authent. I can connect to the DB but cannot ad users or grant permissions.

I can create tables fine, but other than that not much? Any idea.

I basically wanted to enable SQL Authent. as well as windows in the security Tab after right-clicking on my Database, but the Windows login lacks the rights although it was used to create the DB and all.

Help !

|||

Basically, how can I add my Windows user account to the sysadmin role.

I couldve used the default sa account but whenever I login in SQL Serv authent. mode using 'sa' and blank Pwd on the SQL Serv Mngmt Studio Express CTP, on the 1st attempt, it says smthg. like

Cannot connect to INSPI6K\SQLEXPRESS.

----------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

Upon trying again just says

Cannot connect to INSPI6K\SQLEXPRESS.

----------
ADDITIONAL INFORMATION:

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476

when I changed the Network protocol to Named Pipes or TCP/IP I got

Cannot connect to INSPI6K\SQLEXPRESS.

----------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)

What's happening? Why can't I login as 'sa' ?

Please tell me all U DBA-gods out there...

|||

One f the suggestions I recvd. was to hack the registry, and change theLoginMode of the SQL Server 2005 Express.

Any idea how to go about it, and which Reg. key to change for enabling mixed authentications(SQL & Windows), instead of just Windows auth.?

I saw this article but couldn't find that key

http://support.microsoft.com/default.aspx?scid=kb;en-us;285097

Thanks

|||

OK I finally found theLoginMode key by searching the Registry and changed it to 2 (original value was 1)

Required a Restart, for it to take effect.

Thankfully not getting thetrusted connection error anymore.

But now it's whining about the password.

AFAIK I never set any Pwd for 'sa' account, yet executing sqlcmd on command prompt throws error

Password Msg:18456

Is there any way to reset the sa PWD? What's the way out?

|||

Phew! The problem has finally been resolved.

What a nightmare... all due to installing SQL Server 2005 Express on top of existing MSDE (from VS 7.0)

Seehttp://forums.asp.net/1222469/ShowPost.aspx for further details.

and with some help from this articlehttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124596&SiteID=1

Thanks.

Moral of the story: Always unninstall previous versions. Better safe than very sorry !

How best to do remote site replication?

It has been suggested that we consider how to replicate our production
server to a remote site that does not have a dedicated connection to our
production environment. Any and all suggestions are appreciated.
TIA
Michael MacGregor
Database Architect
SalesDriver
Michael,
assuming there's no direct connection, this type of setup is usually done
through a VPN.
Here is a reference to help you:
http://support.microsoft.com/?id=321822.
Regards,
Paul Ibison
|||Additionally, I should mention that pull subscriptions would be most
suitable.
Regards,
Paul Ibison
|||Thanks Paul.
Totally new to replication and our IT guy is proposing some really weird and
wacky ideas on how to do this, one of which is low-level bit comparison, and
subsequent updating, of backup files to use to restore a database. Makes me
shake my head in wonder.
Michael MacGregor
Database Architect
SalesDriver
|||Michael,
if this is for disaster recovery you might want to consider log-shipping.
There have been a few threads recently (last 2 weeks) comparing this to
transactional replication which might be helpful, and it is a standard way
of maintaining a database copy. Using propriety solutions like
bit-comparisons would no doubt not be supported by ms, and presumably would
require a comparison of the full database backup. Also, log shipping will
just require that you transmit the changes which are in the log to the
remote site rather than full backups.
HTH,
Paul Ibison
|||To be honest, I'm not too sure what problem this is supposed to address. We
have an active/passive SQL Server cluster which has only been required once
in over three years. In addition there is a fairly standard backup/recovery
plan in effect with regular backups, both full and transactional, performed.
The IT guy has got the idea of having another SQL Server installed at a
remote site, to act as what I'm not sure, but wants to have it as close to
the production server as possible.
I wondered about log-shipping as well, but I'm not even sure that this idea
is going to fly anyway, but thought I'd do a little research of my own
before this issue gets raised on a more formal basis, at which point in time
I can address it better then.
Would you be able to provide me with the subject titles of the threads you
refer to?
Michael MacGregor
|||Michael,
the main thread was entitled "Disaster recovery - Use Replication or Log
shipping".
HTH,
Paul Ibison

How ? Global variable as SQL Connection in DTS

Can I define a Global variable and use it as a Connection to SQL Server .

What I want to do is Create a DTS which pumps out files to an app server. However this might be done in different environments and I want to keep the SQL Connection Dynamic and change it in global parameter value.

Please help ,,,

ThanksI would write a sproc with bcp...and keep the configurations in a table...

Does it have to be DTS?

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
> > We are looking at the possible deployment of the SQL 2005 hot fix
> > described inhttp://support.microsoft.com/kb/916002#appliestoto
> > resolve connection issues with .net to SQL. However, we are unable to
> > determine if this hot fix has any prerequisites (such as sp1), or if
> > it fixed in sp1 or even in sp2. I have searched extensively online,
> > and I do not see this as fixed in any service pack documents (although
> > the lists are seldom complete), and the prerequisites are missing in
> > the KB article.
> > Any help would be appreciated.
> > Terry- Hide quoted text -
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps :)
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps :)
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
> > The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> > this is not a SQL hotfix?
> > Terry- Hide quoted text -
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
TerryIt's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegroups.com...
>
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...th
at
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product th
at
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry

Hot Fix Prerequisites and Need with Service Packs

We are looking at the possible deployment of the SQL 2005 hot fix
described in http://support.microsoft.com/kb/916002#appliesto to
resolve connection issues with .net to SQL. However, we are unable to
determine if this hot fix has any prerequisites (such as sp1), or if
it fixed in sp1 or even in sp2. I have searched extensively online,
and I do not see this as fixed in any service pack documents (although
the lists are seldom complete), and the prerequisites are missing in
the KB article.
Any help would be appreciated.
Terry
It's not a SQL Server hotfix:
APPLIES TO
. Microsoft ADO.NET 2.0
So in theory, you could be running RTM SQL 2005 and this would work after
applying the fix.
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Terry" <tduffy@.calamos.com> wrote in message
news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
> We are looking at the possible deployment of the SQL 2005 hot fix
> described in http://support.microsoft.com/kb/916002#appliesto to
> resolve connection issues with .net to SQL. However, we are unable to
> determine if this hot fix has any prerequisites (such as sp1), or if
> it fixed in sp1 or even in sp2. I have searched extensively online,
> and I do not see this as fixed in any service pack documents (although
> the lists are seldom complete), and the prerequisites are missing in
> the KB article.
> Any help would be appreciated.
> Terry
>
|||On Jan 31, 9:47 am, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> It's not a SQL Server hotfix:
> APPLIES TO
> . Microsoft ADO.NET 2.0
> So in theory, you could be running RTM SQL 2005 and this would work after
> applying the fix.
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
> "Terry" <tdu...@.calamos.com> wrote in message
> news:1170253010.111201.95670@.p10g2000cwp.googlegro ups.com...
>
>
> - Show quoted text -
The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
this is not a SQL hotfix?
Terry
|||The "applies to" is the defining term here, not the (SQL Hotfix) part...that
simply means the portion of ADO that is being fixed.
SQL Hotfix KBs have a list of the files that are being replaced, this KB
does not.
I tried to install it on my box and was told I did not have the product that
it applied to, but I do have the correct versions of SQL Server on my test
box.
Hope that helps
You can always call PSS and get a free incident opened and ask the same
question...just give them the KB article number when you call,
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

> The KB Article mentions. BUG #: 483 (SQL Hotfix). What makes you say
> this is not a SQL hotfix?
> Terry
>
|||On Feb 1, 12:40 pm, "Kevin3NF" <k...@.SPAMTRAP.3nf-inc.com> wrote:
> The "applies to" is the defining term here, not the (SQL Hotfix) part...that
> simply means the portion of ADO that is being fixed.
> SQL Hotfix KBs have a list of the files that are being replaced, this KB
> does not.
> I tried to install it on my box and was told I did not have the product that
> it applied to, but I do have the correct versions of SQL Server on my test
> box.
> Hope that helps
> You can always call PSS and get a free incident opened and ask the same
> question...just give them the KB article number when you call,
> --
> Kevin Hill
> 3NF Consultinghttp://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:http://kevin3nf.blogspot.com
>
>
> - Show quoted text -
Thank you Kevin. Your efforts and responses are greatly appreciated.
Terry