Search results for query: *

My dataset has two tables: Skills and Employee_Skills. Skills has a complete list of SkillName. Employee_Skills has a list of SkillName that an employee has obtained. They are from different databases, and the two tables are filled using dataAdapter with separate DB connections. Now I want to...

I have a company-wide authentication standard page written in classic asp (sign_on.asp). In my classic ASP applications, I just include "sign_on.asp" in the first line of every page and the authentication is taken care of. Now I have a ASP.net (2.0) with C# Web application. I cannot include the...

I tried to connect CR to my IIS Log. When I clicked "Web/IIS Log Files", it prompted me to select a directory. I selected the mapped drive I created that links to my IIS server. The directory's name is like "//testserver/C$/Systems32/W3C.../". The connection is done, but there are no items...

I didn't add CAO 1.0 Type Library. Let me give it a try. Thank you.

Thanks, but I am asking how to get the source of data (like c:\temp\test.mdb). Once I got the data source, I know how to build connection string and so on. Any thoughts?

I am using Autodesk Map 2005 and I opened a dwg file and attached an Access database (C:\temp\abc.mdb) through the menu Map->Data Source -> Configure. Now I want to retrieve the data source (C:\temp\abc.mdb) via VBA code, but I don't know how. I have looked at Database object and ModelSpace...

I am using autodesk Map 3D 2005. I need to create a macro inside the autodesk Map. This vba macro will make connection to database as appears in "data source", extract the data in the database, and save the data into a xml file sequencially (read data and always append to the end of the file)...

I performed backup from Enterprise Manager: right click on database -> All tasks ->backup database. Then it took about 10 minutes to get the first Backup Wizard screen.

I have a problem with backing up 300G DB. It is SQL Server 2000, the MDF(50MBs) is in C drive, one NDF(33,000MBs) and one LDF (21G) are in F drive. The index files are in F drive too. The backup mode is "Full". When I tried to back it up in Enterprise Manager, after 10 minutes of running, I got...

Let me repost it with the valid XML: My XML structure: --------------------------- <INVOICE> <TASKS> <TASK ID=&quot;1000&quot; NUMBER=&quot;01.A001&quot;/> <TASK ID=&quot;2000&quot; NUMBER=&quot;01.A002&quot;/> <TASK ID=&quot;3000&quot; NUMBER=&quot;01.B001&quot;/>...

My XML structure: --------------------------- <INVOICE> <TASKS> <TASK ID=1000 NUMBER=&quot;01.A001&quot;> <TASK ID=2000 NUMBER=&quot;01.A002&quot;> <TASK ID=3000 NUMBER=&quot;01.B001&quot;> <TASK ID=4000 NUMBER=&quot;01.B005&quot;> </TASKS> <LINE>...

How do I stop execution inside a stored procedure immediately after a certain line, just like EXIT does in a loop? What I need is: ------------------- procedure my_procedure() is begin ... IF my_cursor%NOTFOUND THEN -- exit; end if; ... end; ---------------------- Thanks.

An example: ---------------------- TYPE task_rec_type IS RECORD (id NUMBER, name VARCHAR2(25)) TYPE task_tbl_type IS TABLE OF task_rec_type INDEX BY BINARY_INTEGER; --------------------- Question: Can I have the function: FUNCTION load_table(p_task_id IN NUMBER) RETURN task_tbl_type IS ...

That's wonderful! Thanks a million, folks. I got a big package to write and my several tables have nearly 100 columns. The code will definitely help me to make it shorter and neater and faster.

Check the following: ---------------------- TYPE task_rec_type IS RECORD (id NUMBER, name VARCHAR2(25)) TYPE task_tbl_type IS TABLE OF task_rec_type INDEX BY BINARY_INTEGER; --------------------- I have a table (tasks) in database with two columns(id, name). Now I want to select records from...

Thank you. That works. But I don't understand why I need to do this. Doing this way requires me to do it on all the objects (tables and SPs). That's a pain. So, two more questions: (1) I connect QA as myLogin(sysadmin and db_owner), all objects are owned by myLogin. Since myLogin is sysadmin...

Thank you both. I connect QA with &quot;mylogin&quot; account, which is DB_owner and sysadmin. Under myDatabase, I ran the following: sp_changedbowner [mylogin], [dbo] Then I got the following error: &quot;The proposed new database owner is already a user in the database.&quot; When I...

I restored a database from a backup file on the other server. Then I ran sp_auto_fix_login to fix the logins on the new server. I need to run tens of stored procedures (with a single call) developed by our vendor and all the procedures and other referrenced objects have [dbo] as...

I forgot to type &quot;Subject&quot; in my previous post. Here I post it again. I have a table (&quot;title&quot;) that stores tree-structure info: -------------------------------------- id name parent_id has_child 0 CEO -1 1 1 VP-Finance 0...

I have a table (&quot;title&quot;) that stores tree-structure info: -------------------------------------- id name parent_id has_child 0 CEO -1 1 1 VP-Finance 0 1 2 VP-CIO 0 1 11 Controller 1...