Install Problem...Please Help!

A third party application is trying to install MSDE 2000 on our XP Professional machine. Install gets to about "2 seconds remaining" then backs out and simply quits. No error messages. Saw a similar post on here but it was never resolved. I've made sure t
he Server service is running and that File and Print Sharing for Microsoft Networks is installed and enabled. Any help would be greatly appreciated...this is a very important application we are trying to install. Thanks.
Floyd
Thanks for the reply. The application never installs so there is no .ini file...not that I would know what to change in it if it was there. Why won't this stupid thing just install? This is driving me batty!
"sthomas" wrote:

> hi :
> Check the .ini file if you have any that is coming with
> the application and do modifications if it is required
>
> on our XP Professional machine. Install gets to about "2
> seconds remaining" then backs out and simply quits. No
> error messages. Saw a similar post on here but it was
> never resolved. I've made sure the Server service is
> running and that File and Print Sharing for Microsoft
> Networks is installed and enabled. Any help would be
> greatly appreciated...this is a very important
> application we are trying to install. Thanks.
>

Installation and Manage MSDE

We have an application running on SQL-Server and now we want to have another
verison for MSDE. But I could not install it successfully. According to
some articles I know that there would have problem to install MSDE on
Chinese Version (Hongkong) Windows XP. Could someone help to tell me any
solution for this issue.
And, can I use the Enterprises manager to manage the MSDE? And how can I
know any MSDE is running on the PC?
Many Thanks!!!!!
hi,
"BBC1009" <bevis168@.yahoo.com.hk> ha scritto nel messaggio
news:%235n7vqu7EHA.3836@.tk2msftngp13.phx.gbl
> We have an application running on SQL-Server and now we want to have
> another verison for MSDE. But I could not install it successfully.
> According to some articles I know that there would have problem to
> install MSDE on Chinese Version (Hongkong) Windows XP. Could someone
> help to tell me any solution for this issue.
try changing your Windows collation before installing MSDE to one of the
"supported" SQL Server Windows collations

> And, can I use the Enterprises manager to manage the MSDE? And how
> can I know any MSDE is running on the PC?
>
you are not allowed to use Enterprise Manager, Query Analyzer and so on, on
MSDE solutions... you have to rely on home built tools or third party
solutions... please have a look at
http://www.microsoft.com/sql/msde/partners/default.asp ,
http://www.aspfaq.com/show.asp?id=2442 for some of them, both free and
commercial... google for further..
in order to know if you are connected to MSDE instances, you can query for
SET NOCOUNT ON
SELECT SERVERPROPERTY( 'Edition' ) AS [Edition]
which returns, for MSDE,
Edition
Desktop Engine
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Install Components for my OLAP Application on client machine (OWC11, msolap9.0, MSXML 6) - for a

Hi,

i have a problem by installing my application by a customer,

i think some rights should be given for a normal user before he can use my application.

But I don't know where to search:

Where I can look what happens on installing this components:

OWC11, msolap9.0, msxml6 ?

Are there some registry entries written, or are there created some directories?

Is there somewhere a referrence where I can find answers on this questions?

My problem:

Customer has no rights for installing this components,

so i logged on his computer as admin and installed all.

But if I log in later as a normal user, my application doesnt work.

Thank you in advanced for the answers,

Mastroyani

You got to separate installation problems from connectivity or other problems.

To install, many applications require admin rights on the machine. If user running setup is not local machine administrator setup will most likely fail. That what you have seen with your customer.

Once your application is installed, you got to take a look at user permissions.

If you are saying that running as administrator you can run your application and connect to Analysis Server then most likely application has been installed correctly. You need to take a look at what permission your user has to access Anlysis Services.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Install Components for my OLAP Application on client machine (OWC11, msolap9.0, MSXML 6) - for a

Hi,

i have a problem by installing my application by a customer,

i think some rights should be given for a normal user before he can use my application.

But I don't know where to search:

Where I can look what happens on installing this components:

OWC11, msolap9.0, msxml6 ?

Are there some registry entries written, or are there created some directories?

Is there somewhere a referrence where I can find answers on this questions?

My problem:

Customer has no rights for installing this components,

so i logged on his computer as admin and installed all.

But if I log in later as a normal user, my application doesnt work.

Thank you in advanced for the answers,

Mastroyani

You got to separate installation problems from connectivity or other problems.

To install, many applications require admin rights on the machine. If user running setup is not local machine administrator setup will most likely fail. That what you have seen with your customer.

Once your application is installed, you got to take a look at user permissions.

If you are saying that running as administrator you can run your application and connect to Analysis Server then most likely application has been installed correctly. You need to take a look at what permission your user has to access Anlysis Services.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Inserts not committing

A user entered 20 debit memos thru the application. For each db memo, 1 - th
e
data is inserted into two SQL Server 2000 tables, 2- a commit is issued
(Begin Trans / Commit Trans), 3 - a Select is used to retrieve data to
display on the db memo thru Crystal Reports and is printed. For each of the
20 entered, a db memo was printed but when the application closed, only data
for the first four db memos was saved / committed in the database. The other
16 had not been saved / committed in the database. We know the data for the
16 were inserted or else the Select would not have retrieved the data to
display and print the DB memo. There were no error messages and the
application did not crash. This happened only three times in 18 months and w
e
cannot duplicate the error. The commits are all processed in the same VB for
m
flow code. Anyone ever have a similar issue? Anyone have an idea on what
might have occurred? Thanx.Are you printing inside the transaction?
AMB
"Inserts not committing" wrote:

> A user entered 20 debit memos thru the application. For each db memo, 1 -
the
> data is inserted into two SQL Server 2000 tables, 2- a commit is issued
> (Begin Trans / Commit Trans), 3 - a Select is used to retrieve data to
> display on the db memo thru Crystal Reports and is printed. For each of th
e
> 20 entered, a db memo was printed but when the application closed, only da
ta
> for the first four db memos was saved / committed in the database. The oth
er
> 16 had not been saved / committed in the database. We know the data for th
e
> 16 were inserted or else the Select would not have retrieved the data to
> display and print the DB memo. There were no error messages and the
> application did not crash. This happened only three times in 18 months and
we
> cannot duplicate the error. The commits are all processed in the same VB f
orm
> flow code. Anyone ever have a similar issue? Anyone have an idea on what
> might have occurred? Thanx.

Inserts and updated sqlserver

Hi
I have a multithreaded application. VC6++, VB6 and OLEDB. Every thread
has its own session to the database.
If I do all the inserts and do updates in one thread it works fine.
All my data is in the database.
If I split the work to be done on more than one thread it shows in the
SQL Profiler the it does the inserts and updates, but when I look in
the database not all the data was added. There were no errors logged.
Does anyone have an idea what could cause this?
Thanks
GertGert wrote:
> Hi
> I have a multithreaded application. VC6++, VB6 and OLEDB. Every thread
> has its own session to the database.
> If I do all the inserts and do updates in one thread it works fine.
> All my data is in the database.
> If I split the work to be done on more than one thread it shows in the
> SQL Profiler the it does the inserts and updates, but when I look in
> the database not all the data was added. There were no errors logged.
Do you insert the data in the transaction? Maybe you do not call COMMIT at
the end of it and the transaction is rolled back after the timeout.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Inserts and updated sqlserver

Hi
I have a multithreaded application. VC6++, VB6 and OLEDB. Every thread
has its own session to the database.
If I do all the inserts and do updates in one thread it works fine.
All my data is in the database.
If I split the work to be done on more than one thread it shows in the
SQL Profiler the it does the inserts and updates, but when I look in
the database not all the data was added. There were no errors logged.
Does anyone have an idea what could cause this?
Thanks
GertGert wrote:

> Hi
> I have a multithreaded application. VC6++, VB6 and OLEDB. Every thread
> has its own session to the database.
> If I do all the inserts and do updates in one thread it works fine.
> All my data is in the database.
> If I split the work to be done on more than one thread it shows in the
> SQL Profiler the it does the inserts and updates, but when I look in
> the database not all the data was added. There were no errors logged.
Do you insert the data in the transaction? Maybe you do not call COMMIT at
the end of it and the transaction is rolled back after the timeout.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

inserting the date into SQL Server problem

Im having problems inserting the current date into SQL server from my ASP.net application.

The error that asp.net throws is:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. "

In my page, im setting the date as follows:

Dim strDate as Date

strDate = now()

Then in my page I call a function called "do_store"

This works fin putting my variables into my database until I tried adding the date to the statement. Here is my function. Can anyone see my problem?

Public Function do_store(ByVal strTestID As String, ByVal strUserName As String, ByVal strUserID As String, ByVal strWrong As String, ByVal strRight As String, ByVal strAnswers As String, ByVal strDate As Date)
Dim strSQL As String
Dim sConn As String
Dim oConn As SqlConnection
'do the insert into the database
strSQL = "insert into test_results (test_plan_id, user_name, user_id, questions_wrong, questions_right, questions_answered, date_time) values (" & strTestID & ", '" & strUserName & "', " & strUserID & ", " & strWrong & ", " & strRight & ", " & strAnswers & ", '" & strDate & "')"
sConn = ConfigurationSettings.AppSettings("ConnectionString")
oConn = New SqlConnection(sConn)
Dim myCommand As SqlCommand

myCommand = New SqlCommand(strSQL, oConn)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
End Function::Im having problems inserting the current date into SQL server from my ASP.net
::application.
::
::The error that asp.net throws is:
::
::"The conversion of a char data type to a datetime data type resulted in an out-of-range
::datetime value. The statement has been terminated. "

* Your datetime formates between the server and your process dont match.

Means: your server expects (for example) YMD, and you deliver YDM. Result: the date gets interpreted as month, and this can result in you "entering" month values from 13-31, which ARE out of range.

You need to make sure that the string you create actually is what the SQL Server expects.

BTW - if this is for a website, your code is insecure and very sucesseptable to a SQL INJECTION ATTACK.

Please read up the fundamental basics of SQL security - do it now.|||How do I check what format SQL Server wants?
how can I format the date so it fits into SQL server?
I got it all running locally (SQL Server and VS.NET) so Presumed their locale setting would be the same.
Im only building this as an intranet so its not open to the big bad world.|||This is explained in the SQL Server oducmentaiton. Actually you should not care - you should ALAWYS insert datetimes as ISO form, country independant. The correct way to insert this is:

return String.Format ("'{0:yyyy-MM-dd HH:mm:ss}'", Value);

At least this is what our EntityBroker O/R mapping framework uses, and it works so far.

The documentation of SQL Server has more information on this.

inserting null values into smalldatetime

hi
how can we insert null into a small datetime field (from client application VB)Insert into table values (null);|||Originally posted by r123456
Insert into table values (null); that only works if the field in question happens to be the only field in the table ;)

insert into thetable (foo, bar, datetimefld, qux, fap)
values ( 21, 'fred', null, 42, 'okay')