Search results for query: *

Hi All, We have been experiencing this problem for many years now, and even calls to Frontrange tech support didn't result in any lasting results. I'll show the error, followed by the actions we tool to attempt to resolve it: General SQL error. Native SQL error: 10025 Context: SQLQuery...

Hi All, I have set up a pull subscription, but everytime I run it, I receive the following error (I have captured this to an output file): I have been absolutely unable to find any help googling the error. Does anyone have any ideas? Thanks! Take Care, Mike

Hi All, I am developing some reports in VS2005 in a Reporting Service project using the integrated report designer. The query runs just fine in the data tab and returns about 5000 rows. However, when I run the report in the preview tab, set my applicable report parameters (which should further...

Hey All! I've been reading up on the UPDATETEXT functionality, and it seems like a step in the right direction, however: I am unable to find any examples that update text fields based on query results. I'm looking for something like this: UPDATE target_table SET target_field =...

Hi Everybody! I have had this constant problem with linked servers: I can never get them to connect despite following all the FAQs and articles out there. Here's the situation: 1 - Server A running on Windows 2003 R2 Server, SQL2005, mixed mode authentication. 2 - Server B running on Windows...

Hey Everyone! I have a script that I am using to clean up some legacy data. It runs, and functions exactly like it should. However, there is one problem: it takes much too long to run. Here's the scenario: - I have 100,000 records that need to be processed. - Currently it processes about...

Hello friends, I am working on doing a database cleanup in preparation for some application migration. This entails making sure (as much as I can anyway) that each field contains the correct values. One of these field is for storing URLs. Is there any way I can check for valid URL format...

I'm having a *insert something here* of a time getting CPS connected to ActiveDirectory. As soon as I add User Search Branch DN, I get "Error connecting to LDAP server." when testing on the Test tab. Is there a good resource on getting things set up right, specifically for ActiveDirectory? The...

I am able to get the list of tables from my linked server in SQL2000 using the following query: BEGIN DECLARE @t_tables TABLE (table_name VARCHAR(255)) DECLARE @s_current_table_name VARCHAR(255) ,@s_sql AS VARCHAR(4000) DECLARE c_loop CURSOR FOR SELECT table_name FROM @t_tables INSERT...

I would like to pass the reference of the instance of class A from within itself to class B, so that I can perform a callback from class B, once it has completed its processing. How is this possible? My current work-around, which I am trying to get away from, is hard-coding the class A...

I've been browsing some scripts on the net lately and have come across something I haven't seem before: var [name] = { [name] : function ([parameters]) { [...] } } I'm at a loss as to how this works? is this a class immediately instantiated in a variable, with all its...

Hi All! I have the following situation: SQL Server 2000 server at company A wants to send data to a SQL Server 2000 server at company B. Company B wants to send an acknowledgment back to the SQL server at company A once the received data is processed. What is the best way to do this? I was...

I must be having a brain-fart or something. Something I know I have done in the past is giving me problems today and I can't get my head around it. (Must be one of those days ...) Here's my situation: I want to pass the instance of a class (my db abstraction class) into another class, like...

I'm getting the following error, eventhough I have the include and library directories set up: Any ideas why? Thanks! Mike

I have tried setting mssql.timeout in php.ini to 300 (5 minutes) to no avail. I still get the following error when trying to get query results: This is line 112: $o_rs = mssql_query("EXEC get_ct_multi_facilities '" . $a_row[$i]['ct_facility_name'] . "', '" . $a_row[$i]['v_city'] . "', '" ...

Hi everyone! I am experiencing a very strange bug using PEAR:MDB2 in conjunction with my MS SQL 2000 Server, which has some Oracle servers set up as linked servers. Here's the problem: If I run a query against just the MS SQL Server I get all records as expected. However, if I join these...

Hi All! I'm hoping someone can help me with the following code: var o_doc = opener.document; var o_row = null; var o_cell_name = o_doc.createElement("td"); var o_cell_phone = o_doc.createElement("td"); var o_cell_zip = o_doc.createElement("td"); if...

Hi all, I've worked myself in a bit of a pickle here, and can't quite seem to figure this one out. Requirements: the regex must not match the string if a phrase that is being tested for is in it. What I am Doing: I am looking at email headers and directing them appropriately. If my email does...

My basic question is: how can I execute dynamic SQL (declaring a cursor from dynamic SQL) from within a user-defined function? Here's the function: ALTER FUNCTION concat_results ( @sql AS VARCHAR(1000) ,@delimeter AS VARCHAR(255) ,@pre_text AS VARCHAR(255) ,@post_text AS VARCHAR(255) )...

Hi All, For the life of me, I can't figure out how to successfully execute stored procedures in PHP (on IIS) in MSSQL using MDB2. I have the following code: $db = MDB2::connect([...]); $db->loadModule("Function"); $r_resultset = $db->function->executeStoredProc("[stored proc name]", [parameter...