Dreaded "SQL Server does not exist or access denied. " Error

I have built a web application that runs on my local web server against my local SQL server and my development server, but now I'm trying to get it to work on the live server and I'm not getting a connection. Whenever I try to open the connection, I get a.

SQL Server does not exist or access denied.

error.

Here is my connection string...

Public connString as string

Dim SQLServerAsString = "xxx.xx.xx.xxx"

connString = "server=" & SQLServer & ";" _

& "database=DBName;Trusted_Connection=No;user id=xxxID;password=xxxPassword;"

myConnection2 =New SqlClient.SqlConnection(connString)

------------------

I'm starting my connection to run a datareader this way...

Dim strSQLAsString

strSQL = "SELECT ClientID, ClientName " & _

"FROM Client; "

' Create a connection to the table in the SQL database located on

' the remote computer.

Dim myCommand2AsNew SqlClient.SqlCommand(strSQL, myConnection2)

myCommand2.CommandTimeout = 1200

myConnection2.Open() 'HERE IS WHERE THE ERROR OCCURS

Dim myReaderAs SqlClient.SqlDataReader = myCommand2.ExecuteReader(CommandBehavior.CloseConnection)

While myReader.Read()

-------------------

I can communicate with the server with no problem from my local computer. I can ping the server, and I also tested it by creating a system DSN using the login and password in my application, and it finds the database with no problem. I've tried to connect using the SQL Server's server name and the IP address and both return the same result. I've also saw something in another post to set the trusted connection parameter to "yes" and that didn't work either.

I'm developing on a Windows XP Professional and I'm trying to connect to a Windows 2003 Server with SQL Server 2000 installed on the machine.

I did add the database by restoring a backup from my local server onto the live server. I don't think that should matter, but maybe it does. If anyone has any ideas, I would greatly appreciate it.

Try adding this to the end of your connection string and see if it makes a difference:

;Network Library =dbmssocn

This will force a TCP/IP connection instead of a named pipes connection.

(fromBUG: Named pipes do not work when worker process runs under ASPNET account)|||Thanks for the suggestion. Unfortunately that didn't work. Could there be some server firewall setting that is preventing the web user account from accessing the server?|||I would also try adding a port number to the end of the IP address:

Dim SQLServerAsString = "xxx.xx.xx.xxx,1433"

And I would remove Trusted_Connection=No completely. Seehttp://www.connectionstrings.comfor connection string examples. If none of that works, perhapsthe user ID and password are incorrect? Sorry, just grasping atstraws. My last recommendation is to review this KB article:Potential causes of the "SQL Server does not exists or access denied" error message. As you'll see, there are a lot of things to check.|||Thanks for your help. It looks like the problem stemmed from a security hole in Windows 2003 Server, which was shutting down the TCP ports. We applied SP4 and it seems to be working for now. Hopefully that's all it was.

Drawing error when rendering report in PDF

Hi
We had run SQL Server Report Services Service PAck2 and after installing that we are not able to open reports in PDF format. it gives drawing error .

Any help in this regard is appreciated.What the exact error message ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Hi Jens
The exact error message would be "A Drawing Error Occured"

As I had told we are having SQL Server 2000, SQL Server 2000 Reporting Services. Somebody in the forum suggested to install service pack2 which we did for earlier another issue where it was printing extra pages in both Excel and PDF. So after installing sp2 the PDF got messed up.

Any help in this regard is appreciated

Thanks|||

Hi,

This is probably an error in SP2, you can get a fix from Microsoft by contacting them on the mentioned ways here: http://support.microsoft.com/kb/912424/en-us

This is a PDF Error, probably a ressources not reachable or an out-of-memory error.

http://support.microsoft.com/kb/912424/en-us

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Hi
Thanks Jens the link helped us solve the issue.There is another related issue which if you could show us a little direction in solving it. Here is the issue

We are working on SQL Server Reporting Services 2000. We designed a

report and exported the same into excel. The original report has lets

say one page information, then before printing when we see print

preview it shows up an extra blank page and similarly if the there are

two pages in the report ,in the preview we are seeing 4 pages ie two

extra blank pages. Any help to solve this issue would be appreciated.

The same thing we are exporting in PDF format also and here to same

issue.

We are in need of a solution. It would be of great help if you could help us in getting a solution to this issue.
We have SQL Server 2000 and SQL Server 2000 Reporting services and Microsoft Office 2003

Thanks
|||Thats a really common problem. You defined the report margins to big. If the report exceeds the page format it will break the report to multiple pages. So make sure that the visible area of your report (and the additional borders) does not exceed the format specified on the report properties. Sizing the report will let you keep your report on one page per report page. Its something like playing around with the margins and sizes to fit all your data on one page.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Dr Watson error after writing to SQL Server

I have a VB6 program that receives data using socket and save the data to a
SQL Server 2000 database.
It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
The program had been running for years with no problem, but for the last 3
days it had died exactly at 3 AM, right after it finished writing the data
to SQL Server.
No error on the screen, but there is Dr.
Watson error (it is in drwtsn32.log).
The error in drwtsn32.log is:
Exception number: c0000005 (access violation) --> this is on this VB
program.
I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
c:\winnt\system32\comsvcs.dll.
I searched on the internet and found that there was an Access Violation
error with comsvcs.dll, and the fix is to install the latest Windows
patches, which we already did. We also increased the memory from 1 gig RAM
to 2 gig. The program still happens.
There is no scheduled task running at 3 AM.
Does anybody know how to read Dr Watson log ?
How can I fix this problem ?
Thank you very much.
The previous 2 days when the program did not write to the SQL Server
database, the program did not die.
But today, it starts writing to the database again, and it again died at 3
am. The program writes to the database every minute every day without any
problem, except after it finishes writing to the database at 3 am.
I found this article that talks about Access Violation error and SQL Server
(but it is with Windows 2003, and I am using Windows 2000)
http://ask.support.microsoft.com/kb/910471
Symptoms
An access violation occurs in Microsoft Distributed Transaction Coordinator
(MS DTC) when a client that is connected to an MS DTC clustered resource
tries to create an enlistment in MS DTC. For example, this problem may occur
if a computer where Microsoft SQL Server is installed loses synchronization
with an MS DTC server and then tries to enlist a transaction in MS DTC.
Cause
This problem occurs because of two race conditions in the MS DTC code. In
one race condition, the transaction manager (TM) tries to create a trace
before an interface pointer to perform that trace exists. A second race
condition exists when the MS DTC proxy sends TMDown notifications to
enlistments and resource managers.
Could that problem related to my problem, even though for different Windows
version ? What does it mean by "Microsoft SQL Server is installed loses
synchronization with an MS DTC server and then tries to enlist a transaction
in MS DTC" ?
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:uW9dGglNHHA.1872@.TK2MSFTNGP04.phx.gbl...
>I have a VB6 program that receives data using socket and save the data to a
> SQL Server 2000 database.
> It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
> The program had been running for years with no problem, but for the last 3
> days it had died exactly at 3 AM, right after it finished writing the data
> to SQL Server.
> No error on the screen, but there is Dr.
> Watson error (it is in drwtsn32.log).
> The error in drwtsn32.log is:
> Exception number: c0000005 (access violation) --> this is on this VB
> program.
> I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
> c:\winnt\system32\comsvcs.dll.
> I searched on the internet and found that there was an Access Violation
> error with comsvcs.dll, and the fix is to install the latest Windows
> patches, which we already did. We also increased the memory from 1 gig RAM
> to 2 gig. The program still happens.
> There is no scheduled task running at 3 AM.
> Does anybody know how to read Dr Watson log ?
> How can I fix this problem ?
> Thank you very much.
>
>

Dr Watson error after writing to SQL Server

