Hi there SQL TEAM
Can someone please point me in the right direction?
We have a customer who would like us to write an application in flash that has a SQL 2005 Backend
Can Flash integrate with Microsoft sql 2005?
And if so are there any tutorials?
have query flash back facility in sqlserver 2005?
View 3 Replies View RelatedI have a utility I wrote which can backup/restore my database as wellas schedule backups. This has always worked pretty well except when Itry to backup to a USB Flash Disk. When I use one of these the backupfails. If I backup to the C:/ drive then copy it over to the disk itworks fine but when SQL Server tries to do it, it can't.I am simply doing the following:BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INITAnyone know what could be going wrong?
View 3 Replies View RelatedHi,
I hope somebody here can help on my problem.
I wrote a MFC application using sql ce and is running prefectly smooth on wince and PPC 2003.
But when i deploy it to Windows Mobile, the database performance drop dramatically.
I knows the drop on performance is due to the I/O speed on the flash memory.(The previous mobile os are using ram instead).
Is there any solution or work around which I can solve this problem.
Recently i solved the performance issues on "insert" to DB by using a commit buffer(Instead of commit to the sdf instantly).
But how about the "select" performance? It's too slow which take about 3 sec to select a record from the DB.
Does Microsoft provide any suggestion on the sqlce perofrmance on windows mobile?
Thanks
Keith
Hi,
I have a question about using SSCE with flash memory. Our CE components equally allocate the write access to the memory location. But write access is guaranteed only 10000 times per memory cell.
So I need to know
1. what changes are made to the file system if I add an entry to a table?
Is this entry the only information added to the file system?
2. What happens if I delete an entry? Will SSCE optimize the data in the filesystem?
Thanks a lot for helping.
Regards Flo
Hi friends, i want to know something abt sql server installation and database properties as under.1) how much disk space reqd by multiuser sqlserver 2000 db to install ?2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?3) When v create a database user Enterprise Manager , which files created by database ?4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?5) is it possible to create database on flash drive ? thanx in advance.
View 2 Replies View RelatedI am not sure if this is the right folder to post, but currently I'm considering using Flash as an interface, the application at www.mobik.com seems impressive, simple and sweet. But I'm wondering if I can build desktop application with flash and SQL2005 as backend for all the processing. at the same time, the flash shall be getting updates from a server. Possible?
View 4 Replies View RelatedI'm working on a project where the client wants us to create custom charts which have features not found in the standard Reporting Services charts. I would like to use flash to build this and have found an existing flash charting package for which I have the code and which I plan to expand.
Here's the problem:
The client wants to include these charts in his Reports. Is there some way to add a flash control to a report so that it will appear on the web page as a fully-functional flash presentation, which can then be included when printing or exporting?
The alternative, would be to figure out some means of generating the chart using flash outside of the report, exporting a bitmap of the chart and then saving the bitmap to a known location on the file system so It can be referenced by a report. This has some serious complications, and may not be feasible.
Any ideas?
Hello everyone,
I'm currently developping a windows .net compact framework application which is basically a local datalogger.
Since my application will log data to the database (located on compact flash card) a few times a second over long period, I wonder if SQL Server Compact Edition offers some mechanism to reduce disk access.
By example, can SQL Server compact edition wait let's say 5-10 "insert into" commands before actually write to the database located on the flash card ?.
Any ideas which could help me to reduce flash wear would be greatly appreciated !
Thanks
I want to copy a database in my company's computer to my flash driver.
Then I am going to copy this database to my home compuer.
What is the full procedure?
Thanks
Hello friends,
So, this is my senario...
i'm using SQL 2005 reporting service which reports are shown to the client from my web-site...
I've included a report viewer in my ASPX page through which i'm displaying the reports.
I wanted to know if their is any way by which i can embed a flash file in my report.
Secondly, i have some reports in which I have used the matrix control. And to display the headings of the columns i've created individual text-boxes & have made them overlap on the top region of the matrix.thoe these text boxoes are getting rendered in proper places when i preview the reports during design time, but when they get rendered in my website all the heading text-boxes get scattered all 'round the report......has anyone faced such weired problems & is there any alternate way of do'in the same ??
thanks in advance,
regards,
Rohan
Hi
Can someone please tell me if it is possible to insert a flash movie into MSSQL 2005 and if so what would be the most appropraite data type to use for this.
Any links to tutorials on how to uplaod such fiules would be appreciated
Cheers
Hi There,
Can I store flash files in the database. I have a table with one of the columns as varbinary datatype. Previously, I was saving images (as filebytes) into this column. But now I need to implement something to store the flash file. So, is it possible to store flash files in the database and retrieve them and display them in an asp.net page?
Thanks a lot for your suggestion!!
Hi
How to store flash files into the sql server 2000 database and again display them back in asp.net/C# user interface?thanks
I created a SQl Server 7 database and used an Access 97 frontend on the same computer. The Access frontend uses linked tables to reach the SQl server. The security setup I have is based on the NT Domain Accounts and whatever group
I have them in (example: Mr. D is in Marketing therefore he is in a NT Domain
Group called "SQL_MARKETING"...the SQL Server recognizes that everyone in this
group has access to whatever role I have designated for it in the database").
I can access the linked tables fine on my computer at my desk or at the server. Another person with the exact same administration rights as me can
get to the server through the network neigborhood or by mapping..and they
can access the Access frontend with no problem from their computer. But
when they try to open a linked table they recieve an error message that
the ODBC connection has failed. We are all running Access 97 service pack
2 and another person and me have the exact same administration..but only
I am able to access the Access linked SQL tables but not him.I tried deleting
the ODBC system dsn on the server and the linked tables and then re-adding them and the ODBC link but to no avail. Does anyone know why this would
be occuring? Thank You in advance.
and the
I have create an Excel application which connects to an SQL Server backend.I have written an Excel vba procedure to update a table via ADO.But it couldn't---the error message says the provider (sqloledb) does not support updating database.
View 2 Replies View RelatedWe are entertaining the idea of moving our data to a cloud and I need to know how to convert my Access backend DB to SQL. which version of SQL will I need to use to do the conversion and will also work in a cloud environment.
View 2 Replies View RelatedHi,
I have some knowledge of SSIS and CRM. But i don't know how to create Integration Service using CRM 3.0 as my external data source. If anybody know about this, pls give steps to create Integration Service as soon as possible.
Thanx in advance.
I have an exe file which was generated using a visualbasic application and has a backend sqlserver database. the exe works fine on my computer which is also connected to sqlserver and the same exe when i run on the clients computer does not work and gives an error ...related to converstion of datetime datatype ...
View 2 Replies View RelatedI have a database with a sql backend and an access frontend. I put it in a folder on the network for users to access. First, they were getting errors like not being able to access the database if someone else had it open and not being able to perform certain functionality. It was suggested that i put a mde on each of the users pc. i gave them all access to their own front ends on the folder because they use different pcs. this solved the problem. however, i need a way to perform updates without manually creating mdes for every user. i used to work for a co that there was one mde was put into a folder on the network with a config file. The users access the database through CITRIX. Whenever they accessed the shortcut on the server, it created the users their own front end. Whenever we need to provide updates, we simply made a new mde from the mdb and whenever the user accessed the database again, they would have the latest mde and it would created an update frontend for the user. Does anyone know of such an utility or know what I am referring too? I encounted several suggestions like a batch file; but they refer to putting the file and the mde on each users pc. This is not how i'm set up. Thanks
I add a table to sql studio express, but i cand see it in access backend in the other computer.
What is wrong?
Thanks,
Azi
My question is this: "Does anyone know where to set up the connectivity for an access database to store data on an Sql Server?"
View 6 Replies View RelatedHi,
Currently I am developing a project which requires to generate time-consuming reports in ad-hoc real time basis. The mechanism is
(1) User submits report request with required parameters
(2) The request will be processed one by one (I guess a queue is required to monitor the number of requests and the status of each request)
(3) Reporting service will get the report request and generate report in real time.
(4) Once report is generated, send the report to user
So, is there any idea on how to handle this type of mechanism in reporting services? Any tool in MS reporting services that can help?
Thanks in advanced.
If I'm using an Access front-end, and the data is on SQL Server being accesses via a linked table, and I create a query in Access, Where is all the work done?
I know access has the option of using a pass-through method, but if I do not use it, is Access processing the query locally? I plan on migrating several tables to SQL because the sizes are getting to large for Access and want to know if their will be a performance increase with out re-writing the queries in Access.
Thanks in advance,
Adam
Hello. I have an Access 97 frontend and a SQL 7 backend. When I try to open up the linked SQL tables in the frontend I recieve the error " This recordset is not updatable" from Access. I have the permissions in SQL set at this point to public having all permissions but it still does not change my problem. Does anyone know the answer?
View 3 Replies View Relatedhow can i do an access frontend to sql server backend
View 4 Replies View RelatedWhenever we run the mdx query in SSMS, how it will fetch the data from cube.
Using XMLA script used to fetch the data or any thing else ..
hello,
is it possible to use reporting services 2005 with an oracle warehouse?
if so, how does work?
can someone advise me as to what i have to do to connect an access frontend to an sql server express backend db on another server.
can i somehow link the tables so a user can enter in data in the access db they are familiar with but it will actually go into sql server.
please help
Hi, can anyone post the steps to upgrade the backend of issuetracker to sqlexpress 2005? Thanks a lot.
View 1 Replies View RelatedThis maybe belongs in the Data-Access Forum, but I'm not sure.
Is it generally a better idea to enforce things like unique constraints in the Database or the Webform? Say for example I want to make sure no duplicate Social Security Numbers are entered. Is it better to have an "If Exists" clause in my query, with a function to deal with it in the application or is it better to just fire the data to SQL Server and let the unique constraint on the dbase column deal with it? I then still have to have some code in my application to deal with the potential exisatance of that number, so is it a case of tomatoe, tomahtoe? If I understand things correctly, SQL server will return an error code if the piece of data does exist, and I will be able to parse the error code and display a message to the user.
Are there performance/coding issues involved? Best practices?
Ok, little frustrated hence the excessive exclamation points.
I'm designing a database in access to use a sql backend. Table structures are setup and am creating a view to join multiple tables together for data entry purposes. Tables are joined properly but when I add more than one join, ie adding more than two tables, I can't add records!?!
I checked the joins, it's not the table, since if I add one table its ok, remove table, add another table and that works, but when I add both tables together, it prevents me from adding records!
And another thing, when I have just two tables joined together and add a record, it comes up with this save changes, drop changes or cancel thingie!!! WTF!!!?
Is there something simple i'm missing or is it my table structure????
Thanks in advance!
Hi, this is my first post (hopefully of many) on this board. Just wanted to say a quick hello before I dive into my question. :)
As the title suggested, I have to develop a MS Access form app (yes, it has to be Access - I know it sucks) that will post and query data to and from a remote SQL Server db. While I have no problem linking the two through the default ODBC drivers, my question is security. Some (actually most all) of the data being passed back and forth is sensative information, and I would like to know the best way to keep it safe.
If anybody has any suggestions, instructions, or can redirect me to a good FAQ site on the subject, I would be most appreciative. I have already done a search on these forums for an answer, but have sadly come up short.
Thanks to all in advance!