freelanceprogrammers.org Forum Index » ASP
Link for Web Service
Joined: 10 Jan 2006
Posts: 33
Link for Web Service
I am creating a contact center that will make telephone calls and send emails.
I want to create a synchronous process for the emails though so I know when
someone starts working on a ticket. My idea is to email out an HTML enabled
email with specific information in a hyperlink (query string). I want to
collect that information and the user`s NTLM information and send it to a web
service so that the information can be logged and then display the information
on a web page. My question is can I get the NTLM and query string information
at pre-render issue the web services post there and display the problem
information including the confirmation they are assigned to the ticket, which
would come back from the web services RMI?
Travis
*************************************************************************
This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************
Joined: 11 Jan 2006
Posts: 38
Link for Web Service
Hi Travis...
I`m a little confused as to why you`re bothering with an email instead of
just sending the information to the web service directly; can you elaborate?
Cheers,
Peter
On 1/10/06, Falls, Travis D (HTSC, CASD) <travis.falls@...>
wrote:
>
> I am creating a contact center that will make telephone calls and send
> emails. I want to create a synchronous process for the emails though so I
> know when someone starts working on a ticket. My idea is to email out an
> HTML enabled email with specific information in a hyperlink (query
> string). I want to collect that information and the user`s NTLM information
> and send it to a web service so that the information can be logged and then
> display the information on a web page. My question is can I get the NTLM
> and query string information at pre-render issue the web services post there
> and display the problem information including the confirmation they are
> assigned to the ticket, which would come back from the web services RMI?
>
> Travis
[Non-text portions of this message have been removed]
Joined: 10 Jan 2006
Posts: 33
Link for Web Service
Sure, the email actually is generated based on an application sending a
"flagged" MSMQ message to my notify application. This message may be configured
to have either a telephonic or email notification type. The email is sent to a
support group saying application xyz is having an issue please click here for
more information. By clicking they are accepting the problem ticket. I figured
I needed to have this link send ticket information to the web page so I could
then have code in the web page that grabs the "clicker`s" NTLM information.
This way I can say user NU09876 (NT USERID) has accepted the problem. I would
then still in this pre-render take the NTLM, time date, and ticket information
received in the query string and send it to a web service to log in a sql log
base. Sorry if I am not explaining this well. ;-) I don`t have a gift for
concise communication that is for sure.
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 |
travis.falls@...
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com]On Behalf Of Peter Brunone
Sent: Tuesday, January 10, 2006 10:51 AM
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: Re: [AspNetAnyQuestionIsOk] Link for Web Service
Hi Travis...
I`m a little confused as to why you`re bothering with an email instead of
just sending the information to the web service directly; can you elaborate?
Cheers,
Peter
On 1/10/06, Falls, Travis D (HTSC, CASD) <travis.falls@...>
wrote:
>
> I am creating a contact center that will make telephone calls and send
> emails. I want to create a synchronous process for the emails though so I
> know when someone starts working on a ticket. My idea is to email out an
> HTML enabled email with specific information in a hyperlink (query
> string). I want to collect that information and the user`s NTLM information
> and send it to a web service so that the information can be logged and then
> display the information on a web page. My question is can I get the NTLM
> and query string information at pre-render issue the web services post there
> and display the problem information including the confirmation they are
> assigned to the ticket, which would come back from the web services RMI?
>
> Travis
[Non-text portions of this message have been removed]
Yahoo! Groups Links
*************************************************************************
This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************
Joined: 23 Jan 2006
Posts: 4
Link for Web Service
I`m performing a particular word Search in MS Word, Text, PDF docs and
displaying the results through Index Server linked to SQL Server when
it is matched. For which I`m using Openquery in the stored procedure
which works fine in Query Analyzer of the SQL Server but doesn`t work (
shows none of the results) when i call it from the ASP.NET Page. I am
not able to figure out Where and What is the problem?
The Stored Proc which is i`m using is shown below
Any help will be greatly appreciated. Thanks for your time and help in
Advance
CREATE PROCEDURE SelectIndexServerCVpaths
(
@searchstring varchar(100)
)
AS
SET @searchstring = REPLACE( @searchstring, ````, `````` )
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
TABLE_NAME = `FileSearchResults`)
DROP VIEW FileSearchResults
EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
OPENQUERY(FileSystem,``SELECT Directory, FileName,
DocAuthor, Size, Create, Write, Path FROM
SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
FREETEXT(````` + @searchstring + `````)``)`)
SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
F.PATH AND C.DefaultID=1
GO
which works with followin stat in Query Analyzer
Exec SelectIndexServerCVpaths
@searchstring = `The Search text`
but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@searchstring",strsearchstrings);
objConn.Open();
objRdr = objcmd.ExecuteReader();
dgcvs.DataSource=objRdr;
dgcvs.DataBind();
objRdr.Close();
objConn.Close();
---------------------------------
Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo.
[Non-text portions of this message have been removed]
Joined: 11 Jan 2006
Posts: 46
Link for Web Service
No error message of any sort?
This is smells of a permissions problem. It is likely that Index
Server uses the Identity context of the calling process to determine
access. When you are using query analyzer you it is using the
Identity of your user account, which has the necessary access to call
Index Server. When you call the stored proc from ASP.NET however you
are using the ASP.NET Identity which is fairly restricted.
You can work around this using impersonation in your asp.net app to
use an account with more access. Though is a dangerous practice.
On 1/23/06, john gera <jgera_dotnet@...> wrote:
> I`m performing a particular word Search in MS Word, Text, PDF docs and
> displaying the results through Index Server linked to SQL Server when
> it is matched. For which I`m using Openquery in the stored procedure
> which works fine in Query Analyzer of the SQL Server but doesn`t work (
> shows none of the results) when i call it from the ASP.NET Page. I am
> not able to figure out Where and What is the problem?
> The Stored Proc which is i`m using is shown below
> Any help will be greatly appreciated. Thanks for your time and help in
> Advance
> CREATE PROCEDURE SelectIndexServerCVpaths
> (
> @searchstring varchar(100)
> )
> AS
> SET @searchstring = REPLACE( @searchstring, ````, `````` )
> IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> TABLE_NAME = `FileSearchResults`)
> DROP VIEW FileSearchResults
> EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
> OPENQUERY(FileSystem,``SELECT Directory, FileName,
> DocAuthor, Size, Create, Write, Path FROM
> SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
> FREETEXT(````` + @searchstring + `````)``)`)
> SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> F.PATH AND C.DefaultID=1
> GO
> which works with followin stat in Query Analyzer
> Exec SelectIndexServerCVpaths
> @searchstring = `The Search text`
>
> but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
> SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
>
> objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> objcmd.CommandType = CommandType.StoredProcedure;
> objcmd.Parameters.Add("@searchstring",strsearchstrings);
> objConn.Open();
> objRdr = objcmd.ExecuteReader();
> dgcvs.DataSource=objRdr;
> dgcvs.DataBind();
> objRdr.Close();
> objConn.Close();
>
>
>
>
> ---------------------------------
> Yahoo! Photos – NEW, now offering a quality print service from just 8p a
photo.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Joined: 23 Jan 2006
Posts: 4
Link for Web Service
Thanks for your time and help
I tried with impersonation with both true and false in my webconfig file
<location path="filename.aspx">
<system.web>
<identity impersonate="false" />
</system.web>
</location>
i used this link http://support.microsoft.com/kb/323293/en-us
the problem is still there
At present i`m getting some results which are not changing with the search
word
Though the search word text box is empty, i`m getting some sort of results
which are not related the particular search word
Is there any problem in my Connection String which is shown below
SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User
ID=sap;Password=sapres;");
that`s it i`m not using any provider name, catalog name nothing of that
sort, Is that right ?
i`m not able to understand where the problem is ?
Thanks in Advance
Dean Fiala <dfiala@...> wrote:
No error message of any sort?
This is smells of a permissions problem. It is likely that Index
Server uses the Identity context of the calling process to determine
access. When you are using query analyzer you it is using the
Identity of your user account, which has the necessary access to call
Index Server. When you call the stored proc from ASP.NET however you
are using the ASP.NET Identity which is fairly restricted.
You can work around this using impersonation in your asp.net app to
use an account with more access. Though is a dangerous practice.
On 1/23/06, john gera wrote:
> I`m performing a particular word Search in MS Word, Text, PDF docs and
> displaying the results through Index Server linked to SQL Server when
> it is matched. For which I`m using Openquery in the stored procedure
> which works fine in Query Analyzer of the SQL Server but doesn`t work (
> shows none of the results) when i call it from the ASP.NET Page. I am
> not able to figure out Where and What is the problem?
> The Stored Proc which is i`m using is shown below
> Any help will be greatly appreciated. Thanks for your time and help in
> Advance
> CREATE PROCEDURE SelectIndexServerCVpaths
> (
> @searchstring varchar(100)
> )
> AS
> SET @searchstring = REPLACE( @searchstring, ````, `````` )
> IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> TABLE_NAME = `FileSearchResults`)
> DROP VIEW FileSearchResults
> EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
> OPENQUERY(FileSystem,``SELECT Directory, FileName,
> DocAuthor, Size, Create, Write, Path FROM
> SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
> FREETEXT(````` + @searchstring + `````)``)`)
> SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> F.PATH AND C.DefaultID=1
> GO
> which works with followin stat in Query Analyzer
> Exec SelectIndexServerCVpaths
> @searchstring = `The Search text`
>
> but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
> SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
>
> objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> objcmd.CommandType = CommandType.StoredProcedure;
> objcmd.Parameters.Add("@searchstring",strsearchstrings);
> objConn.Open();
> objRdr = objcmd.ExecuteReader();
> dgcvs.DataSource=objRdr;
> dgcvs.DataBind();
> objRdr.Close();
> objConn.Close();
>
>
>
>
> ---------------------------------
> Yahoo! Photos – NEW, now offering a quality print service from just 8p a
photo.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Yahoo! Groups Links
---------------------------------
Win a BlackBerry device from O2 with Yahoo!. Enter now.
[Non-text portions of this message have been removed]
Joined: 11 Jan 2006
Posts: 46
Link for Web Service
So, you are getting results. Not just the right ones. That means
your connection string is working (there are many variations that
work), since you are succesfully contacting the DB.
So either your web page is calling the procedure with incorrect
information or there is something else going on. Perhaps you are
caching the page or results in some way?
Post your page code so we can rule out the first possibility.
On 1/23/06, john gera <jgera_dotnet@...> wrote:
> Thanks for your time and help
> I tried with impersonation with both true and false in my webconfig file
> <location path="filename.aspx">
> <system.web>
> <identity impersonate="false" />
> </system.web>
> </location>
> i used this link http://support.microsoft.com/kb/323293/en-us
> the problem is still there
> At present i`m getting some results which are not changing with the search
word
> Though the search word text box is empty, i`m getting some sort of results
which are not related the particular search word
> Is there any problem in my Connection String which is shown below
> SqlConnection objConn = new
> SqlConnection("Server=MISC\MISC;Database=sapresources;User
> ID=sap;Password=sapres;");
> that`s it i`m not using any provider name, catalog name nothing of that
> sort, Is that right ?
> i`m not able to understand where the problem is ?
> Thanks in Advance
>
> Dean Fiala <dfiala@...> wrote:
> No error message of any sort?
>
> This is smells of a permissions problem. It is likely that Index
> Server uses the Identity context of the calling process to determine
> access. When you are using query analyzer you it is using the
> Identity of your user account, which has the necessary access to call
> Index Server. When you call the stored proc from ASP.NET however you
> are using the ASP.NET Identity which is fairly restricted.
>
> You can work around this using impersonation in your asp.net app to
> use an account with more access. Though is a dangerous practice.
>
>
> On 1/23/06, john gera wrote:
> > I`m performing a particular word Search in MS Word, Text, PDF docs and
> > displaying the results through Index Server linked to SQL Server when
> > it is matched. For which I`m using Openquery in the stored procedure
> > which works fine in Query Analyzer of the SQL Server but doesn`t work (
> > shows none of the results) when i call it from the ASP.NET Page. I am
> > not able to figure out Where and What is the problem?
> > The Stored Proc which is i`m using is shown below
> > Any help will be greatly appreciated. Thanks for your time and help in
> > Advance
> > CREATE PROCEDURE SelectIndexServerCVpaths
> > (
> > @searchstring varchar(100)
> > )
> > AS
> > SET @searchstring = REPLACE( @searchstring, ````, `````` )
> > IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> > TABLE_NAME = `FileSearchResults`)
> > DROP VIEW FileSearchResults
> > EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
> > OPENQUERY(FileSystem,``SELECT Directory, FileName,
> > DocAuthor, Size, Create, Write, Path FROM
> > SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
> > FREETEXT(````` + @searchstring + `````)``)`)
> > SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> > F.PATH AND C.DefaultID=1
> > GO
> > which works with followin stat in Query Analyzer
> > Exec SelectIndexServerCVpaths
> > @searchstring = `The Search text`
> >
> > but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
> > SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
> >
> > objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> > objcmd.CommandType = CommandType.StoredProcedure;
> > objcmd.Parameters.Add("@searchstring",strsearchstrings);
> > objConn.Open();
> > objRdr = objcmd.ExecuteReader();
> > dgcvs.DataSource=objRdr;
> > dgcvs.DataBind();
> > objRdr.Close();
> > objConn.Close();
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Photos – NEW, now offering a quality print service from just 8p a
photo.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---------------------------------
> Win a BlackBerry device from O2 with Yahoo!. Enter now.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Joined: 23 Jan 2006
Posts: 4
Link for Web Service
Thanks for your time for answering my questions
I been trying to solve this problem since a week. I think Caching problem
seems to be bit close to my situation.
coz i`m getting some results without any search word
and the results doesn`t dissappear or change on the button click event in
which i`m calling the stor. proc.
and even i change the text they remain the same.
This is my exact present situation
till now i have tried different probabilities of checks but none worked
This Caching seems to be bit close but i`ve no other controls except the
textbox , search button and a datagrid.
Please guide me out of this if any idea strikes you
Thanks in Advance
Dean Fiala <dfiala@...> wrote:
So, you are getting results. Not just the right ones. That means
your connection string is working (there are many variations that
work), since you are succesfully contacting the DB.
So either your web page is calling the procedure with incorrect
information or there is something else going on. Perhaps you are
caching the page or results in some way?
Post your page code so we can rule out the first possibility.
On 1/23/06, john gera wrote:
> Thanks for your time and help
> I tried with impersonation with both true and false in my webconfig file
>
>
>
>
>
> i used this link http://support.microsoft.com/kb/323293/en-us
> the problem is still there
> At present i`m getting some results which are not changing with the search
word
> Though the search word text box is empty, i`m getting some sort of results
which are not related the particular search word
> Is there any problem in my Connection String which is shown below
> SqlConnection objConn = new
> SqlConnection("Server=MISC\MISC;Database=sapresources;User
> ID=sap;Password=sapres;");
> that`s it i`m not using any provider name, catalog name nothing of that
> sort, Is that right ?
> i`m not able to understand where the problem is ?
> Thanks in Advance
>
> Dean Fiala wrote:
> No error message of any sort?
>
> This is smells of a permissions problem. It is likely that Index
> Server uses the Identity context of the calling process to determine
> access. When you are using query analyzer you it is using the
> Identity of your user account, which has the necessary access to call
> Index Server. When you call the stored proc from ASP.NET however you
> are using the ASP.NET Identity which is fairly restricted.
>
> You can work around this using impersonation in your asp.net app to
> use an account with more access. Though is a dangerous practice.
>
>
> On 1/23/06, john gera wrote:
> > I`m performing a particular word Search in MS Word, Text, PDF docs and
> > displaying the results through Index Server linked to SQL Server when
> > it is matched. For which I`m using Openquery in the stored procedure
> > which works fine in Query Analyzer of the SQL Server but doesn`t work (
> > shows none of the results) when i call it from the ASP.NET Page. I am
> > not able to figure out Where and What is the problem?
> > The Stored Proc which is i`m using is shown below
> > Any help will be greatly appreciated. Thanks for your time and help in
> > Advance
> > CREATE PROCEDURE SelectIndexServerCVpaths
> > (
> > @searchstring varchar(100)
> > )
> > AS
> > SET @searchstring = REPLACE( @searchstring, ````, `````` )
> > IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> > TABLE_NAME = `FileSearchResults`)
> > DROP VIEW FileSearchResults
> > EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
> > OPENQUERY(FileSystem,``SELECT Directory, FileName,
> > DocAuthor, Size, Create, Write, Path FROM
> > SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
> > FREETEXT(````` + @searchstring + `````)``)`)
> > SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> > F.PATH AND C.DefaultID=1
> > GO
> > which works with followin stat in Query Analyzer
> > Exec SelectIndexServerCVpaths
> > @searchstring = `The Search text`
> >
> > but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
> > SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
> >
> > objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> > objcmd.CommandType = CommandType.StoredProcedure;
> > objcmd.Parameters.Add("@searchstring",strsearchstrings);
> > objConn.Open();
> > objRdr = objcmd.ExecuteReader();
> > dgcvs.DataSource=objRdr;
> > dgcvs.DataBind();
> > objRdr.Close();
> > objConn.Close();
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Photos – NEW, now offering a quality print service from just 8p a
photo.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---------------------------------
> Win a BlackBerry device from O2 with Yahoo!. Enter now.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Yahoo! Groups Links
---------------------------------
To help you stay safe and secure online, we`ve developed the all new Yahoo!
Security Centre.
[Non-text portions of this message have been removed]
Joined: 11 Jan 2006
Posts: 46
Link for Web Service
Post your code so we can see what`s going on.
On 1/23/06, john gera <jgera_dotnet@...> wrote:
> Thanks for your time for answering my questions
> I been trying to solve this problem since a week. I think Caching problem
seems to be bit close to my situation.
> coz i`m getting some results without any search word
> and the results doesn`t dissappear or change on the button click event in
which i`m calling the stor. proc.
> and even i change the text they remain the same.
> This is my exact present situation
> till now i have tried different probabilities of checks but none worked
> This Caching seems to be bit close but i`ve no other controls except the
textbox , search button and a datagrid.
> Please guide me out of this if any idea strikes you
> Thanks in Advance
>
>
> Dean Fiala <dfiala@...> wrote:
> So, you are getting results. Not just the right ones. That means
> your connection string is working (there are many variations that
> work), since you are succesfully contacting the DB.
>
> So either your web page is calling the procedure with incorrect
> information or there is something else going on. Perhaps you are
> caching the page or results in some way?
>
> Post your page code so we can rule out the first possibility.
>
> On 1/23/06, john gera wrote:
> > Thanks for your time and help
> > I tried with impersonation with both true and false in my webconfig file
> >
> >
> >
> >
> >
> > i used this link http://support.microsoft.com/kb/323293/en-us
> > the problem is still there
> > At present i`m getting some results which are not changing with the search
word
> > Though the search word text box is empty, i`m getting some sort of results
which are not related the particular search word
> > Is there any problem in my Connection String which is shown below
> > SqlConnection objConn = new
> > SqlConnection("Server=MISC\MISC;Database=sapresources;User
> > ID=sap;Password=sapres;");
> > that`s it i`m not using any provider name, catalog name nothing of that
> > sort, Is that right ?
> > i`m not able to understand where the problem is ?
> > Thanks in Advance
> >
> > Dean Fiala wrote:
> > No error message of any sort?
> >
> > This is smells of a permissions problem. It is likely that Index
> > Server uses the Identity context of the calling process to determine
> > access. When you are using query analyzer you it is using the
> > Identity of your user account, which has the necessary access to call
> > Index Server. When you call the stored proc from ASP.NET however you
> > are using the ASP.NET Identity which is fairly restricted.
> >
> > You can work around this using impersonation in your asp.net app to
> > use an account with more access. Though is a dangerous practice.
> >
> >
> > On 1/23/06, john gera wrote:
> > > I`m performing a particular word Search in MS Word, Text, PDF docs and
> > > displaying the results through Index Server linked to SQL Server when
> > > it is matched. For which I`m using Openquery in the stored procedure
> > > which works fine in Query Analyzer of the SQL Server but doesn`t work (
> > > shows none of the results) when i call it from the ASP.NET Page. I am
> > > not able to figure out Where and What is the problem?
> > > The Stored Proc which is i`m using is shown below
> > > Any help will be greatly appreciated. Thanks for your time and help in
> > > Advance
> > > CREATE PROCEDURE SelectIndexServerCVpaths
> > > (
> > > @searchstring varchar(100)
> > > )
> > > AS
> > > SET @searchstring = REPLACE( @searchstring, ````, `````` )
> > > IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE
> > > TABLE_NAME = `FileSearchResults`)
> > > DROP VIEW FileSearchResults
> > > EXEC (`CREATE VIEW FileSearchResults AS SELECT * FROM
> > > OPENQUERY(FileSystem,``SELECT Directory, FileName,
> > > DocAuthor, Size, Create, Write, Path FROM
> > > SCOPE(```` "c:inetpubwwwrootsap-resourcesUploads" ````) WHERE
> > > FREETEXT(````` + @searchstring + `````)``)`)
> > > SELECT * FROM CVdetails C, FileSearchResults F WHERE C.CV_Path =
> > > F.PATH AND C.DefaultID=1
> > > GO
> > > which works with followin stat in Query Analyzer
> > > Exec SelectIndexServerCVpaths
> > > @searchstring = `The Search text`
> > >
> > > but doesn`t work when i connect it to a Datagrid in my ASP.NET Page
> > > SqlConnection objConn = new
SqlConnection("Server=MISC\MISC;Database=sapresources;User ID=database user
id;Password=pwd");
> > >
> > > objcmd = new SqlCommand("SelectIndexServerCVpaths", objConn);
> > > objcmd.CommandType = CommandType.StoredProcedure;
> > > objcmd.Parameters.Add("@searchstring",strsearchstrings);
> > > objConn.Open();
> > > objRdr = objcmd.ExecuteReader();
> > > dgcvs.DataSource=objRdr;
> > > dgcvs.DataBind();
> > > objRdr.Close();
> > > objConn.Close();
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Yahoo! Photos – NEW, now offering a quality print service from just 8p a
photo.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Dean Fiala
> > Very Practical Software, Inc
> > http://www.vpsw.com
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Win a BlackBerry device from O2 with Yahoo!. Enter now.
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> Dean Fiala
> Very Practical Software, Inc
> http://www.vpsw.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> ---------------------------------
> To help you stay safe and secure online, we`ve developed the all new Yahoo!
Security Centre.
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help