Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 744/1212 | < Previous Page | 740 741 742 743 744 745 746 747 748 749 750 751  | Next Page >

• sp_addlinkedserver procedure not linking Excel source

  - by brohjoe

  I am attempting to link an Excel source to a SQL Server DB on the Go Daddy website.  When I execute the sp in SQL Server, it shows it executed successfully, but no data is linked. This is the main part of my procedure:      EXEC sp_addlinkedserver @server = 'XLHybrid', @provider = 'Microsoft.ACE.OLEDB.12.0',    @srvproduct = 'Excel',    @provstr = 'Excel 12.0 Macro',    @datasrc = 'C:\Database\XLHybrid.xlsm' What's the problem here?

  Read the article

• Getting OpenID to work on an existing MyBB Install

  - by Djdoubt03

  I am the administrator for a forum,The Vortex. It operates on the latest version of MyBB ver1.6.3. I would like to know how I can get OpenID to become the login for the forums, and also add the users to the MyBB Sql file and overwrite any users that are already registered. This must work on an existing install as I will not be dumping my SQL database to do a fresh install just to get OpenId to work. Any Thought?

  Read the article

• Create a DB alias using T-SQL in SQL Server 2005

  - by Randall Salas

  Hi: I am trying to create a Database alias for many of the DBs. I wonder if there is a T-sql that can let me do it. I have not found anything about this. Thx.

  Read the article

• Disconnected DataSet

  - by Ritesh Jain

  DataContext/Entity Model always read data from Database. is there any way DataContext/Entity Model will read the data from DataSet. Thanks

  Read the article

• How to get image URI

  - by Shashi

  Hi I am developing a simple application. I have an image stored in sdcard. In one activity I am displaying that image using imageview.setImageUri() .... Now on clicking on that Image I want to retrieve uri of that image and want to store it in sqlite database... can anybody tell me how that is possible.

  Read the article

• mysql: am I doing something dumb with my indexing if my .MYI (index files) are bigger than my .MYD f

  - by chongman

  Is there ever a circumstance where the .MYI files should be bigger than my .MYD file? I've got some pretty huge .MYI files and joins are running slowly. I'm pretty new to MySQL. Database engine is MyISAM.

  Read the article

• PHP URL Security Question

  - by TaG

  I want to have users store the url in my database I'm using php mysql and htmlpurifier I was wondering if the following code was good way to filter out bad data? Here is the Partial PHP code. $url = mysqli_real_escape_string($mysqli, $purifier->purify(htmlspecialchars(strip_tags($_POST['url'])));

  Read the article

• Fast way to code forms in C# which is bind to SQL data

  - by adopilot

  I am coming from MS-ACESS world and their programing habits, There was nice utility to make form from table, You can simply hit right click on table and make form for it. Now I looking for something similar for Visual Studio and WinForms. I am trying to develop simple application for which I need to have more then 30 forms for handling data, till now I designed database tables, keys and sprocs in SQL2008 and before I start coding forms for handling data, I asking You for main guidelines how to save my time while coding forms.

  Read the article

• Retrieve data using Dynamic Query and Linq to SQL

  - by GigaPr

  Hi I have a really complicated dynamic query that i want to use to retrieve data from the database I am working in .net 3.5 sql server 2008 i created a stored procedure that accepts a varchar(max) as input parameter and does execute (@SqlQuery) it executes but does not return anything I really would like to use LINQ as all my project is implemented using linq Any Idea how to do it what is the problem?

  Read the article

• Writing a DBMS in Python

  - by Matt Luongo

  Hey guys, I'm working on a basic DBMS as a pet project and planning to prototype in Python. I figure there's a reason there are only a few Python databases, and my gut agrees that my favorite language will be too slow to act as an honest performing database, but I'm looking forward to using it to learn what I need quickly. Would someone please contradict me? Is Python as ill-suited right now for this sort of thing as I think?

  Read the article

• finding distance between two UK addresses

  - by effkay

  Hello; I need to write an application which is to calculate the estimated driving distance between two UK addresses; I think I can use Google as following: http://maps.google.com/maps/nav?q=from:London%20to:Dover However, anyone knows what is the daily/monthly limit of querying the database from a single IP address? I need to implement in a commercial application (freight services), is there any reliable alternative? Development language/platform: C#, .NET Regards,

  Read the article

• Mysql storing quotes as &#39;

  - by Click Upvote

  I have some PHP code which stores whatever is typed in a textbox in the databse. If I type in bob's apples, it gets stored in the database as bob&#39;s apples. What can be the problem? The table storing this has the collation of latin1_swedish_ci.

  Read the article

• How to setup cscope with aquamacs on MacOS?

  - by yinglcs

  Can you please tell me how can I setup cscope with aquamacs on MacOS? I have followed a link from Google saying how to build a cscope database for my source code. But how can I invoke cscope with aquamacs? Thank you.

  Read the article

