How to insert Hex values through SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]

Answer Question   |  April 23, 2013  11:07 PM
SQL Database, SQL Query, SQL/400

Access
How do I access SQL data in software?

Answer Question   |  April 18, 2013  11:20 AM
SQL Database, VB .NET

I need the date to go to my dataTable
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]

Answer Question   |  March 29, 2013  5:10 PM
SQL Database, VB 2012

Changing web server can access back office app through local host but not when it is on DMZ
We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into [...]

Answer Question   |  November 19, 2012  11:04 AM
DMZ, SQL Database, Windows Web Server 2003

Database
How to create a database of prison management system using SQL?

Answer Question   |  October 9, 2012  4:33 PM
SQL, SQL Database

SQL table connectivity via odc
Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

Answer Question   |  August 30, 2012  2:18 PM
Microsoft Excel, Microsoft odc, SQL Database

Insert values into database from form VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]

Answer Question   |  March 28, 2012  9:52 AM
SQL Database, VB.NET

Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]

Answer Question   |  February 27, 2012  10:25 AM
SQL Database, SQL Server 2005

SQL Server backup to remote internet location
We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, [...]

Answer Question   |  October 20, 2011  10:21 AM
SQL Backup, SQL Database, SQL Server, SQL Server backup

Updating SQL 2000 Data
Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle [...]

Answer Question   |  March 31, 2012  3:56 PM
MDF File, SQL 2000, SQL Data Set, SQL Database

Create new SQL 2008 database in external drive
My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.

Answer Question   |  March 31, 2012  4:00 PM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008

Visual Basic and SQL database design
i have vb.net & sql  application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid  it Will give a bad performance  or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net  wich [...]

Answer Question   |  March 31, 2012  6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET

Connecting to SQL Database
We are no longer able to connect to our SQL database or open the DB manager on Windows Server 2008. This is SQL 2005 how can we troubleshoot this issue? We have a 2.9gb database and backups from each night.

Answer Question   |  March 31, 2012  5:59 PM
Database management, SQL 2005, SQL 2005 Database, SQL Database, Windows Server 2008

Update Data SQL Server From AS400
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

Answer Question   |  March 31, 2012  5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server

SQL database design
i have slary system using vb.net  and sql server there is  27 user the compute up to  700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key  is there any proplem with this algorthim [...]

Answer Question   |  March 31, 2012  6:09 AM
Database, Database design, SQL Database, SQL Server database design and modeling

How to search more than a word in a column SQL database?
i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute(“SELECT idf FROM instance WHERE instance=’”+ word +”‘”)     conn.CommitTrans() but some of the searchword cannot be access eventhough it do exist in my database table. [...]

Answer Question   |  March 31, 2012  5:19 AM
Python, SQL, SQL commands, SQL Database

VPN Hollander Powerlink Server issues
I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having [...]

Answer Question   |  March 31, 2012  3:34 AM
SQL Database, SQL Server 2005 performance, SQL Server security, VPN connectivity, Windows XP Pro SP3

VPN Connectivity Issue with SQL Database
My Issue is with a VPN Connection. I have an SQL Data Base set up on a Windows XP Pro machine. We are using a Clear Motorola WFIMAX Modem and an AirPort Extreme Router. I have port 1723 Forwarded and Out going and Incoming Connections created on both Server and Client.  The Server has a [...]

Answer Question   |  March 31, 2012  1:26 AM
Networking services, SQL Database, VPN connection problem, VPN connectivity, VPN issue

Optimize SQL 2005 databases on a schedule
How can I optimize my SQL 2005 databases on a schedule?

Answer Question   |  June 28, 2011  6:21 PM
SQL 2005, SQL 2005 Database, SQL Database, SQL Server 2005, SQL Server 2005 Database

Modifying a Stored Procedure
The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the [...]

Answer Question   |  June 9, 2011  2:31 PM
Crystal Reports, SELECT statement, SQL, SQL Database, SQL stored procedures, Stored Procedures