Intermittent SQL Server does not exist or access denied.

ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
RoxanneWhen they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:

>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne|||Search no further...
http://support.microsoft.com/defaul...kb;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.

Intermittent SQL Server does not exist or access denied.

ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Servers running Windows 2003 SQL 2000.
This has been a problem for a long time (less than .3% of the time). No
code changes have been made. The only changes was Windows SP1 and post
SP patches on all servers. The patching may have made this issue more
pronounced.
Any suggestions from the experts?
Thanks,
Roxanne
When they are intermittent they are difficult to track down.
Often those related to network connectivity issues. Have you
checked the event logs on the IIS box - particularly looking
for any network related issues?
-Sue
On 2 Nov 2005 10:32:52 -0800, roxy636@.yahoo.com wrote:

>ASP.NET application with intermittent returns of 503 errors with the
>following message.
>System.Data.SqlClient.SqlException: SQL Server does not exist or access
>denied. SQL Server does not exist or access denied.
>An unhandled exception was generated during the execution of the
>current web request. Information regarding the origin and location of
>the exception can be identified using the exception stack trace below.
>Servers running Windows 2003 SQL 2000.
>This has been a problem for a long time (less than .3% of the time). No
>code changes have been made. The only changes was Windows SP1 and post
>SP patches on all servers. The patching may have made this issue more
>pronounced.
>Any suggestions from the experts?
>Thanks,
>Roxanne
|||Search no further...
http://support.microsoft.com/default...b;en-us;328476
Note, this answer took forever to find so I'm posting everywhere...
|||So was your solution to enable connection pooling? Or was it simply a
tcp/ip configuration issue. Unless you explicitly disable connection
pooling, then connections should be pooled, were you disabling pooling?
Thanks for any info, we are seeing the exact same symptoms at a client
of ours.
|||Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:
path:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\servic es\Tcpip\Parameters
type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)
type: DWORD
name: MaxUserPort
value: 10000 (decimal)
Ultimately is connection ooliing is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt...if you see around
4000 connections in TIME_WAIT, then that is the problem.
|||Thanks, since connection pooling is enabled and this is occuring even
soon after a reboot under low load. I do not suspect we are creating
too many connections to sql, but I do suspect some network
communication problems. I am going to further diagnose thier network
configuration relative to the front and back planes of the web server.
But I will not overlook this as a possibility, so I will also get a
netstat -n Thanks so much for the info..
|||Turned out to be Bandwidth Throttling, disabling that option for the
Application Pool alleviated the HTTP 503 errors.

intermittent SQL Server does not exist or access denied

