Collation Or Local Sensitive Settings Or Other Configuration Properties
Dec 26, 2005
I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.
Living in Belgium, the local settings are:
language = Duch (Belgium)
code page = 850
e.g. in the database samples (AdventureWorks database €“ AdventureWorks Warehouse database)
my date notation is: 26-12-2005
my number notation is: 1,0013016921998599
all demo samples and tutorials are developed using
language = English (United States)
code page 1252
e.g. in SampleCurrencyData.txt
the date notation is: 12/26/2005 00:00:00
the number notation is: 1.0013016921998599
I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !
e.g. for Integration Services Tutorial - lesson 1: €śCreating the Project and Basic Package€?
there are no error messages, 1097 rows are processed
but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !
Why?
- is the problem related to the local language settings? how to solve this?
- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?
- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?
- when to use float data type DT_R4 or DT_R8?
- I have remarked that the DT_DBTimeStamp is undependent from the source time notation €“ Is this correct?
- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?
- Is Integration Services dependant of the local settings of the database engine?
- how to set / modify additional regional properties in a SSIS and SSRS package?
- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language €“ Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?
- how to work with e.g. US based data as source and Belgium settings for reports?
View 6 Replies
ADVERTISEMENT
Jul 28, 2004
This problem concerns files FTP'd (using True64) from an AIX app, to an WIN server
These files can't be loaded into the SQL Server DB using BCP (String data, right truncation) nor into an ACCESS DB ("Overflow"), (but can be loaded into Excel).
If the file is opened and saved in a Windows/DOS environment it loads fine, or contents copied to an empty win/dos file.
If the same file is sent from to the Win server using DOS FTP then it loads fine.
It seems to be that these DBMS's don't like something about the operating system level file properties (hdr or EOF?).
Can any one help?
View 1 Replies
View Related
Jul 16, 2002
New SQL2000 installation into which I've copied data from multiple SQL7 installations. Some of the databases I've copied over from a SQL7 server with code page 850, sort order/collation 42, using the detach-copy mdf/ldf-attach procedure outlined elsewhere on this site (thank you). Other databases have been DTS'd from another SQL7 server with code page 850, sort order/collation 44.
In the end I want all databases to be in the default Latin1_General_CI_AI collation I've chosen for my installation.
I'm off to immerse myself in collation papers and alter database documentation from BOL, but was hoping someone could enlighten me in a less painful way.
Thanks,
Al
View 2 Replies
View Related
Apr 17, 2003
hi all,
I need to select collation settings to support chinese characters. As i came to know that i need to select 950 character set. But problem is that i am not able to find the option for chinese characters i.e, 950 character set in the collation settings of the setup. It will be helpful if anyone could suggest me if there is any other option to set while set up or in an existing sql server instance to support chinese character data.
Thanks in advance,
sekhar
View 2 Replies
View Related
Apr 5, 2008
Dear All,
I am facing one problem when I am trying to create some stored procedures,
Msg 468, Level 16, State 9, Procedure SG_GET_USER_SECTOR_POSITION, Line 11
Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure SG_GETRANKLIST, Line 4
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.
I need to change these collation settings, please help me how to change them.
thanks & regards,
Shahbaz.
View 3 Replies
View Related
Mar 18, 2008
Hi,
I'm installing SQL Server 2005 on windows 2003 R2.
Which Collation Designator is to be used so that the both English as well as Arabic characters can be stored simultaneously...?
That is "The collation settings designator which support both Arabic as well as English character set"...
Thanks,
Vivek
View 1 Replies
View Related
May 18, 2015
Over the weekend I decided to give it the ability to do a case sensitive character swap. Updating the code was pretty straight forward but when I was through, I noticed that I was getting Cardinality Estimate warnings that I wasn't getting before.
Anyway, here is some test data and two versions of the executed SQL (the base code is all dynamic and the two code versions are the result of toggling the @MatchCase parameter).
/* ========================================
CREATE TABLE
======================================== */
CREATE TABLE [dbo].[PersonInfoSmall](
[PersonID] [BIGINT] NOT NULL,
[FirstName] [NVARCHAR](50) NOT NULL,
[MiddleName] [NVARCHAR](50) NULL,
[LastName] [NVARCHAR](50) NOT NULL,
[code]....
View 8 Replies
View Related
Mar 5, 2008
Does anyone know what I could change the collation of a table to, to properly handle Mapics data?
Thanks.
View 1 Replies
View Related
Sep 13, 2006
I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time).
I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK.
That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally).
Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this.
Now I'm focussing on using SQL Package Configurations to try and drive this. As I see it, just like XML configurations, if you change a value in the configuration source, then when the package runs, it get's that value, and uses it.
I have change the configuration value (outside of the package). I confirm it is actually changed by running a SQL Task that gets the value from the configuration table, and view the value assigned to the variable in watches. The value returned is a different value (in my case I changed it to an invalid servername), and yet the task still runs through successfully, using the previous SMTP servername.
huh?
View 4 Replies
View Related
Apr 7, 2015
We changed the IP addresses for several SQL Servers and we're a little confused by what we see in Configuration Manager. The TCP/IP properties "IP Addresses" tab still shows the old IP address, even after a restart. On "Protocol" tab, Listen All is set to "Yes".
We've found one source that says this setting causes the listening on an individual IP to be ignored.
View 0 Replies
View Related
Jul 20, 2005
Hi,I would like to know how to get a list of configuration settings for adatabase.Is there a table that I can select this info from?Or a file (perhaps an ini file?) of some kind?Things like timeout settings, rollback space, table space, etc.Thanks
View 2 Replies
View Related
May 27, 2008
OK, here's the scenario:
I have some libraries (DLL) that I call from a regular console application. The data access methods get the connection string from the app.config, nothing special there.
The thing is: now I need to use the libraries inside a SSIS package. I call them from a script task, and everything is fine, except for the connection string.
Is there a way that I can get the connection string from the SSIS package configuration like I would from the app.config? Maybe some alternative to ConfigurationManager.AppSettings["ConnString"] in the DTS Runtime?
Thanks in advance...
View 3 Replies
View Related
Jun 26, 2006
I need another opinion about the SQL Server Configuration Manager's TCP/IP settings...
Recreation steps:
Start, (All) Programs, SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
Expand the "SQL Server 2005 Network Configuration"
Select the "Protocols for x" where "x" is the named-instance or "MSSQLServer" for default.
On the right-hand pane, right-click "TCP/IP" and select "Properties."
Select the "IP Addresses" tab.
Visually on the screen I have this:
_______________________________________
- IP1
Active Yes
Enabled No
IP Address 106.xx.xxx.xx
TCP Dynamic Ports
TCP Port 1433
- IP2
Active Yes
Enabled No
IP Address 127.0.0.1 <-loopback
TCP Dynamic Ports
TCP Port 1433
-IPAll
TCP Dynamic Ports
TCP Port 1433
_______________________________________
Questions:
1. If I want to change the listening port, I change all three at the same time?
1a. Does a value in the IPAll section override the individual IPx sections?
2. What does "enabled" mean? How can IP1 and IP2 not be enabled?
3. What does "active" mean? How can something be both active yet not enabled?
(4. Any plans to change the "NULL=False, 0=True" values for the Dynamic Ports?)
View 4 Replies
View Related
Mar 27, 2006
I have just upgraded to SQL Server 2005 from SQL Server 2000.In Microsoft SQL Server Management Studio, when I click on databaseproperties, I receive the following error:-Cannot resolve the collation conflict between"Latin1_General_CI_AS"and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.(Microsoft SQL Server, Error: 468)Some reference suggest that I can change the database collation byclicking database properties!What can I do?
View 21 Replies
View Related
Aug 15, 2007
We would like to use the SQL Server 2005 Express at our customers.
But now we have to meet the local security settings of the PC.
What is happening with the database users password (e.g. sa) when the "Maximum password age" in the "local security settings" for the password policy is to >0 (e.g. 30 days)?
Because this cause a frequently change of the passwords at the customers!!!!!!
View 1 Replies
View Related
Jul 20, 2015
We have build configuration setup for each environment that we automatically deploy to (DEV, UA, PROD 1, PROD 2, etc.) Â We've recently come across a scenario where one environment will now be running a different version of SQL Server than the others.
Is it possible to tie the Target Platform version to a configuration. Such that one configuration could target 2012 while another targets 2014?
View 2 Replies
View Related
Apr 24, 2007
Hello Everybody,
I have developed a SSIS package to pull data from a remote SQL Server.
I have specified Database related settings in a dtsconfig file.
I was just wondering if we have any way of encrypting the config file so that only my package can read information out of it.
Or is there any other better way where i can store my database configuration (uid, pwd) so that it is not viewed by anyone.
please help me with this issude, thanks in advance...
Regards,
Sudhir Kesharwani
View 4 Replies
View Related
Jan 29, 2008
Hi,
I developed a report in development environment, which will later be deployed to QA, Staging and then Production. This report has more than 10 datasets and if the report is moved through each of the databases, datasource has to be changed for all the datasets. is there anyway that I can do it globally, what i mean is can i set up any configuration files which I can use in QA, Staging and Production.
Any ideas
Thanks,
Priya T
View 4 Replies
View Related
Aug 10, 2006
Suppose 2 environments on a single machine.
Each environment has different configuration settings....different
databases etc.
All the packages in the first environment have a hardcoded config files
referencing the local drive.
In order to create the second environment do I have to
go into each package and manually change the location of the
hardcoded config files. If I don't it will it not use the config files
from the first environment.
Thanks
View 1 Replies
View Related
Mar 22, 2000
Is there no longer a graphic interface for the parameters that are output with sp_configure?
There are many options that are settable that are not in the Sql Server Propreties, but
these items were in the 6.5 graphic interface through EM ex. number of open objects.
Is there a script to save these settings so the installation can be recreated?
View 1 Replies
View Related
Jul 2, 2007
Hi,
When you check out the project properties of a RS project, you can find the deployment attributes like targetdatasourcefolder, etc... There's also a button "Configuration Manager...". Here I can see a column "Platform" which is empty. I got the feeling I should be able to configure different platforms here, select an active environment and deploy to it some how. Is this correct; how does this work, and why not?
Regards, Jeroen
View 1 Replies
View Related
Jun 25, 2007
I'm quite addicted to Patterns-&-Practices Enterprise.Library.Data module, but I can't get it to access a SQL Server Express Database. I've tried several different .CONFIG files and a unch of different settings and I keep getting:
The local database "XXYYZZ" is not defined in configuration.
I'm using Visual Studio 2005 C# in a WinForms application.
Can Microsoft.Practices.EnterpriseLibrary.Data access SQL Server Express Database????
View 3 Replies
View Related
Mar 16, 2015
I have an ODBC connection string that is working fine with the following properties:
Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.
I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.
Under Registered server name I've tried:
YYYYYYXXXXX
When I browse the server for the database instance list, I receive "network path was not found".
I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.
What am I doing wrong ?
View 1 Replies
View Related
May 1, 2007
Hello,
I've restored a SQL Server 2000 database with a Latin1_General_BIN collation from a .dmp file to a SQL Server 2005 server with a default collation of SQL_Latin1_General_CP1_CI_AS. When I try to change the database collation I get hundreds of the following error:
The object 'CK_PM10200_GLPOSTD_00AF8CF' is dependent on database collation. So, in this case, is it even possible to change the collation if there are objects in the database that are dependent on it?
Thanks,
Bruce
View 7 Replies
View Related
Sep 15, 2014
I changed the default collation of a database and every table within that except sysDiagrams , which I can't even through the designer .
View 9 Replies
View Related
Oct 15, 2015
I am using SQL Server 2008. In ServerProperty function, there are two properties called “Collation” and “CollationID”. In some cases, I will only know the CollationID. Is it possible get the collation name from the CollationID? Is there a function called CollationNameFromID?
View 1 Replies
View Related
Oct 16, 2015
I am using SQL Server 2008. In ServerProperty function, there are two properties called “Collation” and “CollationID”. In some cases, I will only know the CollationID. Is it possible get the collation name from the CollationID? Is there a function called CollationNameFromID?
View 2 Replies
View Related
Oct 2, 2007
We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines.
Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either.
Any help is greatly appreciated.
Thanks,
Craig
View 3 Replies
View Related
Sep 22, 2007
I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
View 3 Replies
View Related
May 2, 2007
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
===================================
View 1 Replies
View Related
May 23, 2006
Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do
thanks in advance Dave
Background:
SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go
http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx
Wizard results:
Name:
ETL
Type:
SQL Server
Connection name:
ETLConfiguration
Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.
Configuration table name:
[dbo].[SSIS Configurations]
Configuration filter:
PT_CUST_ABR
Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]
USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
View 3 Replies
View Related
Jun 7, 2006
I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
View 7 Replies
View Related
Dec 21, 2005
Hi Everyone
I am at the stage of architecting my solution
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
I would appreciate your help immensley
View 7 Replies
View Related
