Connection option in MSSQL2005

Hi,
There is a setting in option-> connection -> 'Perform translation for character data' in Query Analyzer in MSSQL 2000. Is there any option in MSSQL2005 has simliar function? Thanks in advance

(stephanielauym@.discussions.microsoft.com) writes:
> There is a setting in option-> connection -> 'Perform translation for
> character data' in Query Analyzer in MSSQL 2000. Is there any option
> in MSSQL2005 has simliar function? Thanks in advance There does not seem to. I had enough with character translation with the 6.5 tools, so I can't say that I miss it. What use would you see for such an option? -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

|||in the DB, some of the field in varchar contains chinese characters. In MSSQL2000, we un-click this option to read the chinese char.|||

(stephanielauym@.discussions.microsoft.com) writes:
> in the DB, some of the field in varchar contains chinese characters. In
> MSSQL2000, we un-click this option to read the chinese char. And you are saying that there is no way to turn transkation off in Mgmt Studio? I have it off in my QA, but I can't say whether that is the default or not. (I assumed that it was off by default, but maybe I was wrong.) What is the collation of these columns? How do they display in QA currently? If this is important for you I suggest that submit a suggetion on http://lab.msdn.microsoft.com/productfeedback/. It's a good idea to give a background why you want this. -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

|||Yes, I can't find the option which is similar to the option 'Perform translation for character data' in Management Studio. In our case, turning off this option would display chinese in varchar field.sqlsql

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classi
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Connection

Hi
when i design a report using SQL 2005 and try to run it in production mode
with setting the servertarget rul property of the project to http://localhost
i get an error that it cant connect to the local host, but when i click the
preview tab i find the report with correct data so whats the problem ?
the OS is win 2003 enterprise
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643
The url needs to be the path to the Reporting Services web service i.e.
http://localhost/ReportServer
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Pure Heart" <PureHeart@.discussions.microsoft.com> wrote in message
news:055ADB25-181E-41FE-BC2B-A081538FB646@.microsoft.com...
> Hi
> when i design a report using SQL 2005 and try to run it in production mode
> with setting the servertarget rul property of the project to
> http://localhost
> i get an error that it cant connect to the local host, but when i click
> the
> preview tab i find the report with correct data so whats the problem ?
> the OS is win 2003 enterprise
> --
> Ammar S. Mitoori
> IT Head QIMCO Co.
> Tel : +9744831199
> Mobile : +9745378400
> Fax : +9744831643
|||hi
thanx for ur replay i tried and it didnt work also,, so any suggestions ?
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643
"Jasper Smith" wrote:

> The url needs to be the path to the Reporting Services web service i.e.
> http://localhost/ReportServer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Pure Heart" <PureHeart@.discussions.microsoft.com> wrote in message
> news:055ADB25-181E-41FE-BC2B-A081538FB646@.microsoft.com...
>
>