SQL Anywhere database - DotNetNuke and SQL Anywhere

Author

DotNetNuke and SQL Anywhere

Thomas Auer

2005-07-14, 3:23 am

Hello,

has anybody experience with DotNetNuke ? It seems to be a cool CMS, but uses
MSDE or MS SQLServer. I want to use DNN with Sybase SQL Anywhere 9.
Has anybody any sources for informations ?

Thanks

Thomas

Rick Blythe

2005-07-18, 7:23 am

If I recall correctly, DotNetNuke uses php.

Have a look at:
http://www.ianywhere.com/developer/...php_module.html

The SQL Anywhere PHP module can be used to retrieve data from an Adaptive
Server Anywhere database.

"Thomas Auer" <tauer@kues.de> wrote in message news:42d6181f@forums
-2-dub...
> Hello,
>
> has anybody experience with DotNetNuke ? It seems to be a cool CMS, but
> uses MSDE or MS SQLServer. I want to use DNN with Sybase SQL Anywhere 9.
> Has anybody any sources for informations ?
>
> Thanks
>
> Thomas
>

Greg Fenton

2005-07-18, 9:23 am

Rick Blythe wrote:
> If I recall correctly, DotNetNuke uses php.
>

I think you are thinking of PostNuke (http://www.postnuke.com) or its
parent PHPNuke ( http://phpnuke.org/ )

I had not heard of DNN, but I am going to assume it is one of the
multitude of *Nuke derivates that has been ported to .NET ?
( http://www.dotnetnuke.com/ )

I am going to assume that, like most OSS projects, the database layer is
not a fluid as one would like. Some folks here at iAnywhere have ported
various OSS projects to ASA; sometimes it is straightforward, other
times it is ... uh ... not ;-)

Often the biggest problems with any porting project is that the original
authors focus on one RDBMS and so they end up using features of that one
RDBMS in particular. The good news for anyone going after an
MSSQL-backed project is that ASA does support TSQL.

Let us know what your experiences are. If you hit any stumbling blocks,
post back with particulars.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Rick Blythe

2005-07-18, 11:23 am

duh.

It was a little too early this morning when I replied to this.

OBVIOUSLY, it is .net not php.

Sybase

2005-07-18, 11:23 am

Hello Guys,

I am just going to provide you with the steps that I think will get you
going. I have not tested it yet.

> I am going to assume that, like most OSS projects, the database layer is
> not a fluid as one would like. Some folks here at iAnywhere have ported
> various OSS projects to ASA; sometimes it is straightforward, other times
> it is ... uh ... not ;-)

I have looked at the source code and here is the modification needed to get
this project going with ASA

1- You need to modify the web.config file and modify few lines in there
a) <add key="SiteSqlServer"
value=" ENG=yourASAServer;DB
N=ASADatabaseName;ui
d=dba;pwd=;sql" />

b) <data defaultProvider="ASADataProvider">
<providers>

<clear />

<add name="SqlDataProvider"
type="DotNetNuke.Data.ASADataProvider, DotNetNuke.ASADataProvider"
connectionStringName
="SiteSqlServer" upgradeConnectionStr
ing=""
providerPath=" ~\Providers\DataProv
iders\ASADataProvide
r\" objectQualifier=""
databaseOwner="dbo" />

</providers>

</data>

2- You need to create a new folder called, ASADataProvider, under
... \Providers\DataProvi
ders which is located under the root directory of the
dotnetnuke project

3-Copy the source code from the \Providers\Data\Prov
iders\SqlDataProvide
r to
the new folder you have created ASADataProvider

4- Modify the source code and change SqlDataProvider to ASADataProvider.

5-Modify anything refer to SQL server objects such as SqlConnection. This
should be replaced with ASAConnection Object

6-Modify all the SQL Statements to be compatible with ASA

Tip: You can create the SQL server database and migrate it to ASA.

Good Luck!

Ali Chalhoub

Thomas Auer

2005-07-20, 7:23 am

Yes, it's http://www.dotnetnuke.com/

How do I "Tip: You can create the SQL server database and migrate it to
ASA." ?

"Sybase" <achalhou@sybase.com> schrieb im Newsbeitrag
news:42dbd28f$1@foru
ms-1-dub...
> Hello Guys,
>
> I am just going to provide you with the steps that I think will get you
> going. I have not tested it yet.
>
>
> I have looked at the source code and here is the modification needed to
> get this project going with ASA
>
> 1- You need to modify the web.config file and modify few lines in there
> a) <add key="SiteSqlServer"
> value=" ENG=yourASAServer;DB
N=ASADatabaseName;ui
d=dba;pwd=;sql" />
>
>
> b) <data defaultProvider="ASADataProvider">
> <providers>
>
> <clear />
>
> <add name="SqlDataProvider"
> type="DotNetNuke.Data.ASADataProvider, DotNetNuke.ASADataProvider"
> connectionStringName
="SiteSqlServer" upgradeConnectionStr
ing=""
> providerPath=" ~\Providers\DataProv
iders\ASADataProvide
r\"
> objectQualifier="" databaseOwner="dbo" />
>
> </providers>
>
> </data>
>
> 2- You need to create a new folder called, ASADataProvider, under
> .. \Providers\DataProvi
ders which is located under the root directory of
> the dotnetnuke project
>
> 3-Copy the source code from the \Providers\Data\Prov
iders\SqlDataProvide
r
> to the new folder you have created ASADataProvider
>
> 4- Modify the source code and change SqlDataProvider to ASADataProvider.
>
> 5-Modify anything refer to SQL server objects such as SqlConnection. This
> should be replaced with ASAConnection Object
>
> 6-Modify all the SQL Statements to be compatible with ASA
>
>
>
> Tip: You can create the SQL server database and migrate it to ASA.
>
> Good Luck!
>
> Ali Chalhoub
>
>

Greg Fenton

2005-07-22, 3:23 am

Thomas Auer wrote:
>
> How do I "Tip: You can create the SQL server database and migrate it to
> ASA." ?
>

SQLAnywhere Studio comes with data migration tools. In Sybase Central
you can use the Migrate Database wizard to migrate from another RDBMS to
an ASA database. From DBISQL (or any client connection to an ASA
database) you can use the sa_migrate() stored procedure.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links