MS SQL Topic

|
|
Thread 25 of 25 | Thread Starter | | |  Johnc | paradox 9 tables to mysqlDoes anyone know how to convert paradox 9 tables into mysql? If so is the conversion simple and does paradox have a built in function or script that can be run to do this? Which tables are more stable for alot of users and records being accessed per day Paradox or SQL ,  |
 5843 Hits | |
Thread 24 of 25 | Thread Starter | | |  simd01 | Cannot see fields in MS SQL tables in ParadoxI am attempting to convert a Paradox database into MS SQL back end using Paradox 10 as a front end. I can now connect to MS SQL 2008 Server Express and see tables in the Paradox data model but when I double click them I just get the SQL hourglass and that is it - none of the fields appear for selection (my dummy tables contain char(10) fields).
Has anyone else seen this?
1 Reply: |  Anonymous | I replied to your other post so I am curious. How are you connecting to the SQL server? Did you use the BDE native driver? Does that work? Did you use ODBC?
---
Robert M.
|
|
 3956 Hits | |
Thread 23 of 25 | Thread Starter | | |  brian p kim | Abnormal error - MS SQL board= = = = =, Sorry, UBB has encountered an unexpected, fatal error. This error is extremely abnormal. Please contact the board administration. The error text is:, , Can't open 'NonCGIPath/cache-(cache_pw)/ubb_files/forums/Forum39/000018.cgi'. , , I was unable to find that file or directory. Please check the paths., , The exact error returned by the operating system is:, No such file or directory, , ╗ Please use your browser's back button to return., = = = = = 1 Reply: |  adamlum | Thanks for the notice. Another error produced by the old boards system, which is why we created our own at Prestwood. Hopefully no more errors or headaches. |
|
 16046 Hits | |
Thread 22 of 25 | Thread Starter | | |  KCRABBE | SQL and blob and long binary dataWe run a client database using MS SQL., , We can get access to some of the data via ACCESS but there are fields that are "blob" and "long binary data" that we cannot get direct access to via ACCESS., , The vendors will not help us claiming proprietary software issues., , Is there any "simple" way or any third-party products that will give us access to the contents of the blob and logn binary data files?, , We are not extremely MS SQL literate but we'd be willing to try any suggestions., , Thanks, KC 1 Reply: |  mprestwood | Hi Kathy,, , I think you might be out of luck. If the vendor has put proprietary data in a binary field, then you'll have to rely on them to help you get the data out. By all means, you can use Access, or Paradox, or Delphi (for example) to read the data into a binary variable and then write it to disk and look at it to see if you can make sense of it., , Mike |
|
 3222 Hits | |
Thread 21 of 25 | Thread Starter | | |  KMerker | SQL QuerySuppose I have a table that looks like, , ID CAR1 CAR2 CAR3 ..., --------------------------------------, 001 HONDA PONTIAC FORD, 002 NISSAN TOYOTA HONDA, 003 MITSU MAZDA NISSAN, , etc..., , I want to build a query that retreives the total number of occurances of each type of car. For example,, , CAR COUNT, --------------, HONDA 2 , PONTIAC 1, NISSAN 2, MITZU 1, FORD 1, TOYOTA 1, MAZDA 1, , I know how to do it if there is only one column of CAR, however, I'm not sure when you have mulitple columns. 2 replies. Last post: |  jdschram | Yahoo normalization!!! |
|
 2281 Hits | |
Thread 20 of 25 | Thread Starter | | |  andyhud | Calling SQL Server 7 Stored Procedures from C++I am having trouble calling a SQL Server 7.0 Stored Procedure from C++ that returns a recordset and an output parameter., , Here's the criteria - I wish to bind parameters at run time and I need to return an output parameter. Presumably, I need to use rs.Open not execute in order to get the recordset - the problem is that I don't get the output parameters if I am opening the recordset., The stored procedure may change so I don't really want to implement a static wrapper for it., I have tried to implement this with ADO, MFC DAO and MFC ODBC support classes., , A sample piece of code that does exactly what I need would be ideal... 3 replies. Last post: |  southland | It will work, It will work. I try it before. |
|
 4119 Hits | |
Thread 19 of 25 | Thread Starter | | |  Mike Rock | 16-bit ODBC to sql serverI am trying to access Sql Server 6.5 and 7.0 using 16-bit ODBC (vb 3.0). The program uses two methods to execute stored procedures..., DB_SQLPASSTHROUGH - gets "invalid argument", SQLPREPARE --> SQLEXECUTE get "Stored Procedure" "not found", , I have tried using "dbmssoc3" and even "dbnmp3" as network libraries, but that did not help., , I expect that I have something wrong with my ODBC setup., , Any ideas? I have searched the web, but cannot find much help. Maybe an install of the latest version of 16-bit ODBC might help, but I cannot find it. I did install Access 2.0 attempting to get a more current 16-bit ODBC., , Help! |
 1912 Hits | |
