• 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 issue. when...

    Sagar20005 pointsBadges:
  • 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

    5149365 pointsBadges:
  • ESX luns allocated on Symmetrix will not format.

    Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs format fine but one or two come up with an error message that says "unable to read partition information from this disk." All of the luns were exactly the same capacity. The ESX is currently attached to a Symmetrix array as...

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

    GIG240 pointsBadges:
  • 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 uses to updated a different...

    Arielnavon15 pointsBadges:
  • Auto download a .CSV file from network drive

    to a AS/400 physical file through a cl program? how can I do this?

    UARTJ105 pointsBadges:
  • 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. Any ideas...

    Warykat20 pointsBadges:
  • 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?

    Detox5 pointsBadges:
  • 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 information is distributed to our...

    Mandolorean5 pointsBadges:
  • How Do I release unused space from a tablespace after dropping a blob table

    I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

    Hmhora10 pointsBadges:
  • redord retrieval in SQLRPG

    Hi, can anybody tell me how to retrieve a record randomly using cursors...(say 8th record) using SQLRPG(Embedded sql)

    ten20081,150 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • Access 2007 Report OutputTo Print

    Please help. This is driving me around the bend. I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see: Has anyone encountered this before? I have many other reports and they all save correctly...

    Riaane65 pointsBadges:
  • ASP.NET and Multiple Access Databases Open

    Dear Colleagues Please could you help me? Is it possible to have an ASP .Net Web application with multiple (7) large MS Access 2000 databases open simultaneously. When I heard this I was surprised because there could be dozens of users each using up to 7 large and disparate Access databases...

    Hessm0035 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    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

    Inprise610 pointsBadges:
  • Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)

    HI, I have upgrade oracle database from 9i to 10g via export/import, My application is using Jreport. When I was using oracle 9i Reports were working perfect but after upgrading to 10g when I fetch reports it goes blank.

    Hasan15 pointsBadges:
  • Creating a CSV file to FTP

    I just loaded Office 2007 and created a csv file which then was FTP'ed to a server. When picked up it had lost its csv extension. I follow this process regularly and this only happened after I upgraded to 2007. Any ideas?

    Superiorsys15 pointsBadges:
  • Limit number of rows in a table

    Dear all, I'd just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 sites. When...

    ElArZ15 pointsBadges:
  • SQL Server Query Help Needed

    I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the...

    Arlin70 pointsBadges:
  • Performance of very large SQL Server table with millions of rows

    Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

    Elhajjh5 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