Trouble Upgrading From Access To SQL On The Web

Dec 19, 2001

Hello

I have a problem regarding the importing the access database in the SQL server 7.0.
We have a matrimonial portal named www.viwahmandap.com which is using an access database.We are using the dsn to access this .mdb file. Now we will be upgrading to SQL 7.0.The server administrator won't
do anything like importing the access database .So i will have to download the access database on our domain ,import this access file into an SQL database using the DTS wizard which is available in SQL 7.0(This i can do). This will create the respective .mdf & .ldf files.Now What are the next steps to be followed at my end? What should i ask for from the the server administrator?Are there any changes required in my ASP application.What else should be done?Please help.


Ashish

View 1 Replies


ADVERTISEMENT

Trouble Upgrading An MSDE 1.0 Engine To SQL Express 2005

Jul 13, 2006

I am creating an install for our product and as part of the changes I
am making, I want to upgrade a user's DB engine, if they are still
using MSDE 1.0, to SQL Express 2005.



The upgrade path we have chosen is the following.....

MSDE 1.0 --> MSDE 1.0 sp4 --> SQL Express 2005



I believe this should work, yes? Anywho, I am trying to run a
"passive" install of SQL Express and I am using the following parameter
list:



/qb
UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL
DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SQLAUTOSTART=1
SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"



When SQL Express is installing, everything installs properly except the
backward compatibility component....any idea why this is happening?



I'm certain that some of the above parameters (in red) are wrong because if I install all the engines (above in blue) manually then it all works.





Thanks

View 1 Replies View Related

Upgrading From Access

Mar 11, 2004

I have read a few books on SQL Server and on access. I recently got my 1st programming job (vb.net)

I want to move my database from Access to SQL server. But I would like to Use access as the front end for simple data entry, queries and reports. I dont know how to do this,, (using Access as a front end for SQL Server)

Can anyone recomend topics of interest or a good book?


Thanks



~M

View 6 Replies View Related

Upgrading From Access Questions?

Feb 21, 2005