I have a VB6 program that receives data using socket and save the data to a
SQL Server 2000 database.
It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
The program had been running for years with no problem, but for the last 3
days it had died exactly at 3 AM, right after it finished writing the data
to SQL Server.
No error on the screen, but there is Dr.
Watson error (it is in drwtsn32.log).
The error in drwtsn32.log is:
Exception number: c0000005 (access violation) --> this is on this VB
program.
I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
c:\winnt\system32\comsvcs.dll.
I searched on the internet and found that there was an Access Violation
error with comsvcs.dll, and the fix is to install the latest Windows
patches, which we already did. We also increased the memory from 1 gig RAM
to 2 gig. The program still happens.
There is no scheduled task running at 3 AM.
Does anybody know how to read Dr Watson log ?
How can I fix this problem ?
Thank you very much.The previous 2 days when the program did not write to the SQL Server
database, the program did not die.
But today, it starts writing to the database again, and it again died at 3
am. The program writes to the database every minute every day without any
problem, except after it finishes writing to the database at 3 am.
I found this article that talks about Access Violation error and SQL Server
(but it is with Windows 2003, and I am using Windows 2000)
http://ask.support.microsoft.com/kb/910471
Symptoms
An access violation occurs in Microsoft Distributed Transaction Coordinator
(MS DTC) when a client that is connected to an MS DTC clustered resource
tries to create an enlistment in MS DTC. For example, this problem may occur
if a computer where Microsoft SQL Server is installed loses synchronization
with an MS DTC server and then tries to enlist a transaction in MS DTC.
Cause
This problem occurs because of two race conditions in the MS DTC code. In
one race condition, the transaction manager (TM) tries to create a trace
before an interface pointer to perform that trace exists. A second race
condition exists when the MS DTC proxy sends TMDown notifications to
enlistments and resource managers.
Could that problem related to my problem, even though for different Windows
version ? What does it mean by "Microsoft SQL Server is installed loses
synchronization with an MS DTC server and then tries to enlist a transaction
in MS DTC" ?
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:uW9dGglNHHA.1872@.TK2MSFTNGP04.phx.gbl...
>I have a VB6 program that receives data using socket and save the data to a
> SQL Server 2000 database.
> It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
> The program had been running for years with no problem, but for the last 3
> days it had died exactly at 3 AM, right after it finished writing the data
> to SQL Server.
> No error on the screen, but there is Dr.
> Watson error (it is in drwtsn32.log).
> The error in drwtsn32.log is:
> Exception number: c0000005 (access violation) --> this is on this VB
> program.
> I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
> c:\winnt\system32\comsvcs.dll.
> I searched on the internet and found that there was an Access Violation
> error with comsvcs.dll, and the fix is to install the latest Windows
> patches, which we already did. We also increased the memory from 1 gig RAM
> to 2 gig. The program still happens.
> There is no scheduled task running at 3 AM.
> Does anybody know how to read Dr Watson log ?
> How can I fix this problem ?
> Thank you very much.
>
>

Dr Watson error after writing to SQL Server

I have a VB6 program that receives data using socket and save the data to a
SQL Server 2000 database.
It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
The program had been running for years with no problem, but for the last 3
days it had died exactly at 3 AM, right after it finished writing the data
to SQL Server.
No error on the screen, but there is Dr.
Watson error (it is in drwtsn32.log).
The error in drwtsn32.log is:
Exception number: c0000005 (access violation) --> this is on this VB
program.
I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
c:\winnt\system32\comsvcs.dll.
I searched on the internet and found that there was an Access Violation
error with comsvcs.dll, and the fix is to install the latest Windows
patches, which we already did. We also increased the memory from 1 gig RAM
to 2 gig. The program still happens.
There is no scheduled task running at 3 AM.
Does anybody know how to read Dr Watson log ?
How can I fix this problem ?
Thank you very much.The previous 2 days when the program did not write to the SQL Server
database, the program did not die.
But today, it starts writing to the database again, and it again died at 3
am. The program writes to the database every minute every day without any
problem, except after it finishes writing to the database at 3 am.
I found this article that talks about Access Violation error and SQL Server
(but it is with Windows 2003, and I am using Windows 2000)
http://ask.support.microsoft.com/kb/910471
Symptoms
An access violation occurs in Microsoft Distributed Transaction Coordinator
(MS DTC) when a client that is connected to an MS DTC clustered resource
tries to create an enlistment in MS DTC. For example, this problem may occur
if a computer where Microsoft SQL Server is installed loses synchronization
with an MS DTC server and then tries to enlist a transaction in MS DTC.
Cause
This problem occurs because of two race conditions in the MS DTC code. In
one race condition, the transaction manager (TM) tries to create a trace
before an interface pointer to perform that trace exists. A second race
condition exists when the MS DTC proxy sends TMDown notifications to
enlistments and resource managers.
Could that problem related to my problem, even though for different Windows
version ? What does it mean by "Microsoft SQL Server is installed loses
synchronization with an MS DTC server and then tries to enlist a transaction
in MS DTC" ?
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:uW9dGglNHHA.1872@.TK2MSFTNGP04.phx.gbl...
>I have a VB6 program that receives data using socket and save the data to a
> SQL Server 2000 database.
> It has Windows 2000 SP4 with all hot patches in it. It has 2 gig of RAM.
> The program had been running for years with no problem, but for the last 3
> days it had died exactly at 3 AM, right after it finished writing the data
> to SQL Server.
> No error on the screen, but there is Dr.
> Watson error (it is in drwtsn32.log).
> The error in drwtsn32.log is:
> Exception number: c0000005 (access violation) --> this is on this VB
> program.
> I do not know how to read Dr Watson log, but the "Raw Stack Dump" contains
> c:\winnt\system32\comsvcs.dll.
> I searched on the internet and found that there was an Access Violation
> error with comsvcs.dll, and the fix is to install the latest Windows
> patches, which we already did. We also increased the memory from 1 gig RAM
> to 2 gig. The program still happens.
> There is no scheduled task running at 3 AM.
> Does anybody know how to read Dr Watson log ?
> How can I fix this problem ?
> Thank you very much.
>
>

DPE method error; passing DS persisted As XML

Hello,
I am using Teo Lachev's DPE and have done the following so far.
Added the datasource with 'Nothing' in query. Also the @.datasource parameter
is taking a path to the xsd file that i created off the dataset that i will
use. The designer has the fields setup on the report.
Through code, based on parameters I am forming a dataset that i write to an
xml (this contains the same elements and schema as the xsd).
Then..
DataSet dsDataSet = new DataSet();
dsDataSet.ReadXml(@."C:\FSChartSampleDS.xml", System.Data.XmlReadMode.Auto);
parameters[0] = new ParameterValue();
parameters[0].Name = "DataSource";
parameters[0].Value = dsDataSet.GetXml();
followed by a call to the render function. Here the call fails with this
error:
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
System.NullReferenceException: Object reference not set to an instance of an
object.\n at
AWC.RS.Extensions.DataExtensions.DsDataReader.GetOrdinal(String name)\n at
Microsoft.ReportingServices.DataExtensions.MappingDataReader..ctor(String
dataSetName, IDataReader sourceReader, String[] aliases, String[]
fieldNames)\n at
Microsoft.ReportingServices.ReportProcessing.g..ctor(String A_0, IDataReader
A_1, String[] A_2, String[] A_3)\n at
Microsoft.ReportingServices.ReportProcessing.a0.v()\n at
Microsoft.ReportingServices.ReportProcessing.aw.c()\n at
Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)\n at
Microsoft.ReportingServices.ReportProcessing.aw.b()\n at
Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)\n -- End of
inner exceptionsolved this myself
"google" wrote:
> Hello,
> I am using Teo Lachev's DPE and have done the following so far.
> Added the datasource with 'Nothing' in query. Also the @.datasource parameter
> is taking a path to the xsd file that i created off the dataset that i will
> use. The designer has the fields setup on the report.
> Through code, based on parameters I am forming a dataset that i write to an
> xml (this contains the same elements and schema as the xsd).
> Then..
> DataSet dsDataSet = new DataSet();
> dsDataSet.ReadXml(@."C:\FSChartSampleDS.xml", System.Data.XmlReadMode.Auto);
> parameters[0] = new ParameterValue();
> parameters[0].Name = "DataSource";
> parameters[0].Value = dsDataSet.GetXml();
> followed by a call to the render function. Here the call fails with this
> error:
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
> error has occurred during report processing. -->
> System.NullReferenceException: Object reference not set to an instance of an
> object.\n at
> AWC.RS.Extensions.DataExtensions.DsDataReader.GetOrdinal(String name)\n at
> Microsoft.ReportingServices.DataExtensions.MappingDataReader..ctor(String
> dataSetName, IDataReader sourceReader, String[] aliases, String[]
> fieldNames)\n at
> Microsoft.ReportingServices.ReportProcessing.g..ctor(String A_0, IDataReader
> A_1, String[] A_2, String[] A_3)\n at
> Microsoft.ReportingServices.ReportProcessing.a0.v()\n at
> Microsoft.ReportingServices.ReportProcessing.aw.c()\n at
> Microsoft.ReportingServices.ReportProcessing.a0.a(Boolean& A_0)\n at
> Microsoft.ReportingServices.ReportProcessing.aw.b()\n at
> Microsoft.ReportingServices.ReportProcessing.a0.a(Object A_0)\n -- End of
> inner exception

DPE Error running on report Server

We created a DPE to pull data off a Web Service to be used as a datasource in
the reports we create. We created and added the code group to the
rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
name to the Data section of the RSReportServer.config file. The report works
correctly in debug designer mode but we receive the following error when
trying to run the report through the report manager or report server.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
Get Online Help
Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.Check the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We created a DPE to pull data off a Web Service to be used as a datasource in
> the reports we create. We created and added the code group to the
> rssrvpolicy.config and rsmgrpolicy.config files. Also added the extension
> name to the Data section of the RSReportServer.config file. The report works
> correctly in debug designer mode but we receive the following error when
> trying to run the report through the report manager or report server.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Query execution failed for data set 'NewDataset'. (rsErrorExecutingCommand)
> Get Online Help
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
>

