Clarification on ALT Snapshot Folder Location

I have 2 sql boxes setup in a VM environment, with neither of them knowing each other (No Trusted Domains)
Here's what I have accomplished:
I was able to put the entry in the Hosts file for each
Put an Alias for each box in Client Network Utility
Setup the Publication - allowing anonymous pull subscribers
Setup the anonymous pull subscription
NOTE: I set the publisher snapshot location as follows;\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B _test_test\unc\SQL2000B_test_test\20051208181044
Then I copied this folder to the Subscriber & setup the alt. snapshot location with the same path
\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B_test_te st\unc\SQL2000B_test_test\20051208181044
I even tried to put the Subscriber path to point to the local folder location (Where I copied the Snapshot files to) c:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL2 000B_test_test\20051208181044
But I continue to get an error message stating:
The process could not read file 'C:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL 2000B_test_test\20051208181044\testtbl_1.sch' due to OS error 3. The step failed.
I am so missing something when trying to setup anonymous pull subscription replication....
Made changes in the mean time...
I needed to Share the folders & give everyone rights (What is the minimum security I need to give everyone when I try & do this exact same setup when using the Internet?)
Publisher Alt Snapshot Folder = \\SQL2000B\C$\REPLDATA
Subscriber = C:\REPLDATA
I copied the folder from Publisher to Subscriber, changed subscription Alt Snapshot folder as described above & VIOLA! It finally works...
Man, I really, really hope this works when I try & set this up the same way from the DMZ (Internet) to the domain.
Any suggestions on that folder permission? Not being a network person, but recalling giving Everyone Full Control may be a bad thing (But it's just this replication folder, so in reality how bad can that really be?)
Thanx for putting up with my gazillion posts!!!!
Jude
"JLS" <jlshoop@.hotmail.com> wrote in message news:uYigLPO$FHA.3804@.TK2MSFTNGP14.phx.gbl...
I have 2 sql boxes setup in a VM environment, with neither of them knowing each other (No Trusted Domains)
Here's what I have accomplished:
I was able to put the entry in the Hosts file for each
Put an Alias for each box in Client Network Utility
Setup the Publication - allowing anonymous pull subscribers
Setup the anonymous pull subscription
NOTE: I set the publisher snapshot location as follows;\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B _test_test\unc\SQL2000B_test_test\20051208181044
Then I copied this folder to the Subscriber & setup the alt. snapshot location with the same path
\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B_test_te st\unc\SQL2000B_test_test\20051208181044
I even tried to put the Subscriber path to point to the local folder location (Where I copied the Snapshot files to) c:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL2 000B_test_test\20051208181044
But I continue to get an error message stating:
The process could not read file 'C:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL 2000B_test_test\20051208181044\testtbl_1.sch' due to OS error 3. The step failed.
I am so missing something when trying to setup anonymous pull subscription replication....
|||Its read and list files and folders.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message
news:ub7HLgO$FHA.1288@.TK2MSFTNGP09.phx.gbl...
Made changes in the mean time...
I needed to Share the folders & give everyone rights (What is the minimum
security I need to give everyone when I try & do this exact same setup when
using the Internet?)
Publisher Alt Snapshot Folder = \\SQL2000B\C$\REPLDATA
Subscriber = C:\REPLDATA
I copied the folder from Publisher to Subscriber, changed subscription Alt
Snapshot folder as described above & VIOLA! It finally works...
Man, I really, really hope this works when I try & set this up the same way
from the DMZ (Internet) to the domain.
Any suggestions on that folder permission? Not being a network person, but
recalling giving Everyone Full Control may be a bad thing (But it's just
this replication folder, so in reality how bad can that really be?)
Thanx for putting up with my gazillion posts!!!!
Jude
"JLS" <jlshoop@.hotmail.com> wrote in message
news:uYigLPO$FHA.3804@.TK2MSFTNGP14.phx.gbl...
I have 2 sql boxes setup in a VM environment, with neither of them knowing
each other (No Trusted Domains)
Here's what I have accomplished:
I was able to put the entry in the Hosts file for each
Put an Alias for each box in Client Network Utility
Setup the Publication - allowing anonymous pull subscribers
Setup the anonymous pull subscription
NOTE: I set the publisher snapshot location as
follows;\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B _test_test\unc\SQL2000B_test_test\20051208181044
Then I copied this folder to the Subscriber & setup the alt. snapshot
location with the same path
\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B_test_te st\unc\SQL2000B_test_test\20051208181044
I even tried to put the Subscriber path to point to the local folder
location (Where I copied the Snapshot files to)
c:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL2 000B_test_test\20051208181044
But I continue to get an error message stating:
The process could not read file
'C:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL 2000B_test_test\20051208181044\testtbl_1.sch'
due to OS error 3. The step failed.
I am so missing something when trying to setup anonymous pull subscription
replication....
|||THANX!
Jude
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message news:uGIyPwO$FHA.1288@.TK2MSFTNGP09.phx.gbl...
Its read and list files and folders.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JLS" <jlshoop@.hotmail.com> wrote in message
news:ub7HLgO$FHA.1288@.TK2MSFTNGP09.phx.gbl...
Made changes in the mean time...
I needed to Share the folders & give everyone rights (What is the minimum
security I need to give everyone when I try & do this exact same setup when
using the Internet?)
Publisher Alt Snapshot Folder = \\SQL2000B\C$\REPLDATA
Subscriber = C:\REPLDATA
I copied the folder from Publisher to Subscriber, changed subscription Alt
Snapshot folder as described above & VIOLA! It finally works...
Man, I really, really hope this works when I try & set this up the same way
from the DMZ (Internet) to the domain.
Any suggestions on that folder permission? Not being a network person, but
recalling giving Everyone Full Control may be a bad thing (But it's just
this replication folder, so in reality how bad can that really be?)
Thanx for putting up with my gazillion posts!!!!
Jude
"JLS" <jlshoop@.hotmail.com> wrote in message
news:uYigLPO$FHA.3804@.TK2MSFTNGP14.phx.gbl...
I have 2 sql boxes setup in a VM environment, with neither of them knowing
each other (No Trusted Domains)
Here's what I have accomplished:
I was able to put the entry in the Hosts file for each
Put an Alias for each box in Client Network Utility
Setup the Publication - allowing anonymous pull subscribers
Setup the anonymous pull subscription
NOTE: I set the publisher snapshot location as
follows;\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B _test_test\unc\SQL2000B_test_test\20051208181044
Then I copied this folder to the Subscriber & setup the alt. snapshot
location with the same path
\\Sql2000b\c$\Inetpub\wwwroot\unc\SQL2000B_test_te st\unc\SQL2000B_test_test\20051208181044
I even tried to put the Subscriber path to point to the local folder
location (Where I copied the Snapshot files to)
c:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL2 000B_test_test\20051208181044
But I continue to get an error message stating:
The process could not read file
'C:\Inetpub\wwwroot\unc\SQL2000B_test_test\unc\SQL 2000B_test_test\20051208181044\testtbl_1.sch'
due to OS error 3. The step failed.
I am so missing something when trying to setup anonymous pull subscription
replication....

Chinese characters doesn't print correctly

I develop my report in VS2005 and it print out with the Chinese characters
but when I deployed it to reporting service and print it I get boxes that
replaced the Chinese characters. The Chinese character is held in text boxes
in the report that are not queried from the database. The Chinese characters
are static headers.
--
Thank you,
The DiepHi Diep,
Since you were using a static report without querying from your database,
could you please send your report to me (changliw_at_microsoft_dot_com) for
further research?
Currently I performed a simple test with a TextBox header which was filled
with Chinese characters. After I deploy it to my report server, it worked
fine. The Chinese characters were displayed without any problem.
Look forward to your response. I am very glad to work with you for further
research.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||After I installed the Report Viewer 2005 service pack 1 and reboot my server
the report printed Chinese characters fine. Thank you.
--
Thank you,
The Diep
"Charles Wang[MSFT]" wrote:
> Hi Diep,
> Since you were using a static report without querying from your database,
> could you please send your report to me (changliw_at_microsoft_dot_com) for
> further research?
> Currently I performed a simple test with a TextBox header which was filled
> with Chinese characters. After I deploy it to my report server, it worked
> fine. The Chinese characters were displayed without any problem.
> Look forward to your response. I am very glad to work with you for further
> research.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Diep,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi
I have the same problem: the legend of a chart displays boxes instead of
chinese characters.
I've installed the Report Viewer 2005 service pack 1 on my local pc and it
works fine. But when I've installed the service pack on the server, in the
report the chinese characters are still replaced with boxes! Where is the
problem?
The OS on the pc used for development is Windows 2000 service pack 4; the
server OS is Windows Server 2003 standard edition service pack 1.
Thank you
Renato|||I have it working on my server 2003. I installed the service pack 1 from
here http://support.microsoft.com/kb/933137 then I installed some chinese
true font on my server as well. The chinese characters still didn't display
correctly until I rebooted my system.
--
Thank you,
The Diep
"Renato" wrote:
> Hi
> I have the same problem: the legend of a chart displays boxes instead of
> chinese characters.
> I've installed the Report Viewer 2005 service pack 1 on my local pc and it
> works fine. But when I've installed the service pack on the server, in the
> report the chinese characters are still replaced with boxes! Where is the
> problem?
> The OS on the pc used for development is Windows 2000 service pack 4; the
> server OS is Windows Server 2003 standard edition service pack 1.
> Thank you
> Renato
>|||Hi Renato,
If you are a MSDN Managed Newsgroup user, could you please have a new post
so that we can assist you more dedicatedly?
Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
=========================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

checkboxlist sql database

I have a form with text boxes and checkboxlists that a user will fill out and click submit. When the user clicks submit, it will update the sql database. In my sql database I have checkbox fields. My question is how can I use the selected items in a checkboxlist to update the sql database individual check boxes. Below is the code I have so far that works for a text box:

PartialClass windrockform

Inherits System.Web.UI.Page

ProtectedSub submitButton_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles submitButton.Click

Dim dashdatasourceAsNew SqlDataSource

dashdatasource.ConnectionString = ConfigurationManager.ConnectionStrings("WindrockIssuesConnectionString").ToString

dashdatasource.InsertCommandType = SqlDataSourceCommandType.Text

dashdatasource.InsertCommand ="INSERT INTO IssueLog (initiator) VALUES (@.initiator)"

dashdatasource.InsertParameters.Add("initiator", initiatorTextBox.Text)

Dim rowsAffectedAsInteger = 0

Try

rowsAffected = dashdatasource.Insert()

Catch exAs Exception

Server.Transfer("problem.aspx")

EndTry

If rowsAffected <> 1Then

Server.Transfer("problem.aspx")

Else

Server.Transfer("confirm.aspx")

EndIf

EndSub

EndClass

I am new to asp.net and would appreciate the help.

Thanks,

I believe the key you are looking for is

CheckBox11.Checked =False

|||

What are checkbox datatypes in SQL server? Maybe you mean they are of BIT datatype?

I think you will probably have to loop through your checkbox list and check each box to see if its checked, and set a parameter accordingly.

|||

Hi nkair19 ,

When the user clicks submit, it will update the sql database. In my sql database I have checkbox fields. My question is how can I use the selected items in a checkboxlist to update the sql database individual check boxes

I think maybe you mean you want to update certain data fields in your sql server database based on selected values in your checkboxlist. If I've understood you wrong, please feel free to tell me, thanks.

I think you can use an arraylist as a bridge between your checkboxlist and database filed. Like this:

ArrayList list=new ArrayList();

for (int i=0; i<checkboxlist1.Items.Count; i++)
{

if (checkboxlist1.Items[i].Selected)
{

list.add("the value you want to assign to the database field when checkbox item checked");
}

else

list.add("the value you want to assign to the database field when checkbox item not checked");
}

After this,in your sqlcommand text, you can refer to the corresponding arraylist value directly.

Hope my suggestion helps

|||

Did I forget to mention that I am using vb, not C#?

|||

I have this so far:

Dim listAsNew ArrayList()

3:

4:Dim iAsInteger = 0

5:While i < pacheckboxlist.Items.Count

6:

7:If pacheckboxlist.Items(i).SelectedThen

8:

9: list.Add("win6310_pa--is this where I add the check box name that I have in the SQL database?")

10:Else

11: list.Add("the value you want to assign to the database field when checkbox item not checked--I don't want anything to happen if nothing is checked because I have other checkboxlist groups to choose from")

12:

13:

14:EndIf

15: System.Math.Max(System.Threading.Interlocked.Increment(i), i - 1)

16:EndWhile

After this,in your sqlcommand text, you can refer to the corresponding arraylist value directly. --confused here.

Thanks.