Re: Error when install sql server sp4 - Database Discussion Boards

7mam30-Nov-05 4:39

30-Nov-05 4:39

hello all i have a problem and want to ask for solution
which is
i have make a webservice and i have connect the database with it and i have try it and its working but on THE LOCAL HOST , the problem that i reserve a domian its free ar somee.com and i dont know how to make the datasoure of the connections on that server i.e domain so any body help me please.
thanx

tedy

Re: web services

Farhan Noor Qureshi30-Nov-05 9:14

Farhan Noor Qureshi

30-Nov-05 9:14

Read their support docs at http://somee.com/Support.aspx[^]. There is section dedicated to database related FAQs.

Farhan Noor Qureshi

^{if (this == this) thow this;}

Hyperlink Column in SQL Server

R. A. Abbasi29-Nov-05 19:17

R. A. Abbasi

29-Nov-05 19:17

I need to include a column in an SQL Server table, which can hyperlink to some text stored somewhere inside or outside the same database.
Please help.

-- modified at 1:18 Wednesday 30th November, 2005

Re: Hyperlink Column in SQL Server

Mekong River1-Dec-05 14:04

Mekong River

1-Dec-05 14:04

R. A. Abbasi wrote:
I need to include a column in an SQL Server table, which can hyperlink to some text stored somewhere inside or outside the same database.

In case of the text store in the database you should scan through the table and search for the text that you need by using SELECT statement. Check here for the SELECT statment information.[^]

In case of the text outside the database you should know the file path. The field that you are create must store the file path and point to the specific file that you need to open it. Check here for the information about read and write to text file.[^]

Comparing only Time in Sql?

majidbhutta29-Nov-05 18:41

majidbhutta

29-Nov-05 18:41

Comparing only Time in Sql?
Hi Dears!
I have two Different DateTime Values i want to Compare only their times independent of Dates How to do it?
let
DateTime @dt1='2004-10-30 19:30:00.917'
DateTime @dt2='2005-11-29 15:00:00.917'
accordint to my requirements
@dt1>=@dt2 should be true as 19:30>=15:00
because i have to compare only the time not the Date how to achieve this in sql .Function required.

Re: Comparing only Time in Sql?

Michael Potter30-Nov-05 3:46

Michael Potter

30-Nov-05 3:46

You can change your times to milliseconds since midnight and compare those.

CREATE FUNCTION MillisecondsSinceMidnight
(
    @in DATETIME
)
RETURNS INTEGER
AS
BEGIN
    DECLARE @retval INTEGER
	
    SET @retval =
            DATEPART(ms,@in) +
            DATEPART(ss,@in) * 1000 +
            DATEPART(mi,@in) * 60000 +
            DATEPART(hh,@in) * 3600000

    RETURN @retval
END

Error when install sql server sp4

Mekong River29-Nov-05 14:02

Mekong River

29-Nov-05 14:02

Hi, I have a problem while trying to install SQL server 2000 sp4. There are 3 component that i need to install:

- sql server sp4
- analysis serverice sp4
- msde sp4

The first 2 option could be install successfully. But when i try to install the last option (msde sp4) it display a message "The instance name is invalid" after i double click on the file setup.exe. Does any one challenge this problem before? If you have please let me know about the solution how to fix it.

Re: Error when install sql server sp4

Mike Dimmick30-Nov-05 3:10

Mike Dimmick

30-Nov-05 3:10

You don't need to install 'MSDE SP4' on a regular instance of SQL Server: Developer Edition, Standard Edition, Workgroup Edition, Enterprise Edition or Personal Edition. 'MSDE SP4' is only for updating the SQL Server 2000 Desktop Engine, also known as MSDE 2000.

Stability. What an interesting concept. -- Chris Maunder

Re: Error when install sql server sp4

Mekong River30-Nov-05 5:36

Mekong River

30-Nov-05 5:36

Thank you very much for your comment. But in technically, if you want install it and meet the problem like i post in the previous thread, what is the best solution to solve it?

Recordset Open method error IDispatch error #3121

flyflyfly29-Nov-05 9:24

flyflyfly

29-Nov-05 9:24

Hello

I seriously need help on this. Please take time listen to my problem.