Hi,
We seperated out our web server (IIS) from our SQL Server recently. Things
have gone well, except one thing. Intermittently, we get the message "SQL
Server does not exist or access denied" when users try to get to the site.
The two machines are connected via a 1GBps direct connection. We've seen
high usage of that connection at times when this has happened, but not
always. Does anyone have any ideas?
Here's the connection string...
"Provider=SQLOLEDB;User ID=our_db_user;Initial
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
rd"
Thanks in advance.
JoshNo one has any ideas?
"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> Hi,
> We seperated out our web server (IIS) from our SQL Server recently.
Things
> have gone well, except one thing. Intermittently, we get the message
"SQL
> Server does not exist or access denied" when users try to get to the site.
> The two machines are connected via a 1GBps direct connection. We've seen
> high usage of that connection at times when this has happened, but not
> always. Does anyone have any ideas?
> Here's the connection string...
> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
> rd"
> Thanks in advance.
> Josh
>|||Try the following troubleshooting article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>No one has any ideas?
>"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> Hi,
>> We seperated out our web server (IIS) from our SQL Server recently.
>Things
>> have gone well, except one thing. Intermittently, we get the message
>"SQL
>> Server does not exist or access denied" when users try to get to the site.
>> The two machines are connected via a 1GBps direct connection. We've seen
>> high usage of that connection at times when this has happened, but not
>> always. Does anyone have any ideas?
>> Here's the connection string...
>> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
>> rd"
>> Thanks in advance.
>> Josh
>>
>|||Thanks for the info, Sue.
I think most of those are for cases where you can't EVER connect.
Unfortunately, ours is only intermittant. It seems like the number of
connections jumps up when it happens, too. Any thoughts?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
> Try the following troubleshooting article:
> INF: Potential Causes of the "SQL Server Does Not Exist or
> Access Denied" Error Message
> http://support.microsoft.com/?id=328306
> -Sue
> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
> <josh@.sparkpeople.com> wrote:
> >No one has any ideas?
> >
> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> >> Hi,
> >>
> >> We seperated out our web server (IIS) from our SQL Server recently.
> >Things
> >> have gone well, except one thing. Intermittently, we get the message
> >"SQL
> >> Server does not exist or access denied" when users try to get to the
site.
> >> The two machines are connected via a 1GBps direct connection. We've
seen
> >> high usage of that connection at times when this has happened, but not
> >> always. Does anyone have any ideas?
> >>
> >> Here's the connection string...
> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
> >>
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
o
> >> rd"
> >>
> >> Thanks in advance.
> >> Josh
> >>
> >>
> >
>|||You can still have intermittent problems with some of the
network related issues sited in the article. You may also
want to check the Windows event logs on both servers for any
network related issues.
-Sue
On Thu, 23 Oct 2003 14:42:31 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>Thanks for the info, Sue.
>I think most of those are for cases where you can't EVER connect.
>Unfortunately, ours is only intermittant. It seems like the number of
>connections jumps up when it happens, too. Any thoughts?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
>> Try the following troubleshooting article:
>> INF: Potential Causes of the "SQL Server Does Not Exist or
>> Access Denied" Error Message
>> http://support.microsoft.com/?id=328306
>> -Sue
>> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
>> <josh@.sparkpeople.com> wrote:
>> >No one has any ideas?
>> >
>> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> >> Hi,
>> >>
>> >> We seperated out our web server (IIS) from our SQL Server recently.
>> >Things
>> >> have gone well, except one thing. Intermittently, we get the message
>> >"SQL
>> >> Server does not exist or access denied" when users try to get to the
>site.
>> >> The two machines are connected via a 1GBps direct connection. We've
>seen
>> >> high usage of that connection at times when this has happened, but not
>> >> always. Does anyone have any ideas?
>> >>
>> >> Here's the connection string...
>> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>> >>
>>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
>o
>> >> rd"
>> >>
>> >> Thanks in advance.
>> >> Josh
>> >>
>> >>
>> >
>sql

Intermittent Connection Problems with Sql Server

I am experiencing intermittent connection problems with the Northwind database and sql server express. The most frequent error message indicates that I am already logged in and will not allow another user.

The odd thing is that even when I am locked out I can access a Northwind database from another connection on Server Explorer.

I ran code to demonstrate simple binding for two text boxes, no problem. I added a project to show complex binding using the datagrid view tool, but could not get past selecting the database.

I tried the same simple binding project on another computer running a beta version of VS 2005 Pro and could not connect to Northwind on that computer also. (Two different Northwind databases, different computers)

A couple days ago I restored the database in Solutions Manager and that helped for a while, but I should not have to resort to that, I know.

How do I remove the user lock? I tried Solutions Manager Express with the first computer but could not access the database in the management module.

The exact text of the error would help. It sounds like you might be trying to access the data through both a User Instance and through the parent instance. This doesn't work since only one copy of SQL can access a database at a time.

Mike

|||

Mike-

I learned that whenever I had a problem with connecting to a database, it was because I was using the dataset from the prior project in the solution, in a new project.

Thanks for replying.

Ruel

P.S.

I don't know if I should start a new thread, but how do I pull data from an Excel spreadsheet into a sql server database table?

|||

Hi,

i would suggest to refer

http://blogs.msdn.com/euanga/archive/2006/07/20/672272.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=293466&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1088614&SiteID=1

HTH

Hemantgiri S. Goswami

|||

Thanks Hemantgiri -

The links were helpful for understanding the process of pulling data files into sql server. However, I am still running into a roadblock. For instance, the following:

===================================================================

bulk insert

AAS Accounts

from 'c:\documents and settings\ruel\desktop\invest\aas downloads\dailydownloads'

===================================================================

Where:

AAS = Database Name

Accounts = Table Name

Gives the following error message:

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'Accounts'.

|||

Hi,

run it like,

bulk insert

AAS..Accounts

from 'c:\documents and settings\ruel\desktop\invest\aas downloads\dailydownloads'

or

bulk insert

AAS.ObjectOwner.Accounts

