Temporary recordset in MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]

Answer Question   |  February 19, 2009  6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA

How to move the msdb database to sql 2005
I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I’m getting a compatability error message. Any suggestions greatly appreciated.

Answer Question   |  February 17, 2009  2:30 PM
SQL 2005, SQL 7, SQL database replication, SQL Server MSDB Database

SQL Server does not exist or Access Denied Error
I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use [...]

Answer Question   |  February 17, 2009  12:23 PM
Database connectivity, Error: Access Denied, SQL Server, VB.NET, Visual Basic .NET

A Socket Connection was Attempted to an Unreachable Host
Hi, i am getting this Ureachable Exception when connecting From Pocket PC Application To Desktop Application through Scoket. But The same is Working with Wondows Form Application.Not Working with PockePC Application. I can’t Understand this. Please tell me How to solve This Problem

Answer Question   |  February 16, 2009  5:38 AM
Mobile development, Network connectivity, Pocket PC, Socket error, Unreachable host, Windows Forms

Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]

Answer Question   |  February 16, 2009  7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  February 18, 2009  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures

Auto download a .CSV file from network drive
to a AS/400 physical file through a cl program? how can I do this?

Answer Question   |  February 13, 2009  6:09 PM
CL Program, CSV, Physical File

protect sybase DB on centos server
I would like to know if there is an anitivirus prog that will scan automatically on sybase DB’s. Our server allows staff to upload word doc’s into the DB,,, with the increase of virus’s occuring on out windows PC’s,,, i would like to add protection to the doc’s in the DB. Any ideas?

Answer Question   |  February 12, 2009  4:19 PM
Antivirus, Sybase, Sybase Databases, Sybase Virus Scanning

Access 2003 Form fields Sync
Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first… : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form [...]

Answer Question   |  February 13, 2009  3:01 PM
Access 2003, Access 2003 forms, Microsoft Access, MS Access VBA, Office 2003

Monitoring Tool
Which monitoring tool is the best tool for application and database monitoring?

Answer Question   |  April 24, 2011  12:36 PM
Application monitoring, Database monitoring, MONITOR, Monitoring

Database Mirror connection string in sql 2008
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 [...]

Answer Question   |  February 13, 2009  7:30 PM
Database mirroring, SQL Server 2008, SQL Server Database Mirroring, SQL Server Mirroring

How do i have access fill in a field in the form in opening with data from the parent form
My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where [...]

Answer Question   |  February 11, 2009  7:00 PM
Access 2000, Microsoft Access, PostgreSQL, Windows Server 2003, Windows XP

New Contest: ASK, Answer and win some Amazon.com gift cards
It’s that time again — a chance to win an Amazon.com gift certificate based on your activity in the IT Knowledge Exchange community! Remember: the more you ask, answer and discuss questions, the more Knowledge Points you will earn. (Only valid questions, answers and discussions will be counted towards your total.) The top 10 most [...]

Answer Question   |  April 3, 2012  5:17 PM
AS/400, CIO, CRM, Data management, Database, DataCenter, Exchange, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, VMware, VoIP, Windows

VB.NET code to search if a record already exists or not
Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I’m sending you the code. Please [...]

Answer Question   |  April 19, 2013  9:49 AM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005

Will a BSc in Information Security get me a network security job?
I would like to get my BSc in Information Security Systems. In the near future I would like to get a networking security career. Do you think this is a good degree? Otherwise what can I do to get into the security field?

Answer Question   |  February 11, 2009  7:47 PM
BSc, Degree, Degree programs, degrees, Information security, Information security careers, IT career planning, IT careers, IT jobs, Network security, Networking, Training, training and certificatio, Training/education

After earning a CCNA, which certification is best for job security?
I am currently getting my CCNA and would like to do one of the Cisco professional courses after. Which one would you recommend in terms of job security and money? I have been told CCVP is a good option, but I am not sure.

Answer Question   |  February 23, 2009  7:42 PM
CCNA, CCVP, Cisco certifications, IT career planning, IT careers, IT jobs, Networking, Networking certifications, Training, Training and certifications

Is a job in networking or storage better for one year’s worth of work experience?
I have been particularly interested in networking and as a result got CCNA certified. But due to business requirement constraints, my company’s human resource placed me into the Backup Operations team where I work on Veritas Netbackup for Windows. I have been given an opportunity to move to the networking team next month if I [...]

Answer Question   |  February 18, 2009  7:39 PM
Field, IT career planning, IT careers, IT jobs, Job training, Networking, Networking careers, Networking careers and salaries, Salaries, Salaries and jobs, Salaries and wages, Salary & hiring, Storage

PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL
Hi Experts, How can we make a check on an attribute not null but can take – rather I have address 3 which can’t take null instead – would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN … END IF But i want to [...]

Answer Question   |  February 20, 2009  3:59 AM
NOT NULL, NULL, PL/SQL, PL/SQL procedure

How to use embedded SQL in a RPG program used as a stored procedure
When I use embedded SQL in a RPG program and call it from another program it works fine. But, when I try to use the program as a stored procedure it gives me a SQL error. I have worked with stored procedures and understand them, but have not been successful using embedded SQL with them. [...]

Answer Question   |  February 12, 2009  9:36 PM
Embedded SQL, iSeries RPG programming, Stored Procedures

Problems with VAL function
I have a table with an NVarChar field that contains left aligned numeric values. I’ve tried using the VAL function to return the integer values, but I’m getting back Short Date results. What can I do to get integer results? Thanks, Arlin

Answer Question   |  February 17, 2009  4:33 PM
Access reports, Microsoft Access, VAL Function