I have a legacy system of Foxpro running on UNIx. I require a data migration tool for migrating those data to SQL Server.<br/>I just want to know how to access the records in Unix Platform - Once that is done I can write the sub-routine to migrate those .

Hi, I'll try to describe my problem: There are 2 tables, where are various informations, these tablesare in relation M:N ( via 3. table ). Short desc.: TabFilm : PK - primary key - number ( no automatic ) film - string type - number ( 1-action,2-romance,3-document... ) ... TabActor: PK - pri...

I have a MS SQL server database.I want to synchronize this database with the Microsoft Outlook database (The synchronizing program should access the Outlook database using the Outlook API provided by Microsoft).ie, any changes made in the SQL server database should be reflected in the Outlook databa...

Hi!<br/>I am trying to create this procedure:<br/>CREATE PROCEDURE prueba_proc<br/>AS<br/>INSERT INTO prueba (campo) values (2);<br/>But when I execute that, it inserts one file, but it doesn't create the procedure. Any idea?<br/>Thank you in advance.

How do I access crystal report 8.5 with password when that report is being called using VB codes? Urgent need. Would appreaciate your help.

Hi,we are using Oracle 8i as backend for our application, since my company is in IT enabled services, we need to store huge volume of data e.i 50,000 to 200,000 records.We have to process atleast 5000 records a day, our server is configured with AMD 1 Ghz, 256 Ram , 40 Gb Hdd, windows 2000 server.S...

hi<br/>I am a newbie in DB, and I have a simple question:<br/>I have a database make in SQLBASE with extension .dbs<br/>Who can I open and work with this database whitout SQLBase 6 program?

Hi Gurus,I wanted to know the SQL query to find out the list of all tables in a database.I got to know from a friend that I could achieve this by using:select * from information_security or something similar.. correct me if i'm wrong, but this does not seem to work for MS Access database.Kindly...

Hi,I want to store in database (ms-access), and display some non-English content in the web site (Arabic). The database stores the english and arabic contents in it. It will pick the respective contents on the user's selection policy.I made changes at the ASP to make language charset as follows...

I have got a stored procedure in SQL2000 that selects a range of customers into a temp table. The problem is, due to the various parameters that influence which customers I need, I have to build the "insert into select" statement into a variable and then execute it ("exec(@sSql)"). The whole program...

I have an sql server 2000 database in my office. i want to update my SQL server 2000 database present on my web server on a daily basis or weekly basis. Pls keep in mind that the other is a web server. i can get connected to it only through the net. both r running win2000 server<br/>Surya

hi all,<br/>i have fired update query in access database.<br/>is there a possibility that i can rollback.<br/>if yes then please tell me how i can do it<br/>thanks in advance<br/>mahendra

Hi thereI'm stuck in Oracle by trying to overtake the MS SQLs nice syntaxSELECT portfolio, in = CASE WHEN trn = 'in' THEN SUM(trn_amount) END, out = CASE WHEN trn = 'out' THEN SUM(trn_amount) ENDFROM ...This query gave a resu...

hi,<br/>how can i link crystal report and interbase using bde

Hi,I'm using db access. I have a query that generates the following fields.fnum1 field1 field2 field3fnum2 field1 field2 field3fnum3 field1 field2 field3Now I want to add field1, field2 and field3 and put the value in field4. Basically, i'm trying to add the columns field1, field2, field...

Please, forgive me about possible mistakes.I have a problem with usage of UNICODE in database project.The database is created in MS Access. There is a one table "human" in the database.I register it in Data Sources (ODBC) using Microsoft Access Driver (*.mdb).Then I create a console application MFC....

Hello,We can:-Connect via SQLDriverConnect-get a list of procedures & parameters using SQLProcedureColumnsWhen we try SQLExecDirect(hstmt,"{call query.ADDRESS_SRCH(293837)}",SQL_NTS);We get the following error:The record (ADDRESSES) does not exist in the access groups available to you. (29,6)as well...

