MSDE In 98 Machine

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


ADVERTISEMENT

MSDE: Renaming Machine Without Reinstall Of MSDE

Mar 27, 2001

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

View 3 Replies View Related

SQL Server && MSDE On Same Machine?

Jul 23, 2005

Can an individual computer be configured contain both a SQL Serverinstance & an MSDE instance?Our software we charge separate costs depending if they are running ona MSDE or SQL Server edition, and if they already have SQL Serverrunning (which they may have installed for some other application), canwe install our MSDE instance on the same machine?And on the flip side, if they already have a machine that has an MSDEinstance, can the SQL Server install be done over top of that withoutaffecting the MSDE?Thanks for any help,GregJoin Bytes!

View 1 Replies View Related

MSDE And SQL2K On Same Machine?

Aug 16, 2006

Can I have MSDE and SQL2K installed on the same machine?



Thanks

Mary

View 4 Replies View Related

Pervasive SQL && MSDE On The Same Machine

Nov 28, 2007

Is it possible to run MSDE and Pervasive SQL on the same machine ?
If possible but not recommended I'd really appreciate the reasons why it should not be done.
If not possible I'd also really appreciate hearing why.

Thanks in advance.

View 4 Replies View Related

MSDE && SQL Server 2000 On The Same Machine !

Aug 13, 2004

Hi all,

I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.

Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.

I still have databases on the MSDE.

My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?

Can i uninstall MSDE safely since i already installed SQL Server 2000 ?

Please let me know.

Thank You
:-)

View 2 Replies View Related

How To Run A Sql Script On A MSDE Installed Machine?

Dec 7, 1999

Hi everyone,

I have MSDE install on my machine with Office 2000. I have a sql script(db.sql) that create the database(db1) and its objects. I would like to run this script on this machine. Is there a utility like SQL ISQL.exe in the MSDE version?

Thanks in advance...

Thanks...
cobenho@my-deja.com

View 2 Replies View Related

Changing Machine Names MSDE

Mar 11, 2006

I have a local install of MSDE on my workstation. I have also defined alinked server with another SQL Server on our network. I accepted all thedefaults when I installed MSDE and the server got named my machine name.Everything is working great.Our IT department now needs to change my machine name. What effect willthis have on my current SQL installation?Help and suggestions appreciated.Thanks,Frank*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

Get Local Machine Name In MSDE Setup .bat File

Nov 5, 2003

I have the following command in a .bat file

osql -E -S localhost sp_grantlogin 'GREGASPNET'"

What I would like to do is replace GREG with the name of the local computer this .bat file is being run on.

Is there any string for this... i.e [LOCALMACHINE]ASPNET or something like that?

Greg

View 1 Replies View Related

Is It Possible To Get MSDE && SQL Server 2005 Express Run On The Same Machine?

Dec 27, 2006

Hi guys,

I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.

Thanks in advance.

View 5 Replies View Related

MSDE 2000 And SQL 2005 Express On The Same Machine

Jul 26, 2007

Hi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar

View 1 Replies View Related

Can I Access MSDE On A Remote Machine With Enterprise Manager?

Sep 22, 2007

We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).

I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.

exec sp_grantlogin @name
go

exec sp_addsrvrolemember @name, 'sysadmin'

But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.

What gives??? Is it just not possible, or am I missing something here?

My goal is to just be able to see the data stored in the MSDE db. Write views, etc...

Please advise,

Marc

View 2 Replies View Related

Ssis Package Hangs On Script Transformation When Running On One Machine Not Developing Machine

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

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

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

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

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

Running A Stored Proc On A Standalone Machine From Another Machine In A Domain

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

Copying Database From 2000Server Machine To 2003 Server Machine

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

Select Data From 2000 Machine From A 2005 Machine

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

Select Data From 2000 Machine From A 2005 Machine

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

GetDate() - From Server Machine Or Client Machine ?

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

Migrating SQL 2005 Test Machine To New Machine

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

MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)

Jun 6, 2005

Hello,

I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters. 
I'm trying to setup a news database for my website, which will populate
the information into a datagrid.  To test, I manually added a news
item in the database through the visual studio 2003 gui.  I
immediately noticed a problem as the I was getting an error after a
long news item saying:

"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."

I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column.  As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.

I would appreciate someone leading me in the right direction on this one.

Thanks a lot.

View 1 Replies View Related

How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE

May 27, 2000

I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.

My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"

View 1 Replies View Related

MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)

Mar 9, 2005

I'm not sure if this is the correct forum for this this question but I'll give it a shot.

The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?

View 4 Replies View Related

Coredll.lib(COREDLL.dll) : Fatal Error LNK1112: Module Machine Type 'THUMB' Conflicts With Target Machine Type 'ARM'

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

Is This Possible:Report Db Is On A Machine And IIS Is On An Other Machine

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

Replication From Machine Not In Domain To Machine In A Domain

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

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 View Related

SQL 6.5 And 7.0 On The Same Machine

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

SQL 6.5 & 7 On The Same Machine

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

How To Get Machine Name.

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

MS SQL Uses 100% Of My 2 CPU Machine

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

X64 And X32 On Same Machine

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







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