Thread 18 of 25 | Thread Starter | | |  BigJ | MSSQL DB log issueI've been experiencing an anoying database log file issue. The file grew 200mb during the past 2 weeks. It's a database for a staging web site and no one's accessing the site in any way. Even after I took the site offline a week ago, it didn't take care of the log file issue. Anyone has any thoughts? Thanks for checking in. |
 2249 Hits | |
Thread 17 of 25 | Thread Starter | | |  dynamictiger | Access / SQL QuestionI have been playing around with a database structure on and off for about 18 months. The structure is huge and contains several circular relationships. Current Model is in excess of 70 tables and is around 70% complete (although I am not going to sweat about the 30%)., , I had been planning in doing the whole thing in Access in a frontend backend configuration. However, it has been suggested I use SQL to store the tables., , I have never used SQL, has anyone got any suggestions where to start to learn how to use my tables within this program? And I guess more importantly how to link the tables into my Access front end?, , I will be using Office XP and SQL that comes with the developer edition., ,  1 Reply: |  Crabjoe | dynamictiger,, , To use SQL table in access, the 1st thing you need to do is set the permisssions in the SQL tables. Then to link the tables in Access, it's easy. I use an ODBC connection and the in Access go to File ->Get External Data -> Link Tables. Hope the answer isn't too late for you. |
|
 2509 Hits | |
Thread 16 of 25 | Thread Starter | | |  Marksql | password not recognizedOn a newly installed SQL7 DB, started up via TSQL using command sqlsevr -m, for purpose of restoring a master file from another server. No problem there. But when I attempt to log in, using the server admin uid/password, SQL does not like the password, says it is invalid. Also tried the service login/password just for grins, but same result. Any suggestions? Thanks in advance. Mark |
 1778 Hits | |
Thread 15 of 25 | Thread Starter | | |  evismaniac | Urgent help needed.....thx{Too Long!} |
 1956 Hits | |
Thread 14 of 25 | Thread Starter | | |  brent | s.o.s!hi all.i;m quite new to this boards.and i hope somebody will give a little favour for me., , i'm using ms sql server2000 for my project.tragically,my os(winxp) broke down., i'm worried bout all the data inside., can i just save these data,reinstall mssql server and then copy back all the old file with the precious data into the new file?, , and i wanna know if i can do just like that.actually where's my old data(databases,tables,stored procedures) are in the sql file?is it in the Binn file., , i appreciate any help from all of you.thanx |
 2580 Hits | |
Thread 13 of 25 | Thread Starter | | |  dmichael | Wireless WarehouseI have some warehouses filled with products, and a database showing locations within containing different products., , I'm migrating the databases to SQL Server in order to provide access to the data using a wireless, portable data terminal., , This device initiates a telnet session to the SQL Server and after logging in, provides a command prompt on the server. I want to create a VT100-capable menu for these users. It must allow entry of variable-length product codes so that employees can search for warehouse locations to find a product., , What is the best way to do this?, , TIA , , Darron |
 2100 Hits | |
Thread 12 of 25 | Thread Starter | | |  pehi | Database Maintenance Plan Doesn't runHi - I have a strange situation where the Maintenance plan on a SQL 7, build 961 will not generate .BAK and .TRN files based on the maintenance plan (or at all). I have tried deleteing and recreating the maintenance plan, but, according to the system log, and to maintenance plan logs, the entire maintenance plan is not launching any tasks. However the application log whoes all the jobs as failing, but gives no furhter details. , , However I have another server running build 623 that is working fine. , Here's the error from Eventlog: , , SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Webmon1'' (0x42E6C45B360CD611935D0002B330ABF9) - Status: Failed - Invoked on: 2/8/02 4:10:46 PM - Message: The job failed. The Job was invoked by User XXXXXX\Administrator. The last step to run was step 1 (Step 1). |
 2786 Hits | |
Thread 11 of 25 | Thread Starter | | |  Pablo Abbate | Retrieve Default ValueDoes anoyone know how can I retrieve a value from a field default value?, Thanks in advance. 1 Reply: |  ghreddy | HI , you can use Syscomments and Syscolumns tables to get default value of specific column., Use following Query, , Select B.Name , A.Text From sysComments A INNER JOIN sysColumns B On A.ID = B.cDefault , Where B.ID = OBJECT_ID(' '), , Regards, Harinatha Reddy G |
 2545 Hits | |
Thread 10 of 25 | Thread Starter | | |  Perry Godfrey | Access XP ADP output Excel Files from Stored ProceI converted an Access datebase to SQL 2000 and some queries needed to be changed to stored procedures. Upon doing this, I cannot export this data like I normally do in code: DoCmd.TransferSpreadsheet acExport, 8, QryText, strSaveFileName, True, "" , , Any help would be great. Thank you, Perry Godfrey |
 2876 Hits | |
Thread 9 of 25 | Thread Starter | | |  DanB | MS SQL and MS Access project.How do you reference a value on a form in MS Access Project in a view or stored procedure?, , Say you have a view that looks up employer information using the value thats passed as a parameter in the employee ID field., I want that parameter to get its value from a text box on a form. How do I do that?, , Please Help!!!  |
 2424 Hits | |
Thread 8 of 25 | Thread Starter | | |  Leslie | Databases on the fritzI have three main databases that sporadically stop for anywhere from 60 seconds to three minutes. At this time, if you are in Enterprise Manager and try to connect to the server it says it is unavailable. It then fixes itself. It leaves no error messages in the event log, and nothing in the SQL Log. I have a server-monitoring program monitoring the server and the server can be pinged at the time the database is experiencing problems (which indicates the network is communicating fine). I have tried everything I know to try to diagnose the problem with no success. If there is anyone out there who can help I would appreciate your expertise as soon as possible. Thanks in advance. You can e-mail me at halll@yosemite.cc.ca.us , Thanks again,, , Leslie, ,  :) |
 1972 Hits | |
Thread 7 of 25 | Thread Starter | | |  Flavio Firmo | SQL and ProxyI would like to know if someone have a step by step to setup a MS SQL server on a internal LAN with proxy and users from the internet get access from this server., If I am not clear, let me know. |
 1851 Hits | |
Thread 6 of 25 | Thread Starter | | |  TR | SQL-server 2000 performanceDoes anyone have any experience with using MS SQL-server 2000 (or 7) for bulky databases (1 million+ customer register). It will recieve fairly complex statistical queries (eg. for finding customer behaviours and segmenting them)., How does it stand up to the challenge compared to eg. Oracle ?, Anything thats especially (maybe even notoriously) important to keep in mind with SQL-server ?, , Regards, , Torben Rohde, ------------ [URL=http://www.des.dk]www.des.dk[/URL] |
 2699 Hits | |
Thread 5 of 25 | Thread Starter | | |  dprothero | SQL Server 2000?Has anyone played much with [b]SQL Server 2000[/b]? I know it is designed to support the new .NET framework and adds XML support. Are there other new features that are worth mentioning? How does a SQL Server 7 application convert to SQL Server 2000? Pretty easy?, , , ------------------, David Prothero, Owner / Consultant, Prothero Consulting, (209) 956-9180 1 Reply: |  tcronin | SQL 2000 upGrade is easy. Also a more refined product. Just need to figure out licensing, it may be a little pricey if you don't have CALS(still very cheap compared to Oracle). Unless you are using system objects in your code app should convert no problem |
|
 2575 Hits | |
Thread 4 of 25 | Thread Starter | | |  Leslie | Transaction LogsHelp!!!!!, , I am at a new job and have just been asked to move the transaction logs on our SQL server. This may be a stupid question, however how do I do this. Please help me a.s.a.p., , Thanks in advance.  2 replies. Last post: |  lesrhall | This is only going to back the log files up (am I correct)?  I need to acctually move the files. I am trying to improve performance by seperating the log files from the databases. Thanks in advance!  |
|
 2517 Hits | |
Thread 3 of 25 | Thread Starter | | |  walker1475 | Delphi & MS SQLIs there a book or any info that is available for using Delphi with MS SQL. My company is in the process of migrating from Paradox to MS SQL and we have run into problems. The main problem is some commands and functions that worked fine with Pardox, do not with MS SQL. Thanks in advance for any advice given. 1 Reply: |  Mido | Hi,, There is book called Advanced delphi guide to MS SQL Server 2000 .... I didn't read it yet but I heard that it is great |
|
 2600 Hits | |
Thread 2 of 25 | Thread Starter | | |  Rhowk | Hmmm?I have been given the task of developing an online contact database for my company. Our NT server is using MS SQL 7.0 but they want me to test it on my Win 98 Laptop before trying it out on the server. I am trying to to develop the ASP using Ultradev but it tells me I need MS PWS which of course I can't find on Microsoft's site. In short I have quite a few newbie questions to be answered. Can anyone suggest some links outside of Webmonkey to help? Biggest question facing me, don't have Access or any other database other than ACT! and Excel(I know a spreadsheet program) on the laptop, is it possible to fudge a demo together using either of these? Thanks for any help!, , Rh |
 2171 Hits | |
Thread 1 of 25 | Thread Starter | | |  cancane1 | SQL 7.0 query conversion to XMLHi,, I am trying to have a SQL 7.0 query convert to XML then to run it. I am using InterDev 6.0 as the editor. I tried the following codes for conversion but they didn't work. I am new and a little confused where to use what. I made a recordset but haven't been able to convert it. Any direction would be appreciated., '
Follow PrestwoodBoards on: |
 |
|
|
| |