DPE Error on Report Server

We have created a DPE that returns data from a Web Services and uses it as
the datasource in the reports. We have changed the config files and added
the code group also added the name to the data section of the
rsreportserver.config file. We have strong named the dll and added it to the
GAC. The report runs fine in debug designer mode but will not run through
the report server or report manager. We get the following error.
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
An attempt has been made to use a data extension 'ISIS WS Data' that is not
registered for this report server. (rsDataExtensionNotFound) Get Online HelpCheck the documentation about how to deploy a similar DPE.
[WebService Data Processing Extension]
http://www.rdlcomponents.com/DTE/default.aspx
Thanks
Jerry
"Deb Taylor" wrote:
> We have created a DPE that returns data from a Web Services and uses it as
> the datasource in the reports. We have changed the config files and added
> the code group also added the name to the data section of the
> rsreportserver.config file. We have strong named the dll and added it to the
> GAC. The report runs fine in debug designer mode but will not run through
> the report server or report manager. We get the following error.
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> An attempt has been made to use a data extension 'ISIS WS Data' that is not
> registered for this report server. (rsDataExtensionNotFound) Get Online Help
>|||I did all that I'm now getting a 401 unauthorized error.
"Jerry" wrote:
> Check the documentation about how to deploy a similar DPE.
> [WebService Data Processing Extension]
> http://www.rdlcomponents.com/DTE/default.aspx
> Thanks
> Jerry
> "Deb Taylor" wrote:
> > We have created a DPE that returns data from a Web Services and uses it as
> > the datasource in the reports. We have changed the config files and added
> > the code group also added the name to the data section of the
> > rsreportserver.config file. We have strong named the dll and added it to the
> > GAC. The report runs fine in debug designer mode but will not run through
> > the report server or report manager. We get the following error.
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> >|||Generally this error message means you need to log on (enter a valid user ID
and password) somewhere first. If you have just entered these and then
immediately see a 401 error, it means that one or both of your user ID and
password were invalid for whatever reason (entered incorrectly, user ID
suspended etc.).
Jerry
--
[Call a WebService from SQL Server 2000]
www.rdlcomponents.com
"Deb Taylor" wrote:
> I did all that I'm now getting a 401 unauthorized error.
> "Jerry" wrote:
> > Check the documentation about how to deploy a similar DPE.
> >
> > [WebService Data Processing Extension]
> > http://www.rdlcomponents.com/DTE/default.aspx
> >
> > Thanks
> > Jerry
> >
> > "Deb Taylor" wrote:
> >
> > > We have created a DPE that returns data from a Web Services and uses it as
> > > the datasource in the reports. We have changed the config files and added
> > > the code group also added the name to the data section of the
> > > rsreportserver.config file. We have strong named the dll and added it to the
> > > GAC. The report runs fine in debug designer mode but will not run through
> > > the report server or report manager. We get the following error.
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > An attempt has been made to use a data extension 'ISIS WS Data' that is not
> > > registered for this report server. (rsDataExtensionNotFound) Get Online Help
> > >

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i gotsql

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

||||||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||

i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

||||||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||

i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i gotsql

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

||||||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||

i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

||||||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||

i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Download VBScript

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

This is not the right place for this question, however I suspect your issue is addressed by this;

http://www.keathmilligan.net/node/139

|||

I sent you an email did you every receive it. It is regarding the issure I have.

Thank you

Paula

|||

The problem you are hitting is a problem with Apples installer. You forum you asked the question in was a Microsoft forum related to a product called SQL Server, Idid a quick search and found the below but I suggest you ask apple the question.

http://docs.info.apple.com/article.html?artnum=304405

|||

I'm having the same issues...Were you able to resolve your problems and if so how did you?...

Thanks,

Chief

|||Google sent me here with the exact same problem. I might be nice to post the answer, not just say, wrong forum.|||Other than the posts we already made the people here are not experts in itunes or vista so they don't know the answer|||

No I was never able to solve the problem how about you. this really stinks that we can't solve this issue. I feel that every body wants to pass it to someone else and say that it is not there problem. Do you feel the same way?

Paula

|||

If this link http://docs.info.apple.com/article.html?artnum=304405 did not work then please contact Apple.

I understand your frustration but I am not sure why google is sending you all here, this forum is where peers are supported by each other (not by Microsoft) for questions surrounding Microsoft SQL Server Management Objects programming problems.

|||

