Convert Database From Access2000 To SQL Server2000

Dec 12, 2005

Hi

I want to convert the access2000 database to SQL server 2000.
I am able to convert the tables but unable to convert the query as view in SQL server 2000.


please quide how to convert the query as view in sql server 2000.


thanks

asm

View 6 Replies


ADVERTISEMENT

Convert Access2000 To SQL 6,5

Jun 27, 2000

Is there any utility which will generate sql script for access2000 database into sql 6.4

View 1 Replies View Related

Problem With CAST And CONVERT In SQL Server2000 Converting Decimal Places From 4 To 2

May 11, 2005

All of my currency columns are only storing 2 decimal places when I insert into the database but when I pull out the data with a SELECT statement, I always get 4 decimal places instead of the 2 that were inserted. 
For example: 
Database Price            SELECT statement Price
100.56                           100.5600
I have tried to use the CAST and/or CONVERT commands but I cannot get the output to come out as 100.56.  Has anyone had a similar problem?
Thanks

View 5 Replies View Related

Access2000 Database(table) Replicated To SQL 2000/2003 Server

Nov 4, 2006

I'm trying to replicate a table(s) in access 2000 to MS SQL server 2000/2005 programatically on a timed instance and then have these tables merged in SQL to create one table.

Any guidance appreciated.

Thank you,

View 1 Replies View Related

Database Sql Server2000 Very Slow

Jul 20, 2005

I have a database that had worked under msde 1.0 until reached the 2GBof dimension and the dB was blocked. To make possible the work i haddeleted old data from some table. The database restart, but theanswers from server become very slow. So i decided to pass to SqlServer 2000 without success. May i perform a check of this database?if is a indexs problem there is a way to rebuild them?Thanks in advanceAndy Wet

View 1 Replies View Related

How To :Attach A Database File (.mdf) To SQL Server2000 Automaticly

Nov 9, 2006

Dear All...
I want  my database file to be attached to remote server database  when i published my site
Notes :
Remote Server Database:SqlServer2000
.net Version:1.1
 

View 3 Replies View Related

Connection String For Remote Database Connectivity(SQL Server2000)

Jun 12, 2007

hai,
I am working on ASP.NET 2003 with SQLServer2000. My application requires to be connected to the Database which is there in my Headoffice.
My SQLServerName is "MyDBServerTestDB"
Database Name is "WebTO", UserID="******" and Password="******"
My Remote Server IP Address is "192.168.1.2" and its Static IP is "58.93.61.235"
I have specified the Connection string for my Remote Server as
"Provider=SQLOLEDB.1;Server=58.93.61.235TestDB;UID=******;PWD=******;Database=WebTO"
                               (or)
"Provider=SQLOLEDB.1;Server=58.93.61.235TestDB,1433;UID=******;PWD=******;Database=WebTO"           (1433 is the Port number of the Remote SQLServer)
but it is giving the error " SQL Server does not exist or access denied".
if i execute the same application at my Headoffice (Remote Server) by changing the Connection string as
"Provider=SQLOLEDB.1;Server=192.168.1.2TestDB;UID=******;PWD=******;Database=WebTO"
then, it is working fine.
Can anyone tell me where i went wrong or what i have to specify in my Connection string so that i can access my Remote Database Server.
Thanks in Advance,
Srinivas.

View 7 Replies View Related

Problem While Creating A Linked Server From SQL-Server2000 To An Access97 Database

Apr 30, 2007

I was attempting to create a linked server from SQL-Server2000 to an Access97 mdb file using the following scripts

EXEC sp_addlinkedserver
@server='REMOTE_OFFICE',
@srvproduct='Jet 4.0',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='F:RealEstate_Office1.mdb'

and

EXEC sp_addlinkedsrvlogin
@rmtsrvname='REMOTE_OFFICE',
@useself='false',
@locallogin='sa',
@rmtuser='Admin',
@rmtpassword=NULL

And while querying the linked server from the query analyzer using the following select command

SELECT *
FROM REMOTE_OFFICE.RealEstate_Office1.dbo.E_GOV_RE_OK

I got the following error

Server: Msg 7312, Level 16, State 1, Line 1
Invalid use of schema and/or catalog for OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.
OLE DB error trace [Non-interface error].

could you explain why this happen

View 4 Replies View Related

Run A SQL Server Script From Access2000

Apr 9, 2001

How can I run a SQL Server script or a single statement from Access 2000 front end. Can some one help!!
Thanks
Wilson

View 1 Replies View Related

Log Off Users In Shared Drive - Access2000

May 18, 2004

I have an Access2000 app placed on a shred drive. The problem i am having is that users leave it opened and take long breaks. Sometimes they leave it overnight. I would like to make corrections to the form but can't. How can I save and close all users. I would like to send a message telling all users to save any changes and give them 1 minute before shutting down.

Thanks

View 2 Replies View Related

Strange Results When Calling A Sql Stored Proc From Within An Access2000 Project

Nov 18, 2006

Hi,I have written a stored procedure which includes a DATEPART command, i.e.DATEPART(weekday, <date>)The result when ran from SQL Query Analyser is as expected . i.e. Sundayreturns 1, Monday 2, etcWhen the same proc is called from within the Access 2000 project Sundayis returned as 7, Saturday as 6 instead of 1 and 7 respectively.Basically the same stored proc returns different data depending on fromwhere it has been called.This is causing some issues obviously as the resulting tables andreports are showing incorrect data when presented in Access 2000.Has anyone else experienced this before or have any idea what may cause it.Regards,PB

View 1 Replies View Related

Can You Convert Access Database Data Over To An SQL Database?

Feb 15, 2008

I would like to start using SQL, how would I convert my data in MS Access over to an SQL Server Database?

View 2 Replies View Related

How To Convert Oracle 8 Database Into SQL Server 7.0 Database

Oct 15, 2001

Ho do I convert Oracle 8 database into SQL server 7.0 database ? Is it possible ? Please let me know at skbhaduri@rediffmail.com

View 1 Replies View Related

SQL Server2000

Aug 27, 2007

When I try to install MS SQl server2000 on windows XP machine,it says the server component is not supported by OS.What should I do to get it run on my machine?

View 3 Replies View Related

A New BUG Id Sql Server2000

Feb 3, 2008

Hi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001

Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted

Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted

Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?

View 1 Replies View Related

A New BUG In SQL SERVER2000

Feb 2, 2008


Hi,
I'm Arash Baseri a Sql Server2000 developer and mail you from Dubai (U.A.E). I have a problem in Sql Server locking table. My problem is not reasonable so the more I researched the more I understand it is not my problem .it is a bug in Sql Server2000.
Now I explain the situation:
I have two tables (Table A and Table B).Table A has a clustered index on col1 and col2, Table B has a clustered index on col1 and col2. I join these tables and update col3 in table A, like this
begin tran
insert [Table A]
select * from Arshiv_Master where Col1 between 26001 AND 26001

Update AI31 set Col3=Case
when 1=1 then 1
Else 0 End
From [Table A]AI5, [Table B]AI31
where AI5.Col1=AI31.Col1 And AI31.Col1 Between 26001 And 26001
/* intentionally I didn't rollback or commit transaction to hold locks on table*/
In another connection I execute this query and I face "Lock request timeout period exceeded" error message.
set lock_timeout 1
set transaction isolation level read uncommitted

Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 60000
Now the most interesting part is here .when I use a smaller data range for Col1 no error message is shown. A query like this
set lock_timeout 1
set transaction isolation level read uncommitted

Update AI31 set Col3=Case
when 1=1 then 0
Else 0 End
From [Table A] AI5, [Table B] AI31 where AI5.Col1=AI31.Col1 and AI31.Col1 between 45018 And 50000
As you see the difference between the last two queries is on WHERE clause especially on data rages of Col1.
As you know Sql Server 2000 has row level lock and when I acquire a lock on a record the other records are free. So what's wrong with Sql Server that assumes the others records are locked. I tested this situation in Sql Server 2005 and this problem was not seen so I think it's a bug in Sql Server 2000.Who can help me about this problem?

View 1 Replies View Related

Access - SQL Server2000

Oct 11, 2001

HI,
I have a application which has Access as Front end and SQLServer as BackEnd.
I have a table which has student details.

Table Fields are:
Record#,FirstName,LastName,MiddleName,Address,City ,State,Pin,.....
The table has about 1200 records.

Every Thing works fine but in the front end when i try to do a search by
FirstName it is VERY SLOW.But it is okey if i search by the Record#.
I need to search by lastname or Firstname and speed up the process.

Any Help will be appreciated,
Thanks,
Rang.

View 1 Replies View Related

Why Should I Upgrade To SQL Server2000 ?

Apr 5, 2001

What are the experiences of those who have upgraded to

View 2 Replies View Related

Why Should I Upgrade To SQL Server2000 ?

Apr 5, 2001

What are the experiences of those who have upgraded to SQL Server 2000?
I am writing a paper for my company and wish to list features of SQL Server 2000 from a user/developer/business aspect. We are on
SQL Server 6.5 and I need to highlight the advantages and disadvatages of upgrading.

Thanks

Jeff

View 7 Replies View Related

Log Shipping In SQL Server2000

Jun 11, 2001

Hi everybody,

I configured Logshipping in sql server 2000(Enterprise edition).in destination server copy and restore is failing(but there is no error).Out ofsync threshold value is set 27 minutes, after 27 minutes i found the error message in sql server error logs "The log shipping destination HARSHA.Northwind1 is out of sync by 27 minutes..

Any body help me

View 2 Replies View Related

How To Move From A2K To SQL Server2000

Aug 27, 2004

Hi gang,

Just trying to get some information on what is required to migrate from Access 2000 to SQL Server?? Is it pretty difficult to do? Are there any changes to the data or structure that is needed? Is SQL Server more secure? What about MSDE instead of SQL?? I'm just needing some tips and info on what to expect and all as I think we are going there kinda soon. I can do many things in Access but not sure how to go about them in SQL Server? Can you also do reports from there as well?

Inquiring mind wants to know
have a nice one,
Bud

View 3 Replies View Related

Help-Can I Use 4 GB Memory By SQL Server2000?

Dec 18, 2006

There is a Server with 4G Memory. I installed a SQL Server 2000 standardversion on it.I heard that SQLServer2000 could use only up to 2GB memory. Is it true?How can I use those 4GB memory? I can not upgrade to SQL Server 2005 orother version because i don't want to take this risk.Thank you very much.

View 8 Replies View Related

SSIS And Sql Server2000

Oct 31, 2006

Hi, Is it possible to use ssis for the etl processes and still have an existing 2000 db? For e.g. CanI create a ssis pkg and use the xml task to download data to a 2000 db.

View 4 Replies View Related

Can You Tell Me Why The Char ?? In SQL Server2000,Windows XP?

Jan 18, 2005

HI,Thank you to pay attention to this thread.i am chinese,may be i coudln't say my problem clearly,it's.....

okay,i use the TextBox,SQL Server 2000,i fill the TextBox as Chinese,then,I use the T-Sql INSERT to Finish Inserting A record,but when i open the SQL Server 2000,i find that the char showed in field as the char '???',i don't understand what happened,if the fault of UnicodeEncoding?can you help me? Thx~!

View 4 Replies View Related

Analysis Manager Sql Server2000

Feb 3, 2005

dear sir/madam,

i have to create a cube in analysis manager in sql server 2000.as i want to see the data according to my organisation levels.

organisation level:

1.Business unit

2.Team manager

3.Sales manager.


and also i create the three user respectively and assign all user has adminstrator category in user accounts of windows XP.

after create the user and design the manage role to restrict the levels which i have create the dimension.after login which i have to create the user i can see all levels of data.

so pls solution for see data which i have to restrict the dimenssion only..

thanks

kesavan

View 1 Replies View Related

SQL Server2000 And COLUMN DESCRIPTION

Nov 16, 2001

HI

I have a big problem with SQL server2000. I can't get COLUMN DESCRIPTION.
I will print DATADICTIONARY from a DB, I can get all elemnts (table name, columns name, datatype, precision, scale, FK, PK, default value..) I missed only DESCRIPTION. How I can get it????

Medo

View 1 Replies View Related

SQL Server2000 Multiple Instances

Mar 2, 2001

Please Help me on this.
I installed the two instances SQL on one box. ONe is default instance called ACSQL1(actually machine name) and the other one is called ACSQL1/DEVELOPMENT. THrought the my client site of SQL 2000 I can access both instances. When I try to get connection from VB. I can access the default instance but I can not access the second instance. Any ideas about this???
Qun Lu

View 2 Replies View Related

High Availability On MS SQL SERVER2000

Jan 19, 2003

Hi,
I am new in SQL SERVER.I wanted to setup high availability database.It would be great if any one could answers my questions please.
-What are the options availability for HA except clustering?
-How to set up log shipping HA ?
-How to monitor log shipping?
-Is standby DB and log shipping same ?
-Can I setup log shipping without backup/restore method.Like I have to create db1 on server A and create db1 on server B and then configure log shipping?
-Is it necessary to ship log for master database or only user Database?
Thx
-Blace

View 1 Replies View Related

Should I Need I Install SQL Server2000 When Distribute My App

Feb 1, 2004

I want make setup cd for my program and i use visualbasic 6 and SQL Server 2000 .
What i should make and include my setup file to make it work with any one install it in his computer and we assume he dont have SQL Server2000 in his computer .
Please help me on that
Should SQL Server 2000 must alreeady installed on his computer?
If its must be installed,Is there any way to make it easy through my setup file to make it install sql server automatic ?
Can i make my program in visual basic create database and tables and relations and so.
Please help me on that becuase its too Important.
Thanks.

View 1 Replies View Related

Sql Server2000 Analysis Service

Oct 14, 2006

Hi,
I want to install the sql server2000 analysis service.Can you please tell me the website from which I can install that.

View 2 Replies View Related

From Server7/nt4 To New Server2000/windows2000

Aug 14, 2004

Hello,
Can anyone please tell me the best way to upgrade server1 with SERVER7 and OS of NT to a new server2 with SERVER2000 AND WINDOWS 2000 ?
The data in the old server is very important.
Thanks

View 2 Replies View Related

SQL Server2000 DB Restore Problem

Sep 18, 2006

Hi,
I'm wondering if anybody can help me. I have to restore the database from the backup sent by vendor. Backup itself (backup_0906 file) is 60 MB. Below is a statement I run:
RESTORE DATABASE PDMUpload
FROM
DISK = 'e:ftpdirackup_0906'
WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY ,
REPLACE ,
MOVE N'PDMUpload_Data' TO N'E:MSSQLDataPDMUpload_Data.MDF',
MOVE N'PDMUpload_Log' TO N'E:MSSQLDataPDMUpload_Log.LDF'

I get the following error messages:

Server: Msg 3257, Level 16, State 1, Procedure RestoreUpload, Line 9
There is insufficient free space on disk volume 'E:' to create the database. The database requires 28181331968 additional free bytes, while only 6759866368 bytes are available.
RESTORE DATABASE is terminating abnormally.

If anybody can explain why DB needs 28 GB???? BTW, there is 6 GB of diskspace available on E: drive.
I appreciate any help.

View 6 Replies View Related

CmdExec Job Step In Sql Server2000

Aug 20, 2007

Thanks for the invitation to post a question, so I will post one.

I need to create a job step that uses cmdExec.

This is the command line I entering:
D:odbcTimeClockUpdatesinReleaseTimeKeepingNo nLogouts.exe

When I run this job the job fails. When I look at the job history, the only information I get is the date and time, user that ran the job and the fact that it failed. I haven't been able to get any CmdExec job to run at all. Can anyone tell me what I'm doing wrong?

Facts.
1. This exact same command is used by my network administrator using windows scheduler on the server. The only reason he wants me to create an sql server job is because it's mostly sql functions.
2. I know the Sql Server agent is running, because I have other jobs that are run.
3. I have verified that I have permission to run the file because I can go to the actual directory and run the exe.
4. Do I need to enclose my command in quotes i.e. “D:odbcTimeClockUpdatesinReleaseTimeKeepingN onLogouts.exe”
5. the path of the file I need to run is the path on the server and not the path on my local machine.

If you need any other information, please let me know
Thanks for you help
GEM

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved