How Prevent The Local Administrator To Read The Content Of The Database
Hi everybody,
I have an application in dotnet that uses sql express.
This application will be deployed on the user computer and I have to find a way to prevent the user to be able to read the data and access the structure of the database.
Is there a way to do this ? Even if the user is a local administrator of the computer ?
That's a difficult question, isn't it ? ;-))))
Thank you for your possible ideas,
Ciao,
Aurore
View Complete Forum Thread with Replies
Related Forum Messages:
How To Read The Content Of DTS Local Package?
I create a local package in DTS a few months ago. And set a schedule to run daily. Now i need to modify. How to read the content of DTS local package? i try to right click the package in job, and edit, but i didn't see the content. How can i see it and modify. Why mine can't be read? Thanks.
View Replies !
How To Prevent System Administrator To View And Edit A Database Structure And Data
I represent a software development house and we have developed a client server system based on SQL Server. Most of our customers have already purchased Enterprise License of SQL Server, therefore they own the SA Login and Password. We are bound to attach our Database with their Server on their machine. My question is how can we stop a System Administrator of SQL Server to view our Database Structure, Queries, Data installed on their SQL Server on their machine. Our database structure is a trade secret and we cant reveal the structure to the client. please answer this question by email to me at farhandotcom@gmail.com Thanks & Regards Farhan
View Replies !
SQL Server Administrator And Local Administrator
Please help! I am new in SQL Server 2000 Administration. My manager had ask me to manage a SQL Server, but Windows Adminstrator refuse to give me Local Admin rights. I only have sa account to login to databases. I don't know any excuses or reasons to give to Windows Adminstrator so that he can give me the local admin rights. If any one have this answer, please help. Thank you. -JC
View Replies !
Read Text File From SQL Server, Read Its Content, And Load It In RichTextBox (Related Component: Context.Response.BinaryWrite(), And StreamReader)
OBJECTIVE: I would like to read a text file from SQL Server 2000, read the text file content, and load its conntents in a RichTextBoxTHINGS I'VE DONE AND HAVE WORKING:1) I've successfully load a text file (ex: textFile.txt) in sql server database table column (with datatype Image) 2) I've also able to load the file using a Handler as below: using System;using System.Web;using System.Data.SqlClient;public class HandlerImage : IHttpHandler {string connectionString;public void ProcessRequest (HttpContext context) {connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["NWS_ScheduleSQL2000"].ConnectionString;int ImageID = Convert.ToInt32(context.Request.QueryString["id"]);SqlConnection myConnection = new SqlConnection(connectionString);string Command = "SELECT [Image], Image_Type FROM Images WHERE Image_Id=@Image_Id";SqlCommand cmd = new SqlCommand(Command, myConnection);cmd.Parameters.Add("@Image_Id", System.Data.SqlDbType.Int).Value = ImageID;SqlDataReader dr;myConnection.Open(); cmd.Prepare(); dr = cmd.ExecuteReader();if (dr.Read()){ //WRITE IMAGE TO THE BROWSERcontext.Response.ContentType = dr["Image_Type"].ToString();context.Response.BinaryWrite((byte[])dr["Image"]);}myConnection.Close();}public bool IsReusable {get {return false;}}}'>'> <a href='<%# "HandlerDocument.ashx?id=" + Eval("Doc_ID") %>'>File </a>- Click on this link, I'll be able to download or view the file WHAT I WANT TO DO, BUT HAVE PROBLEM:- I would like to be able to read CONTENT of this file and load it in a string as belowStreamReader SR = new StreamReader()SR = File.Open("File.txt");String contentText = SR.Readline();txtBox.text = contentText;BUT THIS ONLY WORK FOR files in the server.I would like to be able to read FILE CONTENTS from SQL Server.PLEASE HELP. I really appreciate it.
View Replies !
Local Administrator To Northern Virginia
If there is a local Administrator to the Tyson's Corner area I need help with Administrating my custom App hosted on SQLServer 2005. Must be local, secure server can only be worked on from my site. Can be done in your off hours. Call me David if you are interested 800.230.5331 or email david.jed@knowledgesystemsllc.com
View Replies !
SQL Server How To Prevent Locking To Do Read-Only Reports
Need some information regarding SQL Server locking.Requirement is to run SQL Statements for reports (read-only) that willnot lock-out other people trying to update (write lock). For this, wetried the following to make the db connection not deny write locks(our report code will not have a read-only lock).ADODB.ConnectionObj.Mode =adModeShareDenyNoneBut this made our connection bumped whenever someone tried to update.Tried enabling dirty reads by doing:ADODB.ConnectionObj.IsolationLevel =adXactBrowseEven this made our connection bumped whenever someone tried to update.Is there a way to achieve what is needed without having a seperatedatabase for reports?
View Replies !
Reset Database Files From Read-only To Read-write
I have two database files, one .mdf and one .ndf. The creator of these files has marked them readonly. I want to "attach" these files to a new database, but cannot do so because they are read-only. I get this message: Server: Msg 3415, Level 16, State 2, Line 1 Database 'TestSprintLD2' is read-only or has read-only files and must be made writable before it can be upgraded. What command(s) are needed to make these files read_write? thanks
View Replies !
Not Able To Connect To The Local Database With (local) As Server Name
I am facing a problem in connecting to the local database with server name as (local). I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally. if anyone can help me what is the problem in this case it is highly appriciated.
View Replies !
Need Help - Local Synchronization Between SQL Mobile And Local SQL Database
Hi Everyone I am at the stage of architecting my solution My goal is to develop the system on a windows application and pda There is a central server which will create a publication called inventory The laptops which host the windows application will be subscribers to the central server using merge replication The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server I have been reading for days and I am still unsure whether this is possible to do. I know Appforge provide a conduit for palm to access synchronization but not local sql databases I would appreciate your help immensley
View Replies !
Stubborn Database Administrator
Hi,At my company we've got a stubborn database administrator who wants the SQL Server to be restarted each night. This has a performance-cause.Is it necesarry to restart the SQL Server regularly?With regards,ThaYoung1!
View Replies !
Need To Prevent Database Assembly Creation
On certain servers, I don't want developers to be able to create assemblies. Unfortunately, the command sp_configure 'clr enabled', 0 only prevents the CLR-type from being executed, not its creation. I am unable to rename nor put triggers on sys.assemblies, sys.assembly_modules, sys.assembly_files, and sys.assembly_references . I would prefer the user know the boundaries well before implementation. Has anyone succeeded at this?
View Replies !
Sql Server And Oracle 8.0 Database Administrator
Hi Friends, If anyone looking for a SQlserver+ Oracle8.0 database administrator for their company please contact me. I am a Senior level SqL server Dba with Junior level experience administering Oracle8.0. I am a MCSE With Microsoft Sql 6.5 administration as one of my electives(completed in 1997). I have trained on Oracle8.0 database administration, Backup Recovery,database& sql tuning by Oracle Co-op. I have also been trained on Unix Sunsolaris System administration1 and System administration2 by Sun Micro System. I have completed the 'database administration in 8.0','backup and recovery' OCP exams. I will be sitting for the sql and plsql exams very soon. I would prefer to work for a company where they have both SQL Server and Oracle. I am also ready to work as a Junior Oracle Database Administrator if they have only Oracle. I have about 5-6 months experience in working with Oracle8.0 and prior to that I was a SQL Server DBA for a long time, If anyone knows that some body looking for such a person Please feel free to contact me. Note: I don't need any Sponcership. I live in MA, USA. I Thank you all very much and hoping to hear from you soon.
View Replies !
How To Prevent The Insertion Of The Same Entry Of An Unique Value Into The Database
how to prevent the insertion of the same entry of an unique value into the database? assume that I have a primary key username " abc" in the database and then I insert the "abc" again ,the debuggging error msg pops out saying the primary key cannot be duplicated.. how can I do an if--else statement to check the database against this unintentional inputs of the same unique data " abc"???
View Replies !
Prevent SQL Connections During Database Schema Upgrade
Hello, We utilise SQL scripts, executed via sqlcmd.exe, to upgrade the schema and common data of our database(s) when we deploy new versions of our software to a production site. At the moment we simply wait until after hours to do the upgrade and ask nicely for all users to not use the system for a while. Obviously, asking nicely doesn't always work, and there is also the issue of scheduled server tasks and web services / web sites that operate against the database 24/7. What are our options for putting the entire server (or preferrably just one database) into a semi-offline state so that users and services cannot connect to it while our script connects and performs the upgrade? I imagine there may be several approaches each with their own pros and cons. If you could point me in the right direction or perhaps mention what strategy has worked for you, it would be greatly appreciated. We perform these upgrades from hundreds of kilometers away via VPNs and Remote Desktop so we can't just unplug the network cable :). Thank you. Regards, - Jason
View Replies !
How To Store A Content Into Database
Hi everyone, I'm just using TEXTBOX control to save data into my DB. My question is, if I have multiple lines of sentences, it does not store as what it looks like. For example; Hello, Mike It stores into the database as "Hello, Mike" and if I read from the database, it does not have seperate lines and shows it like this; Hello, Mike How can I store the contents into database and make the contents as original? (Sorry for the poor English, but I hope you understand it.)
View Replies !
Merge Database Content
hi,i have a sqlserver CE and a sqlserver database.The tables are exactly the same on both databases.the sqlserver CE database Content will be synchronized with thesqlserver database with insert orders..is there a way to merge the two databases?this would be great cause different content will be inserted in bothdatabases. After a synchronisation both databases should have the samecontent..i hope you understood my problem. my english is not very well..christian
View Replies !
Formatting Database Content
HiI have set up a SQL database to contain alist FAQ's for our company andthen plan to pull this info off using a web page.So far I have entered the data but I am unable to control how it isdisplayed inside SQL ie I cannot enter new blank lines I have triedusing lots of spaces but this does not work when I use the website todisplay the info.Is there a way of formatting and editing the data in the sql databaseas I am unable to do this, if I try to edit the data in the database Ihave to copy it to notepad delete what is in the database, edit thetext in notepad then paste it back in.There must be a better way.Please helpalamb200
View Replies !
Web Content Database. Is There A Limit?
HiI've developed a simple web service that lets people easily set up their ownwebsites, and keep them up-to-date themselves.I'm storing all the content, including images in the SQL 2000 database. Sofar it's working well enough. Is there likely to be a performance orreliability problem as the system grows?You can see it in operation here: www.up-to-the-minute.comIt's early days and any comments and ideas are welcome.John SouthPangbourne UK
View Replies !
Senior Database Administrator, Toronto, Canada
NeoEdge Networkswww.neoedge.comWe're looking for a Senior Database Administrator, for our office inToronto, Ontario Canada.Position Description· Responsible for ongoing development and tuning of Data TierDatabases (MS SQL Server 2005) and the C# API to the databaseExperience managing large scale, high concurrency, live, productiondatabases (i.e., security, clustering, monitoring, maintainingrespectable uptime, applying upgrades and patches with minimaldowntime, etc.)· Experience managing physical aspects of databases (i.e., file,disk,server, data center, backups, etc.)· Proven experience developing object-relational persistenceframeworkand/or using various commercial/open source frameworks (ideally basedon ado.net)· Proven ability to troubleshoot and fix blocking, deadlockingandperformance problems· Responsible for development/maintenance of existing reportinginfrastructure using Reporting Services 2005· Experience with the architecture, design and development ofDataWarehouses and Business Intelligence tools· SQL Server 2005 DBA Certification/experience a plusRequired Skills· Minimum 4 years commercial development using MS SQL Server -muchof this experience should be focused on developing, deploying andoperating large, highly reliable databases with particular emphasis onidentifying and resolving performance problems - this experienceshould include time spent implementing and executing day to day DBAtasks - experience defining, evaluating and recommending appropriatedatabase hardware is very desirable· Hands on experience using Reporting Services 2005, IntegrationServices 2005 and Analysis Services 2005· Minimum 1 year commercial development experience in .NET usingC#· Minimum 1 year commercial development experience in .NETFramework1.0 and 1.1 System.Data.SqlClient interface to MS SQL Server· Minimum 1 year commercial development experience is large scalemulti-threaded and distributed systems ideally with an operationalfocus· Hands on experience implementing, maintaining and monitoringSQLServer 2005 Transactional Replication, Log Shipping and DatabaseMirroring.Nice To Have Skills· Oracle, IBM DB2 or MySQL DBA experience· Programming experience w/ other DB APIs (i.e., JDBC, ODBC,etc.)Education· 4 year Bachelors Degree in Computer Science, ComputerEngineering orequivalentPlease email Justine at Join Bytes! with your resume andcovering letter.
View Replies !
Web Administrator Tool - Unable To Connect To SQL Server Database.
I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database". I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message. I am using web developer 2008 and SQL Server 2005. Please advice me how to tackle this problem. Thank you.
View Replies !
Senior Infrastructure Database Administrator - Calgary, Canada
I am a SQL Server DBA Manager and my employer (Symantec) will beopening a position in the near future (20-60 days) for my DBA team.Here is the job description:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Sr Security Infrastructure AdmCalgary, CanadaConsultingJob DutiesSenior Infrastructure Database Administrator will work as part of aDBA team that provides 24x7 support of all technical aspects MS SQLServer in a 100+ server enterprise environment. Primary support andduties are performed during standard business hours, however 24 houron-call support during off hours and weekends is required on arotation schedule.The production environment is an OLTP 1000+ distributed databasesystem, consisting of databases ranging in size from small-medium toVLDBs (>400 gig). DBA responsibilities include:·Automation of MS SQL Server maintenance and alerting.·Implement and maintain database security.·Monitor failed and long running MS SQL Server jobs.·Monitor, tune, and analyze database performance and allocate serverresources to achieve optimum database performance.·Support and maintenance of MS SQL Server Log Shipping.·Support and maintenance of MS SQL Server Transactional Replication.·Setup new MS SQL Server instances and databases.·Documentation of MS SQL Server system environment, setup,maintenance and standards.·Capacity planning of MS SQL Servers.·Work closely with technically savvy users and developer to resolvedatabase production problems.RequirementsEducation and training:Symantec's managed security service is seeking an experiencedcandidate with a minimum of 3 years experience administering MS SQLServer. Bachelors in Computer Science or similar Engineering Degree;can substitute 4-6 years of experience in the IT field. Must haveknowledge of MS SQL Sever best practices. MCSE/MCDBA is desirable.Required Skills:·Strong understanding of major components of MS SQL Serverarchitecture.·Hands on experience with SQL Enterprise Manager, Query Analyzer,Profiler, Data Transformation Services.·Strong experience in database Backup, Restore and Recoveryprocedures.·Strong SQL programming skills including, developing & testing T-SQLstored procedures & queries.·Strong understanding of relational database modeling and design.·Experience in tuning and analyzing SQL Server databases forperformance.·Performance monitoring experience using Windows Performance Monitorand MS SQL Server Profiler.·Candidates must have excellent trouble shooting skills.·Other Skills:Ability to work both independently and as a part of a team.Strong desire and passion to learn new technologies.Fluent in English language good written and verbal skills.Good problem solving and documentation skills.Ability to perform challenging assignments under general supervision.Demonstrated commitment to quality.Desirable/bonus Skills (for additional consideration):·Knowledge of Windows 2000 operating systems and SQL server in aclustered environment are advantageous.·Knowledge of Dimensional modeling and OLAP services in a datawarehousing environment is a plus.·Knowledge of networking and systems security.------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------We are flexible on some of the jobs requirements (e.g. yearsexperience). If one has solid MS SQL Server skills (depth ofknowledge) and a decent command of the English language your have meetthe minimal requirements.If you are interested send me an email at:Join Bytes! or Join Bytes!.Recruiters please do not contact me.Thanks,Sean Powell
View Replies !
Looking For A SQL Database Administrator With Working Knowledge Of SQL Server 2002
This is a permanent/full-time position based at Simi Valley, CA, 93062 Please see the enclosed job description: Primary Responsibilities Include: This position demands a Microsoft SQL Server Database Administrator in a Production DBA role with a working knowledge of Microsoft Clustering and operating systems. The candidate should be proficient in trouble shooting, performance tuning, replication and backup/recovery strategies. The individual should possess excellent communication, facilitation and negotiation skills. The individual must be comfortable adapting to a rapidly moving client focus and must be adept at multitasking. Knowledge and expertise in SQL high availability and EMC SAN environment is a plus. The individual has to support a distributed application for users in multiple locations and therefore should possess strong problem solving, debugging and database maintenance skills. Also critical would be the ability to manage change and effectively test fixes and enhancements and adhere to SDLC principles. The individual will provide SQL Server database administration (DBA) support and technical support for multiple applications in development, integration test, user acceptance test, quality assurance, performance and production environments. The position will consist of both systems and application DBA administration responsibilities for large-scale SQL Server databases on multiple clustered and non-clustered Windows platforms. Database duties include: Database creation and configuration, performance tuning, code migration, disk space management, database backups, database performance and resource monitoring, and trouble shooting. Other duties include creation of backup plans, test disaster recovery scenarios, manage security and spec out hardware requests from business units. The individual must have senior level experience managing Microsoft SQL Server 2000 databases and experience with Analysis Services, OLAP and Data Warehouse. Working knowledge of SQL Server 2005 The individual must have strong communication skills, both verbal and written. Additionally, the individual must be able to work in teams consisting not only of their peers, but representatives from our applications development and operations teams, who in effect are our customers. The DBA will have overall responsibility to ensure work is performed, including tasks assigned to multiple DBAs. The DBA will be the primary attendee at project meetings, and must work well with application developers and managers, especially when differing opinions occur over technical approaches. The DBA is expected to be an effective influencer, having good collaborative skills, and be effective at implementing our standards, policies, and procedures. The DBA also must have a broad knowledge of the technical aspects of SQL Server databases where client applications use .NET Framework with Visual Basic, Visual C++ and Visual C# based code and middle-ware such as WebSphere and IIS. Besides strong skills in Database Administration, preference will be given to individuals with working knowledge and experience in EMC SAN technologies, HP/Compaq Hardware, NetIQ AppManager, Remedy, Symantec/Veritas NetBackup and Microsoft Operations Manager. The individual will be assigned on-call responsibilities on a rotational basis, which often requires work after normal business hours. A Successful Candidate Will Have: Requirements: Bachelors€™ degree in Business or Computer Science or equivalent work experience. Microsoft Certification as MCDBA is a plus. Minimum 5+ years experience in SQL Server Database Management. Strong Windows OS skills. Strong technical understanding of Microsoft SQL Server 2000 internals. Technical understanding of prior SQL Server versions including 6.5 and 7.0. Broad knowledge in various backup and recovery methodology's (NetBackup a plus) Strong skills / understanding of database performance factor, monitoring tools and recovery procedures. Strong analytical skills in fault detection and resolution. Strong skills in DBMS maintenance tools. Team work orientation a must. Strong people / customer skills a must. The Ideal Candidate May Also Possess: Post-graduate degree If you are interested, please send your Updated Resume in Word Format and the following details as soon as possible. 1. How quickly can you start? 2. What is your expected salary? 3. Is location OK? Do you need to relocate? 4. If hired, will you be able to provide documentation of your eligibility to work in the US for all employers? 5. If requested, would you be able to provide 2-3 professional references? 6. Best time to call you and your contact numbers. If you have any questions do not hesitate to contact us. We look forward to hearing from you soon. Karthy Nair Technical Recruiter Hartwell Global €“ People Are Our Business! Karthy@HartwellGlobal.com Ph: 818-338-3240 Ext: 319 31194 La Baya Dr Ste 202 Westlake Village, CA 91362 http://www.hartwellglobal.com
View Replies !
Insert Text File Content Into Database
Hello everyone!I'm having a problem with inserting the content of a text file into a Sql Server 2005 database.I'm reading the text file into a dataset, and works fine. What I can't do is what I suspect is the simple part: Insert all the data into a table that has exactly the same configuration that the file. I've never worked with dataset's before, and I can't seem to find the answer to this!This is what I have done so far: Dim i2 As Integer Dim j As Integer Dim File As String = Server.MapPath("..DocsFactsFORM_MAN_V3_1.txt") Dim TableName As String = "Facts" Dim delimiter As String = "9" Dim result As DataSet = New DataSet() Dim s As StreamReader = New StreamReader(File) Dim columns As String() = s.ReadLine().Split(Chr(9)) result.Tables.Add(TableName) Dim strs1 As String() = columns For i2 = 0 To CInt(strs1.Length) - 1 Dim col As String = strs1(i2) Dim added As Boolean = False Dim [next] As String = "" Dim i As Integer = 0 While Not added Dim columnname As String = String.Concat(col, [next]) columnname = columnname.Replace(Chr(9), "") If Not result.Tables(TableName).Columns.Contains(columnname) Then result.Tables(TableName).Columns.Add(columnname) added = True Else i += 1 [next] = String.Concat("_", i.ToString()) End If End While Next i2 Dim strs2 As String() = s.ReadToEnd().Split(Chr(13) & Chr(10).ToString()) For j = 0 To CInt(strs2.Length) - 1 Dim items As String() = strs2(j).Split(Chr(9)) result.Tables(TableName).Rows.Add(items) Next j So now I have my dataset populated with all the information, but how can I insert it into the database?If anyone can help I would appreciate very, very much!Thank you Paula
View Replies !
OT: How Can I Copy Database Content To Another SQL Database?
Hey guys,I am looking for a simple method that would allow me to complete thecomplete contents of one SQL database into another SQL database. Ihave a test data with the exact same table structure as my Livedatabase. I want the test to be a mirror copy of the Live.I thought I might just delete my test database, and then restore theLive backup as my test database. Unfortunately I hit a briak wallbecause it tells me that users are logged into the test database. Howcan I find out who is logged into the database?Would it be easier to write a SQL script? Thanks!
View Replies !
How Do I Quickly Populate A New Database With Place-holder Content?
I am using SQL server to create a rather complicated client database for a nonprofit organization. I have access to an ancient version of the database in Access format, but would rather create a new database from scratch instead of "up-sizing" the old database. Although the old database is mostly useless, it contains a goldmine of names and addresses that I could use to populate the new database that I'm creating. My question is this: Is there any relatively easy way to cut and paste from external data sources into a new SQL database? For example, I would love to just select twenty rows of "first names" from the old database and then paste that into my new table. Can anyone suggest any quick and easy tricks for populating a new database with place-holder content? Thanks!
View Replies !
Sample Database Schemas - More Cool Learning Content For You!
(Thanks to the hard-working SQL Marketing guys and our community team for getting these samples together. - Mike) Are you a new SQL Server DBA? Learn the basics with these SQL Server Express Starter Data Schemas! Take advantage of these fully-functional data schemas designed for new database administrators to quickly learning the basics of managing and administering SQL Server Express in real-world environments. These starter data schemas cover a wide-range of scenarios so you can quickly and easily deploy SQL Server Express within your organization. In addition, they can be easily modified and extended to suite your individual needs. The list of available SQL Server Express starter data schemas include: § Customers and Orders § Assets Maintenance § Help Desk § Retail Inventory Control § And more €¦ Each data schema includes SQL Server Express scripts, a sample database and database schema. There€™s even a training video available for beginners to learn how data schemas relate in a real-world database environment, including a step-by-step guide on how to build a data schema! Get started today by visiting the MSDN SQL Server Express Starter Data Schemas page.
View Replies !
Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive
Being a very novice SQL Server administrator, I need to ask the experts a question. How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions? Thanks, Rick
View Replies !
Store Blog Post Content In Text File Or Database?
Hi. I am currently building a blog application, and I need some advice... I have the post title, post date, post by, etc stored in a database table, however I was wondering whether I should store the actual post content in the database as well or in a text file. For example, if the posts get really long would it slow down database performance or would there not be much of a difference? Furthermore, if I wanted to keep the posts private, a text file would not be ideal as it can be accessed easily by surfers... What do you recommend?Thanks a lot
View Replies !
Access Database Synchroniser Fails With 'incorrect Format Or Content'
I've installed ADS on a windows mobile 5.0 device and am trying to run the sample Wizard application. It connects to the test database on the device OK, but fails to connect to the database on the desktop with the error: "The HTTP request failed due to incorrect format or content. Try restarting the IIS server" I've tried changing the port from 1024 in case it was already in use, but this doesn't change the error. Nor does restarting IIS (v5.1). IIS appears to be running correctly on the desktop. Any ideas what to try next? thanks irs
View Replies !
Northwind Database In SQL Server Express Is Busted And Gone,after SqlCommand Fails In VB2005Express-How To Prevent It Happen?
Hi all, I tried to use dbo.tables of Northwind database in SQL Server Express to do SqlCommand to populate a DataTable in DataSet. The SqlCommand failed in the project execution and I found that Northwind database in SQL Server Express is busted and gone (just the name "Northwind" remained in the SQL Server Management Studio Express). How can I prevent it from happening in my "SqlCommand-SqlConnection" project? Please help and advise. I tried to repair my "Northwind" database by using the SQL2000SampleDb.msi of Northwind and pubs Sample Databases for SQL Server 2000 downloaded from the http://www.microsoft.com/downloads. My "pubs" database is still in my SQL Server Management Studio Express. How can I just repair my "Northwind" database by using the Microsoft SQL2000SampleDb.msi program? Please help and advise this matter too. Thanks in advance, Scott Chang
View Replies !
How Can I Copy The Content Of MS Access Table In Database SQL Using Visual Studio Basic
Code Snippet Hi there, I'm struggeling for more than a week now with this problem, without a finding the solution. I have two databases, MS Access and SQL Server 2005 Express Edition Using a procedure in Visual Studio i would like to copy all the records from one table in MS Access into an existing table in SQL Server (the tables have the same name and the same layout) I tried to prepare one Dataset to copy from Access into SQL Server but when i run the command 'DaSQL.Update(DsSQL, "Tabella") nothing happens (not even an exeption has been raised), looking during debug, the DataSet seems filled though... Please could anyone explain what's wrong and / or is there a more quicker way to copy data from a table to another? Note i woul have as a final goal to get data from an AS400 database by ODBC, manage it, and put it on SQL Server for a 'data mining' scope (eliminating the use of MS Access, not suited for FE-BE). the procedure goes like this; ' Create a connection to the MS Access Database Dim connectionToAccess As New OleDbConnection(DBConnectionAccString) strsql = "SELECT * FROM [TABELLA]" connectionToAccess.Open() Dim DaAccess As New OleDbDataAdapter(strsql, connectionToAccess) Dim DsAccess As New DataSet("ACCESS") DaAccess.FillSchema(DsAccess, SchemaType.Source, "Tabella") DaAccess.Fill(DsAccess, "Tabella") ' Create a connection to the SQL Database Dim connectionToSQL As New SqlConnection(DBConnectionSQLString) connectionToSQL.Open() Dim DaSQL As New SqlDataAdapter(strsql, connectionToSQL) Dim DsSQL As New DataSet("SQL") DaSQL.FillSchema(DsSQL, SchemaType.Source, "Tabella") DaSQL.Fill(DsAccess, "Tabella") DaSQL.Update(DsSQL, "Tabella") Note I tried also the following, withou a result; DsSQL = DsAccess.Copy DaSQL.Update(DsSQL, "Tabella") Please is there someone who could respond !!???
View Replies !
Is There A Microsoft Document Exchange And Database System Like Lotus Notes Or Oracle Managment Content?
Hello,I work for an attorney staff, so basically the whole day they aresending themselves a lot and a lot of papers (Word docs or Excellsheets).We are going to propose them the use of a Document Exchange andDatabase System (like Lotus Notes or Oracle Managment Content,formerly known as Internet File System IFS ) with .NET interfazes.Basically the idea is that instead of sending papers the whole day,they can use a software to check and manage more quickly theirdocuments.We are looking for a system that allows us to manage:- Security- Versioning- Folders- Check-in/Check-out- Workflow- Search and Retrieval- Extensible MetadataMy question is:1) Is there any Microsoft tool who can help us to achieve that(management of codes, dates, text, names of documents- I mean like aDocument Exchange and Database System) with .NET interface?2) Or do we have to built it from scratch?Thank you very much!Jorge
View Replies !
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =======================================================
View Replies !
SQL Server Management Studio Express: Object Explorer - How To Re-attach The Content Of User-defined Database
Hi all, I just found that the content of my Database "ssmsExpressDB" is gone, but the name "ssmsExpressDB" remains in the Object Explorer of SQL Server Management Studio Express. If I delected the name "ssmsExpressDB" and executed the following .sql: exec sp_attach_db @dbname = N'ssmsExpressDB', @filename1 = N'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf', @filename2 = N'C:Program filesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB_log.LDF' GO I got the following error message: Msg 5120, Level 16, State 101, Line 1 Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDatassmsExpressDB.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". And I have closed all my projects and I do not know what " The process cannot access the file because it is being used by another process" is all about!? Please help and tell me how I can re-attach the content of my "ssmsExpressDB" in the Object Explorer of SQL Server Management Studio Express. Thanks in advance, Scott Chang ==================================================================================== I found the "ssmsExpressDB" is being used by my VB 2005 Express project "Hello-SQLCLR-1": in the Database Explorer, Data Connections place. How can I put it back to the Object Explorer of SQL Server Management Studio Express? Please help and advise. =====================================================================================
View Replies !
Import Wizard - Using Query For Remote Database To Compare Local Database
I am trying to use the Import Wizard to setup a daily job to import new records based on an ID field (PK). The source database is remote and a replica. I am inserting new records to update my table called the same thing. Both are SQL Native Client Code Snippet select * from [CommWireless].[dbo].[iQclerk_SaleInvoicesAndProducts] as S1 join [IQ_REPLICA].[dbo].[iQclerk_SaleInvoicesAndProducts] as S2 on S1.SaleInvoiceID = S2.SaleInvoiceID where S1.SaleInvoiceID > S2.SaleInvoiceID When I parse the query, I keep getting an error message. Deferred prepare could not be completed. Statement(s) could not be prepared. Invalid object name 'IQ_REPLICA.dbo.iQ_SaleInvoicesAndProducts'. (Microsoft SQL Native Client) Anyone know an easy why to get this to work? Or should I add a create table to verify new records?
View Replies !
|
TRACKER