My current website is based on access and running fine but a bit slow, the size of the file have always increase rapidly (i don't know why) and I have to download the mdb file every week, using access to compact it and send it back to the hosting company's server. Therefore I concern to upgrade it to SQL server or MSDE. I never used any of them and I have no idea how they work. Here are a few questions:

1, Should I use SQL server or MSDE? I know the differences among access, SQL server and MSDE, but I am curious why is MSDE free? are there any limitation or anywhere worse then access? (considering access does cost money but less powerful then MSDE)

2, Is there a file size problem like what I got with mdb files? it is very important to me because I have limited space for the hosting company.

3, I downloaded MSDE and installed into my WindowsXP, and what I see is only an icon in the task bar any nothing else. I have no clue how it work at all. What else do I need for the upgrade? What are the steps?

4, It seems SQL server and MSDE are tightly integrated into the system. Can I still have a database file and upload it to the hosting company just simply replace the mdb file? Please if someone could provide any tutorial how to run and manage MSDE.

Thankyou

View 1 Replies View Related

Constraints Go When Upgrading Access DB

Dec 8, 1998

Hi,

I have just tried to upgrade an Access database for the first time. All the tables & data have been moved into SQL Server, but all the Primary Keys & Foreign Keys have disappeared. The Primary Key columns are marked as allowing NULL values in SQL Server, and I can't change them to be NOT NULL.

I used the ACCESS export facility to upgrade the database.

Can anyone help me put the constraints into the SQL Server database???

Thanks

Steve

View 1 Replies View Related

Upgrading Backend Access

Sep 10, 2013

We are entertaining the idea of moving our data to a cloud and I need to know how to convert my Access backend DB to SQL. which version of SQL will I need to use to do the conversion and will also work in a cloud environment.

View 2 Replies View Related

Problem After Upgrading Access Database To Mssql

Jan 21, 2004

Oke here is the problem. I hope sombody can help me with it.

After a lot of discussion, I finaly got the people that control the MS SQL server with my appertment as far to allow me to upgrade my access database to the MS SQL server.
After this I've created an access project. Devellopping in access I concluded I made a mistake in the rowsource property of one of the tablefields. The people that control the MS SQL server don'n allow me to make changes to the database structure from within access. So I've to write a SQL statement to change this.

example:

fields table1: id_document, id_document_type, document_name
fields tabel2: id_document_type, document_type_description.

the field id_document_type from table 1 is defined as a combo/list box tha contains the values from the field document_type_description from table 2.

I hope somebody can tell me if it is possible to write an SQL statement for this problem and how it shoud look like ?

thank you

View 1 Replies View Related

Access Trouble

Sep 28, 2007



I'd been using this DB for months. Then I had to install Vista and it's become very difficult to work with because of so many security demands. You set permissions here and there and it still does not work. For some reason the permissions are being wiped out often after a sign off.

Anyhow it seemed to work until about an hour ago off and on. Accasional breakdowns happen. I also want to add that I am debugging a huge C# app and Sql Server is attached to it. So the conditions are definitely unstable but that part of code which broke down has not been changed for months.

I had to disconnect DBs and reconnect them in Sql Server and VS back and forth a number of times.

In short, I got this error (after some other similar):

Cannot open user default database. Login failed.
Login failed for user 'DDMNVT61AlexBB'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at tapTCPports_1.HttpHistoryRequests.subHistoryRequest_Click(String symbol, String passThru, String discriminator) in C:VCsharp_Projects apTCPports_1HttpHistoryRequests.cs:line 103

I go to Sql Server and see all tables in the Server Explorer.

I go to my VS Server Explorer and see all tables.

Connection strings haven't been changed.

What could be the problem?

Thanks.

View 3 Replies View Related

DTS Connect To Access 97 Secure Database Trouble...

Oct 7, 2005

Ok, I need to give some details. I have a secure Access Database using WorkGroup Security logon. It is an Access 97 database (yes I know it is "old").

I tried to create a DTS package in SQL Server 2000 to connect to it, but I am getting the same error that I got before I "joined" the workgroup when attempting to access the DB. So I changed the Service logon identites to mimic <me> as the logon, and still I can't get it to connect. The user name and password I put in the connection are correct.

It seems like nothing is working and I am all out of ideas. Does anyone have any recommendations? Has anyone done anything like this successfully?

PS: I can manually logon to the database, and extract the data 1 table at a time, but I don't want to export 40 tables each time I have to load this data. Any help would be appreciated. Thanks in advance.

Frank

View 6 Replies View Related

Trouble Translating Query From Access To SQL Server

Feb 16, 2006

Gary writes "I'm imported the query from Access (where it worked perfectly) to SQL View where the "Iif" statements caused an issue.

Here's a SMALL portion of the original:
SELECT tblTransactionBuyer.TransBuyerID,
tblDefaults.CompID,
([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA,
[TransBuyerPropSalePrice]*
(IIf([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],
IIf([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA])))/100 AS VAFunding, ......


Below, are my changes so far, but I'm stuck.
SELECT tblTransactionBuyer.TransBuyerID,
tblDefaults.CompID,
([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA,

[TransBuyerPropSalePrice]*
If([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],
If([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA]/100)) AS VAFunding, ........

It appears that I may not be able to put an IF into a SQL SELECT. If not, how can I get the same effect ?

Thanks. Gary

Listed Below is the Full Access Query:

SELECT tblTransactionBuyer.TransBuyerID, tblDefaults.CompID, tblTransactionBuyer.TransBuyerEntryDate, qryUserAlphaList.UserName, qryUserAlphaList.UserAreaCode, qryUserAlphaList.UserPhone, tblTransactionBuyer.TransBuyerName, tblTransactionBuyer.TransBuyerVaEligible, tblTransactionBuyer.TransBuyerPropAddress, tblTransactionBuyer.TransBuyerPropCity, tblTransactionBuyer.TransBuyerPropSalePrice, ([TransBuyerPropSalePrice]*([DefBasePercentFHA])/100) AS LoanBaseFHA, ([TransBuyerPropSalePrice]*([DefBasePercentCONV])/100) AS LoanBaseCONV, ([TransBuyerPropSalePrice]*([DefBasePercentVA])/100) AS LoanBaseVA, ([TransBuyerPropSalePrice]*([DefBasePercentJumbo])/100) AS LoanBaseJumbo, [LoanBaseFHA]*[DefMipFHA]/100 AS MipFHA, [LoanBaseCONV]*[DefMipCONV]/100 AS MipCONV, [LoanBaseJumbo]*[DefMipJumbo]/100 AS MipJumbo, [TransBuyerPropSalePrice]*(IIf([TransBuyerPropSalePrice]>=[DefLoanMinJumbo],[DefFundingJumboVA],IIf([TransBuyerVaUsed]="Yes",[DefFundingUsedVA],[DefFundingVA])))/100 AS VAFunding, [LoanBaseFHA]-[DownOverMinFHA]+[MipFHA] AS LoanTotalFHA, [LoanBaseCONV]-[DownOverMinCONV]+[MipCONV] AS LoanTotalCONV, [LoanBaseJumbo]+[MipJumbo]-[DownPaymentJumbo] AS LoanTotalJumbo, [LoanBaseVA]+[VAFunding]-[DownPaymentVA] AS LoanTotalVA, [TransBuyerPropSalePrice]*([DefMinDownPayFHA]/100) AS MinDownFHA, [TransBuyerPropSalePrice]*[DefMinDownPayCONV]/100 AS MinDownCONV, [TransBuyerPropSalePrice]*[DefMinDownPayVA]/100 AS MinDownVA, [TransBuyerPropSalePrice]*[DefMinDownPayJumbo]/100 AS MinDownJumbo, tblTransactionBuyer.TransBuyerIntRate, tblTransactionBuyer.TransBuyerLoanYears, tblTransactionBuyer.TransBuyerHazardIns, tblTransactionBuyer.TransBuyerFloodIns, tblTransactionBuyer.TransBuyerClosingDate, IIf(([TransBuyerConvDownPayPercent]/100)*[TransBuyerPropSalePrice]>[TransBuyerConvDownPayCash],([TransBuyerConvDownPayPercent]/100)*[TransBuyerPropSalePrice],[TransBuyerConvDownPayCash]) AS ConvDownPay, tblDefaults.DefBuyAppraisal, tblDefaults.DefBuyCreditReport, tblDefaults.DefBuyJumboUnderwriting, tblDefaults.DefBuyVAUnderwriting, tblDefaults.DefBuyFHAUnderwriting, tblDefaults.DefBuyCONVUnderwriting, tblDefaults.DefBuyJumboTaxService, tblDefaults.DefBuyVATaxService, tblDefaults.DefBuyFHATaxService, tblDefaults.DefBuyCONVTaxService, tblDefaults.DefBuyFloodCert, tblDefaults.DefBuyAbstractTitle, tblDefaults.DefBuyMiscFedex, tblDefaults.DefBuyRecording, tblDefaults.DefBuySurvey, tblDefaults.DefBuyAttorney, tblDefaults.DefBasePercentFHA, tblDefaults.DefBasePercentCONV, tblDefaults.DefBasePercentJumbo, tblDefaults.DefBasePercentVA, [TransBuyerPropSalePrice]*[DefPropTaxRate] AS PropTax, [LoanBaseFHA]*[DefBuyOrigFHA]/100 AS OrigFHA, [LoanBaseCONV]*[DefBuyOrigCONV]/100 AS OrigCONV, [LoanBaseVA]*[DefBuyOrigVA]/100 AS OrigVA, [LoanBaseJumbo]*[DefBuyOrigJumbo]/100 AS OrigJumbo, [DefTitleInsDollar]*([TransBuyerPropSalePrice]/[DefTitleInsPerX]) AS TitleInsurance, [OrigFHA]+[DefBuyAppraisal

View 1 Replies View Related

SQLExpress - Remote Access Trouble When Publishing A Site

Sep 12, 2007

Hi all,
I followed this excellent tutorial (from Microsoft) about creating and using a SQLExpress db table internal to your website:
http://www.asp.net/learn/videos/video-08.aspx
and the site I created works just fine - locally. When I publish to my web host provider I get this error:
[SqlException (0x80131904): An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
My web host provider supports .NET 2.0 but doesn't support MS SQL Server. But that should matter - right? Because I'm putting the db instance right in the website?
I did a search and followed some of the advice:
I went into the SQL Server Surface Area Config Mgr and set SQLExpress for local and remote connections and rebooted/republished. I also have SQL Server 2005 installed as a separate entity (if that makes a difference).
I still get the above error. This is the connection string from the web.config:
<connectionStrings><add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Customers.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>And this is the call from the markup:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Customer]"></asp:SqlDataSource>
Does any know the fix for this? 
Thanking you in advance
Pat

View 4 Replies View Related

K, I Got Dreamweaver To Hook Up To My Access Database(Yes Lots Of Trouble) BUT...

Jan 6, 2008

when I hit F12 to preview my page and forms etc it goes to this error

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.
For more information about HTTP errors, see Help.
 
AND when I try to hold up to an SQL database it wont let me and says the server doesnt exist still. Whats wrong with my SQL server and what can I do to resolve this problem?

View 1 Replies View Related

Trouble With Cursor Designed To Revoke Object Access.

May 30, 2008

Hi everyone. I am having difficulties with a cursor that I am trying to write. The purpose of the cursor is to loop through all tables in a selected Database and revoke "Select" access to that table for the indicated role (RoleToRevoke). I am getting the error on the @name variable within the REVOKE statement. I have placed a comment indicating where I am getting the error. Is there a way to have sql server interpret this @name variable within the REVOKE statement? Thanks for your help.




Code Snippet

USE [Database_Name];

Declare cursorExample Cursor for
Select TABLE_NAME
from information_schema.tables
Where TABLE_TYPE='Base Table'
and TABLE_SCHEMA='dbo'

Declare @name as varchar(255)
Declare @ErrorSave as int
Declare @ErrorCount as int

Open cursorExample

Fetch Next from cursorExample into @name


SET @ErrorSave = 0
SET @ErrorCount = 0




Begin Tran

While @@Fetch_Status=0

Begin

--Getting Error on Line below on @name
REVOKE SELECT ON OBJECT::@name FROM RoletoRevoke;

IF (@@ERROR <> 0)

BEGIN

Print 'Error Revoking Access to Table: ' + CAST(@name AS varchar(75))
SELECT @ErrorCount = @ErrorCount + 1
END
IF (@@ERROR = 0)

BEGIN

Print 'Successful Revoking Select Rights on Table: ' + CAST(@name AS varchar(75))








SELECT @ErrorSave = @ErrorSave + 1
END
Fetch Next from cursorExample into @name


End

IF @ErrorCount = 0

BEGIN

COMMIT TRAN
PRINT 'COMMITTED TRANSACTION'
PRINT 'Total Tables Affected:' + CAST(@ErrorSave AS varchar(75))
END
ELSE

BEGIN

ROLLBACK TRAN
PRINT 'ROLLED BACK TRANSACTION'
END

Close cursorExample
Deallocate cursorExample
GO

View 9 Replies View Related

Having Trouble Following Tutorial - Working With Data In ASP.NET 2.0 :: Creating A Data Access Layer

Nov 1, 2006

HiI'm having problems following the tutorial on creating a data access layer -  http://www.asp.net/learn/dataaccess/tutorial01cs.aspx?tabid=63 - when I try to compile in Visual Studio 2005 I get namespace could not be found. I followed exactly the tutorial - I created a dataset and added this code in my aspx page.  <asp:GridView ID="GridView1" runat="server"             CssClass="DataWebControlStyle">               <HeaderStyle CssClass="HeaderStyle" />               <AlternatingRowStyle CssClass="AlternatingRowStyle" />In my C# file I added these lines...    using NorthwindTableAdapters; <<<<<this is the problem - where does this come from?   protected void Page_Load(object sender, EventArgs e)    {        ProductsTableAdapter productsAdapter = new         ProductsTableAdapter();        GridView1.DataSource = productsAdapter.GetProducts();        GridView1.DataBind();    }Thanks in advance

View 6 Replies View Related

Upgrading To Sql 7.0

Feb 5, 2002

Hi,

I have to upgrade the sql server from 6.5 to 7.0 for the first time. I have decided to go with two machine upgrade using named pipes.

The question is: Can we still use 6.5 machine and database as production version until we test out the application on 7.0?

We are planning to relpeat the upgrade once the testing is done on 7.0 server once the testing is done.

View 1 Replies View Related

Upgrading From 6.5 To 7.0

May 14, 1999

We're going to be upgrading our Server from 6.5 to 7.0. In addition we're getting a new SQL Server Box.

Which of the following is better: a) Install SQL 6.5 on the new box, restore the DB from old box to the new box, then install 7.0 on the new box and use the upgrade wizard to upsize the DB. (We'll have room to leave the 6.5 devices on the box after upgrading.) or b) Install SQL 7.0 on the new box and upsize the db across the network (100megabit network cards).

Thanks,

Kevin M. Tupper
EZLinks Golf, Inc.
http://www.ezlinksgolf.com

View 3 Replies View Related

Upgrading 6.0 To 6.5

Jan 19, 1999

I'm following a white paper and have run chkupg65 and am stuck at resolving keyword conflicts. I see many TechNet references about fixing them...but none about how. A little help? Below are the conflicts:
Keyword conflicts
Column name: SyncModification.ACTION[SQL-92 keyword]
Column name: Jobs.EXPIREDATE[SQL-92 keyword]
Column name: SqlStoreTable.SIZE[SQL-92 keyword]
Column name: JobDetails.TIME[SQL-92 keyword]
Column name: SchedulerSafeDelete.TIME[SQL-92 keyword]
Column name: SMSEvent.TIME[SQL-92 keyword]
Column name: SyncModification.TIME[SQL-92 keyword]
Column name: vJobDetails.TIME[SQL-92 keyword]
Column name: vSMSEvent.TIME[SQL-92 keyword]
Column name: Sites.TIMESTAMP[SQL-92 keyword]
Column name: QueryExpressions.VALUE[SQL-92 keyword]

View 1 Replies View Related

Upgrading 6.5 To 2k

Jun 15, 2001

Does anyone know of a good book or resource on what's the best way to upgrade 6.5 to 2k? Or generally how would you do that considering you need to do on more then 50 servers?

View 1 Replies View Related

Upgrading 2k5 To Sp2

May 15, 2008

So I'm using Visual Studio's one click deployment to install/update software for users. SQL Express 2005 is the default, and I need to get all current and new users to update to SQL Express 2005 SP2. Ontop of that, I need to change the sa password for all current users (I should be able to manually set it for the new guys).

The problem I'm having is that instead of just updating the current SQL Express engine installed, it creates a new instance of the SQL Express engine when installing SQL Express SP2.

Is there anyway to just update SQL Express to SP2? Is there an easy way to change the sa password when doing so?

View 1 Replies View Related

Upgrading From 3.23 To 4.1

Jul 23, 2005

I have an application which installs MySQL 3.23. It's hard-coded. Irealize there are newer versions, so I am thinking, what's easiest:1) install the application with its default 3.23 and then run a scriptto convert 3.23 to 4.1 or later,or2) modify the application to install a newer version of MySQL from thestart.

View 2 Replies View Related

Upgrading From MDB

Nov 29, 2007

I'm in the process of upgrading a gazillion apps from using .MDB files to using SQLCE 3.5. (Or, at least planning the upgrade). Is there an easy way to save existing .MDB files as .SDFs? Also, we have an occasional app that's web based (eg. certification exam, where we have 10 people take it online at the same time, in one day, and the database keeps the score, questions, etc.); is it a good idea to move that kind of app to SQLCE from MDB?

View 3 Replies View Related

Upgrading To SP2

May 29, 2008



Hey,
I have a SQL Server 2005 Express Edition installed, and I want to upgrade to SP2.
Is there a way to configure (using the setup ini file maybe?) the installer to install only the SP2?

Thanks ahead

--sternr

View 7 Replies View Related

SP3 &&amp; SP4 Not Upgrading

Dec 22, 2005

When I run SP3 & SP4 for SQL Server it runs okay.  I get no errors after the installation & both installations call for a reboot which I do with no problems.

But yet when I get back into my machine, go to the Query Analyzer & run "Select @@version" and execute it, it's still showing v8.00.194 (Original release).  It should be showing 8.00.2039.

 

Any ideas or suggestions?

 

Thanks!

View 1 Replies View Related

Why The Data Are Different After Upgrading From 6.5 To 7.0

Apr 29, 2002

We are upgrading our servers from 6.5 to 7.0 SQL servers. I used the same configurations on both 6.5 server and 7.0 server like ANSI and the others. But SQL7.0 server turns out to have different data on some tables. Here is the example on one table. Why?

6.5 database

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
------------------ ------------ -------------- ---------------
Apr 20 2002 12:00AM 0.00 0.00 0.00


WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
N 3.76 135.21

WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.21 0

7.0 database

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
----------------------- ------------ -------------- ---------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50


WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
Y X 3.7600 135.2050

WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.2050 373








------------ 135.21 135.21 0

7.0 databases

WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS WT_MS_APPR_IND WT_NEW_EMPL_FLAG
------------------------------------- -------------------------- --------------------------------- -------------------------------- ----------------------------- --------------------------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50 Y X

WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP WT_MS_TOT_EXP WT_MS_MILE_LIM
------------------------------------------- ----------------------------------- -------------------------- ---------------------------
3.7600 135.2050 135.2050 373
************************************************** ************************************************** ************************************************** **********************
I have checked the datatypes that are transferred from SQL6.5. They are the same types as SQL6.5. Plus the configurations are the same on both 6.5 and 7.0. The question is that why the values are different? What the way is to fix it?

View 1 Replies View Related

Errors When When Upgrading To SQL 7 Sp3

Apr 30, 2002

Hi,

Well there's always a first for everything!! I have a SQL 7.0 server on sP1
and ran upgrade to sp3 and recieved error 'error in upgrade script' retry or cancel. When I retried the upgrade ended. I tried to run the upgrade again and it tries continue where it ended before, but the upgrade ends unsucessfully. I even tried extracted the sp3 exe to a diffrent folder and ran the sp3 upgrade with same results.

I started the MSSQL service ok but not able to use Query Analyzer, DTS, EM.

Get the following message:ISQL.EXE - Entry Point not found. The procedure entry point?DeleteRow@CDataCTLStorage@@UAEJJPAPAG@Z could not be located in the dynamic link library SQLGUI.dll

I get similar msgs when trying to open DTS, Enterprise manager from the server. The user databases and appear to be ok. I am able to get to Query Analyzer, etc. from my worksation fine.

Has anyone encountered this before? Is there a fix for it or do I need to rebuild the server from SP1 and restore the databases, etc.??

Thanks Much,
Steve Bajada
Senior DBA

View 3 Replies View Related

Upgrading From Sql 7 To 2000

Jul 18, 2001

Has anyone attempted an upgrade from sql7 to 2000? is it a difficult process? what happens to the users. Is there a good site i can go to to get this info ?

Thanks in advance

View 1 Replies View Related

Upgrading The Sql Server Dsn

Aug 5, 2001

Does anyone know how to upgrade a sql driver. Or where to get the driver dll from. The client machine is running 3.70.06.23 and needs 3.70.08.20 to connect to the sql server!

View 1 Replies View Related

Problem Upgrading To SQL 7.0

Aug 11, 1999

One of my students' company is doing an upgrade from SQL 6.5 to SQL 7.0
and everything converts fine except one veiw. Does anyone know what
would cause this to happen? If they run the script in SQL 7.0 it works
fine. Any thoughts?

CREATE VIEW dbo.vewRptWooActiveList
AS
SELECT vewRptWooActiveListSub1.wotUserValue1,
vewRptWooActiveListSub1.wooNum,
vewRptWooActiveListSub1.wooCreatedWhen,
vewRptWooActiveListSub1.wooDispatchedWhen,
vewRptWooActiveListSub2.MaxOfwslInsertedWhen AS wooLastStatusWhen,
vewRptWooActiveListSub1.wosUserValue1,
vewRptWooActiveListSub1.sitName,
vewRptWooActiveListSub1.empFullName_Cp,
vewRptWooActiveListSub1.Company,
vewRptWooActiveListSub1.Region,
vewRptWooActiveListSub1.ServiceCenter,
vewRptWooActiveListSub1.Zone
FROM vewRptWooActiveListSub1 INNER JOIN
vewRptWooActiveListSub2 ON
vewRptWooActiveListSub1.wooID = vewRptWooActiveListSub2.wsl_WooIDFk

Thanks
Dawn Gill

View 2 Replies View Related

Codepages When Upgrading From 6.5 To 7.0

Jul 21, 1999

I have a couple of 6.5 installations with different codepages/sort orders, when I come to upgrade these databases, is it possible to change the code pages/sort order during the upgrade of my existing databases so that I have the same sort order/codepages across all my sites?

The databases don't actually have any extended characters in.

Thanks
Dan

View 1 Replies View Related

Upgrading From SQL Server 6.0

Jul 29, 1998

All the documentation I have read talks about upgrading from SQL Server 6.x. I presume I can use the upgrade wizard to upgrade my 6.0 system directly to 7.0 without having to upgrade to 6.5 first.

Any thoughts, comments or help would be much appreciated.

View 4 Replies View Related

Upgrading From SQL6.5 To 7.0

Dec 7, 1998

Hi all :

Does the upgrade wizard in 7.0 help me upgrade ALL the database objects in SQL 6.5 (including stored procedures, triggers) to 7.0? Has anyone encountered any problems?

Rnathan

View 1 Replies View Related

Upgrading From 7.0 To 2000

Feb 13, 2002

Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?

liz

View 2 Replies View Related

Upgrading SQL 6.5 To 7.0 Problem.

Jun 29, 2001

Have you ever faced a problem like this. I am running MS SQL Server 6.5 on Windows NT 4.0 computer whose name is with dashes (hou-is). Now, I try to update to version 7.0 and it gives me error message: @@nameserver from export 6.5 is not valid. Use sp_addserver and sp_netname.
How you can change a sql server name to non-dash name in order to complete the upgrade sql server?
I know this is a challenging tech question.
I appreciate your tech expertise.

Vinh Nguyen from Houston, TX.

View 2 Replies View Related







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