We have a SQL 2000 database running for a year. the main table called 'datatable' has grown to 1.8GB. Now we want to change the old database name to a different name without losing all the data in it. We made full backup of the old database and create a new empty database and restore the old database to it.

After I done that the program that populates the "datatable" in the newly restored database always give me error (IDispatch error #3121: [Microsoft][ODBC SQL Server Driver]Timeout expired :Microsoft OLE DB Provider for ODBC Drivers)
when rs->Open("DataTable", _variant_t((IDispatch *)conn,true), adOpenKeyset, adLockOptimistic,adCmdTable); excuted.

I have tried to recreate table index. It still doesn't work.
The datatable has first column "ID" as integer AutoNumber.

If I truncate the table, the program works fine. If I delete most of the data
for example only keep last a few hundred rows, the program also works.
If I don't use rs->open and rs->addNew() method to insert data, instead of using a simple insert SQL query, it works fine.

I believe the problem is that when we do restore something got messed up, but
how? If the datatable is too big and need more time to process when we call rs->open, but why the old database doesn't have this problem. The same program are running on those two databases. Any ideas?

Please help me out.

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi29-Nov-05 12:04

Farhan Noor Qureshi

29-Nov-05 12:04

Opening a 1.8GB table is not a good idea either. USe WHERE clause to filter the records you need.

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Recordset Open method error IDispatch error #3121

flyflyfly30-Nov-05 6:42

flyflyfly

30-Nov-05 6:42

hello Farhan

I don't quite understand.
If I use a where clause for example select * from datatable
where id = (select max(ID) from datatable), the rs->Open method will be okay. However, later on I do
rs->addNew() after addNew method, I do "if (FAILED(rs->Update()))" to commite the insertion. It will return me false means that it cannot update to datatable.

I don't know how to put a where clause there in order to do a insertion. Any ideas?

Thank you

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi30-Nov-05 7:48

Farhan Noor Qureshi

30-Nov-05 7:48

AddNew()/Update() is a very inefficient way of adding new records, specially in a big table. I suggest you use INSERT query to insert new records.

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Recordset Open method error IDispatch error #3121

flyflyfly30-Nov-05 8:30

flyflyfly

30-Nov-05 8:30

I understand AddNew() and Update is not a good way to
insert into a large table.

However, my question is why this method works fine with
the original table.
For the restored new table it refused to work.

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi30-Nov-05 9:04

Farhan Noor Qureshi

30-Nov-05 9:04

Look for physical and logical fragmentation. Physical fragmentation can be fixed by using a good defragmenter. Database files fragmentation can be viewed and fixed using DBCC commands. For example

DBCC SHOWCONTIG(DataTable)

Also, check if antivirus or malware is blocking access to data files (very rare possibility).

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Recordset Open method error IDispatch error #3121

flyflyfly1-Dec-05 6:24

flyflyfly

1-Dec-05 6:24

Hello Farhan

I tried
DBCC DBREINDEX (datatable)
DBCC SHOWCONTIG(datatable)

It does reduce some fragmentation of the database file.
This is the message I got

DBCC SHOWCONTIG scanning 'DataTable' table...
Table: 'DataTable' (607341228); index ID: 1, database ID: 10
TABLE level scan performed.
- Pages Scanned................................: 4100
- Extents Scanned..............................: 514
- Extent Switches..............................: 513
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 99.81% [513:514]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 0.39%
- Avg. Bytes Free per Page.....................: 703.8
- Avg. Page Density (full).....................: 91.31%
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

It seems even better than the production database, but still
the program works on the production database only, and give me the same timeout expired error when tried on the new database which is restored from the production database.

Any ideas ?

Thank you very much

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi1-Dec-05 7:17

Farhan Noor Qureshi

1-Dec-05 7:17

Please post connection strings for both database.

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Recordset Open method error IDispatch error #3121

S Douglas30-Nov-05 22:38

S Douglas

30-Nov-05 22:38

Might have been just an error in your explanation but, your old table name was “datatable” right? This table was deleted after backing up the data right?

Could the problem be you failed to update your open command? It looks like your attempting to open a connection to the old table.

rs->Open("DataTable", _variant_t((IDispatch *)conn,true), adOpenKeyset, adLockOptimistic,adCmdTable);

Anther shot in the dark here, is your autonumber column a 32 bit int? How many rows do you have in that table?
int

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

ZeePain! wrote:
This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

thedailywtf.com[^]

Re: Recordset Open method error IDispatch error #3121

flyflyfly1-Dec-05 6:19

flyflyfly

1-Dec-05 6:19

Thank you for your reply

Let me explain

I have a production live database called FASD. Now I make backup of the database. It will create a back file in harddisk.

Then, I create a brand new database called POMS. On this database, I restore FASD's backup file to it. The steps are
All tasks -> Restore Database -> Restore: From device -> Select device -> Add -> Pick a File name (the database backup file) On the Option tab click Force restore over existing database click box.

It is just like create a copy of production database FASD, and the new name of the database is called POMS. That's it.
Every table in FASD database should be exactly the same in POMS database.

The autonumber column is a 32 bit int. Currently we only have
140000 rows.

One thing I want to mention is that each row contains a binary column. The column stores picture binary data.
The datatype for this column is image. This why the database
is 18GB.

Any idea?

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi1-Dec-05 7:20

Farhan Noor Qureshi

1-Dec-05 7:20

Do FASD and POMS reside on the same machine? If yes, then, are database files on the same volume (or HDD or partition)?

Farhan Noor Qureshi

^{if (this == this) thow this;}

Re: Recordset Open method error IDispatch error #3121

flyflyfly1-Dec-05 7:49

flyflyfly

1-Dec-05 7:49

Yes FASD and POMS reside on the same machine, same volume (D:\ drive)
Do you know how to look at those database's logic file name?
I notice that when I do the restore, I need changed the physical data file name, and physical log file name to the new physical data and log file name.
For example I need to change D:\MSSQLDATA\MSSQL\Data\FASD.mdf to D:\MSSQLDATA\MSSQL\Data\POMS.mdf and D:\MSSQLDATA\MSSQL\Data\FASD_log.ldf
to D:\MSSQLDATA\MSSQL\Data\POMS_log.ldf

however I am not be able to change to logic file name.
The restore utility read those infomation from the backup file.

Re: Recordset Open method error IDispatch error #3121

Farhan Noor Qureshi1-Dec-05 8:55

Farhan Noor Qureshi

1-Dec-05 8:55

flyflyfly wrote:
Do you know how to look at those database's logic file name?

Run select * from sysfiles

IMHO, having same logical file names is not an issue here. Check for the differences (FASD and POMS) in 'Recovery Model', triggers, Locks (Under Management->Current Activity->Locks/Object in EM).

Farhan Noor Qureshi

^{if (this == this) thow this;}

Failed to compare Time portion of DateTime when read ACCESS database

Roman Muntyanu29-Nov-05 8:35

Roman Muntyanu

29-Nov-05 8:35

Hi all,

I have datetime field in database. When I am getting records older than
specific date that I passed in parameter I can not get records that
differs only in Time part of the datetime value.
Looks like comparison of Time portion in query failed.

I am using ACCESS database and ADO OleDbCommand. When in debug in Visual Studio QuickWatch clearly can see that the record that am going to get is older than datetime in TimestampParam by 10 sec (for example). If I substract 1 day from the
database field value I am getting the record. It is definetly time
portion comparison failed.

These are some lines from my code to show how I am reading database
OleDbDataAdapter adapter = new OleDbDataAdapter();
myCommand.CommantText = "SELECT [NetLog].* FROM [NetLog] WHERE
Timestamp < TimestampParam"
adapter.SelectCommand = myCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
int iNumRows = adapter.Fill( dataSet );

I would appreciate any advice

Thanks,
Roman

MSDE and SQL SErver Express 2005

inphone29-Nov-05 4:52

inphone

29-Nov-05 4:52

Is possible to keep MSDE on my machine, and install MS SQL EXPRESS 2005?
I want to keep both engines.

Re: MSDE and SQL SErver Express 2005

Paul Conrad29-Nov-05 5:07

Paul Conrad

29-Nov-05 5:07

Yes it is possible. I am doing so right now on my machine Smile | :)

. Along with MySQL and Firebird.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.