• How to connect Visual Basic 6.0 to wampserver using odbc

    Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.

    Dudz20105 pointsBadges:
  • CR 11 connection to sql 6.5

    I need too connect CR 11.5 to SQL 6.5. Which connection method do I use?

    creggFisher5 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • I am getting following error for SQL server 2005/2008

    Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL...

    Brijeshkumar5 pointsBadges:
  • What are the security risks of using hosted SQL

    B"H Where ever I look I see that no one recommends having your SQL Server available on the Internet (public ip). Everyone says that you should only have local machines access your sql. If you need to access your sql then you should VPN into your secure network and then have access. or you should...

    Mplotkin5 pointsBadges:
  • How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD

    I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype field to store Nodes of XML

    VinayVerma510 pointsBadges:
  • machine name/sqlexpress2008r2 is giving error

    Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error....

    georgesmith55 pointsBadges:
  • Security Awareness training for FTI

    I am responsible for the Security Awareness program and I’m trying to put together my IRS Security Awareness training. I work for a government agency and we have to have annual training for security FTI (federal tax information) data, which is required by the IRS. I am looking for a video that we...

    mizblue10 pointsBadges:
  • 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.

    tswanson3005 pointsBadges:
  • SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue

    I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are for web...

    Jabba12310 pointsBadges:
  • Sql Search

    Hi, I have a Search box on my site at top. Where visitor can enter any keyword. I have Full Text Search enabled on my DB and index the Columns. I have one Columns SalesTitle in one of Table Catalog.Product, which contains almost our required keyword, like ProductNumber, Description, BrandName,...

    Mr. SEA130 pointsBadges:
  • how do I cause a field to be null, using DFU?

    how do I cause a field to be null, using DFU to update/insert a record?

    tegarvey35 pointsBadges:
  • Career change RPG/ILE to ASP.net

    After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today's business needs. I am still working for the same company so no real risk in the move. My question is what do you think will be the...

    ToddN20009,700 pointsBadges:
  • Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server

    Hello, I am getting the below error on customer production error, Query timeout expired - State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC's record sets. if I try to run that queries on SSMS directly I am not getting that error. How...

    Narasimhulu10 pointsBadges:
  • java

    i need to include N number names into the database from single textbox at the run time of the program using java

    SABARISHJAGANATHAN15 pointsBadges:
  • Trigger Perormance Issues when Journalling Started

    I have an external trigger program (RPGIV) that is added to about 50 files. Its task is to store record images upon insert, delete, update in any of the 50 files. It stores the images in another file (the monitor file) which also contains an identity field (generated always as identity). All files,...

    FrankWM110 pointsBadges:
  • 2003 Sever Domain Issue

    Currently my customers running a Windows 2003 server with 2005 SQL and a Active Server.We just put a 20 meg Fiber service into the Office. The issue we are having is it will still take 1-3 mins to load a web page. The DHCP on the router has been placed inactive for a block of IP and the Server has...

    greatjubee165 pointsBadges:
  • Internet Connection Battle in windows 2003 Server.

    My customer currently is using a Windows 2003 server with 2005 SQL server, and an active directory in place. The server is set to do DHCP and DNS on the LAN. We have a Cbeyond Cisco Fiber router recently installed. All workstations are set to Static IP address same Sub net with Default Gateway...

    greatjubee165 pointsBadges:
  • Restore SharePoint 2003 database/s on SQL Server 2005

    I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the...

    TLMercer45 pointsBadges:
  • Recursive CTE With UNION gives error

    why can’t we use , just “UNION” instead of “UNION ALL” in the recursive CTE’s. If I use just UNION in the recursive CTE it is throwing error. Can you please help me out? Example, CREATE TABLE te (sno int) Go INSERT INTO te VALUES (1),(4),(10) Go ;WITH ctemax(maxsno,minsno) AS (SELECT...

    RecursiveCTE15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following