MS SQL Server :: NEWBIE.. SQL EXPRESS Attach During VB.NET Windows Application Install

MSDE Install On Windows 2003 SP1 Application Server

May 23, 2006

I am trying to install MSDE 2.8 on this OS. When I try to install, I receive the following error: Fatal error setup This setup does not support installing on this operating system

Any ideas?

View 4 Replies View Related

NEWBIE: How Do I Embed And Quietly Install Sqlserver Express On A User's Machine Without Their Intervention?

Feb 23, 2007

Hello,

I am kind of new with .Net development and really new with using SqlExpress. Here is my question, I hope it is easy:

I have a shareware program that I have been selling since 2000 and it was written in VB6 using a third party database program. What I would like to do is rewrite this application using C# and SqlServer Express. The program as it stands right now is about 5mb to download and install.

My concerns:

1) How do I embed and quietly install sqlserver express to the end user's computer without them having any intervention?

2) By using sqlserver express as my database how much extra overhead is going to be included in the install package? I want to keep the install package as small as possible and the user experience of installing the program as painless as possible.

Thanks in advance,

View 8 Replies View Related

Insert Arabic Text To Sql Express 2005 (windows Application)

Jul 17, 2007

Hi,

I need your help guys. Am devolving a windows application by c#. I have problem of insert Arabic text to sql express 2005. I always get ???? instead of the Arabic letters. I change the collation of the database field to windows collation and choose Arabic but still I get the same problem.

Your help is appreciated

View 7 Replies View Related

SQL Express Install And Windows Firewall

Apr 22, 2008

I am trying to install SQl express as part of a custom app.I have been able to use the template.ini to pass in all the parameters and install. installs fine,however the installation isnt browseable by remote machines due to the sqlserver.exe and sqlbrowser.exe not being in the windows firewall list. How can i add then to this list automatically at install time? or is there another way around this?

View 1 Replies View Related

Install Sql Server 2005 Express On 64 Bit Windows

Jun 2, 2006

I am trying to install sql server 2005 express on 64 bit windows but i get a error message saying SQLncli_x64.msi file is missing and asks me to download it.

How can i fix this problem to install the SQL server on my Windows XP x64 Edition?

View 28 Replies View Related

How To Install Express 2014 LocalDB On Windows 8.1

May 30, 2015

I've developed an application that uses SQL server (in particular localdb), and, I have just pushed it out to the client.

The client runs Windows 8.1 x64, but, when I try to install either x86 or x64 version of SQL LocalDB direct from Microsoft, I keep getting this error:

Microsoft
SQL Server 2014 Express LocalDB

Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.

I am using LocalDB on my Windows 8.1 dev machine.... .Net framework 3.5 and 4 are both installed already.

How can I resolve this?

View 3 Replies View Related

SQL Express Install Error On Windows 2k Professional SP4...please Help

Dec 6, 2006

Hello all,

This is my first time posting, so be gentle as I'm not exactly sure what the protocol here is regarding posting errors.

I'm encountering an issue with an installation of SQL 2005 Express (SQLEXPR_ADV.EXE) on a Windows 2000 Professional SP4 machine (Intel P4 1.8 Ghz). The following error is what I receive:

Setup.exe - Entry point not found:

The procedure entry point _create_local could not be located in the dynamic link library mscvr80.dll

< OK >

The following is what I see in the error log (C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles):

SQLSetup0007_SQL2005TEST_Core.log

