I'm losing my tildes over here!

Hi all,
Looks like I inherited a little collation problem, and it's causing me
headaches. This is a little involved, so please bear with me:
Most of the CHAR and VARCHAR columns in the tables of this database are set
to SQL_Latin1_General_CP1_CI_AS collation. A few are set to
SQL_Latin1_General_CP437_CI_AI. Basically this can't be changed. Now when
I bulk import I'm getting strange results. A regular INSERT with some
accented, etc., Latin characters is working fine. An INSERT of 'MÃirk' in
the CP437 columns (the A has a tilde over it -- in case it doesn't show up
correctly in people's newsreaders) works as expected.
When I try to bulk import with the ODBC Bulk Operations API the A loses the
tilde. I've tried the Windows MultiByteToWideChar function with several
different Windows code pages with some success (I no longer lose the
accented é [e acute] or the French ç [c with the cedilla] characters.)
Does anyone have any ideas I can try to keep from losing the tilde over the
A and any other diacritic marks in my Latin characters?
BTW, I can't change the column collations or change them to NVARCHAR.
ThanksHmmm... After more testing, it looks like the Code Page 437 *is* the
problem. It strips out a lot of accent marks. Looks like they'll have to
take it without accent marks or change the code page. Thanks.
"Mike C#" <xyz@.xyz.com> wrote in message
news:uEQe2eryGHA.4452@.TK2MSFTNGP05.phx.gbl...
> Hi all,
> Looks like I inherited a little collation problem, and it's causing me
> headaches. This is a little involved, so please bear with me:
> Most of the CHAR and VARCHAR columns in the tables of this database are
> set to SQL_Latin1_General_CP1_CI_AS collation. A few are set to
> SQL_Latin1_General_CP437_CI_AI. Basically this can't be changed. Now
> when I bulk import I'm getting strange results. A regular INSERT with
> some accented, etc., Latin characters is working fine. An INSERT of
> 'MÃirk' in the CP437 columns (the A has a tilde over it -- in case it
> doesn't show up correctly in people's newsreaders) works as expected.
> When I try to bulk import with the ODBC Bulk Operations API the A loses
> the tilde. I've tried the Windows MultiByteToWideChar function with
> several different Windows code pages with some success (I no longer lose
> the accented é [e acute] or the French ç [c with the cedilla] characters.)
> Does anyone have any ideas I can try to keep from losing the tilde over
> the A and any other diacritic marks in my Latin characters?
> BTW, I can't change the column collations or change them to NVARCHAR.
> Thanks
>

I'm losing my tildes over here!

Hi all,
Looks like I inherited a little collation problem, and it's causing me
headaches. This is a little involved, so please bear with me:
Most of the CHAR and VARCHAR columns in the tables of this database are set
to SQL_Latin1_General_CP1_CI_AS collation. A few are set to
SQL_Latin1_General_CP437_CI_AI. Basically this can't be changed. Now when
I bulk import I'm getting strange results. A regular INSERT with some
accented, etc., Latin characters is working fine. An INSERT of 'Mirk' in
the CP437 columns (the A has a tilde over it -- in case it doesn't show up
correctly in people's newsreaders) works as expected.
When I try to bulk import with the ODBC Bulk Operations API the A loses the
tilde. I've tried the Windows MultiByteToWideChar function with several
different Windows code pages with some success (I no longer lose the
accented [e acute] or the French [c with the cedilla] characters
.)
Does anyone have any ideas I can try to keep from losing the tilde over the
A and any other diacritic marks in my Latin characters?
BTW, I can't change the column collations or change them to NVARCHAR.
ThanksHmmm... After more testing, it looks like the Code Page 437 *is* the
problem. It strips out a lot of accent marks. Looks like they'll have to
take it without accent marks or change the code page. Thanks.
"Mike C#" <xyz@.xyz.com> wrote in message
news:uEQe2eryGHA.4452@.TK2MSFTNGP05.phx.gbl...
> Hi all,
> Looks like I inherited a little collation problem, and it's causing me
> headaches. This is a little involved, so please bear with me:
> Most of the CHAR and VARCHAR columns in the tables of this database are
> set to SQL_Latin1_General_CP1_CI_AS collation. A few are set to
> SQL_Latin1_General_CP437_CI_AI. Basically this can't be changed. Now
> when I bulk import I'm getting strange results. A regular INSERT with
> some accented, etc., Latin characters is working fine. An INSERT of
> 'Mirk' in the CP437 columns (the A has a tilde over it -- in case it
> doesn't show up correctly in people's newsreaders) works as expected.
> When I try to bulk import with the ODBC Bulk Operations API the A loses
> the tilde. I've tried the Windows MultiByteToWideChar function with
> several different Windows code pages with some success (I no longer lose
> the accented [e acute] or the French [c with the cedilla] char
acters.)
> Does anyone have any ideas I can try to keep from losing the tilde over
> the A and any other diacritic marks in my Latin characters?
> BTW, I can't change the column collations or change them to NVARCHAR.
> Thanks
>

iis connection problem with sql server

Hi all,
I am new to this so please bear with me. I have scoured the ms help pages
and could not find the answer so here goes:
I have a web serverwith iis and a db sql server on separate boxes.
I am trying to use the tool configure sql xml support in iis to connect to
the server.
I tried following the instructions given. However, when I try the connect
option and type in the computer name of the webdev server (which does have
iis installed) I get the following error: 'An error occurred connecting to
'webdev'. This server does not exist or is unavailable.'
I have double-checked to make sure that iis does exist in the webdev server.
there is no iis installed on the sql server box.
What am I doing wrong here?
Please help me out if you can.
Thanks : )
Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )
|||Unless you mean right-clicking the IIS Virtual Directory Manager node in the
tree-pane and clicking Connect, in which case it's looking for an IIS server
to manage (in other words you want to use the Configure SQL XML Support in
IIS tool to create a SQLISAPI application on a remote IIS server). I assume
SQLXML has to be installed on the Web server you're connecting to (and you
might as well download and install SQLXML 3.0, which is the latest version,
rather than use the version that shipped with SQL Server 2000).
If that doesn't resolve it, it could simply be a network name resolution
issue. Can you ping the Web server from the computer where the SQL XML
config tool is installed? Can you manage IIS remotely using the standard IIS
Manager tool?
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Irwin Dolobowsky [MS]" <irwind@.mail.microsoft.com> wrote in message
news:uYMODJx4EHA.2192@.TK2MSFTNGP14.phx.gbl...
Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )

iis connection problem with sql server

Hi all,
I am new to this so please bear with me. I have scoured the ms help pages
and could not find the answer so here goes:
I have a web serverwith iis and a db sql server on separate boxes.
I am trying to use the tool configure sql xml support in iis to connect to
the server.
I tried following the instructions given. However, when I try the connect
option and type in the computer name of the webdev server (which does have
iis installed) I get the following error: 'An error occurred connecting to
'webdev'. This server does not exist or is unavailable.'
I have double-checked to make sure that iis does exist in the webdev server.
there is no iis installed on the sql server box.
What am I doing wrong here?
Please help me out if you can.
Thanks : )Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )|||Unless you mean right-clicking the IIS Virtual Directory Manager node in the
tree-pane and clicking Connect, in which case it's looking for an IIS server
to manage (in other words you want to use the Configure SQL XML Support in
IIS tool to create a SQLISAPI application on a remote IIS server). I assume
SQLXML has to be installed on the Web server you're connecting to (and you
might as well download and install SQLXML 3.0, which is the latest version,
rather than use the version that shipped with SQL Server 2000).
If that doesn't resolve it, it could simply be a network name resolution
issue. Can you ping the Web server from the computer where the SQL XML
config tool is installed? Can you manage IIS remotely using the standard IIS
Manager tool?
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Irwin Dolobowsky [MS]" <irwind@.mail.microsoft.com> wrote in message
news:uYMODJx4EHA.2192@.TK2MSFTNGP14.phx.gbl...
Hi there,
To Clarify, webdev is the name of the Web Server? When you say you try the
"connect option", the connect option in what? Our IIS tool? That is
supposed to connect to the db server.
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://msdn.microsoft.com/xml
This posting is provided "AS IS" with no warranties, and confers no rights.
"mari" <mari@.discussions.microsoft.com> wrote in message
news:9575E87B-56BD-4767-9E70-3237B2124A2A@.microsoft.com...
> Hi all,
> I am new to this so please bear with me. I have scoured the ms help pages
> and could not find the answer so here goes:
> I have a web serverwith iis and a db sql server on separate boxes.
> I am trying to use the tool configure sql xml support in iis to connect to
> the server.
> I tried following the instructions given. However, when I try the connect
> option and type in the computer name of the webdev server (which does have
> iis installed) I get the following error: 'An error occurred connecting to
> 'webdev'. This server does not exist or is unavailable.'
> I have double-checked to make sure that iis does exist in the webdev
> server.
> there is no iis installed on the sql server box.
> What am I doing wrong here?
> Please help me out if you can.
> Thanks : )