Db Not Recognised

Sep 10, 1999

I've just reinstalled SQL 7, and it will no longer recognise a .mdf file created last week.

Any ideas ?

'last' Is Not A Recognised Function Name

Jul 18, 2006

Hi all,

ive tried to run a query in a view and am getting this error message:

'last' is not a recognised function name

i was sure that last was used in sql, how can i get the same result if it wont accept 'last'?

greg

View 2 Replies View Related

Custom Log Provider - Not Recognised.

Feb 15, 2007

Hi All,

I have a tricky one for you...

1. I create a custom log provider on machine A.

2. I deploy the signed assembly to the../../DTS/90/LogProviders directory & the GAC on both machine A & machine B.

3. I create a new package on machine A & go to enable logging for this new custom provider: I find it in the drop-down list of providers, and I can add it successfully.

4. I create a new package on machine B & go to enable logging for this new custom provider: I find it in the drop-down list of providers, but I can't add it. I get the following error:

'...failed to create log provider...the log provider type "_" specified for log provider "_" is not recognized as a valid log provider type. This occurs when an attempt is made to create a log provider for an unknown log provider type. Verify the spelling in the log provider type name (package)."

Any ideas anyone??

Tamim.

View 5 Replies View Related

Incompatible Datatype?? Varchar(50) Not Recognised As String?

Jun 15, 2008

here is my code snippet

Session("matricN") = Trim(TextBox1.Text)
Dim txtValue As String
txtValue = Session("matricN")
da = New SqlDataAdapter("select MatricNumber,Name, Roles from Register where MatricNumber = " & txtValue, addRoleConn1)

MatricNumber is in varchar(50) datatype,, the errror says there is a syntax near "="

View 1 Replies View Related

Column Name Not Recognised Even Though The Procedure Returns A Table With That Name??

Apr 27, 2006

I am databinding a dataset formed from a stored procedure,(all done on page_load).
However, the reference to the column name is not recognised with the following error being returned.
Column with name "CalcVal" was not found.
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: Column with name "CalcVal" was not found.Source Error:

Line 152: chartCommand.Fill(chartDs);
Line 153: Chart1.DataSource = chartDs;
Line 154: Chart1.DataBind();
Line 155:
Line 156: }
This worked before deployment and the other controls which are bound to data using stored procedures seem to work. However, these other data sources are all sqlDatasoure controls.
Any suggestions would be helpful.
I have found issues relating the to user ID and password which seems to depend on whether the web server and data server are the same machine or whether they are remote from each other.
cheers-jim.

View 1 Replies View Related

Failover Partner Keyword Not Recognised With OLEDB

May 10, 2007

Hi

Sincere Apologies for the cross posting. Did not realize that there is a specific DB Mirroring group and so posted initially in the High Availability group. Here is the original post

Hi

I am trying to test DB Mirroring connectivity and running into a road block. using SQLOLDB in my connection string the failover partner keyword seems to be not recognised when the failover occurs and the connectivity fails. The same however works with the SQL Native client driver.

Can any expert please let me know what I am doing wrong and what is the right connection string for the OLEDB one?. I also tried using different flavors of FailoverPartner (like Failover Partner, FailoverPartner etc) to make it work with OLEDB but still could not connect with SQLOLEDB provider.

SQLNCLI works with no issues at all.

Connection string code samples included.

--Code that does not work

Code Snippetconnstring = "Provider=SQLOLEDB;network=dbmssocn;Data Source=Server1SQLInst1;FailoverPartner=Server2SQLInst2;Initial catalog=mydb;INTEGRATED SECURITY=SSPI;"

Code Snippetconnstring = "Provider=SQLNCLI;network=dbmssocn;Data Source=Server1SQLInst1;FailoverPartner=Server2SQLInst2;Initial catalog=mydb;INTEGRATED SECURITY=SSPI;"

Any help is appreciated.

Thanks

AK

View 3 Replies View Related

Database Name With Point In It (mail.archive.mdf) Not Recognised In Query Analyser Of SQL 2000

Jun 21, 2006

Apparently the query analyser of sql server does not recognise adatabase with a point in it, likemail.archive.mdfI receive the following error when I use it:Server: Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'mail'. No entryfound with that name. Make sure that the name is entered correctly.Please help, thanksPrem

View 2 Replies View Related