MS SQL Topic

Does 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 ,

I 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?

= = = = =, 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., = = = = =

We 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

Suppose 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.

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...

I 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!

I'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.

I 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., ,

On 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

{Too Long!}

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

I 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

Hi - 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).

Does anoyone know how can I retrieve a value from a field default value?, Thanks in advance.