HiI currently have a problem with registering a new server in my EnterpriseManager on a new PC.I need to connect to a MSSQL2K server on a windows 2003.My current PC is on the same LAN as the server and has no problemregistering the server in Enterprise manager. This PC uses NT (about time Ichange :-)The new PC runs WIN2K. But this PC is on another LAN and has to access theserver through a firewall. Port 1433 is open in the firewall.I use a Firewall-1 authentication agent to access the server.I use SQL authentification to logon (sa account), I have checked that thenew clients network libraries are the same version as the servers.In the client network Utility I have set up an alias with the server I wantto access.The registration seems to access the SQL server, but comes out with an errorstating: "invalid attribute/option identifier"When I search KB with this message, I get nothing. Did anyone in hereexperience anything like this? Any pointers to help me move on would begreatly appreciated.best regardsRené Pedersen
I'm using a software called epi suite which is used to print id badges. The system is currently running on an access database and everything works according.
I am trying to migrate it off access to SQL 2k and have run into a problem when trying to insert data back into the system.
I can pull back data w/o any problems (to view and even print badges) but the minute I try to Save anything [New Image or change the card to unprinted], it comes back with the error:
Failed to save the card record. Database error: Invalid attribute/option identifier
Error HY092[Microsoft][ODBC SQL Server Driver]
Has anybody ran into this type of situation before? The problem is, the company will only support access and says that SQL is a use at your own risk type of deal.
I'm new to using MS SQL so I am unsure what the best solution would be to try and find the problem. Is it possible that the software is just sending some sort of malformed query over to the database? Anything I have found on that error [HY092] seems to point in that general direction.
Now i am using window authentication to login to SQL2005 Express. Everything is fine when I logged with administrator. But if I use normal user to log in, then I can not connect to SQL database, even I am using user instance. I got the error message is:
Microsoft SQL Native Client (0x80004005) Invalid connection string attribute
My connection String is: Provider=SQLNCLI;Initial Catalog=***;Data Source=***; Persist Security Info=False;User Instance=True; Integrated Security=SSPI; AttachDBFileName=directory***.mdf;"
We have recently been having some problems with our server, and im stuck for ideas of what to try next!
Basically we have a busy period every 2 hours where we have many records that need to be processed etc, but we are getting an error coming back saying 'Invalid connection string attribute'.
Now this would be fine but we are using a UDL and 80% of the records are going in fine and its just this few that are coming back with this error. This happens at 3mins and 55 secs past the hour everytime too.
Now i ran SQL profiler over this time and there are records and such being processed fine, then all of a sudden at 3min and 55 secs past there is a mass 'Audit Logout' noted in profiler.
It would seem to me it has nothing to do with the connection string as it was working perfectly fine before.
The processing is done using a VB6 dll being called through ASP on IIS 6.
Does anyone have any ideas on what to try next or advice?
I'm trying to connect to a tab-delimited text file using the ODBC data access. I set it up using Administrative Tools - Data Sources (ODBC) from the start menu, and clicked the 'Guess' button under Define Format.
It looks OK, but if I go back to Define in Administrative Tools and try to review it, I get a similar error message:
Ini File (or Registry) C:Program FilesCIMSschema.ini is corrupt. Section: cims_output_data.txt, Key: Col1.
Has anyone seen this before? There is nothing on MSDN as far as I could find. I read on another forum that if you replace the label 'Col1' with 'Col' the problem is solved but it still reports that the schema is corrupt when I try to open it in Administrative Tools.
I had to change the key columns of a dimension attribute to fix an error. I did this in BIDS. The change was from a single key column to a composite key column. Now I am getting these error when I process the cube:
Measure group attribute key column x does not match source attribute ..
I looked at the cube XMLA definition under mesaure groups and it still shows a single key column with inherited binding. However, the BIDS does not give me an option correct this in any way. I have had to do this once before and the only option seems to be removing the dimension from the cube and add it back in. But that is very error prone since I lose any specific settings at the cube dimension level not to mention aggregations no longer include the dimension, etc.
Not seeing an alternative, I went through each measure group (I have 7) and changed the key columns manually in the XMLA and saved the cube. This worked, but I don't understand why BIDS automatically doesn't do it.
Is this a flaw in the BIDS or I should be missing something.
Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio 2005 Setup.
So I started a new job recently and have noticed a few strange configurations. Typically I would never mess with min memory per query option and index create memory option configuration because i just haven't seen any need to. My typical thought is that if it isn't broke... They have been modified on every single server in my environment.
From Books Online: • This option is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician. • The index create memory option is self-configuring and usually works without requiring adjustment. However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value.
Does anyone know the column name for the system row identifier. For example Informix uses rowid, for Ingres its tid, in MS SQL server its _______ (fill in the blank).
I'm trying to create a unique identifier number that meets the following criteria. The unique identifier needs to be a concatenation of two values submitted from a form and the identity value (primary key) for the new record that is inserted into the database.
So, if the first field is the year and the second field is a objnumber, the unique identifier number would have the format: ("YR" + "objnumber" + primary key value), where the year and object number are what the user selected in the form.
I have a stored procedure that I use to handle the insert, which also returns @@identity for the purpose of passing that value into another stored procedure that inserts child records.
So, within my stored procedure, is there a way I can create the unique identifier number and return that value back to the application? I'm not sure how to accomplish this?
Msg 103, Level 15, State 4, Line 3 The identifier that starts with ' "C:Program FilesMicrosoft SQL Server90COM ablediff" -sourceserver "VSNET1" -sourceuser "sa" -sourcepassword "sysadm" -sour' is too long. Maximum length is 128.
When i split the Identifier as
SET QUOTED_IDENTIFIER ON DECLARE @sFull varchar(1000) DECLARE @s1 varchar(1000) DECLARE @s2 varchar(1000) DECLARE @s3 varchar(1000) DECLARE @s4 varchar(1000) SET @s1= '""C:Program FilesMicrosoft SQL Server90COM ablediff""' SET @s2= ' -sourceserver "VSNET1" -sourceuser "sa" -sourcepassword "sysadm" -sourcedatabase "PMSTEMP" ' SET @s3=' -sourcetable "DEMAT" -destinationserver "VSNET1" -destinationuser "sa" -destinationpassword ' SET @s4=' "sysadm" -destinationdatabase "PMSRESTORE" -destinationtable "DEMAT" -f "c:Diff"' SET @sFull = @s1 +@s2 + @s3 + @s4 EXEC XP_CMDSHELL @sFull
this executes fine but the optput is as
The input line is too long. NULL
What is this? how could i execute such long commad using CMDSHELL?
Is there a field in the SQLException class that identifies what specific exception was thrown. I tried Number and ErrorCode but those seem to change randomly, they are not consistent. Thanks
I am working on some tables and would like to know which is best way to go when deciding what Type to use for Unique ID in my tables please. Int Or uniqueIdentifier? Or is it all the same??
Hi there,I'm new to sql server. I've created a table which can be updated through an aspx form. However coming from an access background I don't know how to generate an auto number. I've read through a number of the threads on here and keep coming across Identity or unique identifier. However I can't actually find out how to implement these.Any help would be greatCheersStu
Hello!I work with oracle, mySQL but im completely new to SQLserver.How can i set a auto-increment unique variable for userID ?After deleted user, the userID should be never used again on a new user.Thank you,
use projectserver2003 selectr.RES_NAME, p.PROJ_NAME, a.TASK_NAME, w.WWORK_START, w.WWORK_FINISH, w.WWORK_VALUE from MSP_WEB_RESOURCES r, MSP_WEB_ASSIGNMENTS a, MSP_WEB_PROJECTS p, MSP_WEB_WORK w join MSP_VIEW_PROJ_TASKS_ENT TE on r.WPROJ_ID=TE.WPROJ_ID join MSP_VIEW_PROJ_RES_ENT RE on r.WPROJ_ID=RE.WPROJ_ID join MSP_VIEW_PROJ_PROJECTS_ENT PE on r.WPROJ_ID=PE.WPROJ_ID wherew.WWORK_TYPE = 1 -- actual work andw.WASSN_ID = a.WASSN_ID anda.WPROJ_ID = p.WPROJ_ID anda.WRES_ID = r.WRES_ID
This statement is returning the following errors:
Msg 4104, Level 16, State 1, Line 2 The multi-part identifier "r.WPROJ_ID" could not be bound. Msg 4104, Level 16, State 1, Line 2 The multi-part identifier "r.WPROJ_ID" could not be bound. Msg 4104, Level 16, State 1, Line 2 The multi-part identifier "r.WPROJ_ID" could not be bound.
I have all tables identified; however unclear as to why it cannot be bound.
if exists (select 'x' from obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class) BEGIN set @temp_old_ref = (select obj.rowid from obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class) SET IDENTITY_INSERT new_obj ON insert into new_obj(rid, key1, class, is_searchable, is_deleted, is_loaded, old_rid, old_ref) select rid, key1, class, is_searchable, is_deleted, is_loaded, old_rid, @temp_old_reffrom new_obj delete from new_obj where old_ref != @temp_old_ref END
while running it i m getting this error
Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 35 The multi-part identifier "new_obj.key1" could not be bound. Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 35 The multi-part identifier "new_obj.class" could not be bound. Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 37 The multi-part identifier "new_obj.key1" could not be bound. Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 37 The multi-part identifier "new_obj.class" could not be bound.
I've found lot of other people experiencing the same problem I'm having, but I can't get any of their solutions to work for me. I have two tables with the exact same structure Today and Yesterday. I'm trying to compare a price column from Yesterday's column against Today's and I'm getting the 'The multi-part identifier '' could not be bound' error. Here's the code I'm using:
DECLARE @ProgramName varchar(100) SET @ProgramName = 'AffiliateName'
SELECT CJ_RawImport_Today.* FROM CJ_RawImport_Today WHERE (CJ_RawImport_Today.ProgramName = @ProgramName) AND (CJ_RawImport_Today.RetailPrice < CJ_RawImport_Yesterday.Price)
Does anyone know if there is a read-only unique identifier of a database in a given server instance? E.g. a value stored somewhere in the database meta data that is generated during CREATE DATABASE...
Can somebody help me with the following error while deploying my cube:
The attribute key cannot be found : dbo_fact_table, Column: datetime Value 25/10/1901 4:18:00 pm...
The year 1901 is included in the time period of the time dimension. The calendar includes the following dates : 1/1/1753 - 31/12/2007 (Time binding) Why this referential integrity error occurs ??
Please help me because it is urgent and I cannot find a solution..
Hi:I need to store MAC Addresses. What is the standard way of storing thistype of attribute? Datatype? I can't find any discussions about thisanywhere.Thx for any pointers.
