|
by: xo55ox |
last post by:
Hi,
Did anyone successfully set up a local package to first ftp a db.bak
and second perform an automated db restore?
I need to perform an automated task, which ftp nightly backup file to
another server and then restore onto a database and leave the database
in read-only mode for additional transaction logs restore during the
day.
|
by: mjcsfo |
last post by:
I can't seem to find a reference nor any helpful threads on this
topic.
I've gotten the following error in two circumstances:
1. A complex type has nested within it another complex type, in the
"Russian doll" style of schema design, where the nested type is
local
and anonymous (not a separate global type).
2. A complex type has nested within it a simple type which is derived
through restriction with at least one facet, again nested,...
|
by: Tatiana Zadiraka |
last post by:
I use DB2 8.1 with FixPack 5. In command line for sql I get all DATE
columns only in MM-DD-YYYY format. Of course, DATE('20-12-2003') gives
me an error
SQL0181N The string representation of a datetime value is out of
range.
SQLSTATE=22007
My db config is:
Database territory = RU
|
by: robpimentel |
last post by:
Hi, I've been using DB2 for about 1 week, so please bear with me.
DB2 Connect Enterprise Edition v8.1 FixPack 5
Windows Server 2003 Standard Edition SP1
Here is an error that continues to appear on our domain controllers
(Security event log):
Event Type: Failure Audit
Event Source: Security
|
by: LimaCharlie |
last post by:
Good day to all,
My frontend is visual basic and my backend is SQL. I need to pass a date parameter to my DTS Package. What should be my VB syntax?
Here's how I call my DTS package:
Private Sub DTSAccess()
Dim objPackage As New Package
objPackage.LoadFromSQLServer "SQL2K-VBP", , , DTSSQLStgFlag_UseTrustedConnection, , , , "HRIS_DTSFromAccess"
objPackage.Execute
|
|
by: John Morgan |
last post by:
I have my first small SQl Server 2005 database developed on my local
server and I have also its equivalent as an online database.
I wish to update the local database (using and asp.net interface) and
then to upload the data (at least the amended data, but given the
small size all data should be no trouble) to the online database.
I think replication is the straight answer but I have no experience of
this and I am wondering what else...
|
by: nico3334 |
last post by:
Hi, I am coding a DTS Local Package that transfers Access Data into SQL Data. I am pulling 2 fields: a month and a year. The month format is "Jan, Feb, Mar, Apr, May, Jun, etc.), the year format is "2007, 2008, 2009, etc". What I want to do is put these 2 fields together into one column in SQL in this format: "200701" instead of "2007Jan". Or for Feb: "200702".
Here is the code that I have, but I want to make it simpler and quicker:
...
|
by: iavian |
last post by:
Hi All,
Getting below error, what might be the issue...
Can't call method "numify" without a package or object reference at /usr/local/lib/perl5/site_perl/5.6.1/OLE/Storage_Lite.pm line 1329.
My progrmam has just 3 lines of code as below
#!/usr/bin/perl
use Spreadsheet::ParseExcel;
my $excel = Spreadsheet::ParseExcel::Workbook->Parse($ARGV);
|
by: koti688 |
last post by:
Hi Guys, I am a beginner to perl.
I need a perl package which will perform basic DB operations like select , insert,update,delete operation MySql DB.
i Have a Mysql DB which resides on my local machine.DB Deatils are :
Localhost,MySql,DatabaseName:perltest, username:root,pwd:sierra,table:samples with coulms :id,name,phone
I am done with selecting the rows in DB. I need Sample code for inserting , updating and deleting . Please provide...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|