Microsoft SQL Server 2005 Setup beginning at Wed Dec 06 11:28:08 2006
Process ID : 452
c:98b179fcf692887ac3setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/11/6 11:28:7
Complete: LoadResourcesAction at: 2006/11/6 11:28:7, returned true
Running: ParseBootstrapOptionsAction at: 2006/11/6 11:28:7
Loaded DLL:c:98b179fcf692887ac3xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/11/6 11:28:8, returned true
Running: ValidateWinNTAction at: 2006/11/6 11:28:8
Complete: ValidateWinNTAction at: 2006/11/6 11:28:8, returned true
Running: ValidateMinOSAction at: 2006/11/6 11:28:8
Complete: ValidateMinOSAction at: 2006/11/6 11:28:8, returned true
Running: PerformSCCAction at: 2006/11/6 11:28:8
Complete: PerformSCCAction at: 2006/11/6 11:28:8, returned true
Running: ActivateLoggingAction at: 2006/11/6 11:28:8
Complete: ActivateLoggingAction at: 2006/11/6 11:28:8, returned true
Running: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8
Complete: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__452" returned false.
Running: PerformSCCAction2 at: 2006/11/6 11:28:8
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/11/6 11:28:8, returned true
Running: PerformDotNetCheck at: 2006/11/6 11:28:8
Complete: PerformDotNetCheck at: 2006/11/6 11:28:8, returned true
Running: ComponentUpdateAction at: 2006/11/6 11:28:8
Complete: ComponentUpdateAction at: 2006/11/6 11:45:55, returned true
Running: DetectLocalBootstrapAction at: 2006/11/6 11:45:55
Complete: DetectLocalBootstrapAction at: 2006/11/6 11:45:55, returned true
Running: LaunchLocalBootstrapAction at: 2006/11/6 11:45:55
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 128
Aborting queue processing as nested installer has completed
Message pump returning: 128

Notice the time jump; I did this to make sure I was looking at the right log file.

Any help is greatly appreciated as I'll be monitoring this thread closely. Searches of my error show that other people have received it as well, although no resolution has ever been forthcoming. Thanks in advance.

View 3 Replies View Related

Is It Possible To Install Msde 2005 Express On Windows Xp Limited Account?

Nov 27, 2006

Hi,

I would like to know is it possible to installing sql 2005 express edition on windows xp with limited account. I tried to install it. After installing, the service can not start. Is there any thing that I misconfigured?

Thanks for reading and answering my post.

View 3 Replies View Related

FAILED Again! Express Fails To Install On Windows Server 2003

Dec 17, 2006

VERY frustrating. I have tried uninstalling. removing regietry keys. removing with the windows unistaller etc... to NO avial. See my Core.Log:

Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 3221225477
Aborting queue processing as nested installer has completed
Message pump returning: 3221225477

And my Core(local).log:

Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : -1073741819
Error Code: -1073741819
Windows Error Text: Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Mon Jan 16 02:06:13 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3140

Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0014_APPS_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0014.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/11/17 1:32:51
Message pump returning: 3221225477

PLEASE Help.

Rich

View 7 Replies View Related

How To Install Windows Application(C#) With SQLExpress In A System Which Is Having SQLExpress Already?

Jan 19, 2007

Hi All,

I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.

If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.

But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.

Can anybody help me out .

Regards,

Doppalapudi.

View 2 Replies View Related

Steps To Install SQL Server Express (&& Reporting Serivces) On 64 Bit Windows Vista Ultimate

Apr 13, 2007

Steps to install SSX (& Reporting Serivces) on 64 bit Windows Vista Ultimate

I struggled quite a bit over the past few days to complete this install. The sequence of steps is less obvious than those for Windows XP Pro on a 32 bit machine.

I recorded all the steps in one place in cookbook style for non-technical (but database capable) users like myself. I have referenced appropriate other postings and sources for detail steps. These are steps I found useful, you may be in a different situation.

My environment is as follows:
-New HP dv9000 w/ 2GHz and 2GB memory
-Factory installed Windows Vista Ultimate. Note this includes .NET Framework 2.0 so I did not have to deal with installing that.
-I have no extant databases or SQL Server that I am trying to convert or upgrade!

Setup Steps Before Install:
1) Turn off User Account Control.
At present, I am a one-user operation with close control over my system and there seemed to be issues with getting reporting services set up right with UAC. I may come back and modify this step later on and certainly would change this for any releasable systems.

1a)Go to Control Panel Home --> User Accounts --> Turn User Account Control on or off.
1b)Unselect Use User Acount Control.
2)Set up your IIS 7.0 for Reporting Services.
IIS 7.0 has IIS 6.0 Compatibility features turned off out of the box. You will turn them on with this step. This is needed for both Reporting services and to enable the Adminscripts that are used in Step 3 below.

2a) Use the Control Panel --> Programs --> Turn Windows features on and off function.
This is quite nicely desribed with screen shots at:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957
These steps worked for me although they are labeled Vista Beta 2.

3)Set up your 64 bit machine to run 32 bit ASP.NET
This capability is needed to make sure you pass the System Configuration Check for Reporting Services. I don't know the full implications of this step and wonder if it might eventually bite me if I have to flip-flop between 32 and 64 bit ASP.NET or have them both run at the same time.

3a) Open a command line window by:
Start --> Accessories -- Cmd Prompt
3b) In this window type:
cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

At some point, you may wish to go back to 64 bit. For that, see the posting by MihaelaE as an Answer in the SQL Server Reporting Services Forum under a thread started by fagster on 3/8/2007.

Now to actually install SQL Server.

1) Download the 64 bit SSX.
This step fooled me for a while as the 64-bit downloads are 'below the fold' on the web page.

1a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/

1b) Scroll down the page and below Step 5, Register, you will see this text which takes you to the download you want:
"* For the 64-bit install of SQL Server 2005 Express Edition, click here."
1c) Follow the "click here" to get the download.

2) Install the package from step 1c and you will get SQL Server Express.

2a) The install may fail and complain about not finding a valid SQL Server Native Client Install, sqlncli_x64.msi. You will have to extract the files manually and then run the sqlncli_64.msi package by itself. Then you can go back to step 2 and should be successful.
To do this, see post of Mike Wachal on 4/5/2007 to SQL Server Express Forum, titled "Cannot Install SQL Server Express on Vista Ultimate -- cannot find MS SQL Server Native Client".

3) Now add in the SQL Server Management Studio Express 64 bit version.

3a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/

3b) Scroll down the page and below Step 5, Register you will see this text which takes you to the download you want:
"* For the 64-bit install of SQL Server 2005 Management Studio Express, click here."

3c) Follow the "click here" to get the download.

4) Now add the SQL Server Reporting Services.

4a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/

4b) Scroll to Step 3 Download and Install (in the middle of the page) and download SQL Server Express Edition with Advanced Services SP2.
4c) Install, but at the Feature Selection screen, disable all components EXCEPT Reporting Services. You already have the other components installed.
4d) In the install, you will get a screen called "Report Server Installation Options". Go ahead and select the "Install but do not configure the server" radio button.

5) Go ahead and configure SQL Server Reporting Services.
I'm not highly skilled in this area so I recommend the SQL Server Express Video "Learning Video 10: Getting Started with Reporting Services". This is found at: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
I found this video to be cogent and useful.

That's what it took me to get SQL Server Express installed with reporting services on a 64 bit Vista Ultimate system. Sorry if this is so long but I wanted to cover all the steps that hung me up.

To forum moderators: If I have any errors that will lead people astray, I'm more than happy to correct them.

This posting is "AS IS" with no warrantees and caveat emptor.

View 1 Replies View Related

Problem To Install SQL 2005 Express In Windows 2003 Server Standard Edition X64

May 10, 2006

I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems.

It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64.

I Check all request systems requirements many times and looks ok.

How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express.

Regards

Leandro

View 1 Replies View Related

Problem While Installing SQL Server 2005 Express Edition On Windows 2000 PRO SP4...Can't Install!!!

Mar 14, 2007

Hi everyone...

I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4.

After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation.

I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else???

Thank you all,

HERE IS THE LOG FILE:

"Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007
Process ID : 2684
c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/14 7:45:33
Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33
Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text:
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2"

View 4 Replies View Related

Package Execution Fails In Windows Service But Runs Fine As A Windows Application.

Jun 23, 2006

I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.

The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.

Again, the app will run all packages just fine. The data is imported and the results return as "Success."

The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)

Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult

pkgLocation = sPackageFolder & PackageName & ".dtsx"

pkg = app.LoadPackage(pkgLocation, Nothing)

Dim vars As Variables = pkg.Variables

vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath

pkgResults = pkg.Execute()

View 3 Replies View Related

SQL Server Express Edition Fails To Install On Windows Server 2003, R2, SP2

Mar 21, 2008

I cant figure out why this is happening.. its a fresh 2003 x64 R2 sp2
server, during the installation of the SQL Server Database Services the server hangs
and displays Setting File Security. I let the install run for over 45 mins and it still hangs... the log file is useless..
i cant find any clues as to why ...

any thoughts..

View 2 Replies View Related

How To Install Sql 2005 Server Express On Windows Server 2003 X64 Edition

Feb 25, 2008

hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition.
because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net
, when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....."
any idea?

View 1 Replies View Related

Setup Issue: Unable To Install SQL Server 2005 Express On Windows 2003 Server SP2

Aug 17, 2006

Hello Experts,

I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.

Click here for image

So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.

Click here for image

Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?

How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.

Help! :(

View 1 Replies View Related

How To Suppress Dialog [Install Xxx Using The Default Application Install Directory?] ?

Dec 7, 2006

I have compile my application into a Smart Device CAB and also including SQLCE CAB file for SQL.

I have users who choose to install SQLCE into Storage Cards instead and causes the application not to function, when asked which destination to install.

I've done some search and found out about "wceload.exe /noaskdest" but I'm using NSIS to compile into a single .exe file, and its calling "CEAppMgr.exe"

How can I force SQLCE to install into its default directory without asking user?

Thanks!

View 3 Replies View Related

Can't Attach A Database During An Install

Apr 27, 2007

I have a Wise for Windows Installer package that will install SQL Express 2005 and then attach a database. In order to keep consistent I am placing the new .MDF file in C:Program FilesMicrosoft SQL ServerMSSQL$INSTANCEdata. If the folders don't exists I create them. Well, on one test machine I create the folder and copy the MDF to the directory and then use 'osql' to attach the database but I am getting this error:

Msg 5173, Level 16, State 1, Server SREXROAT2FHMOBILE, Line 1 One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. Msg 1813, Level 16, State 2, Server [COMPUTERNAME], Line 1 Could not open new database '[DATABASE NAME]'. CREATE DATABASE is aborted. Log file '[LOG FILE NAME]' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.

Does anyone know how to get around this? It works on our other test machines with the same database.

View 4 Replies View Related

Newbie Problem Using Windows Groups And Schema

Aug 29, 2006

I created a Windows Group in Active Directory ("Database1Users"). populated it with users, and planned to allow everyone in it to have access to a sql 2005 database.

I went to the sql server, Security (at the general level), Logins, New login, and created the Login "<domain name>Database1Users". I assigned "Database1" as Default database, selected the database and assigned it to the above user name (which is actually a group name). I also typed in a default schema of "dbo" and gave the user account the role "db_owner" (just learning....) . Pressing OK gave me this error message:

>>>>

The DEFAULT_SCHEMA clause can not be used with a Windows Group or with principals mapped to certificates or an asymmetric keys."

>>>>

Oh..... how am I supposed to map a Windows group to give the users the access they need?

TIA,

barkingdog

View 1 Replies View Related

HELP: Newbie Install. Can't Register Server.

Dec 19, 1998

I have installed SQL6.5 on my NT4.0 server.
I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:

"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"

The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL.
I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb

View 1 Replies View Related

Install Help For SQL Server 2005 Newbie

Feb 28, 2006

I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.

While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.

I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.

Thanks for your help.

Steve

View 1 Replies View Related

Newbie - Sa Password Error After ACT! Install - Need Pro's Help!!!

Aug 16, 2006

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

View 9 Replies View Related

Newbie - New Install Client Config Problem

Feb 13, 2000

Hi,

I've just set up a new installation of SQL 7 in a WinNT4/sp5 machine so I can learn more about this stuff and I'm trying to configure a Win98 client. From the Win98 client all looks well on the surface. Interestingly when I click on the server from within the Win98 MMC/Enterprise Manager it attempts to establish a dial-up connection to my ISP. The only network protocol I have running is TCP/IP.

Also, I can do what ever I want from within Enterprise Manager and SQL Analyzer but if I attempt to execute a script using the OSQL utility at a dos prompt as follows

osql /Usa /P /i "c:sqlimplexercisech02myscript2.sql"

I get the following error

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).

Any clues as to what I need to do to straighten this out? I have a DSN for the server which tests successfully using TCP/IP on the default port 1433.

View 2 Replies View Related

Can Not Attach Msde2000 Db Into Sql Express

