I just set up MSDE a couple of weeks ago, and had this same frustration. Turns out all I had to do was the run SQL Server Network Utility: c:\Program...
Jeff Peters
jpeters@...
Aug 1, 2005 4:49 pm
2297
I need to export a script to plain text (no windows text or unix text). can you add that option?...
Hi Nicolas, I still don't understand what you mean. The export is in "plain text". There is no such thing as windows or unix text. The export has an option...
If I open it with notepad there are square symbols at the end of evry line (if I open it with word the the file is ok. Right know I open it with word and then...
Hi Nicolas, I used the export tool, and "save results" to save the delimited data of a table with the Platform option to Windows and to Unix. In notepad, the...
I'm using the script generator. Encoding: default and ansi If I do it by hand: script object to window and then save it as script it works great. I need the...
Hi Nicolas, I just ran the Script Generator and the statements are separated correctly, but the problem I am running into is the Bodies of procedures,...
Hello, When I create a table with the following index in Sybase: CREATE TABLE dbo.matching_company_coverage_tbl ( entity_id int NOT NULL ) create unique...
Gonzalez, Amado
amado.gonzalez@...
Aug 2, 2005 9:36 pm
2304
Hi Amado, I've gone ahead and fixed this and added support for ignore_dup_key, ignore_dup_row and sorted_data. You can get the new build here ... ...
I have uploaded 2 files. One with the wrong format and one with the format I need. ... notepad, ... of evry ... text ... has an ... or unix ... the web. ... ...
Hello, I am using Data Studio version 4.0.15 connecting to Sybase 12.5 over TDS 5.5. In the Schema Browser, when I open up a table, the columns are listed ...
Hi Roger, The columns are supposed to be sorted by Column ID, but they currently are just in the order returned by the query with no order statement. I have...
Now is working ok It would be nice a line feed between items, but its ok the way it is now ... seems to ... will ... script ... notepad, ... of evry ... plain...
Hi, John. I have been very pleased with ADS, ever since I stumbled across it a couple of years ago. Your dedication and commitment to the success of the...
Hi Pete, I believe the problem that you are having is related to your configuration of Visual Explain. By default ADS auto-CREATEs and auto-DROPs the tables...
John, Thank you for your excellent explanation. That was exactly the problem - I just didn't think about reviewing the Visual Explain options for Oracle....
Hi Pete, You can execute Autonomous Transactions without creating procedures by executing a PL/SQL block, but I don't think that AUTO-TRANS allow you to ...
Hi List; I'm using data studio 4.01 My currently used java vm.version = 1.5.0_04-b05 Issue1: when I click on the menu icon to open a query analyzer window it ...
kevin.kempter@...
Aug 5, 2005 6:23 pm
2317
Hi Kevin, ... window it ... minutes. Can you tell me what OS/version you are using? Can you tell me what is the network connection between your machine and...
... I'm running Linux (Fedora Core 3) with a local install of Informix. I have registered the server via my i.p. address and a tcpip socket connection to the...
kevin.kempter@...
Aug 5, 2005 7:53 pm
2319
Hi, ... I have ... connection to the database I haven't encountered this problem yet. Is the long connection occuring everytime? or just sometimes? Do you...
... Seems to occur most every time - even if I already have connected to the dd. ... Not yet. I'll set one up and let you know the results...
kevin.kempter@...
Aug 5, 2005 9:26 pm
2321
Hi, I have added to the script generator an option to "Sort by dependencies" (for Oracle, DB2, SQL Server and Sybase), which will make sure that objects are...
Hi i'm santo. Sorry for my english.I have foud a error during create(full) for table. On any table,Aqua extract always the last trigger saved into server dbms....
Hi John, I just discovered ADS last week. Great tool! Beyond writing SQL queries, I have very little experince with SQL databases. This is my first ever...
Hi Bob, In the next couple of weeks I will be working on the table visual editor and will add more support then. So, hopefully in a couple of weeks I'll have...