I have used MS Access for many years to assist in my job (which is non-computing) and have always managed (one way or the other) to get the database to work. I am now interested in moving away from the constraints of having to rely on MS Access. I have been looking at the various different program...

Hello...I have some lines in the code for inserting a record to a table and changing a record in an other table...sometime (most of the times but not always) I get an error: system.NullReferenceExceptionThe next message box that appears is: "There is no source code available for this error".I am usi...

Hi,I have installed j2sdk1.4 over RedHat Linux9.0 successfully. Now, I wanted to connect to my Oracle7.3 server which is installed in a separate SCO Unix machine from my java program. What are the steps to do the same ? What all are the primary requirements ? Is there any ODBC drivers for Oracle...

Hi!<br/>I need help to convert the attached procedure for SQL Server.<br/>Thank you in advance!

Hi All, I would like to know whether it is possible to store custom column Desription in SQL Server 7.0 Database along with column name for each of the columns in the each table. If so :1) How can I do that ? 2) Once stored how can I retrieve it back.( This Option is available in MS Access)Thankx...

Hi All, WE have our own ERP package developed in Oracle Developer 6I. Now we would like to build a set up using Oracle Project Builder (which comes with Developer 6I) so the we can install our product through Oracle Installer like any other Oracle Product. But after creating project and if i try...

Hi <br/>How can I get the Table Names of the Open Database <br/>I use MSSQL2k

I am trying to create an app, to archive data from a database, and then restore it at some point in the future, but in such a way that all the primary and foreign keys of the restored data update automatically!Is there a 3rd party tool, or method for doing this type of thing?I am using an Access (an...

Hi guys,<br/>is it possible to insert values into 2 tables ino one sql statment<br/>ie: insert into tbl1, tbl2 values ( 'ddd','222' ) ('aaa','555','rrr') or something like that.<br/>Thanks

I need to write a stored procedure in SQL Server 2000 that connects to an IBM DB2 database using SQLs 'Linked Server' function.The problem is that I need to use an OLE DB2 provider, but I can not find the OLE DB2 Provider for IBM DB2 version 6.Has anyone had experience in doing this?Thanks...

Hi there, I have created a simple MS Access database, and I wanna add it to MS SQL server (desktop engine) that provided by VS .net, so that I can access the database in my web site (using ASP .net). When I read the samples, I found that I need to have a .ldf and a .mdf file with the MS access d...

Hi, <br/>I'm storing a large amount of video files in my PC.<br/>Should I break them up into fragments of say ~30MB or store them in large chunks like ~300MB?<br/>What are the pro and cons of each method?<br/>And what are the considerations for storing media files like this?<br/>Thanks.

Hi, I have a sp in MsSql and I am trying to translate it to Oracle, can any one help me with the syntax. The From is not acceptable in oracle I guess.UPDATE ReservedDetails SET Price = @Price , PriceName = @PriceName , Commission = @Commision , WasPrinted = 1 FROM (Select top 1 * From R...

Hi All,Need your helps for handling Time Expired issued using ADO.I trapped an error with this error no. during a SQL call:(-2147217871) - Time Expired.i was actually calling a SQL to retrieve about 1000 records.here, i would like to know any solution for this situation?it may be:1. to "prolong" the...

All,A question which draw on the experiences of all of you.I need a database for very high rate record storing (+500 records/sec on SunBlade 150) and access.The requirements are simple, i.e. I don't need any shiny features if they slow me down. * Linux/Sun Solaris. C++.* Storing of single recor...

I have been trying to work with crystal report with 2 database with same field name but data are different. Is there way to make crystal report source from various database.<br/>I am also wondering if there is way to change the database source through vb code?<br/>Please help me!!!

Hi everybody.Can someone suggest me a script to delete all indexes in a SQL Server 2000 DB ?<br/>Thank you.

Hi Gurus,Following are my table schemas:Table A:(aID int primary key,Name varchar(10),Points int);Table B:(bID int primary key,aID int references A(aID),amount int);I want a SQL Server (2000) trigger to do the following:For every insert/update in the table B, the person referred to in table A gets s...

Hello,i must read values from an Excel sheet, which becomes updated by another program. So i tried to open the Excel-File with CDaoDatabase and open a CDaoRecordset with the OpenType "dbOpenDynaset".I can reed the values from the sheet, but the recordset wasnt updated, if the values from the sheet h...

I'm having an issue with a DSNLess Connection page I'm writing for a user to test. The code works on my computer, but when I send it to the user, they get the following error: Cannot open database requested in login 'iquikpay'. Login Fails.Here's my code (ASP): Dim objConn...

Hi Gurus,Table Design of t1:A intB DateTimeC DateTimeInsert Statement:Insert into t1 values (1, '10/21/2002', '14:30')When I view the database, the output is as below:1, '10/21/2002', '1/1/1900 14:30'.I want to format the time the way shown above. Is there any...

Hello ! I am a newbie to MS-SQL. doing MCA final proj , Here I want some info about MS-SQL user defined alerts... Actually I have to design an alert that display message like"the warranty period has been expired for --- good" based on getdate() and warranty period comparisio...

I have an application that is out on several sites which uses C++ and ADO to connect to a remote database (there is one remote database per site)All works fine at the old sites but a new site that has just been installed keeps on giving the following error:Error 80004005Unspecified Error[Microsoft][...

hi ,<br/>i have a problem in vc++.net program.need your help<br/>how to transform the data of excoracle into el or into access ?<br/>thank you very much!

Hi ALL, We are using Postgresql 7.3.3 on Linux 8.x. We have following few questions for you: AND IM New to this. a. When are the temporary tables deleted OR when would temporary tables go out of scope ?. Our backend Java application maintains a connection pool to the database (Postgre...

hi all i have the table like[ number ] [ name ] [ k1 ] [ k2 ] [ k3 ] [ h1 ] [ h2 ] [ h3 ] [ allK ] [ allh] [ 1 ] [ pp ] [ 2 ] [ 3 ] [ 4 ] [ 5 ] [ 6 ] [ 7 ] [ 2 ] [ dd ] [ a ] [ b ] [ c ] [ d ] [ e ] [ f ] how sho...

I have table1 that has a Foriegn Key to table2, using the sql dmo i am able to get the script from Table1 to create the Foreign key with Table2 no problemSet objTable = objDatabase.Tables("table1")strSQLScript = objTable.Script(SQLDMOScript_DRI_ForeignKeys)strSQLScript Now = "ALTER TABLE [TABLE1] A...

I am trying to run an SQL Statements in my Access 97 database,to create a relationship with the CASCADE DELETE (and update).This works great:ALTER TABLE Table2 ADD CONSTRAINT Table2_Constraint FOREIGN KEY (ID) REFERENCES Table1 (ID)But when I add the "ON DELETE CASCADE" I get an error:ALTER TABLE Ta...

Done

Hi all,Hoping somebody who has already had to do this testing can advise me on whether the syntax for creating a database and tables etc. is compatible from SQL Server 2K back to SQL Server 7.0.I have developed a VB application that creates an SQL Server DB the first time the VB app is run, and have...

Hello Techies, I have a table like this TabProduct where there are fields startdate,enddate and difference gives warranty period. I have to design an alert to display "Warranty has been expired for -- product",and i have display Productid in blank from tabProduct. Is it posibble to write user ale...

I am trying to set a datamember of a datagrid to show a many to many relationship but having no luck. As an example I have the following 3 tables in my dataset. There is a many to many relationship between parttypes and assemlies IE... the parttype can have many assemblies and the assemby can belong...

I am trying to do some dynamic SQL and keep getting a -1003 error from Oracle.I canned a basic SQL statement just for testing purposes. My code seems to match the Oracle doc examples. Anyone have any ideas for me?It fails on the Exec Stmt.Code Snippet:strcpy( vsHostStmt.arr, "Select * from Table1...