The reason we are all being sent here is because f*cking apple, in their wisdom, are useless in solving this issue & they are the ones passing the buck by suggesting we pursue an answer via vbscript, which of course, is a microsoft product.

If I knew apple would care (which they do not) I would sent them a scathing email, but for now, I am using limewire for downloads and I'm not bothering to update my ipod.

Life is too short for this garbage

|||

I found the followling website that helped me. http://docs.info.apple.com/article.html?artnum=304405.

After I did what they said I had no more problems with the download.

|||

Rock-n-roll baby! Best post I've read in weeks. Quick time now has this in their knowledge base.
http://docs.info.apple.com/article.html?artnum=304405

|||i try to redown load vbscript but i cant|||

caddylady wrote:

I tired to download I tunes but I got a error message that I needed to download VBScript. when I try to do that, I get the message about turing off the script in anti virus and personal firewall, etc. Well, I would if I knew what I was looking for. Could you please tell me where to find this and what I need to do. I don't understand all this computer talk about VBScript.

Thank you

Caddylady

that is the same thing i got

Double quotes in error messages!

I have a problem when trying to display an error message from sql server 2005 on a web page with an alert (javascript command).

The Sql server 2005 returns a message like:

Insert statement conflicted with foreign key constraint "bla bla". The conflict occured indatabase "databasename", table "tablename", column 'columnname'.

In sql server 2000 the error message is the same except all names (constraint, database, table) is in single quotation marks; just like the columnname in the above example.

Is it a configurable issue on the sql server. I would prefer not to solve this issue on a number of different web pages!

Thanks in advance.

Futte

hi,

you should set this:

SET QUOTED_IDENTIFIER { ON | OFF }

When on, then identifiers can be delimited by double quotation marks.

Regards,

Janos

|||

I all ready tried that without any luck.......

I want to avoid the double quotation marks.

Thanks though

Futte

|||

If you wish to 'embed' single quotes in your message, you need to double them up -use two single quotes in each place of one single quote.)

Try this:

SELECT 'This is my ''message'' with quotes.'

|||

I think my question might be a little misunderstood.

My question is not about query syntax in sql regarding single or double quotation marks or two single quotation marks.

It's about the error message sql server is returning. I suddenly experienced that after upgrading sql server from 2000 to 2005 the response from sql 2005 contained double quotation marks around all object names except for one; namely the column name:

2000:

Insert statement conflicted with foreign key constraint 'constraint name'. The conflict occurred in database 'database name', table 'table name', column 'column name'.

2005:

Insert statement conflicted with foreign key constraint "constraint name". The conflict occurred in database "database name", table "table name", column 'column name'.

This is a problem when displaying the error message on a web page with javascript (alert). So if it's a configurable issue on the sql server where is it set? Otherwise I have to handle this error message somewhere else replacing the double quotes with single quotes.

Kind Regards

Futte

|||

Thanks for the clarification. I better understand the situation.

As far as I am aware, there is no user configurable setting to alter the presentation of the error message.

dotted string in sp calls

Hi there!
why do I get an error when I call a sp wich contains a dotted argument
?
ex:
exec netreport.ps_load_data 'arg1','arg2.arg2'
Error ---^
I got this error :
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '.'.
I get the same error with '\' char..
any idea?
++
VinceHi
Can you post the DDL?
John
"Vince .>" <vincent@.<remove> wrote in message
news:omm2515nqvr132fi8o3ai8im3bv01pl3td@.
4ax.com...
> Hi there!
>
> why do I get an error when I call a sp wich contains a dotted argument
> ?
> ex:
> exec netreport.ps_load_data 'arg1','arg2.arg2'
> Error ---^
> I got this error :
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '.'.
> I get the same error with '' char..
> any idea?
> ++
> Vince
>|||On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:

>Hi
>Can you post the DDL?
>
hum..sorry...i'm new to SQLServer, so what is a DDL? :)
Vince|||Please provide DDL and sample data.
http://www.aspfaq.com/etiquette.asp?id=5006
AMB
"Vince .>" wrote:

> On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
>
> hum..sorry...i'm new to SQLServer, so what is a DDL? :)
> Vince
>|||DDL = Data Definition Language..
The error may not be in calling the procedure, but instead
in the procedure being called.. Create a dummy procedure
that does nothing and see if you have a problem calling it
with a value that contains a period.
"Vince .>" wrote:

> On Mon, 4 Apr 2005 16:30:13 +0100, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
>
> hum..sorry...i'm new to SQLServer, so what is a DDL? :)
> Vince
>