• Populating a db with information stored on another db

    I have a general how-to question. I need to populate a database with information stored on a separate database. I have never done this before and I would like to know the process that is usually used. A little information concerning the databases. My database is set up through phpMyAdmin. The...

    LoganGoesPlaces45 pointsBadges:
  • MySQL Stored Procedures in Crystal Reports

    Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...

    Les za30 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • Moving a SQL database from one host to another

    I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

    Kwoodall10 pointsBadges:
  • While loop Vs Cursor

    What is difference between navigating records in while loop and cursor ?

    Just dream5 pointsBadges:
  • Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

    I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Split Databases – BE Structural Changes Version: 2007 (12.0)

    Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

    Thuzinec10 pointsBadges:
  • How can I accomplish load balancing with redundancy?

    I have two links with different ISP's and both the (512Kbps) links are terminated on separate Cisco routers (2811). Currently, we are using one link. Another link is new. I want to do load sharing and redundancy between them. Right now I am not using BGP (routers are configured in simple manner)....

    NetworkingATE1,545 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • SQL linking to database in XP

    First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and if I want to overwrite it. In trying to...

    Bigblew15 pointsBadges:
  • Deletion of Macros when doing a repair & compact

    We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?

    SharieL10 pointsBadges:
  • access 07 help

    i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help

    Joe26098615 pointsBadges:
  • Storing BLOB to file through SQL Server 2005

    I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB

    Naeem5 pointsBadges:
  • How to use partitioning in SQL Server database to avoid ‘timeout’ errors

    We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using shell execute from Visual Basic

    How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

    Rolandsk5 pointsBadges:
  • No such interface supported

    "No such interface supported" msg shown in try method, while i m assining a dataset to crystal report viewer by following code, dim cr as rpt1 = new rpt1 cr.setdatasource(dataset) crviewer1.ReportSource = cr

    It-base5 pointsBadges:
  • I need help with how to programmatically backup a database

    I’m trying to programmatically backup a database using the following command: expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schema where "system_password" is the actual "system" password and "my_schema" is the name of the schema I want to export. How can I verify in an...

    OracleATE190 pointsBadges:
  • Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • Can you connect a Cisco 7940 desktop IP phone through a wireless switch/bridge to a Cisco access point?

    Is it possible to connect a Cisco 7940 desktop IP phone through a wireless switch or bridge to a Cisco access point (AP) and make it work? I am having problems with this setup. It is most probably unsupported but we sure would like to make it work. Thanks!

    NetworkingATE1,545 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following