-
Db2/AS400 library connecting via oledb in vb.net
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am I...
Last updated: -
How to repair a corrupt Lotus Notes archive database?
Last updated: -
What are the rules for transforming a logical database design into a physical database schema?
What are the rules for transforming a logical database design into a physical database schema?
Last updated: -
How I can convert FXP to PRG? (Foxpro-2.6)
I have lost of my Foxpro 2.6 .prg file. I have only .FXP foxpro file. I want to convert .FXP to .PRG. Remember I have long statement in PRG (above 255 characters). Give me a proper solution. Thanks & Regards Narayan Gadri.
Last updated: -
I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...
Last updated: -
Transfer values to SQL database
How do I get data from Windown form and store it in a SQL database?
Last updated: -
As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!
Last updated: -
Transfering table data from one database to another
I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.
Last updated: -
Hello, How can I find duplicate records in access based on more then ten fields? The wizard only allows 10 fields. I need to find duplicate records based on 17 fields. Is this possible in access? Or is there another way around it? Thanks in advance!
Last updated: -
Is it possible to check for a role in the database script post open event?
Is it possible to check for a role in the postpone event of the database script and close the DB if it doesn't belong to that role?
-
Deleting and redirecting a relationship in Access 2013
I inherited a database that has a duplicate table and both tables are pointing to different things in the relationships. I would like to delete one of the tables and direct all relationships to the existing table.As it stands, I have to update both tables with the exact same information (the table...
Last updated: -
How to check JDBC agent connected with RTCP?
Currently I'm working with JDBC virtualization IBM RIT. I created testcase for database with a basic SQL query and it is working fine. Now I'm facing issues while creating stub with database. It's showing DJBC agent not connected with RTCP. I got struck up with that step. Don't know how to proceed...
Last updated: -
What is the procedure for Deployment in VB 6.0
Dear Friends, I have developed a small project using Visual Basic 6.0 as front End, MsAccess for database & VB reports for reports on OS Windows XP SP2. It was completed successfully and working on my system but how to transfer or make it work on other system where VB is not available....
Last updated: -
Need to know the journals within a library or a list of libraries and write it to an outfile
Hi. Is there an easy way to get a list that will provide information on which physical files are being journaled within a library? For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven't found it, nor have I been able to find it...
Last updated: -
How to read HTML in Lotus Notes inbox messages in VBA
Can anyone show me how to get html from Notes inbox messages in VBA? I am using Access VBA to send notes email messages. The message is a form I'm asking the recipient to fill out and return. The message contains html with <select> and <input> elements. The replies come back and...
Last updated: -
How to prevent users from PC to use ODBC
Hello, how can we stop a user say from a windows to use ODBC to connect to the AS/400 server? I am looking more for setting up a block on the AS/400 machine rather than on the PC itself. Thanks!
Last updated: -
How to install the MySQL JDBC connector?
Can anybody tell me how to install the MYSQL JDBC connector. I am getting error "java.sql.SQLException: No suitable driver ". I placed the driver in the java-jre\lib\ folder also in the shared folder of tomcat 5.0. Even in the lib folder of WEB-INF. But I am getting the same error.
Last updated: -
Problem deleting an object (form) in Access 2000
When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas?
Last updated: -
Can someone tell me what is DBMS in SQL Server?
Last updated: -
We need to migrate a MySql database from one host to another. Will a simple backup and restore work? Are there references to the database inside itself? Will this work?
Last updated: