Search Results

Search found 31293 results on 1252 pages for 'database agnostic'.

Page 389/1252 | < Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >

• how to import the excel file to sql database using vb.net?

  - by subhashiniskmr

  I have a more data in excel file .so i have to import it into sql database using vb.net.can anyone send the source code?

  Read the article

• PHP: How do you safeguard application/server/database from your employees?

  - by Patrick

  What do you guys do (system/framework wise) to safeguard things like 1) employees writing malicious code to destroy your server 2) employees reading all your database sensitive information 3) generally programmers that have access to your back-end and potential damages that they can do. Is there any PHP scripts that guards against these, etc.?

  Read the article

• In a web farm environment, should we base the system date/time to the web servers or the database se

  - by leypascua

  Assuming there are a number of load-balanced web servers in a web farm, is it safe to use DateTime.Now in the application code for getting the system date/time or should we leave this responsibility to the database server? Would there be a chance that machine date/time settings on all servers in the webfarm are out of sync? If date/time will be the responsible of the DBMS, how will this strategy work if we have load-balanced replicated DBs?

  Read the article

• How can I plot graphs with MS Chart controls using data from the database?

  - by Allan

  I need a sample code on how I can plot a graph in a C# application using the MS Chart add on in Visual Studio 2008 using linq to sql to collect the data from the database?

  Read the article

• Excel macro to change external data query connections - e.g. point from one database to another

  - by Rory

  I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a sample? I see there are different types of connections 'OLEDB' and 'ODBC', so I guess I need to deal with different formats of connection strings?

  Read the article

• Is there any MS SQL database designer software like MySQL workbench?

  - by newbie

  I need to design database for MS SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• Where does Drupal store user permissions in the database?

  - by Ryan Nelson

  Does anyone know where Drupal stores, in the Database, the role of a user? It's not in the users table, and I can't seem to find it. I can find where it defines the role, defines the role's permissions, but I can't find where it defines what Role a certain User is. Anyone know? Thanks!

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• i have two tables in my sql database of 1 million records, is there a way to find out the non matchi

  - by sharma

  i have two large tables in a database. table 1 with 2 fields rank,name and table2 with 2 fields rank,name. both are of 1 million records. can you write php sql code to fetch those records which exists in table2 but does not exist in table1.

  Read the article

• problem to Get Date, month Year separately From database in Php File ?

  - by aamir Fayyaz

  i want to separate date, month, time, hour, min ,sec getting from database, for count down timer, in data base stored date is 2010/10/10: me using this code : $m=date('m',$row['Date']); $d=date('d',$row['Date']); output is month=31 date = 12....

  Read the article

• Using serializable in hibernate what underlying database types do i use.

  - by joe90

  I need to use a serializable type in hibernate (to store a Subject (security)) All this works fine. I just need to know what the underlying database types are for the following databases: MSSQL - I used 'image' db2 - postgre - mysql - Thanks..

  Read the article

• Can php listen for a mysql database change or update? ...thinking real-time, live search here

  - by Derrick

  Im trying to think of the best way to handle real time search for a website. The only solution I can come up with is to keep checking the server every few seconds for something new in the database, but that does not seem very practical to me.

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• How can I force NHibernate to hit the database when querying for an entity?

  - by Chris Holmes

  I have a situation where I need NHibernate to ignore its caches and just hit the database because the data has changed (another user on another computer has changed the data). How is this possible? So far I have had no luck. Get, Load, Linq query, doesn't matter. NHibernate is not getting the most recent data.

  Read the article

• How to keep backup of our database in MySql.

  - by Sanjeev

  I want to keep backup of my database and import it into different System? and how to make .dmp or store file in MySql?

  Read the article

• In python, is there a simple way to connect to a mysql database that doesn't require root access?

  - by Matthew

  I'm writing a script to parse some text files, and insert the data that they contain into a mysql database. I don't have root access on the server that this script will run on. I've been looking at mysql-python, but it requires a bunch of dependencies that I don't have available. Is there a simpler way to do this?

  Read the article

• Is it possible to get Java fmt messages bundle from database ?

  - by newbie

  I nedd to localize application and now files are loaded from text files. Is it possible to change source to database? This is how localized messages are now loaded: <!-- Application Message Bundle --> <bean id="messageSource" class="org.springframework.context.support.ReloadableResourceBundleMessageSource"> <property name="basename" value="/WEB-INF/messages/messages" /> <property name="cacheSeconds" value="0" /> </bean>

  Read the article

• What is the most efficient way to populate class attributes with a row from a database query?

  - by ensnare

  Looking to have a database query set all the instance variables in a class: Example: def populate(self, if): #Perform mysql query self._name = row['name'] self._email = row['email'] ... What's the fastest way to do this? Or is this not recommended (with a better approach)? Thanks.

  Read the article

• SQL select from data in query where this data is not already in the database?

  - by Michael

  I want to check my database for records that I already have recorded before making a webservice call. Here is what I imagine the query to look like, I just can't seem to figure out the syntax. SELECT FROM (1,2,3,4) WHERE id NOT IN table.id Is there a way to do this? What is a query like this called?

  Read the article

• Is it a good idea to Strtolower the username then store it in database?

  - by Axel

  Hi, In a php/mysql application where people can registre, is it a good idea to strtolower the username then store in the database in order to not have problems in the future? because people are using DiFfeReNt cases and i'm afraid that will make conflict in some queries. Thanks

  Read the article

• How To Work With SQL Database Added As Item In Visual Studio 2008?

  - by mdvaldosta

  If I'm letting Visual Studio take care of adding an SQL Server database to an existing project, it adds the connection string to app.config. How can I use use THAT connection string to make my own connections and datasets?

  Read the article

• How to load 1 milion records from database fast?

  - by Leonard P.

  Now we have a firebird database with 1.000.000 that must be processed after ALL are loaded in RAM memory. To get all of those we must extract data using (select * first 1000 ...) for 8 hours. What is the solution for this?

  Read the article

• Can I do an ASP.NET Dynamic Data project against a Sybase database?

  - by theog

  Or must it be a SQL Server database? If I'm reading the documentation right, as long as I use Entity Framework and not Linq to SQL, I can go against a Sybase data source. But I'm not certain...

  Read the article

• How can I store large amount of data from a database to XML (speed problem, part three)?

  - by Andrija

  After getting some responses, the current situation is that I'm using this tip: http://www.ibm.com/developerworks/xml/library/x-tipbigdoc5.html (Listing 1. Turning ResultSets into XML), and XMLWriter for Java from http://www.megginson.com/downloads/ . Basically, it reads date from the database and writes them to a file as characters, using column names to create opening and closing tags. While doing so, I need to make two changes to the input stream, namely to the dates and numbers. // Iterate over the set while (rs.next()) { w.startElement("row"); for (int i = 0; i < count; i++) { Object ob = rs.getObject(i + 1); if (rs.wasNull()) { ob = null; } String colName = meta.getColumnLabel(i + 1); if (ob != null ) { if (ob instanceof Timestamp) { w.dataElement(colName, Util.formatDate((Timestamp)ob, dateFormat)); } else if (ob instanceof BigDecimal){ w.dataElement(colName, Util.transformToHTML(new Integer(((BigDecimal)ob).intValue()))); } else { w.dataElement(colName, ob.toString()); } } else { w.emptyElement(colName); } } w.endElement("row"); } The SQL that gets the results has the to_number command (e.g. to_number(sif.ID) ID ) and the to_date command (e.g. TO_DATE (sif.datum_do, 'DD.MM.RRRR') datum_do). The problems are that the returning date is a timestamp, meaning I don't get 14.02.2010 but rather 14.02.2010 00:00:000 so I have to format it to the dd.mm.yyyy format. The second problem are the numbers; for some reason, they are in database as varchar2 and can have leading zeroes that need to be stripped; I'm guessing I could do that in my SQL with the trim function so the Util.transformToHTML is unnecessary (for clarification, here's the method): public static String transformToHTML(Integer number) { String result = ""; try { result = number.toString(); } catch (Exception e) {} return result; } What I'd like to know is a) Can I get the date in the format I want and skip additional processing thus shortening the processing time? b) Is there a better way to do this? We're talking about XML files that are in the 50 MB - 250 MB filesize category.

  Read the article

• How to create a database binding using Windows Builder Pro?

  - by Tiago

  For the first time, I'm creating a Java Swing application. I'm using Windows Builder Pro in Eclipse, and a MySQL database (already setup up). Let's say I have a combo box, and I want (for instance) all 'name' fields from a 'certain' table appear. How can I setup that binding? I know how to programatically handle the connection and query code, what I would like to know is how to make that binding in Eclipse.

  Read the article

< Previous Page | 385 386 387 388 389 390 391 392 393 394 395 396  | Next Page >