MS SQL Server vs.IBM Universe

Not sure if I am posting this in the right area. I have been assigned as a project leader for a new software project that will control all aspects of our business. I am mildly familiar with databases and how they work. We are a internet based retailer with 25 million $ in annual sales with the anticipation of growing that number 4 fold within 5 years. Our website is currently run on a SQL database. The two platforms we are considering include a custom application that is built on SQL. The other option is a product that is used in fields similiar to ours but the company has limited experience in creating a application to coexist with our Web data. This product will be tailored to fit our needs. My real question is how does Universe compare to SQL. Is there anything I should be concerned with eitheir database? Thank you for your input as this issue has divided the ranks on this project.Don't know much about UniVerse.

As with most established relational databases they can cope with most requirements if designed and implemented properly. The most important feature is the experience of the team.

There is a lot to be said for sticking to a single platform as this does not dilute the expertise - and means that you don't need to hire two sets of experienced staff.

Anyone who has spent several years dedicated to implementation on a single platform is likely to be more competent than someone who claims equal expertise in several as long as they have had exposure to several systems and environments.

MS SQL Issues

Hi there I am hoping for some direction in posting this. We have a web
appication that is running on ASP>NET framework with IIS that will
access a 2 gig sql data base. The issue here that we can not get the
application to connect with SQL at all. Here are the errors we are
getting

Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.

Source Error:

Line 121: da = New SqlDataAdapter(SQL, m_ConnectionString)
Line 122: da.SelectCommand.CommandTimeout = 30
Line 123: da.Fill(ds)
Line 124:
Line 125: If ds.Tables(0).Rows.Count > 0 Then

I have double checked the services and everything seems fine we have
uninstalled and reinstalled SQL and we have tried different users and
passwords including the System Accounts. No luck here is what happens
further down the page

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection
connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
DataRoster.User.GetUser(String UserName, String pwd) in
c:\dataroster\User.vb:123
DataRoster.frmLogin.btnGo_Click(Object sender, EventArgs e) in
c:\dataroster\default.aspx.vb:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1277

We have evrything running on one server so named pipes aren't the
issue because we have the the application looking towards the loopback
adpter, so I take that the SQL Server (2000) and the application are
not even trying to talk. We have double and triple checked the ports.
We have applied SP3 to SQL and uopdated the MDAC to 2.8. any
suggestion would be greatly appreciated.
Thank You
TomTom (tom_ruiz@.hotmail.com) writes:
> Hi there I am hoping for some direction in posting this. We have a web
> appication that is running on ASP>NET framework with IIS that will
> access a 2 gig sql data base. The issue here that we can not get the
> application to connect with SQL at all. Here are the errors we are
> getting
> Exception Details: System.Data.SqlClient.SqlException: SQL Server does
> not exist or access denied.
> Source Error:
>
> Line 121: da = New SqlDataAdapter(SQL, m_ConnectionString)

So what does the connection string looks like?

Can you connect to the server from Query Analyzer?

If you look in the Client Network Utility and the Server Network
Utitilty, what do you see? Is Shared Memory check in the Client
Network Utility?

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp