I Want To Run .sql File In MSDE
Sep 27, 2004I want to run .sql file without using query analyzer in sql server
how to do that
ADVERTISEMENT
Open MDF File Without MSDE
Mar 22, 2006Hello,I'm trying to access .mdf file (a sql server database) without havingSQL Server installed on the machine (neither MSDE).It can be done from any programming language (like Java or C#)?Is there anyone who knows how can I do it?Or does a native library that can access the .mdf file exist?Thank to anyone who can help me...Pietro.
View 1 Replies View RelatedConnecting To MSDE W/read Only File?
Jul 23, 2005Hi,Does anyone know how I can connect to an MSDE db using VB with aread-only file? The file will be on a CD, and is actually just archiveddata off a SQL server. I would like to package my app on a CD alongwith the data file and allow users to pop in the CD and run the app,assuming they already have MSDE running. Any help?Thanks,Jason
View 1 Replies View RelatedLog File - Failed MSDE SP4 Installation
May 15, 2006Hi,
I tried installing MSDE SP4 on a windows 2000 Server.
Unable to deploy..getting error "The instance name specified is invalid"
Then tried installing with the following;
setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*v C:MSDELog.log
The log files indicates;
1] SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}
Loading extended custom action library C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}sqlcax.dll
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Attempting to change the service (MSSQLSERVER) path to : C:mssql7Binnsqlservr.exe -sMSSQLSERVER
MSI (s) (F8:30) [14:32:27:328]: Executing op: ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (F8:30) [14:32:27:328]: Executing op: CustomActionSchedule(Action=InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Source=BinaryData,Target=InstallPerfMon,)
MSI (s) (F8:D4) [14:32:27:328]: Invoking remote custom action. DLL: C:WINNTInstallerMSI313.tmp, Entrypoint: InstallPerfMon
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}
Loading extended custom action library C:DOCUME~1 hp-mgbLOCALS~1Temp{E09B48B5-E141-427A-AB0C-D3605127224A}sqlcax.dll
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 14:32:27: InstallFinalize. Return value 3.
2] MSI (s) (F8:30) [14:32:38:656]: Executing op: ActionStart(Name=RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (F8:30) [14:32:38:656]: Executing op: CustomActionRollback(Action=RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (F8:68) [14:32:38:656]: Invoking remote custom action. DLL: C:WINNTInstallerMSI316.tmp, Entrypoint: DeferProperties
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (F8:30) [14:32:38:796]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (F8:30) [14:32:38:796]: Error in rollback skipped.Return: 5
MSI (s) (F8:30) [14:32:38:796]: Unlocking Server
MSI (s) (F8:30) [14:32:38:812]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 14:32:38: INSTALL. Return value 3.
3] Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = C:Documents and Settings hp-mgbDesktopMSDE Patchpatch filesMSDESetup
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
MSI (s) (F8:30) [14:32:38:984]: MainEngineThread is returning 1603
MSI (s) (F8:2C) [14:32:39:000]: Destroying RemoteAPI object.
MSI (s) (F8:68) [14:32:39:000]: Custom Action Manager thread ending.
MSI (c) (24:FC) [14:32:39:046]: Back from server. Return value: 1603
MSI (c) (24:FC) [14:32:39:046]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 14:32:39: INSTALL. Return value 3.
and finally
MSI (c) (24:FC) [14:32:39:078]: Note: 1: 1729
MSI (c) (24:FC) [14:32:39:078]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (24:FC) [14:32:39:078]: Grabbed execution mutex.
MSI (c) (24:FC) [14:32:39:078]: Cleaning up uninstalled install packages, if any exist
MSI (c) (24:FC) [14:32:39:078]: MainEngineThread is returning 1603
Please suggest me whats wrong with the installation.
Regards,
Parveen
Get Local Machine Name In MSDE Setup .bat File
Nov 5, 2003I 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
Problem:MS-Access.adp With MSDE Link To Csv File
Jul 20, 2005Hi. I'm coming from a background of developing mdbs and am trying to migrateour databases to adps running atop MSDE 2000. However, I've encountered aproblem while trying to do analogous things to what I've done before withmdbs...for example:-Linking to a csv file on another machine: I am able to establish a linkuning the 'Link Table Wizard' that shows up as a new view. However, uponopenning the view I see only a single column (left-most).What am I missing here?James
View 1 Replies View RelatedHow To Load A Flat Text File Into MSDE / SQL Server
Mar 27, 2001Hi!
How do I load a comma-delimited text file into MSDE? How does it work for SQL Server 7?
Thanks,
Helmut
MSDE Text Datatype - Unable To Store More Than 900 Characters. (msde + Visual Studio 2003)
Jun 6, 2005Hello,
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.
How Do I Change The Name Of A Computer Running MSDE With Out Reinstalling MSDE
May 27, 2000I 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"
MSDE: Renaming Machine Without Reinstall Of MSDE
Mar 27, 2001We 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
MSDE Worth Using Or Should I Invest In MySQL? (was MSDE)
Mar 9, 2005I'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?
Editing Data In MSDE Data File From Outside Editor
Dec 20, 2006Hi All,
Is it possible for someone to open a msde data file in an editor (text or hex) and modify the data, then save the file back to the filesystem?
I would think this would not be allowed but I want to confirm or see if anyone has had any experiences of someone doing something like this?
Thanks.
Chris
Reporting Services :: Parsing SSRS Config File And Dynamically Changing File Path Of Config File In Code
Sep 2, 2015Currently have a single hard coded file path to the SSRS config file which parses the file and provides the reporting services web service url. Â My question is how would i run this same query against 100s of servers that may or may not share the same file path as the one hard coded ?
Is there a way to query the registry to find the location of the config file of any server ? which could be on D, E, F, H, etc.Â
I know I can string together the address followed by "reports" and named instance if needed, but some instances may not have used the default virtual directory name (Reports).
Am I going about this the hard way ? Is there a location where the web service url exists in a table ? I could not locate anything in the Reporting service database. Basically need to inventory all of my reporting services url's.
File Will Not Attach To SQL Reason File Is Not Primary File
May 10, 2007I have a customer they are running raid 5 on a windows 2000 server one of the drives went bad. The customer replaced the drive and raid rebuilt the drive, every thing seamed to be fine but there is one database file that cannot be attached to SQL. The file is 15G so I know there is information the error states that the file is not a Primary file. Any clue on how to fix this?
mdf file size 5,738,944 KB
ldf file size 10,176 KB
An Attempt To Attach An Auto-named Database For File (file Location).../Database.mdf Failed. A Database With The Same Name Exists, Or Specified File Cannot Be Opened, Or It Is Located On UNC Share.
Sep 2, 2007Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
MSDE
Nov 15, 2003I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
Need Help With MSDE(anybody)
Nov 18, 2003Hi
I have visual studio .net and i recently installed MSDE specific for visual studio.
The name of my server is FRANKNETSDK.
String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();
I created an instance which is NETSDK
I created a password
I don't know why my server choose the name FRANK i was expecting local.
I have to use FRANKNETSDK or else i can't get my server to Start.
This is the error: Login failed for user 'FRANKASPNET'.
[SqlException: Login failed for user 'FRANKASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Any help would greatly be appreciated.
Need Help With Msde(please Anyone)
Nov 22, 2003Hi
For quite some time nowI have been trying to give user rights to my MSDE , needless to say the fruits of my labor have turned up very little success.
So far i have tried using the osql commands to grant user access to my database. I have run the stored procedures(sp_grantlogin ,sp_grantdbaccess ) but to little avail!
So now i have taken a new approach i installed the Enterprise Manager. I have just a minor problem with this new strategy , i don't know how to use it!!
This is what i have prensently installed on my system: Visual studio.Net ,Microsoft SQL(MSDE)
and finally the Enterprise Manager.
My Servername is FRANK.
I have created an instance which is NetSDK (FRANKNETSDK)
My SAPWD is Kildare
I have Mixed Mode
Can anyone please tell me how i can use the Enterprise Manager to grant access to MSDE.
I am sure you have all realized from all these insipid post that i have no experience.
So please be explicit in all your details.
My email roti@videotron.ca
Thank you
Frank
MSDE
Jan 17, 2004Having Problem connecting to Database with WebMatrix
When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?
Any Help/Advice TIA
Tristen
MSDE Help
Jan 31, 2004I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:
A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.
I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.
MSDE
Mar 19, 2004How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.
New In MSDE, Please Help!
Aug 25, 2004Hi,
I am newbie in ASP.NET and MSDE arena. I understand that MSDE has no GUI and I need to have MSDE tools to work with it. I have already installed ASP.NET 1.1 and Microsoft.NET SDK 1.1 and MSDE in my Windown Professional 2000 PC and I have run and tested for .aspx and its working perfectly. But I want to use MSDE to create some database driven web applications.
Could you please help me how I can do that? BTW, I installed Microsoft SQL Web Data Administrator and its giving me SQLWebAdminStart.exe Application error and asking for debugging while opening the program. I am stranded what to do now?
I really appreciate your help.
regards,
Peter-Toronto
(Linux, PHP, MySQL)
Help Me Set Up Msde
Sep 6, 2004I just installed MSDE off of disk that came with teach yourself asp.net in 24 hours. To get the program started you must go to run and type cmd and wait for the C prompt. I get this far, but I can't get a C prompt. It always comes up C:sql2ksp3> How do I get a C prompt from here. I know it must be something easy that I am just overlooking or forgot.
Thanks
Del Dobbs
NEED HELP WITH MSDE!!!!!
Feb 27, 2005Hi ,
I m trying to install MSDE database at my machine to Test my queries and page so i can upload them. I did changed the Path and added osql. and all that things. Its still giving me an error. Which is
" Server Error in '/QuickStart/aspplus/samples/grocertogo/VB' Application.
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. "
not sure what exactly to do. Also if have SQL server runing on remote machine is there any other way i can check my pages. Any help wikk be greatfull. Many thanx in advance
KHan
Using MSDE
Mar 4, 2005Hi all,
I have a web application that uses SQL Server. I have 6 clients that all use the same SQL Server database structure.
I know have a new client who is using MSDE as there Database. The Database should have the same table structures as the SQL ones.
So my questions are this:
1. I have a backup of the new clients data. How do I attach it to SQL Server?
2. Does MSDE have stored procedures?
3. Can I write stored procedures in a SQL Database, that reference tables in an MSDE database.
4. Can someone point me in a direction, that can walk me through this?
Thanks
Scott
Using MSDE
Apr 2, 2005Hi,
Well i want to ask, Is this true that
We can use the MSDE on commercial basis for a limited usagage with out paying.
The limited usage means that may be upto 20 - 25 concurent users can be use the Engine at a time.
thx for the comments
MSDE
Oct 24, 2005I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?
View 2 Replies View RelatedMSDE
Nov 23, 2005Hello,
Is it possible that i have my webapplication on a webserver and my database on another server?The database is MSDE.Thanks for your respond
MSDE
Dec 29, 2005I want to connect to the MSDE database and create database and tables etc.., I am successful in creating the database and tabels etc.., as shown below:
string ConnString;
ConnString = "data source=(local);" +
"database=;integrated security=sspi";
SqlConnection SqlConn = new SqlConnection(ConnString);SqlConn.Open();
SqlCommand SqlCmd = new SqlCommand("Create DATABASE dbase1", SqlConn);SqlCmd.ExecuteNonQuery();SqlConn.Close();
but Instead of connecting to the MSDE without giving any database name,canI create the instance of MSDE on the fly and connect to it. Like creating a MSDE OBject to start the MSDE and then connect to it using Windows NT authentication
MSDE And W98
Dec 21, 2001How do you deal with MSDE on a W98 machine since it can not run as a service?
View 1 Replies View RelatedMSDE
Nov 19, 2001Hi,
I have developed a site for a client using asp and sql server, and now want to roll this out to the client using MSDE, since the only application using the database will be the website, so they really don't need full sql server.
I've seen plenty of articles telling me how this is possible, but I can't find anything telling me how to start.
The webserver will be on the client site, and controlled by myself as this is an intranet application.
Do I install MSDE on the client site from my Microsoft CD's or do I install particular files, and that's just for starters.If anyone has done something similar I would really appreciate their advice.
Regds Paul McGirr
Msde
Jul 15, 2004Hi,
Please guide me.
All our customers have sybase as thier backend and VB as thier front end and now we want to migrate to SQL server. So I have to send a CD to our customers with the free SQL version(MSDE) and everything has to be automated.My CD shud be able to install MSDE in the clients machine and create the schema and transfer the data from thier db to our .mdf(MSDE DB-Free SQL server version) db.
Can the above be achecived thru installshield.I have install shield xpress 2.1.
I even have the .SQL script files to create the schema.
Can anyone guide me the best approach to proceed with this.
Very urgent
Thanks
Msde
Jan 24, 2005Hi Yar,
This might seem like a silly question but please bare with a newbie. I've discovered a few MSDE installations around the place, & most are on a RTM version. I know no -one else cares about them as they came with small apps. But I would like someone to confirm or deny that they are just as vunerable as any other SQL installation i.e. std edition & should apply the Service Packs ?
Cheers
Suze