[OFBiz] Users - Ms SQl server connection

[Mghibeh]

Please
I want to connect ofbiz to Ms sql server 2k and I have problem with this conniction. could you tell the steps I need to do.

Thanks.

 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Chakraborty, Debanjan [WHQEO]]

Hi,

            You can try out the following steps (I tried it out sometime back, and I am writing this from whatever I can recollect):

1)       Copy the msbase.jar, msutil.jar, and mssqlserver.jar to the <OFBIZ home>/framework/entity/lib directory. You will find the jars in the installation folder of MQ SQL Server (i.e. \MS SQL Server installation path\Lib\Msbase.jar). Basically, you need to locate these files.

2)       In the entityengine.xml (you’ll find this in the \framework\entity\config directory), change the datasource-name for the default delegator to point to the mssql datasource (the details of the mssql datasource in mentioned towards the end of this file itself)

3)       Create a database in MS SQL Server. Ensure that the database name and the user name/pswd that you have mentioned in the entityengine.xml (in the previous step) is the same as the one that you are creating.

4)       Run OFBiz to install all the tables in your database.

I think that should be it. Once you have done that, let me know if I missed out something here.

 

Regards,

Debanjan

 

-----Original Message-----
From: [hidden email] [mailto:[hidden email]]On Behalf Of Mghibeh
Sent: Wednesday, August 10, 2005 9:59 AM
To: [hidden email]
Subject: [OFBiz] Users - Ms SQl server connection

 

Please
I want to connect ofbiz to Ms sql server 2k and I have problem with this conniction. could you tell the steps I need to do.

Thanks.

 

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Debanjan Chakraborty]

Hi,

            You can try out the following steps (I tried it out
sometime back, and I am writing this from whatever I can recollect):

1)       Copy the msbase.jar, msutil.jar, and mssqlserver.jar to the
<OFBIZ home>/framework/entity/lib directory. You will find the jars in
the installation folder of MQ SQL Server (i.e. \MS SQL Server
installation path\Lib\Msbase.jar). Basically, you need to locate these
files.

2)       In the entityengine.xml (you'll find this in the
\framework\entity\config directory), change the datasource-name for
the default delegator to point to the mssql datasource (the details of
the mssql datasource in mentioned towards the end of this file itself)

3)       Create a database in MS SQL Server. Ensure that the database
name and the user name/pswd that you have mentioned in the
entityengine.xml (in the previous step) is the same as the one that
you are creating.

4)       Run OFBiz to install all the tables in your database.

I think that should be it. Once you have done that, let me know if I
missed out something here.

 

Regards,

Debanjan

 



On 8/10/05, Mghibeh <[hidden email]> wrote:

> Please
> I want to connect ofbiz to Ms sql server 2k and I have problem with this
> conniction. could you tell the steps I need to do.
> Thanks.
>
>  
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users