Keyword Not Supported: ',server'.

Jun 27, 2006

Hello there.

I'm developing an eCommerce solutions based on the ASP.NET 2.0 Commerce Starter Kit, architechture. It uses the Provider Pattern. In my web-application, i use the CatalogProvider, to retrieve data from a SQL Server 2005 database. I call the methods through a handler class, whoch excists inside the WebApp. I also use a ShoppingCartProvider, OrdersProvider, ShippingProvider etc. in the same way.

In my Web.Config file, i have all the provers listed, and on each provider, the name of the connectionString to use are given.

My connection string looks like this:
"connString" connectionString="Server=xxxx;Database=xxxx;Trusted_Connection=True;" providerName="System.Data.SqlClient" />

 The problem is, that suddently, when browsing the website, that connects to the database through the providers, i get this error:
Keyword not supported: ',server'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported: ',server'.

Source Error:







Line 31: public static IDataReader GetProductsByCategory(int categoryID)
Line 32: {
Line 33: return Commerce.Providers.CatalogProvider.Instance.GetProductsByCategory(categoryID);
Line 34: }
Line 35:


Source File: d:DevelopmentASPNETSeoShopApp_CodeHandlersCatalogManager.cs    Line: 33

Stack Trace:


If i then go back to my web.config file, and removes the providerName section, of the connectionString, the website works again, for a short period. When the error return, i undo the deletion of the providerName, and it will work again... For a short time...

I've also tried to use another connectionsString, like this:
Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI

But then the keyword which is not supported is: ', data source'

 

Does anyone know what the issue might be?

Thanks in advance...

View 9 Replies


ADVERTISEMENT

'Keyword Not Supported: 'provider' Error When Connecting To SQL Server Database

Jan 22, 2008

I've run into a bit of a database connection problem. I'm trying to connect to a SQL Server database. It compiles okay, but then while IE is loading, I get an exception error pointing out in the code saying 'Keyword not supported: 'provider'.

View 2 Replies View Related

Error: Keyword Not Supported: 'dsn' In Asp.net

Jun 10, 2008

hi,i am trying to connect sql server 2005 from my asp.net applicationi have create DSN for this ..then i am getting the following errorKeyword not supported: 'dsn'. in sql serverplease provide me the solution

View 5 Replies View Related

Keyword Not Supported: 'driver'

Apr 5, 2004

y am i having keywork not supported? is there anything wrong with my connection string ??


==========web config================

<appSettings>
<add key="db" value="icms" />
<add key="db_user" value="sqladmin" />
<add key="db_server" value="server" />
<add key="db_pwd" value="12345" />
<add key="session_timeout" value="600" />
</appSettings>

==========DB.vb==============

Dim myDB As New SqlConnection
Dim myCMD As New SqlCommand
Public Sub New()
Dim db_server = AppSettings("db_server")
Dim db = AppSettings("db")
Dim db_user = AppSettings("db_user")
Dim db_pwd = AppSettings("db_pwd")
Dim DBConnection As String = "DRIVER={SQL Server};" & _
"SERVER=" & db_server & ";" & _
"DATABASE=" & db & ";" & _
"UID=" & db_user & ";" & _
"PWD=" & db_pwd & ";" & _
"OPTION=3;"
myDB.ConnectionString = DBConnection
myCMD.Connection = myDB
End Sub
=============================

View 6 Replies View Related

System.ArgumentException: Keyword Not Supported: 'provider'.

May 4, 2004

Hi guys

I'm trying to upload to my SQL DB

in my web.config file I have:

<appSettings>

<add key="MM_CONNECTION_HANDLER_trustnetConn" value="default_oledb.htm" />
<add key="MM_CONNECTION_STRING_trustnetConn" value="Provider=SQLOLEDB.1;Password=****;Persist Security Info=True;User ID=****;Initial Catalog=Trustnet;Data Source="192.194.25.211/>
<add key="MM_CONNECTION_DATABASETYPE_trustnetConn" value="oledb" /><add key="MM_CONNECTION_SCHEMA_trustnetConn" value="" />
<add key="MM_CONNECTION_CATALOG_trustnetConn" value="" />

</appSettings>

i'm trying to make a new connection

Dim myConnection As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_trustnetConn"))

so I can upload files to it

but I keep on getting the error

System.ArgumentException: Keyword not supported: 'provider'.

any ideas

cheers

View 5 Replies View Related

Script Component: Keyword Not Supported: 'provider'

Aug 4, 2007


Hi,

I have a script component that accesses the database with this codes:


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
Dim cn As SqlConnection
Dim SQLCmd As SqlCommand
Dim dr As SqlDataReader
Dim NextKey As Integer = 0


cn = New SqlConnection(Connections.CONNofficetestdb.ConnectionString.ToString)

cn.Open()

SQLCmd = New SqlCommand("select count(*) from accounttrans", cn)

dr = SQLCmd.ExecuteReader

While dr.Read()


NextKey = NextKey + 1

End While

End Sub


But I encounter a problem once I ran it:

Keyword not supported: 'provider'



How do I resolve this?

thanks a lot.

cherriesh

View 4 Replies View Related

The Script Threw An Exception : Keyword Not Supported: 'network Port'.

May 29, 2008

Hi All,

I need to refresh my cube daily and once this processed is done, i will update in ETL table with lastcubeprocessedtime in my timestamp column. Actually i am using IBM db2 provider since my ETL table resides in IBM DB2 source.

In my first task i am using script task where i will check whether my timestamp column value is NULL or not.

I am getting error like "The script threw an exception : keyword not supported: 'network port'." when this script task executes.

Moreover i am getting another error like "The execution succeeded, but the number of error raised(1) reached the maximum allowed(1); resulting in failure. This occurs when the number of errors reaches the number of specified in MaximumErrorCount. Change the MaximumErrorCount or fix this errors." For this error i have changed MaximumErrorCount value from 1 to 100 in dataflow task.

Can anyone tell me what might be the problem for these two errors?

Thanks in advance
Anand Rajagopal

View 7 Replies View Related

Sql Server And Supported Codepages

Apr 12, 2004

Hello community!

Short question:
how can i retrieve all code pages that MSSQL server is installed with?

Thank you in advance for your help.

View 1 Replies View Related

Sql Server CE Supported Classes

Jul 27, 2006

ahi all

iam new to VS.net 2005 and iam trying to convert ready made application from vb.net 2003 to vb.net 2005

and i cant find the sqlcedataadapter

its a windows CE application uses SQL Server CE

and i imported the system.data.sqlsrverce

and i added the sqlserverce refrence

may be its a new classes?

View 1 Replies View Related

Running A Distributed Query Against A Loopback Linked Server In SQL Server 2005 Is Not Supported

Aug 27, 2007

I receive the following error message when I run a distributed query against a loopback linked server in SQL Server 2005:
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.

To resolve this problem, I was told that running a distributed query against a loopback linked server is not supported in SQL Server 2005. And I am suggested to use a remote server definition (sp_addserver) instead of a linked server definition to resolve this problem. (Although this is only a temporary resolution, which will deprecate in Katmai)

However, I run into another problem when I use the remote server definition. I receive the following error message:
Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'ServerNameSQL2005' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name.

Could anyone please help me out?
(I include the reproduce steps for the first error message, followed by my resolution that generates the second error message)
======
Reproduce steps for the first error message
======


On the ComputerAInstanceA instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseA
GO
USE DatabaseA
GO
CREATE TABLE TestTable(Col1 int, Col2 varchar(50))
GO
INSERT INTO TestTable VALUES (1, 'Hello World')
GO

On the ComputerBInstanceB instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseB
GO
USE DatabaseB
GO
CREATE TABLE TestTable (Col1 int, Col2 varchar(50))
GO

On the ComputerAInstanceA instance, create a linked server that links to the ComputerBInstanceB instance. Assume the name of the linked server is LNK_ServerB.

On the ComputerBInstanceB instance, create a linked server that links to the ComputerAInstanceA instance. Assume the name of the linked server is LNK_ServerA.

On the ComputerBInstanceB instance, run the following statement:
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
BEGIN
SELECT * from LNK_ServerA.DatabaseA.dbo.TestTable
END
GO

On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXEC LNK_ServerB.DatabaseB.dbo.InsertA
GO
Then I receive the first error message.

=======
My resolution that generates the second error message
=======


On the ComputerBInstanceB instance, run the following statement:
sp_addserver 'ComputerAInstanceA'
GO
sp_serveroption 'ComputerAInstanceA', 'Data Access', 'TRUE'
GO
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
BEGIN
SELECT * FROM [ComputerAInstanceA].DatabaseA.dbo.TestTable
END
GO

On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXECUTE [ComputerBInstanceB].[DatabaseB].[dbo].[InsertA]
GO
Then I receive the second error message.

View 1 Replies View Related

TOP Keyword SQL Server 2005

Apr 2, 2007

I am using the top keyword as follows in the same SP. The select and the update statements are one below the other:
Select TOP(1) col1,col2 from table1 where col3='val1'
Update TOP(1) table1 set col2= 'val2' where col3='val3'
There is a primary key on the column which is not included in either the select or the update statement.
Can anyone confirm that the both the statments will return the same row?

View 2 Replies View Related

Can I Use Translate In Sql Server,is It A Keyword

Oct 3, 2006

im trying to find the equivalent of the below oracle code in sql server.But to my knowledge i feel "translate "is not supported by sql server. so please send me the equivalent sql server query for this.SELECT 'http://ploft.com/ploft?y='||translate(comp,' ','+')||',+'||translate(california,'','+')||',+'||ca||'+'||pzINTO :ls_MAP FROM project WHERE portno=:dbno;

View 3 Replies View Related

Is SQL Server Supported In A VMWare Environment

Aug 24, 2005

I have looked all over the MS site and can find very little information regarding SQL Server's support for the VMWare environment.  Based on other information that I have obtained on other forums and web-site it looks like it is not supported by Microsoft, but I would like the company line if possible.

View 10 Replies View Related

Fulltext Search With Contain Keyword In Server

Sep 25, 2013

I'm using full text search in sql server 2008 with contain keyword.

My issue is while I'm trying

select * from tbl_item_master where contains (ITM_FULLTEXT,'red and white')

above syntax gives me required output but while I'm trying

select * from tbl_item_master where contains (ITM_FULLTEXT,'red and the and white')

above syntax does not gives me output. I'm using system stop list and "the" is noise keyword.

I want to stop searching "the" but want result as per first syntax.

I do get warning " The full-text search condition contained noise word(s)."

Is it possible?

View 1 Replies View Related

Purpose Of OUTPUT Keyword In Sql Server

May 17, 2006

hello sirspurpose OUTPUT keyword with examples

View 3 Replies View Related

Go To Page X Of Y Fast - Not Supported In Sql Server 2008?

Jun 21, 2007

I've been using full-text for quite some time, but I switched to another product for quite some time. The reason is that microsoft full-text doesn't offer the feature where one can get a resultset of page x out of y pages, i.e: give me top 100 matches of page 125 out of 5000 pages. I disappointedly waited for SQL Server 2005 and now it doesn't seem to support in sql server 2008 full-text search either. I had to get all 5000 pages of data, then jumped to page 125 to get just 100 records of that page--had to go get a coffee and came back for a 2+ millions rows table. Customers want the result in a split of a second.



Anyone knows if the final version of sql server 2008 will have better support for paging and getting top x rows? I scanned through 2008 BOL and didn't see any change from sql server 2005 or even sql server 2000 full-text search. (one improvement in sql server 2005 over sql server 2000 was the speed of populating large catalog and multiple languages support)



Thanks,



HH

View 1 Replies View Related

Is DAC Supported In SQL Server 2005 Express Edition?

Nov 10, 2007

Hi All,
Can you please kindly let me know whether DAC(Dedicated Administration Connection) is supported in SQL Server 2005 Express Edition. As per the documentation available in MSDN(Trace Flags), Trace Flag




7806 Enables a dedicated administrator connection (DAC) on SQL Server Express. By default, no DAC resources are reserved on SQL Server Express.

But when i tried to enable it by passing -T7806 as a parameter to SQL Server (SQL Express) service, the following information is logged into event viewer


Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

Also, the following error message is displayed when I tried to connect to DAC from command prompt


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number) (Microsoft SQL Server, Error: -1)

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

The version of SQL Server I'm using is

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )

Can someone kindly me help me to enable DAC of SQL Express edition?

Many thanks in advance.
Gopoinath
Tech Thoughts

View 10 Replies View Related

Features Not Supported In Future SQL Server Versions

Nov 29, 2007

Books online "Deprecated Database Engine Features in SQL Server 2005" makes references to "Features not supported in Future SQL Server versions".

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

Will there be an Upgrade Advisor available to help us identify issues with our code any time soon or should we start building our own?

View 3 Replies View Related

Encryption Not Supported On SQL Server - Error Message

Jun 17, 2005

Hi,

View 16 Replies View Related

What Kind Of Version Of SQL Server Is Supported Under Vista OS?

Sep 13, 2007



A application using Sql Server 7 is developed under WinNT(Win2000, WinXp) . Now want to transfer this application into Vista OS. When install MSDEx86.exe, "SQL Server7 is not compatible with Vista" was warned. When do such kind of transfer, what kind of software related to Sql Server is required? And is it necessary to modify the code of application?

View 3 Replies View Related

SQL Server Does Not Support LIMIT Keyword In SQL Statement?

Jun 5, 2004

What is the SQL Server equivalent of the LIMIT keyword available in MySQL?

SELECT * FROM MyTable WHERE ID = @ID LIMIT 1


this SQL does not work? I get an error saying that there is an error at keyword LIMIT. When I remove LIMIT 1, it works...

is there anything like this in SQL Server?

View 4 Replies View Related

How Can I Get The Keyword List Indexed By SQL Server 2005

Sep 11, 2007

Full Text search must keep a list of key words or items somewhere.
How can I get access to this list to present to a user.
For example: show me all indexed words starting with letter a* and then ac*.
I'm trying to find this information without success.

View 2 Replies View Related

Transact SQL :: Does Server Support MINUS Keyword

Mar 22, 2006

I have two tables CarType & Cars.  Table CarType has a column CarTypeId which is the primary key (int, identity).  Table Cars includes a column CarTypeId (int) which is a foreign key into the CarType table.Now I am trying to build a list of all those CarTypeId entries (from the CarType table) for which there are no Cars (i.e. there is no corresponding entry in the Cars table).I read that there is an SQL "MINUS" keyword that you can use like this:

SELECT CarTypeId FROM CarTypeMINUSSELECT CarTypeId FROM Cars..So if CarType contains records with the keys {1, 2, 3, 4, 5} and Cars contains records with the foreign keys {2, 4} (using set notation), your result should be the set {1, 3, 5}.  (Note:  I have tried alternate versions of this where I selected the DISTINCT CarTypeId entries from Cars, and where I sorted them; results same in both cases).I tried it in SQL Server 2005 Express.  The result is just {1, 2, 3, 4, 5}.

Is the MINUS capability supported by SQL Server?  I know that there are all sorts of different SQL dialects & implementations and that SQL has evolved & transmutated over the years; perhaps they opted to leave this out of SQL Server..

Here's a reference to the website where I initially found out about MINUS: [URL] ....

View 19 Replies View Related

What Encryption (eg AES128) Standards Are Supported For SQL Server Compact 3.5 On WM5 And WM6?

Apr 15, 2008

I was told that AES 128/SHA1 is supported for SQL Server Compact 3.5. The problem is that I couldn't find any product literature from Microsoft that specifies exactly that and my client wants us to provide proof on that.

I hope to get the endorsement from the forum here, and it would be great if someone could point me to some Microsoft resources that specifies the support clearly.

View 1 Replies View Related

Features Not Supported In Compatibility Level 80 Of SQL Server 2005

Oct 23, 2007

Hello All,
I am in the process of upgrading my current database in SQL Server 2000 to SQL Server 2005. I have finished my analysis using the upgrade advisor and have found a lot of SPs having upgrade related issues. From what I estimate I think it will take around 3-4 weeks to resolve all of those issues. I wanted a quicker way to upgrade my database since we have very little time for the final release. The main reason for upgrade to 2005 was use of new features like Database Mirroring and/or peer to peer replication alongwith the Partitioning features and the new T-SQL enhancements.

The question I wanted to ask was does the compatibility level 80 of SQL Server 2005 supports these new features.
From what I have read on the KB article at http://support.microsoft.com/kb/822400 is that mirroring is supported in any compatibility level, but there is no specific mention on the peer to peer thing.
Also when I personally tried using the New Partitioning Features of 2005 on the database having compatibility 80, it worked fine. Also other features like SQLCLR and TRY...CATCH works fine.
One thing I observed was that new T-SQL statements like PIVOT/UNPIVOT is not supported

It will be nice if someone can give out the entire list of features that will be supported in the compatibility Level 80 and also the list of the ones that are not supported.

Thanks in Advance,
Mitesh

View 4 Replies View Related

On Which Platforms Is SQL Server 2005 Compact Edition Supported.

Dec 2, 2006

Will it be possible to run SQL Server 2005 Compact Edition on the following platforms:

Windows 2000

Windows XP (if yes then on which versions of it)

Vista x86

Vista x64

Are there OLE DB providers for SQL Server 2005 Compact Edition?

View 3 Replies View Related

SQL Server 2012 :: Incorrect Syntax Near Keyword CASE

Aug 4, 2015

I'm getting an error as "Incorrect syntax near the keyword 'CASE' ". When trying to run this query.

CREATE PROCEDURE dbo.SP_CDB_EA2
@RiskRef varchar(100)
--drop table #Tmp
AS
BEGIN

[code]....

View 9 Replies View Related

Different SQL Server Showing This Messages---Incorrect Syntax Near The Keyword 'WITH'.

Dec 6, 2007



Hi,
I using "Microsoft SQL Server 9.00.3042.00" at home. But our company old system using "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) ". I think therefore i showing this error when running.

Query:
SELECT @@VERSION
Results:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
-------------------------------------------------------------------------------------------------------------------
Query:
GO
CREATE VIEW dbo._UrunAgaci_KullanimMiktarlari
AS
WITH RPL (AnaUrunKod, BilesenKod, BilesenMiktar) AS
(
SELECT ROOT.AnaUrunKod, ROOT.BilesenKod, ROOT.BilesenMiktar
FROM _UrunBilesenListesi ROOT
/* WHERE ROOT.AnaUrunKod = '100.0.622' */
UNION ALL
SELECT PARENT.AnaUrunKod, CHILD.BilesenKod, PARENT.BilesenMiktar*CHILD.BilesenMiktar
FROM RPL PARENT, _UrunBilesenListesi CHILD
WHERE PARENT.BilesenKod = CHILD.AnaUrunKod
)
SELECT AnaUrunKod, BilesenKod, SUM(BilesenMiktar) AS [Topİht]
FROM RPL
GROUP BY AnaUrunKod, BilesenKod;
GO
Results:
Server: Msg 156, Level 15, State 1, Procedure _UrunAgaci_KullanimMiktarlari, Line 3
Incorrect syntax near the keyword 'WITH'.

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

What is solving?

Thanks

View 7 Replies View Related

List Of Supported Components For SQL Server 2005 Standard Edition?

Jan 17, 2006

Please can someone give me a url or even their own list of support / unsupported components in SQL server 2005 Standard edition.

I know fuzzy lookup is not supported. Is a slowly changing dimension supported?

Its a bit difficult to tell when I get bizzare "Product level is insufficient" error for even a basic derived column transformation when executing a package using SSIS unless it is executed using a scheduled job....

thanks,

Nicole

View 3 Replies View Related

Replication :: Connections Through A Server Alias / IP Address Or Any Other Alternate Name Not Supported

Nov 13, 2015

While I try to configure replication getting below error message:SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, "servername". (Replication.Utilities)

Note: SQL server instance names shows different in sql server configuration manager and SSMS sql server instance name in  configuration manager: 2di3100sqlserverprod ,but i run the query in SSMS SELECT @@SERVERNAME it shows: 2di3100plugin.

View 3 Replies View Related

SQL Server 2008 :: Full Text Search - Searching For Keyword

Apr 8, 2015

I am searching for the key word 'Platform Customer Support' using full text search. My code is as below

Set @KeywordSearch = 'Platform Customer Support'

Select AA, BB, CC, DD from SM9..TableName A Right Outer Join SM9_Experiment..TableName C
On A.IncdTouchedGSF like '%' + C.SM9GroupName + '%'
Where
(
Contains(A.[Description], @KeyWordSearch)
And A.OpenTime Between @StartDate and @EndDate
And C.Classification = @GroupNameClassification
)

The code is throwing:

Msg 7630, Level 15, State 3, Line 46
Syntax error near 'Customer' in the full-text search condition 'Platform Customer Support.

View 2 Replies View Related

SQL Server 2005 Database Mail Command Not Supported (502) SMTP Error

Dec 4, 2006

Hi all,At this moment I'm trying to get database mail working. According tosome people it should be easy. Well...that is not the case for me.I'm having the following error:The mail could not be sent to the recipients because of the mail serverfailure. (Sending Mail using Account 2 (2006-11-24T08:48:15). ExceptionMessage: Cannot send mails to mail server. (Command not implemented.The server response was: Command not Supported).)SQL Server 2005 is installed on a separate server and the SMTP Serveris Lotus Notes. connecting with port 25.Start and stopping the SQL Server and SQL Server agent i tried already.i tried sysmail_stop_sp and sysmail_start_sp.Sometimes when starting or stopping the Mail with the followingcommands :exec sysmail_stop_spGOexec sysmail_start_spGOI will get the following error:Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - No process is onthe other end of the pipe.)So any help would be appreciated.Hennie

View 1 Replies View Related

SQL Server 2005 Issue - The Cursor Type/concurrency Combination Is Not Supported.

Jun 19, 2007

Hi



I have recently upgraded from SQL 2000 to SQL 2005 and I'm getting the following problem, can you suggest me if this is a issue with SQL 2005 or suggest me an asnwer for this.

Below is the exception from my log file

The cursor type/concurrency combination is not supported.
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source)



The following is the piece of code where the problem I'm assuming is happening, how can I correct it.

varStmt1 = varConnection.prepareStatement(varCitationSQL.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

Have tried using both JDC v1.1 and 1.2 but of no use.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved