SQL 6.5 And SQL 7.0 On Same Machine
Jul 17, 1998
I have SQL 6.5 running just fine on my development server and 6.5 on my production server (which I will not tinker with) but I create summary tables on the development server and transfer them to the production server, this is what I do not want to damage. But, I want to know if I can install Beta 3 to run concurrent with 6.5 or somehow operate 6.5 from 7.0 without damaging the ability to restore 6.5 databases and transfer summar tables to another 6.5 server. I`m asking this because monthly I get a database dump, restore it on my side, do my hashing of the data, and then transfer summary talbes to another server where it`s available to be queried from the web with Cold Fusion.
Please let me know.
P.S. I have 7.0 beta 3 running at home and found that it had removed to 6.5 application group, but when I start 7.0 manager it shows the 6.5 server but I cannot access it for some reason. I didn`t upgrade any databases.
View 1 Replies
ADVERTISEMENT
May 4, 2007
Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as
Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )
The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Thanks!
View 4 Replies
View Related
Nov 28, 2006
Hi All,
I have enterprise version software CD1 and CD2 of SQL server 2005
when i try to run setup.exe..the following error pops -up
The image file Setup.exe is valid, but is for a machine type other than the current machine
MY OS version is windows 2003 32bit Operating system...
I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software
Thanks for your Help
Mohan
View 4 Replies
View Related
Nov 16, 2006
Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
View 2 Replies
View Related
Oct 2, 2000
Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...
View 1 Replies
View Related
Jul 23, 2005
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
View 1 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from login:passw@machineb.dabatase.dbo.customers
thanks!
View 2 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from loginassw@machineb.dabatase.dbo.customers
thanks!
View 6 Replies
View Related
Oct 23, 2006
Hi,
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
From "ServerMachine" or from "ClientMachine"
Thanks
View 3 Replies
View Related
Jul 13, 2007
Hi Guys,
I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.
Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.
So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?
It would be great if someone can show me the links to kb article. Thanks
View 1 Replies
View Related
Jun 30, 2006
Dear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
View 1 Replies
View Related
Aug 30, 2007
Can we have Reporting Services having its database on a server and distribution server (http://IISserver/Reports)
on another server?We dont want our database server to have IIS and dont want SqlServer installed on our IIS server
kind regards
View 4 Replies
View Related
Jul 11, 2007
Hi
I'm trying to set up replication from one SQL server to another.
The publishing server is not a member of a domain and is located in a hosting center (but we have full control over the server). I can set up a Snapshot publication just fine.
The subscribing server is located in another remote location and is a member of a domain. Here I can also set up the subscription without errors.
The errors, I think, comes when the snapshot is about to be created, the error is, on the publisher server:
[298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [SQLSTATE 28000]
And the snapshot is not created.
Is it even possible to set up replication like this. I need to transfer the data from one sql server to another so we have a working "backup" so to speek if the other server does not respond.
View 1 Replies
View Related
Sep 7, 2000
I want to know if there are any issues installing SQL 6.5 and 7.0 on the same server? I know that it can be done and that you cannot have them both running at the same time (at least if you're trying to use the default IP port). I just want to if there are any consideration other than just running the install normally. The server already has 6.5 on it and I want to add 7.0 to it.
--Buddy
View 1 Replies
View Related
Jun 4, 1999
I noticed one of the other messages said it was O.K. to put SQL 6.5 & 7 on the same machine. But, are there any issues/concerns that should be addressed before this is done.
View 1 Replies
View Related
Feb 15, 2006
hai i want the name of the system which executes a SP in sql server is it possible. by using this i can log data by keeping this request is done by person from this machine.
is this possible.
Any one help me.
Thanx in advance.
View 6 Replies
View Related
Jul 20, 2005
Hello,I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machinewith 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power.I do NOT load the DB in any way with queries. Obviously this leads toall kinds of software not working well anymore. Does anyone know how tolower the CPU power used? Please help!?regards,Pierre VerbakelThe Netherlands
View 3 Replies
View Related
Apr 21, 2008
can we install SQL Server 2005 x32 and SQL Server 2005 x64 on same machine with Windows 2003 Ent x64 OS?
many thanks
View 5 Replies
View Related
Feb 22, 2004
Hi,
I have developed an application using SQl Server 2000.
I want to transfer the database to my new server. I want all the tables and datas to be transferred.
I am new to this application. So i am not able to get mysel started. Can someone help me in this problem.
My database is large. It has stored procedures, database diagrams.
Any help in this regard would be highly appreciated.
Thanks,
-sriram
View 6 Replies
View Related
Jun 14, 2005
Hi,i have developed an web-database enabled application, wherein the admin will be importing the data from a remote machine to the server.Is it possible to run the DTS remotely? Also, is there need to install the sqlserver in the remote machine on which the admin is working ? i mean to say, other than server, do i need to install sqlserver on the remote machine too..Thanx in advance
View 9 Replies
View Related
Feb 23, 2001
Hi,
I have to buy a new machine for SQL 7.0/NT.
I know the db size it's going to have.
How can I get what machine configuration I should suggest.
I mean...what should be the RAM/HDD size/etc..?
We are expecting around 40hits/day?
Anyone have any idea?
Please suggest.
Thanking you.!
View 1 Replies
View Related
Aug 4, 2000
i want to a backup a database on a different machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.
any suggestions plz!
thanks.
View 4 Replies
View Related
Aug 7, 2000
Hi,
i want to take a backup a database which is on a different machine to my machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.
Anyone could tell me how to do it step by step plz.
Thanks.
View 2 Replies
View Related
Oct 11, 2000
I am trying to open some DTS packages from another machine, I see the list but when I try to open one and I get the error: The Parameter is incorrect
I have look at permissions and everything looks good. (I can view about 2 out of 20 packages all packages have the same owner.)
Any would be great.
Thanks
Jacqi
View 1 Replies
View Related
Dec 27, 1999
Hi:
We have DTS packages that are scheduled to run on the 1st of every month. Our clients have decided to turn off their machines on the 31st of December. What will happen to the scheduled packeages when the machine is turned back on?
Is there a queue they are put in so that they'll run when the machine comes back up OR is an alert generated and the package scheduling automatically sets the execution for next month??
We are running MSSQL 7.0 SP1 on NT 4.0 SP5.
Any replies will be greatly appreciated.
Thanks,
Nishi
View 2 Replies
View Related
Aug 17, 2000
I am migrating a web server which support two web sites ( with 2 IP addresses). Both the sites have a database associated with it. I am sure one of them is using SQL 7. Now I was told that the other is using SQL6.5. I know you can have both SQL6.5 and 7 on the same machine. But can you get them running at same time? Any feedback is greatly appreciated.
View 4 Replies
View Related
Nov 4, 1999
Are there any issues with retaining both the SQL 6.5 and SQL 7.0 clients as
installed components on our desktops? We have a number of SQL 6.5 and 7.0
Servers which have some fairly specific client side requirements and I am
trying to ascertain what the potential impact is to rolling out SQL 7.0
components to a separate directory to allow all applications to coexist. My
specific concerns are with the shared DLL's in system32 and with updated
7.0 executables that share the same name (i.e. BCP, etc) and resultant path
issues.
Any feedback or articles that cover this subject would be appreciated.
Thanks,
A
View 2 Replies
View Related
Feb 16, 2001
Hi,
I have changed the machine name (NT server 4.0) from test to test1. When I reboot the machine I get the error that Your SQL server installation is either corrupt or has been tampered with (Unknown package id), please run setup) Now do anybody knows about this, My SQL services on test1 are not starting. Is there any fix to this problem or we have to reinstall the server again...please let me know.
Thanks
AJay Deshpande
View 1 Replies
View Related
Oct 16, 2006
I am new to SQL and am linking tables from an Access GUI. Once my application is up and running do I need to create my SQL server on a machine that only houses the SQL, or can it be used as a general server with other applications on it that are not SQL server based? Did I make any sense at all with this question?
Mike
View 2 Replies
View Related
Jan 5, 2004
Hi,
I have installed msde on a 98 machine and so far I have no problem getting the msde running. However, when I run my application, which tries to connect to the msde, it gives me two errors --
1.) Method "OpenConnection" of object "_CurrentProject" failed
2.) Couldn't find the database on the server. Object failed.
I have checked and the database name is correct. I have also installed MDAC 2.8 on that machine.
I am running out of ideas and hope that maybe somebody in the forum has seem this problem before and may be able to give me a hand.
Thanks
SHK
View 2 Replies
View Related
Mar 29, 2007
I wrote trigger to insert old data before update or delete .
Now while inserting i want to insert userid and machine id
for user id ia tried the following query as
SELECT CURRENT_USER;
it retuns o/p as dbo
Please give me solution
Malathi Rao
View 3 Replies
View Related
May 20, 2007
Hi,
we are implementing full text search in our database, but I have a problem while trying to do this in another machine.
In one server in was OK, and this command was running for some time:
EXEC sp_fulltext_table 'accounts', 'Start_change_tracking'
GO
But in another server where I want to do, it's being finished very fast the execution of the script for full text.
CAN YOU PLEASE SUGGEST WHERE THE PROBLEM CAN BE? IS THERE ADDITIONAL CONFIGURATION IN OPERATING SYSTEM OR SQL THAT I SHOULD ENABLE, OR ANY ADDITIONAL SERVIVICE I SHOULD START?
Thank you,
BaniSQL
View 2 Replies
View Related
