订单凤飞飞

If you get Build 1653, you will get the SqlProvider. Some quick steps to use it

Run the SqlStoreManagerGui executable to create the Sql Database. (You have to download the Tools-release too when you want to use this option)
Run the SqlProviderUnitTests (optional)
Launch the web site http://<yourserver>/default.aspx
Go to the http://<yourserver>/Admin/Default.aspx Page and create a new SqlProvider namespace
Begin using the new namespace.

I will be posting more notes in the upcoming days. Maybe. Or Not. Who knows???

Note

You will get fast and better answers to your questions if you post them on the FlexWikiUsersMailingList than if you post them here.

Note:

You may need to modify the CreateFlexWikiDatabase.sql script in SqlStoreManagerLib\Scripts before building the SqlStoreManagerLib and SqlStoreManagerGui when using SQL Server 2005. I had to modify the script to make the initial database 3MB instead of 1MB because the model database for my SQL Server 2005 requires that size.

Change:

CREATE DATABASE [${database}] ON (NAME = N'${database}Data', FILENAME = N'${datadir}\${database}.mdf' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'${database}Log', FILENAME = N'${datadir}\${database}_log.ldf' , FILEGROWTH = 10%)

to:

CREATE DATABASE [${database}] ON (NAME = N'${database}Data', FILENAME = N'${datadir}\${database}.mdf' , SIZE = 3, FILEGROWTH = 10%) LOG ON (NAME = N'${database}Log', FILENAME = N'${datadir}\${database}_log.ldf' , FILEGROWTH = 10%)

-- JeremyWiebe 2006.10.27

Question

My SQL Server is a remote box (IP ends in .158; my webserver's IP ends in .159); the webserver does NOT have Enterprise Manager; how can I create the table(s) needed? SQLStoreManagerGUI isn't connecting to my remote SQL Server -- how can I feed it a connection string?

Question

I am not able to run SQLProviderUnitTests mentioned above. Is this the dll that comes with the Tools package? Or I am missing something?

Answer

It's part of the source distribution, so you'd have to build it yourself. You don't really need to do this step - it tests that the code is working, but we test every build anyway. -- CraigAndera 2005.02.26

Question

Where do i get the SqlStoreDatabaseCreationTool from. <Yannick - 4/02/05>

Answer

The SqlStoreDatabaseCreationTool can be found in the Tools Release download at http://builds.flexwiki.com/FlexWikiCore -- DerekLakin [9-Feb-2005]

Answer

The SqlStoreDatabaseCreationTool can be found also at http://sourceforge.net/projects/flexwiki/ -- LMurillo [13-Dec-2006]

Question

It would be nice to know how to get a particular build, or if there was an updated build on the SF site. <Jhulten - 8/02/05>

Answer

Individual builds are available at http://builds.flexwiki.com/FlexWikiCore . There is a link on each build page that allows you to download the source, full release or upgrade release -- DerekLakin [9-Feb-2005]

Answer

We intentionally don't release every build, because we build every time we check in (this is called ContinuousIntegration), and as a result not all the builds are stable. Periodically, we release a stable build on SourceForge. These are the builds we encourage people to use. -- CraigAndera 2005.02.10

Question

Would be nice to try but the builds asdasdfasdf seems to be forever inaccessible.

Question

Can you please fix the builds link? I'd love to download this wiki <SAnderson - Feb.24.05>

Question

Dittoes on the DNS for builds.flexwiki.com. Ping gives destination net unreachable and reverse DNS isn't resolving <JSlicer - Feb.24.05>

Answer

Both machines (www and builds) were being moved to a new network yesterday. DNS propagation takes a while, but they should both be available now. -- CraigAndera 2005.02.25

Question

Dude, the SqlStoreDatabaseCreationTool was NOT in the tools release. Could you please let us know where it really is? -Erick 2005.3.2

Answer

As noted on the SqlStoreDatabaseCreationTool page, the tool was renamed to SqlStoreManagerGui. It is in the tools download. -- CraigAndera 2005.03.02

Question

Dude, the SqlStoreManagerGui is NOT in the tools release either. -Erick 2005.3.3

Answer

Yes, it is. You are presumably looking at an old build. Read this page and related pages. -- CraigAndera 2005.03.03

Question

When will the next release build supporting SQLProvider (and hopefully MySQL) be released? Which one do you think is close to stable in the interim? TIA -- Andrea 2005.03.03

Answer

When - can't say. It's a spare time project for everyone involved. Pitch in for the best results! As for which build, I can't make a specific recommendation. I don't know of any huge issues with the most current one (1673). -- CraigAndera 2005.03.03

Question

I think you require C#. I do VB (3-6, script, vba, VB.Net). Maybe if there were VB parts, you could split the workload. -- Andrea 2005.03.04

Answer

In theory, new projects could be written in VB.NET. However, since VS.NET doesn't support multiple languages within a single project, and since all FlexWikiProjects are currently written in C#, we have a defacto C# requirement. That said, there are translators out on the web that will change from C# to VB.NET and back again. And even without these, learning one if you know the other is trivial. I hope you'll consider contributing. -- CraigAndera 2005.03.05

Answer

You could use Web User Controls to allow other languages. Maybe if someone could provide a good, free converter I would take a stab at it. I can read some C however it is the nuances that would bug me. -- Andrea 2005.03.05

Question

Why is the formatting for Questions and Answers inconsistent in FireFox? Perhaps I should look at the source code

-- Andrea 2005.03.05

Answer

So far, the weird thing is that hitting the page on the site has a few items formatted wrong. When I save the page to my drive and open it up it looks good. -- Andrea 2005.03.05

Answer

DerekLakin and I chased some of these problems down and isolated them to some code he wrote. I'm not sure where he is with fixing them. -- CraigAndera 2005.03.09

Question

I created the database for the sql store (FlexWikiSqlStore). Is there a web.config setting to get the new namespaces to be saved in sql rather than in the Namespace map folder?

Answer

Yes, you'll need to set up your Namespaces.xml file to use SQL rather than the filesystem. I believe that you can do this via the administrative interface (http://yourserver/yourwiki/admin) but I haven't really set one up myself yet. -- CraigAndera 2005.03.09

Question

What determines the SQL Server User Name? Is it by default IUSR_xxxx? -- Chris Wuestefeld 2005.03.10

Answer

The connection string in the namespace parameters (Namespace.xml, or using the /admin pages).

Question

I am very close to setup a flexwiki on a SQL only host. My ISP does not allow write access to any folder. And I have to remove all the EventLog and Performance Counter code. So far so good. I could see the initial page, but I would not setup a valid SQL Provider name space in the XML, becasue \admin\default.aspx does not have write access. Can someone give me a valid XML sample? -- VincentYang

Answer

NamespaceMapSampleForSQLProvider -- BruceHaley

Question

How can I migrate from file system provider to SQL provider? -- TimothyTan

Question

I found sqlprovider problem. When I edit too long text in wiki editor, the utf8 word can't insert correctly, always show ????. This may cause from the parameters[2] = new SqlParameter("@body",body );

Comment

When updating the NamespaceProviders in the administrative interface, the Web UI will update the NamespaceMap.xml file before it validates the connection info, which may leave you with one or more bogus entries in that file if you make any mistakes.

Question

Which tables hold all the body data, ie the _normalborders information, I can see some tables but I cant find any topic data, only tables i can find is namespace and topic - Cheers

Question

I want to migrate from filesystemstore to sql store. I tried admin page but that page's code are all commented out, so I got exception: throw new NotImplementedException("Change later when implementing admin portion of website."); How to get updated version of source code?

Question

Note to all... As noted by the last person, the method SqlProvider.LoadNamespaces() isn't implemented in 2.0 Beta 1 (2.0.0.41). -VH 6/26/2007