• How do I display a quote for 24 hours

  - by mathew

  I want to display a quote on my site for daily basis. after 24 hours it should change. quotes are stored in MySQL database. how do I do this with PHP Thanks Mathew

  Read the article

• Having a destructor take different actions depending on whether an exception occurred

  - by dan04

  I have some code to update a database table that looks like try { db.execute("BEGIN"); // Lots of DELETE and INSERT db.execute("COMMIT"); } catch (DBException&) { db.execute("ROLLBACK"); } I'd like to wrap the transaction logic in an RAII class so I could just write { DBTransaction trans(db); // Lots of DELETE and INSERT } but how would I write the destructor for it?

  Read the article

• MySQL DUMP as CSV

  - by swt83

  I've looked around and nothing seems to work: $file = '/path/to/file.csv'; $cmd = 'mysqldump DATABASE TABLE > '.$file.' --host=localhost --user=USER --password=PASS'; $cmd .= ' --lock-tables=false --no-create-info --tab=/tmp --fields-terminated-by=\',\''; exec($cmd); Everything I try creates an empty CSV file. Any ideas? Thanks much.

  Read the article

• Is XML a good logic to load data??

  - by Mat

  Hi stack, i'm working on an app that loads some data from xml file from internet. Is this a good way to develop iPhone apps??...I think xml is more light than SQlite database... Basically my logic is: 1 - Parsing Xml file from internet to retrive the data 2 - Load data on device Security?..other stuff??.. Thanks Mat

  Read the article

• SQL GUI Programs

  - by jake

  Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.

  Read the article

• Error in Django set up

  - by ahkeno

  How can I set up Django in Window Xp and Ubuntu OS I finished the step for connection with Database and some problem with connect to admin.. I do it from reading ebook and do it..So there is any easy steps for me.. Please share all idea.

  Read the article

• how to update a selected record in a dataset and update another datatable in another Adoconnection?

  - by ml

  I have 2 adoconnections and 2 datatables in each connection (Local Table1_master Table1_Detail) (Network Table1_master Table1_Detail). I show them in a DBgrid and now I would like to update the (Local Table1_master Table1_Detail) from the tables in (Network Table1_master Table1_Detail). How can I update the selected records? I have tried many ways but normally it inserts more records and doesn´t update the record. I use a .MDB database.

  Read the article

• Removing a default value from a Sql Server 2005 table

  - by Nikola Stjelja

  Hi, I have a tabel in an Sql Server 2005 database. I have the following column IndPL INT DEFAULT 0 NULL I want to change the column to be of the type NVARCHAR but I receive a constraint violation due to the fact that the column has a default value constraint attached to it. I need to find out how to remove a default value constraint from a table column or how to change the column type without impeding the constraint.

  Read the article

• Problem with form buttons in IE

  - by shinjuo

  I have buttons on a page that look like: <a href="view.php"> <input type="button" name="view" value="View Database" /></a></p> IE does not support these buttons or multiple buttons I am not sure which one. Does anyone know how to fix this to work with IE?

  Read the article

• How to read the selected items in an Html.ListBox at postback time

  - by EasyTimer

  I have a search page on my MVC site that contains a list of strings that I think the user might wish to search for in my database. This list of strings is available in my model class, so I can populate an Html.ListBox with those strings thus: <%=Html.ListBox("SearchStrings", new SelectList(Model.SearchStrings)) % My problem is, how can I tell which strings the user selected in that list in my postback action? Any help would be most appreciated.

  Read the article

• Mysql CASE and UPDATE

  - by Rosengusta Garrett

  I asked yesterday how I could update only the first column that was empty. I got this of a answer: UPDATE `names` SET `name_1` = CASE WHEN `name_1` = '' then 'Jimmy' else `name_1` end, `name_2` = CASE WHEN `name_1` != '' and `name_2` = '' then 'Jimmy' else `name_2` end I tried it and it ended up updating every column with 'Jimmy' what's wrong with this? I can't find anything. It could possibly be the structure of the database. So here is what each name_* column is setup like: # Name Type Collation Attributes Null Default Extra 1 name_1 varchar(255) latin1_swedish_ci No None

  Read the article

• Auto Generate Objects in DBIx::Class ORM in Perl

  - by Sam

  Hello, I started learning DBIx::class and I reach the point where you have to create the Objects that represents tables. Should this classes be created manually ( hard coding all the fields and relationships.....) or there is a way to generate them automatically using the database schema. I read something about loaders, but i did not know where they are really used. Please advice. Thanks

  Read the article

< Previous Page | 740 741 742 743 744 745 746 747 748 749 750 751  | Next Page >