A client sent us a oracle database we need to test against. We don't use oracle or have any oracle expertise in house. We need to setup the database so we can connect to it and debug a problem. I did a fresh install of oracle 9 (the version the client is running) and the management tools. I cannot for the life of me get it to import t...
I know how to use the OleDbConnection class to open an excel file and select from it, but is there a simple method to read the data from an excel file that has been read into a Stream? And is there also a similar method for QuickBooks? ...
Hi all, recently I downloaded this open source project and I am trying to compile it. However, one of the line is giving me an error. "import com.sun.org.apache.xpath.internal.functions.WrongNumberArgsException;" Seems that i am missing a library.... is there a way to know WHICH library do I need? I tried searching on google for com...
How do I import a python module given its relative path? For example, if dirFoo contains Foo.py and dirBar, and dirBar contains Bar.py, how do I import Bar.py into Foo.py? Here's a visual representation: dirFoo\ Foo.py dirBar\ Bar.py Foo wishes to include Bar, but restructuring the folder heirarchy is not an option. ...
I'm finding myself writing a bunch of related functions dealing with different nouns (clusters, sql servers, servers in general, files, etc.) and put each of these groups of functions in separate files (say cluster_utils.ps1, for example). I want to be able to "import" some of these libraries in my profile and others in my powershell se...
I have let's say two pc's.PC-a and PC-b which both have the same application installed with java db support.I want from time to time to copy the data from the database on PC-a to database to PC-b and vice-versa so the two PC's to have the same data all the time. Is there an already implemented API in the database layer for this(i.e 1.exp...
I'd like to automate importing cert(s) on a Windows CE device. Pushing the certs down to the devices is not a problem, but once they are there I cannot determine how to import them without using the UI. (I'm currently using Avalanche Mobility Center) ...
I started using a Sql Compact version of my DB and during the development it occured that the DB needs to be accessible over the network. Cause I wasn't able to find a way to share the SDF file over net without replication I need to import it into SQL Server 2008 (Express). Any Ideas? ...
I'm working on an app that is needs to be able to process "file paths" to import resources of different kinds. The issue is that in different situations (OS's for example), some of the file kinds are not applicable. What I want to do is define a very basic set of types that everything supports and then have a plug in architecture that su...
originally i was using easyPHP (windows) then i switch to mac and used MAMP. i archive my db every once in a while and right before i reformatted. The export was made by going into the root of phpMyAdmin and using the export function. Now i am trying to import the data i get this error "#1044 - Access denied for user 'root'@'localhost' t...
If a large module is loaded by some submodule of your code, is there any benefit to referencing the module from that namespace instead of importing it again? For example: I have a module MyLib, which makes extensive use of ReallyBigLib. If I have code that imports MyLib, should I dig the module out like so import MyLib ReallyBigLib = M...
Hi all, how can i import data from an oracle database to a mysql database by using CTL file (generate with Toad for oracle)? Thank in advance Andrea ...
For a new project I have to import the pre-existing data from MySql. In this site I have found many options, some including the installation of drivers. What is the fastest & easiest way to do it? Update: this would be just a one time import ...
I feel like this is a stupid question because it seems like common sense . . . but no google search I can put together seems to be able to give me the answer! I know how to get data OUT of a sqlite3 database using the .dump command. But now that I have this ASCII file titled export.sqlite3.sql . . . I can't seem to get it back INTO the...
Duplicate question - see: How do you dynamically load a javascript file? (Think C’s #include) Is there a javascript equivalent of @import? Because using the following way of including another javascript file from within a javascript file doesn't seem very nice and clean. document.write("<script type='text/javascript' src='something....
Can any one help me to find out a code snippet in PHP to read contents in an CSV file and then insert to some tables as well as fetch some data from www(fetch image fom the image url in CSV file) ...
Do you have any tricks for generating SQL statements, mainly INSERTs, in Excel for various data import scenarios? I'm really getting tired of writing formulas with like ="INSERT INTO Table (ID, Name) VALUES (" & C2 & ", '" & D2 & "')" ...
Say I only needed to use findall() from the re module, is it more efficient to do: from re import findall or import re Is there actually any difference in speed/memory usage etc? ...
Hi, I have a import directive in my inline .aspx page (no code-behind). <%@ Import namespace="Microsoft.SqlServer.Dts.Runtime" %> Getting an error: The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.SqlServer' (are you missing an assembly reference?) What is the issue? Do I need a /bin directory with the .dl...
I have a csv imported into my Hyperion v8.3 bqy file. I have some custom columns and a pivot already created. I just want to refresh the data. In the past, I would hit Process Current and it would direct me to my computer and I could select the csv file to update from. Now it will not do that. It doesn't go to my computer at all. ...