from 'c:\documents and settings\ruel\desktop\invest\aas downloads\dailydownloads'

Hemantgiri S. Goswami

|||

Tried the following as you suggested

bulk insert AAS..Accounts

from 'c:\documents and settings\ruel\desktop\invest\aas downloads\dailydownloads\2a20070112.xls'

With the resulting error message:

Msg 4863, Level 16, State 1, Line 1

Bulk load data conversion error (truncation) for row 1, column 1 (AccountNo).

Column 1 of table Accounts is nchar(15) - I raised it from 10 to 15 to see if that would take care of the truncation issue.

The format for column 1 of the xls file is general.

I have had a similar experience with an xml file.

I also tried the bcp utility to format a file for input but I get a message telling me that either the server does not exist or I do not have access.

Thanks for your assistance

Ruel

|||

Could not get to the server with the bcp utility so I tried bulk insert. I found that I had to use "firstrow=2" to get past error messages.

bulk insert

AAS..Accounts

from 'c:\documents and settings\ruel\desktop\invest\aas downloads\dailydownloads\2a20070112.xls'

with

(

firstrow=2

)

However, the above returns the following message in SSMSE:

(0 row(s) affected)

|||

Hi,

Could ensure the length of the all field!!!!

Hemantgiri S. Goswami

Interface Not Registered

I was trying to burn cds when I got thisfda error message stating Interface not Registered what does this mean and can someone tell me how to fix it

-thanks Lequeta

Wrong forum

Interesting Math Problem

-- Original Message --
I'm not a math genius but I like a challenge and I was thinking over the
wend and am now stuck as to how to go.
My youngest son, Silas is 3
My daughter, Millie is 5
My eldest son, Samuel is 7
These are all prime numbers
My age is a prime number, as is that of the ex wife (although she is older
and fatter than me) - we are both 37
When will this occur again?
By the way, the architect who my ex wife knows rather too well is also a
prime (43) but I don't really care too much for him so he can be excluded
from the equation.
Happy coding, people. My mother, the math teacher already has a solution
that is so tedious it makes you wish you knew SQL instead. Oops.
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiIt will never happen again. Your children are each 2 years apart. All
prime numbers are odd.
If you take any 3 consecutive odd numbers, one of them will always be
divisible by three.
(if you take any 6 consecutive numbers two of them will be divisible by 3,
one even and one odd)
So the only time you can have 3 consecutive odd number that are all prime,
is 3, 5 and 7.
So, after this, you and your kids are all past your prime.
"Mike Labosh" <mlabosh_at_hotmail.com> wrote in message
news:%23dISy83XGHA.4324@.TK2MSFTNGP03.phx.gbl...
> -- Original Message --
> I'm not a math genius but I like a challenge and I was thinking over the
> wend and am now stuck as to how to go.
> My youngest son, Silas is 3
> My daughter, Millie is 5
> My eldest son, Samuel is 7
> These are all prime numbers
> My age is a prime number, as is that of the ex wife (although she is older
> and fatter than me) - we are both 37
> When will this occur again?
> By the way, the architect who my ex wife knows rather too well is also a
> prime (43) but I don't really care too much for him so he can be excluded
> from the equation.
> --
> Happy coding, people. My mother, the math teacher already has a solution
> that is so tedious it makes you wish you knew SQL instead. Oops.
> --
>
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>
>|||> So, after this, you and your kids are all past your prime.
LOL!!
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||> So, after this, you and your kids are all past your prime.
:) Nah, the kids are just fine.
ML
http://milambda.blogspot.com/

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?
I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:

> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?
|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:

> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
>
>

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:
> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:
> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I keep geeting this error message in one of my servers.
> >
> > Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> > 18265 Log backed up: Database: mine, creation date(time):
> > 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> > dump devices: 1, device informa... ..
> >
> >
> > There is no replication configured on the server. The backup job is also
> > successful. What is this message about?
>

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:

> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-107372476
9]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number
of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:

> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
>
>

interesting connection problem

I am having a problem connecting with SQL server management . I get the error I have posted at the end of the message. However, I can successfully connect with my application. I use the same connection attributes with no success. Same login, same protocol, from the same machine.

Any Ideas?

Thanks!

Tracy

TITLE: Connect to Server

Cannot connect to DEEPSHEEP\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: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

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

BUTTONS:

OK

Can you connect to the instance locally by using ".\SQLEXPRESS" instead of "DEEPSHEEP\SQLEXPRESS"?

Do you have SP1 installed with the SSMS Express Edition management tools?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server
http://blogs.msdn.com/sqlrem/

Interesting case of "Invalid attempt to MetaData when reader is closed."

I was going to post a long message but I found the problem. Yet I do not know how to correct it efficiently.

I have a request to my DB using that kind of code :

With SQL_Commande
valiSqlConnection(True)
' Configure SQL_Commande.
.Connection = SQL_Connection
.CommandText = "_Fonctions_valiUtilInfo"
.CommandType = Data.CommandType.StoredProcedure
.Parameters.Clear()
Dim SQL_Lecteur As SqlDataReader = SQL_Commande.ExecuteReader
If SQL_Lecteur.Read And Not IsDBNull(SQL_Lecteur(0)) Then Return SQL_Lecteur(0) Else Return Nothing
valiSqlConnection(False, SQL_Lecteur)
End With

My problem is that I need use a function within the "With" section, and that function calls a request on the DB then closes the query, and when it gets back at executing the remaining part of the code, it stop saying that the query is closed and cannot be excuted anymore. How can I nest a query within an other one without having this problem?

Adding a more user friendly structure explaination :

SQL Request #1
Function A ( Extracted Value #1 )
Extracted Value #2
Extracted Value #3
Closing SQL Resquest #1

Function A ( Value #1 )
SQL Request #A
Returning Extracted Value #A
Closing SQL Request #A

It closes both request. I need to keep the request open. Of course I could change the order, but that is just by passing the problem. As well I know I could redesign the TSQL request to correct the problem, but for now, I do not have the time to do that since the request is very large and would need close to complete redesign.

Thank you!

|||

Finaly, due to lack of answer I remade the entire SQL request.

Interactive Resolver

Error message: "The process failed to get information about the Interactive Resolver from the registry".
I am using MSDE to subscribe to a central 2000 database using a pull subscription and the active X controls. However, the default resolver fails to operate. I have a call in with Product Support and sent them this:
Publication articles are all marked “Use the default resolver” and “Allow Subscribers to resolve conflicts interactively during on-demand synchronizations”. Note we are treating changes to the same column as being a conflict.
On the subscriber, “on demand synchronisations” are marked “Resolve Conflicts interactively…”
In my code to control the ActiveX objects, if I set the “UseInteractiveResolver” property to True, then the error message appears. If I leave this out, the default priority subscription happens.
We ARE NOT using any third party resolver, nor are we using any resolver aside from the interactive one.
However, I still cannot get the interactive resolver to display.
Is there something else. I have tried re-registering all DLLs back on the client after copying them from the 2000 CD ROM (SP3)
Hi Top,
From your descriptoin, I learnt that you the default resolver failed to operate when you subscribed to a
central 2000 database using a pull subscription and the active X controls.
Based on my experience (not 100% sure), the issue would occur if we manually or programmatically
change the Progid of conflict viewer from Wzconflict to CnfViewer. If so, the sync manager is unable to
launch the conflict viewer.
As you have call into Microsoft with Product Support, could you provide us with the Case ID so that we can
handle your post more gracefully and also for community benefits. In this way, we can address your
problem quickly and efficiently making headway to a solution.
We look forward to hearing from you.
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
|||SRS040408600030
|||Hi Mark,
Thank you for your information! We have looked into the issue and found the causes of this issue as I
mentioned in my previous post.
When you tried to merge the data from your client which had MSDE installed you got following error 'The
process failed to get information about the interactive resolver component from the registry". This error was
due to missing DLL files or registry entries of the conflict viewer on your client system.
To solve the problem, we should check the following Registry Keys
------
HKCR\CLSID\{A2CA91F1-7328-4949-8611-8BEDB4AD503C}\InprocServer32 --> 'C:\Program Files
\Common Files\Microsoft Shared\Database Replication\Conflict Viewer\wzcnf.dll'
Check if the dll exists in the same location.
[INFO]Other Keys Accessed by conflict viewer:
HKCR\CLSID\{00000514-0000-0010-8000-00AA006D2EA4}\InprocServer32 -->'C:\Program Files\Common
Files\system\ado\msado15.dll'
HKCU\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
HKCR\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
------
and verify this steps
Steps:
======
1) The Following Files must be in the Directories mentioned for Interactive Conflict resolver to work.
\Program Files\Common Files\Microsoft Shared\Database Replication\Conflict Viewer: wzcnf.dll ,
wzcnfclt.exe
2) The following resource file should be installed in a language specific directory \Program Files\Common
Files\Microsoft Shared\Database Replication\Conflict Viewer\Resources\<LCID>: wzcnfrc.rll
The <LCID> is usually 1033.
IF these files are missing from these directories copy them from the same location on other systems where
the conflict viewer is working fine , or copy them from the Setup CD.Now go to the directory where "Wzcnf.dll
" is located and register it by typing "Regsvr32 wzcnf.dll".
NOTE: If we dont have the Resource file Wzcnfrc.rll, The Conflict viewer will still come up, but the Labels will
be missing from the Buttons on the User Interface.Once we have the Files in place and the Dll file registered,
we'll get the Interactive conflict viwer to come up normally on the MSDE Subscribers.
NOTE: The Conflict Viewer and Interactive Conflict Viewer uses the same exe and Dll.
We appreciated your time and efforts throughout the troubleshooting process. Thank you for posting in
newsgroup.
Best regards,
Billy Yao
Microsoft Online Support
Please reply to newsgroups only. Thanks.

Integrity Violation when syncing with SQL CE, but not MSDE

I'm getting the following error when I do a sync with SQL CE:
Error Code: 80004005 Message : Run
NativeErr.: 28557
Source : Microsoft SQL Server 2000 Windows CE Edition
Err. Par. 0: data source=\Program Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
Error Code: 80040E2F
Message : The row update or insert cannot be reapplied due to an integrity
violation. [,,,,,]
NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
We use merge replication and have several join and select filters. What's
interesting is that MSDE will sync just fine using the same publication.
Is it possible to find out what the offending table is and which row(s) is
causing the problem?
Thanks,
Eli
you might look for data types that were automatically converted during the
merge. For instance any nchar types longer tahtn 255 are converted to ntext
(which can't be a key). ther are a few others that I can't remember. they're
listed in online manuals.
Any of the offending columns can be remedied by modifying the article
properties in the publication setup. There you can turn of indexing
.....integrity settings...etc.. for articles in a publication.
i ran into these type of issues a few times and they were very frustrating
to figure out. If the database structure is intact after the faile merge
perhaps you can look at the local sqlce database with the ce query analyzer.
"Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm getting the following error when I do a sync with SQL CE:
> Error Code: 80004005 Message : Run
> NativeErr.: 28557
> Source : Microsoft SQL Server 2000 Windows CE Edition
> Err. Par. 0: data source=\Program
Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
> Error Code: 80040E2F
> Message : The row update or insert cannot be reapplied due to an integrity
> violation. [,,,,,]
> NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
> We use merge replication and have several join and select filters. What's
> interesting is that MSDE will sync just fine using the same publication.
> Is it possible to find out what the offending table is and which row(s) is
> causing the problem?
> Thanks,
> Eli
>
|||I do have several columns that are varchar(256) that get converted to ntext
when syncing with SQL CE, but as far as I can tell none of these columns are
indexed or are keys. In fact, the sync works fine with some instances of
data, but not with others. When you were having the problem, did it happen
the first time you attempted to sync?
Also, could you explain how to turn off indexing/integrity settings of a
publication in more detail? I couldn't quote follow what you wrote below.
Thanks again for your help,
Eli
"mgarner1980" <mgarner@.kbsi.com> wrote in message
news:u34W8jKhEHA.3916@.TK2MSFTNGP11.phx.gbl...
> you might look for data types that were automatically converted during the
> merge. For instance any nchar types longer tahtn 255 are converted to
ntext
> (which can't be a key). ther are a few others that I can't remember.
they're
> listed in online manuals.
> Any of the offending columns can be remedied by modifying the article
> properties in the publication setup. There you can turn of indexing
> ....integrity settings...etc.. for articles in a publication.
> i ran into these type of issues a few times and they were very frustrating
> to figure out. If the database structure is intact after the faile merge
> perhaps you can look at the local sqlce database with the ce query
analyzer.[vbcol=seagreen]
> "Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
> news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
integrity[vbcol=seagreen]
What's[vbcol=seagreen]
is
>