problem with domain names

I'm developing a report site that will be accessed by mobile devices (mainly
a Nokia 770 Internet tablet). The site works fine up to the point that the
user selects a report or chart to view, then stops. The problem stems from
the mobile device being unable (for whatever reason) to resolve short server
names; to navigate to the site initially, the user must use a fully
qualified domain name, ie, http://myserver/Reports needs to be addressed as
http://myserver.country.company.com/Reports. This in itself isn't a
problem, but for some unknown reason the report or chart page is called from
http://myserver/Reportserver which the mobile device can't see.
I'm trying to find a way to force a fully qualified domain for the
Reportserver URL, but I can't see where this should be set. Any ideas?
Thanks,
Randall Arnold
Nokia Alliance QAI apologize for double posting; it looked like this post had been cancelled.
Randall
"Randall Arnold" <randall.nospam.arnold@.nospamnokia.com.> wrote in message
news:1157079691.401902@.xnews001...
> I'm developing a report site that will be accessed by mobile devices
> (mainly a Nokia 770 Internet tablet). The site works fine up to the point
> that the user selects a report or chart to view, then stops. The problem
> stems from the mobile device being unable (for whatever reason) to resolve
> short server names; to navigate to the site initially, the user must use a
> fully qualified domain name, ie, http://myserver/Reports needs to be
> addressed as http://myserver.country.company.com/Reports. This in itself
> isn't a problem, but for some unknown reason the report or chart page is
> called from http://myserver/Reportserver which the mobile device can't
> see.
> I'm trying to find a way to force a fully qualified domain for the
> Reportserver URL, but I can't see where this should be set. Any ideas?
> Thanks,
> Randall Arnold
> Nokia Alliance QA
>

Problem with decimal point

I have got txt file and I am trying to import this file into the database. For that action I use SQL Server Import and Export Wizard. I use Locale Czech and CodePage 1250. In the text file is the column in that format: 18152.65 - it is number with decimal point. When I use BCP utility for importing data, I use datatype decimal(10,2) and everything is OK. But when I try to use Import and Export Wizard, I choose for that column datatype numeric (DT_NUMERIC - precision 10, scale 2), the Import doesn't start and occurs the error:

- Executing (Error)

Messages

Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "PRED_CEL " returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

Is it always a precision of 10, and a scale of 2? You may have some inconsistent data. There's two things you could do.

1) Increase the precision and scale.

or

2) Create a custom SSIS package, and redirect the error rows to see where the data inconsistency is. The Import/Export Wizard is great for straight forward tasks, but you'll find that with the smallest blib you'll need to create a custom package.

|||The import is very picky about number formats when importing from flat files. It will NOT import zero padded numbers into a decimal field. Even though it will implicetly convert it internally.

For example:
3.99 - OK
003.99 - FAILS
+003.99 - OK
-003.00 - OK

If you import "003.99" into a varchar(12) and then update a decimal(10,2), with the value of teh varchar, it will work fine.