Jun 19, 2007

I have side by side msde2000 and sqlexpress installed. I need to move a db that has been detached from msde2000 and where it works perfectly fine into sql express. After I select the .mdf file to attach I get this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'LTBAHIASQLEXPRESS'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x55555551). It occurred during a read of page (1:97) in database ID 6 at offset 0x000000000c2000 in file 'C:Memo2005DiaryMEMOinMEMOsql.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Converting database 'MEMOsql' from version 539 to the current version 611.
Database 'MEMOsql' running the upgrade step from version 539 to version 551. (Microsoft SQL Server, Error: 824)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=824&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Thanks for any help,

Luis

View 6 Replies View Related

Newbie Question- SQL Server 2005 Management Studio(how To Install SISS)

Nov 1, 2007

Hi all,

Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.

Wee

View 5 Replies View Related

Windows Application With MSDE

Jun 28, 2004

I am developing a windows application that will run on every client station. This application will refer to a database located on a server station. Can I use MSDE for such application and if so how many remote concurrent connection can be open simultaneously?

Eric

View 1 Replies View Related

VS2005 And C# Windows Application

Nov 8, 2006

I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI.

The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) .

I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the projects Reference dialog. These were also copied to the bin folder of the project

sqlceca30.dll

The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.

sqlcecompact30.dll

Provides the compact database functionality. Required if your application will use compaction.

sqlceer30[language].dll

Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.

sqlceme30.dll

Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.

sqlceoledb30.dll

Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.

sqlceqp30.dll

The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.

sqlcese30.dll

I also added using System.Data.SqlCE to the form and the dataset designer.cs

From this code in the dateset.Designer.cs file after the run is started the eroror occurs.

[System.Diagnostics.DebuggerNonUserCodeAttribute()]

private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {

get {

if ((this._adapter == null)) {

this.InitAdapter(); Error on this line....

}

return this._adapter;

Already tried this

http://msdn2.microsoft.com/en-us/library/ms171861.aspx

Is it possible to fix this? Or work around it?

Thanks Jon Stroh

View 3 Replies View Related

My SQL Application On Windows Mobile 5

Jan 30, 2006

Hi

My application :

On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB

I synchronise my DBs through ActivSync.

It runs good before Windows Mobile 5.

My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.

So what are my solutions ?

My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....

Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?

Joël

View 6 Replies View Related

Windows Application Log Settings

Jan 16, 2008

Is there a way to control some of the windows application log settings from within the logging process of a package. Specifically the 'source' parameter which comes out as 'SQLISPackage' which i'd like to be the actual name of the package which wrote to the log, and similarly 'Category' which comes out as 'none' and I'd prefer to assign something more meaniful ?

THX

View 1 Replies View Related

Attach Db To Sql 2005 Express Edition

Sep 13, 2007

My dog ate my sql2000 installation disk! After a recent xp installation I remembered that.
Now I'm in a hurry to get up and running with SQL again. I've installed SQL server 2005 express, but I can't attach any databases, or really do anything for that matter. I have a copy of SQL Server 2005 enterprise edition but that won't install on my development machine, Xp Sp2. Which way should I go, install SQL 2005 enterprise on a Win 2003 server or can I download something to administer the express version?
As always thanks for any and all replies!
/Eskil

View 1 Replies View Related

Unable To Attach SQL Express Database

Apr 19, 2008

Hello,
I have a SQL Express database created with VWD 2005 and I want to attach it to the server using the SQL Server Management Studio. It is not the first time when I attach a database, but now, I don't know from what reason, it is not working anymore. So, I copy/paste the mdf and ldf files from the website location (the SQL Server Management Studio is not opening the folder C:usersmyuser in Vista Home Premium, don't know why) to a new location and try to attach. The error message is:
TITLE: Microsoft SQL Server Management Studio Express------------------------------
Attach database failed for Server 'GEORGE-PCSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Unable to open the physical file "E:SQLaria.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
------------------------------BUTTONS:
OK------------------------------
The file location is OK, what can I do?

Thanks.

View 1 Replies View Related

NEWBIE.. SQL EXPRESS Attach During VB.NET Windows Application Install - Oneclick