sqlserver 2000 stored procedures
Hi, I am not quite sure what you mean exactly with to integrate. Do you have to call the stored procedures or do you have to implament identically one in our MySQL system? First thing should be quite simple. For the second you need to know the exact definitions.
View Answer
| April 4, 2005 10:25 AM
ColdFusion, MySQL, SQL, SQL Server
Hi, I am not quite sure what you mean exactly with to integrate. Do you have to call the stored procedures or do you have to implament identically one in our MySQL system? First thing should be quite simple. For the second you need to know the exact definitions.
View Answer
| April 4, 2005 10:25 AM
ColdFusion, MySQL, SQL, SQL Server
Loading CSV files into Oracle tables
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
There are 6 ways to do it: 1. There is a software, called Oraxel (or something like that) which connect Excel tables with oracle (and vise versa) 2. You could export your Excel tables into Access and link Access – Oracle tables through ODBC 3. You could do such export with OEM (Oracle Enterprize Manager) [...]
View Answer
| April 19, 2013 4:13 PM
Corporate Financial Applications, Database Management Systems, ERP, Financials, Human resource applications, Informix, iReceivables, Microsoft Access, Oracle, Payables, Procurement, Projects
REPORT WAIT TIMES
It would be interesting to know what kind of things would need to be changed in reports to make it SQL Server ready. Reports are based on queries or tables. Queries are based on table. Tables are either native Access, linked using ODBC or OLE datalink. But to Access reports, all these types of tables [...]
View Answer
| March 30, 2005 5:31 PM
Microsoft Access, SQL Server
It would be interesting to know what kind of things would need to be changed in reports to make it SQL Server ready. Reports are based on queries or tables. Queries are based on table. Tables are either native Access, linked using ODBC or OLE datalink. But to Access reports, all these types of tables [...]
View Answer
| March 30, 2005 5:31 PM
Microsoft Access, SQL Server
Help with VBA Code for retrieving data from a table in an MS Access Database
u can create a query to ur employee table with the where clause mentioning ur selected employee id, and then binding the fields with the recorset. also if u have the navigation buttons on ur form, u can use the find and move method of the recordset that binds to the navigation buttons, specifing ur [...]
View Answer
| March 30, 2005 3:51 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
u can create a query to ur employee table with the where clause mentioning ur selected employee id, and then binding the fields with the recorset. also if u have the navigation buttons on ur form, u can use the find and move method of the recordset that binds to the navigation buttons, specifing ur [...]
View Answer
| March 30, 2005 3:51 AM
Database, DB2, Oracle, SQL, VBA, Visual Basic
Security Forensics with Niksun or CA or Sandstorm
The answer on first part of your mail is IMHO the program called Ethereal. It’s FREE, it works on GNU/Linux and Windows OS and it is very easy to use. It provides packet filtering, IP filtering, protocol filtering… Link: http://www.ethereal.com/ Bye
View Answer
| March 27, 2005 6:27 AM
Application security, Bandwidth, Database, Encryption, Exchange, IDS/IPS management, Instant Messaging, Intrusion management, IT architecture, Network monitoring, Networking, Secure Coding, Security, Security management, Vulnerability Assessment & Audit
The answer on first part of your mail is IMHO the program called Ethereal. It’s FREE, it works on GNU/Linux and Windows OS and it is very easy to use. It provides packet filtering, IP filtering, protocol filtering… Link: http://www.ethereal.com/ Bye
View Answer
| March 27, 2005 6:27 AM
Application security, Bandwidth, Database, Encryption, Exchange, IDS/IPS management, Instant Messaging, Intrusion management, IT architecture, Network monitoring, Networking, Secure Coding, Security, Security management, Vulnerability Assessment & Audit
Accessing Linked Server in SQL Server 2000 (Urgent)
Hi All this is bakash again The secon server is linkedserver. I missed ” in my previous question. Sorry pls help thanks
View Answer
| March 23, 2005 10:50 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
Hi All this is bakash again The secon server is linkedserver. I missed ” in my previous question. Sorry pls help thanks
View Answer
| March 23, 2005 10:50 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
Default Group Policy Objects in Active Directory – Windows 2000 Server
I also use Sophos enterprise manager and the only difference in the member of group is I also have it as a member of server operator and domain user. Have you tried running a task for placing a account on those servers using auto-upgrade account through your SAV admin and then running a task to [...]
View Answer
| March 16, 2005 10:33 AM
Active Directory, Application security, Biometrics, Database, DataCenter, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security tokens, Single sign-on
I also use Sophos enterprise manager and the only difference in the member of group is I also have it as a member of server operator and domain user. Have you tried running a task for placing a account on those servers using auto-upgrade account through your SAV admin and then running a task to [...]
View Answer
| March 16, 2005 10:33 AM
Active Directory, Application security, Biometrics, Database, DataCenter, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, Microsoft Windows, provisioning, Secure Coding, Security tokens, Single sign-on
SQL Server equivalent of Oracle’s desc tablename command
sp_columns ‘tablename’
View Answer
| March 15, 2005 2:24 PM
Database Management Systems, MySQL, Oracle, SQL Server
sp_columns ‘tablename’
View Answer
| March 15, 2005 2:24 PM
Database Management Systems, MySQL, Oracle, SQL Server
Difference between SQL and T-SQL(Microsoft SQL Server 2000)
From TechTarget.com: What is the difference between SQL and T-SQL? Why would a company use one over the other? This question posed on 14 February 2002 ANSI SQL is the standard Structured Query Language. Most database vendors support SQL. T-SQL is Microsoft’s “flavor” of SQL; it is ANSI SQL with Microsoft’s extensions. A company could [...]
View Answer
| March 15, 2005 9:42 AM
Database Management Systems, DataCenter, MySQL, SQL Server
From TechTarget.com: What is the difference between SQL and T-SQL? Why would a company use one over the other? This question posed on 14 February 2002 ANSI SQL is the standard Structured Query Language. Most database vendors support SQL. T-SQL is Microsoft’s “flavor” of SQL; it is ANSI SQL with Microsoft’s extensions. A company could [...]
View Answer
| March 15, 2005 9:42 AM
Database Management Systems, DataCenter, MySQL, SQL Server
Database comparison
Hello, I use the folowing script to get obj diffs between my SQL DB and those of the developpers. These scripts only check U,V,IF,FN,TR,P,C existence and diffs in columns or parameters. Since all TSQL code is put into CVS. You can easily add a script that checks systext. Also, default column values are not checked. [...]
View Answer
| March 10, 2005 8:02 AM
Database, DB2, Oracle, SQL Server, SQL Server 2000, T-SQL
Hello, I use the folowing script to get obj diffs between my SQL DB and those of the developpers. These scripts only check U,V,IF,FN,TR,P,C existence and diffs in columns or parameters. Since all TSQL code is put into CVS. You can easily add a script that checks systext. Also, default column values are not checked. [...]
View Answer
| March 10, 2005 8:02 AM
Database, DB2, Oracle, SQL Server, SQL Server 2000, T-SQL
Domino Database Last Used
If the database is marked to be listed in the domain catalog (database properties) then the Domain Catalog will show the creationdate, last modified and activity along with alot of useful info. The activiy includes changes from scheduled agents.
View Answer
| March 9, 2005 7:49 AM
Database, DB2, Development, Domino Designer, Lotus Domino, Oracle
If the database is marked to be listed in the domain catalog (database properties) then the Domain Catalog will show the creationdate, last modified and activity along with alot of useful info. The activiy includes changes from scheduled agents.
View Answer
| March 9, 2005 7:49 AM
Database, DB2, Development, Domino Designer, Lotus Domino, Oracle
Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2
It depends how much work want to put in. If you’re using SQL Server 2000 then you might want to look into its Reporting Services which can handle quite a bit. If you really want to save money and you have time to code, check out a product called ActiveReports by Data Dynamics. It’s a [...]
View Answer
| March 2, 2005 11:01 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
It depends how much work want to put in. If you’re using SQL Server 2000 then you might want to look into its Reporting Services which can handle quite a bit. If you really want to save money and you have time to code, check out a product called ActiveReports by Data Dynamics. It’s a [...]
View Answer
| March 2, 2005 11:01 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Front-End Reporting Tools for Secure Web Service Application with MS-SQL server
In response to 1, wouldn’t you rather use ASP to interrogate the SQL database, instead of Access? Are the other options confidential?
View Answer
| March 2, 2005 10:11 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
In response to 1, wouldn’t you rather use ASP to interrogate the SQL database, instead of Access? Are the other options confidential?
View Answer
| March 2, 2005 10:11 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
Access 2003 Options Group
I can’t tell for sure in your question and I think you are, but you need to use an Option Group and not a Frame. Then the control that is the Option Group has the value and the individual option controls, usually Option Buttons do not have a value property. So if your Option Group [...]
View Answer
| March 2, 2005 9:35 AM
Microsoft Access
I can’t tell for sure in your question and I think you are, but you need to use an Option Group and not a Frame. Then the control that is the Option Group has the value and the individual option controls, usually Option Buttons do not have a value property. So if your Option Group [...]
View Answer
| March 2, 2005 9:35 AM
Microsoft Access
Secure Email Delivery Applications
We have been using IronMail for some time now and have been very happy with it. We are in the process of getting there secure delivery applicance installed so I have no experience with the solution you are looking for but can give a vote of confidence for CipherTrust as a vendor. There secure delivery [...]
View Answer
| March 2, 2005 9:24 AM
Application security, Compliance, CRM, Database, Disaster Recovery, E-mail applications, Encryption, Exchange, Instant Messaging, Policies, Risk management, Secure Coding, Security, Security Program Management
We have been using IronMail for some time now and have been very happy with it. We are in the process of getting there secure delivery applicance installed so I have no experience with the solution you are looking for but can give a vote of confidence for CipherTrust as a vendor. There secure delivery [...]
View Answer
| March 2, 2005 9:24 AM
Application security, Compliance, CRM, Database, Disaster Recovery, E-mail applications, Encryption, Exchange, Instant Messaging, Policies, Risk management, Secure Coding, Security, Security Program Management
I have some problem sending and receiving email in my ISA Server 2000 for certain users.
Just a guess without seeing the ACL. You are allowing those users access to a single site and denying everything else. They must also be allowed to use the email. If you say allow yahoo and then deny everything else this will include all email ports.
View Answer
| March 2, 2005 8:56 AM
Application security, Database, DataCenter, DHCP, DNS, Encryption, Exchange, Help Desk, Instant Messaging, Networking, Networking services, Secure Coding, Security, Tech support
Just a guess without seeing the ACL. You are allowing those users access to a single site and denying everything else. They must also be allowed to use the email. If you say allow yahoo and then deny everything else this will include all email ports.
View Answer
| March 2, 2005 8:56 AM
Application security, Database, DataCenter, DHCP, DNS, Encryption, Exchange, Help Desk, Instant Messaging, Networking, Networking services, Secure Coding, Security, Tech support
Improve MS Access performance on a Win 2k LAN
Hi Harg7769, I am assuming a relatively small wokgroup of around 10-25 users, in the absence of other information. There are possibly two issues here, an easy one and a difficult one. The easy one is to throw RAM at the problem – double the quantities on the workstations and quadruple on the server. You [...]
View Answer
| March 1, 2005 7:58 AM
Microsoft Access, Performance/Tuning
Hi Harg7769, I am assuming a relatively small wokgroup of around 10-25 users, in the absence of other information. There are possibly two issues here, an easy one and a difficult one. The easy one is to throw RAM at the problem – double the quantities on the workstations and quadruple on the server. You [...]
View Answer
| March 1, 2005 7:58 AM
Microsoft Access, Performance/Tuning
Authorization in MIGO
I haven’t come acrooss this particular problem,in the same way you are. however, I have on o ccassin been asked to allow non-admin. users acess to apps. with out granting full permission. So I’ve enclosed this link , and hope it’s of use to your quandry:http://msdn.microsoft.com/library/en-us/dncode/html/secure1152004.asp?frame=true
View Answer
| February 27, 2005 9:31 AM
Application security, Biometrics, Compliance, CRM, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Identity & Access Management, Instant Messaging, Policies, provisioning, Risk management, Secure Coding, Security Program Management, Security tokens, Single sign-on
I haven’t come acrooss this particular problem,in the same way you are. however, I have on o ccassin been asked to allow non-admin. users acess to apps. with out granting full permission. So I’ve enclosed this link , and hope it’s of use to your quandry:http://msdn.microsoft.com/library/en-us/dncode/html/secure1152004.asp?frame=true
View Answer
| February 27, 2005 9:31 AM
Application security, Biometrics, Compliance, CRM, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, Identity & Access Management, Instant Messaging, Policies, provisioning, Risk management, Secure Coding, Security Program Management, Security tokens, Single sign-on
Oracle 8i/9i Database Access
You could use views DBA_ROLE_PRIVS and DBA_TAB_PRIVS to identify what roles and object privileges have been granted to a user. HTH.
View Answer
| February 26, 2005 5:41 PM
Very Large Databases
You could use views DBA_ROLE_PRIVS and DBA_TAB_PRIVS to identify what roles and object privileges have been granted to a user. HTH.
View Answer
| February 26, 2005 5:41 PM
Very Large Databases
Developing an antivirus (efficient):for Windows:Using VC++
Your professor would probably be pleased if you had some perspective on challenges involved. 2600.com has plenty of information in that regard. Good luck! Craig Herberg
View Answer
| June 29, 2012 10:44 AM
Application security, Architecture/Design, Central Command, Compliance, Computer Associates, CRM, Database, DataCenter, Desktop antivirus, Development, Disaster Recovery, Documentation, Encryption, Exchange, F-Secure, Features/Functionality, Fortinet, Help Desk, Information risk management, Instant Messaging, Intrusion management, Lifecycle development, Panda, Policies, Product evaluation, Redundancy, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, Service and support, Signature updating/Management, Software Quality Assurance, Storage, Tech support, Third-party services, Trend Micro, Vendor support, Vendors, VPN, Vulnerability Assessment & Audit
Your professor would probably be pleased if you had some perspective on challenges involved. 2600.com has plenty of information in that regard. Good luck! Craig Herberg
View Answer
| June 29, 2012 10:44 AM
Application security, Architecture/Design, Central Command, Compliance, Computer Associates, CRM, Database, DataCenter, Desktop antivirus, Development, Disaster Recovery, Documentation, Encryption, Exchange, F-Secure, Features/Functionality, Fortinet, Help Desk, Information risk management, Instant Messaging, Intrusion management, Lifecycle development, Panda, Policies, Product evaluation, Redundancy, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, Service and support, Signature updating/Management, Software Quality Assurance, Storage, Tech support, Third-party services, Trend Micro, Vendor support, Vendors, VPN, Vulnerability Assessment & Audit
