I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data Board   Print This     

MS SQL Topic

Miscrosoft SQL Server.

 

 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Johnc
paradox 9 tables to mysql
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 , Big Grin!
18 years ago
3 replies. Last post:

eric_felleiter
Thanks kwmillican I can use it.
9 years ago
Nothing New Since Your Last Visit
5571
Hits

Thread 24 of 25
Thread Starter  

simd01
Cannot see fields in MS SQL tables in Paradox
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?
9 years ago
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.
9 years ago
Nothing New Since Your Last Visit
3737
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., = = = = =
16 years ago
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.
12 years ago
Nothing New Since Your Last Visit
15853
Hits

Thread 22 of 25
Thread Starter  

KCRABBE
SQL and blob and long binary data
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
15 years ago
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
15 years ago
Nothing New Since Your Last Visit
3118
Hits

Thread 21 of 25
Thread Starter  

KMerker
SQL Query
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.
17 years ago
2 replies. Last post:

jdschram
Yahoo normalization!!!
17 years ago
Nothing New Since Your Last Visit
2209
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...
18 years ago
3 replies. Last post:

southland
It will work, It will work. I try it before.
17 years ago
Nothing New Since Your Last Visit
3910
Hits

Thread 19 of 25
Thread Starter  

Mike Rock
16-bit ODBC to sql server
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!
17 years ago
Nothing New Since Your Last Visit
1842
Hits

Thread 18 of 25
Thread Starter  

BigJ
MSSQL DB log issue
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.
17 years ago
Nothing New Since Your Last Visit
2163
Hits

Thread 17 of 25
Thread Starter  

dynamictiger
Access / SQL Question
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., , Confused
17 years ago
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.
17 years ago
Nothing New Since Your Last Visit
2401
Hits

Thread 16 of 25
Thread Starter  

Marksql
password not recognized
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
17 years ago
Nothing New Since Your Last Visit
1713
Hits

Thread 15 of 25
Thread Starter  

evismaniac
Urgent help needed.....thx
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1882
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
17 years ago
1 Reply:

brian p kim
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2472
Hits

Thread 13 of 25
Thread Starter  

dmichael
Wireless Warehouse
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
17 years ago
Nothing New Since Your Last Visit
2029
Hits

Thread 12 of 25
Thread Starter  

pehi
Database Maintenance Plan Doesn't run
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).
17 years ago
1 Reply:

brian p kim
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2691
Hits

Thread 11 of 25
Thread Starter  

Pablo Abbate
Retrieve Default Value
Does anoyone know how can I retrieve a value from a field default value?, Thanks in advance.
18 years ago
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
18 years ago
Nothing New Since Your Last Visit
2449
Hits

Thread 10 of 25
Thread Starter  

Perry Godfrey
Access XP ADP output Excel Files from Stored Proce
I 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
18 years ago
Nothing New Since Your Last Visit
2747
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!!! Confused
18 years ago
Nothing New Since Your Last Visit
2338
Hits

Thread 8 of 25
Thread Starter  

Leslie
Databases on the fritz
I 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, , Big Grin! :)
18 years ago
Nothing New Since Your Last Visit
1904
Hits

Thread 7 of 25
Thread Starter  

Flavio Firmo
SQL and Proxy
I 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.
18 years ago
Nothing New Since Your Last Visit
1778
Hits

Thread 6 of 25
Thread Starter  

TR
SQL-server 2000 performance
Does 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]
18 years ago
5 replies. Last post:

brian p kim
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2562
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
19 years ago
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
18 years ago
Nothing New Since Your Last Visit
2470
Hits

Thread 4 of 25
Thread Starter  

Leslie
Transaction Logs
Help!!!!!, , 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. Confused
18 years ago
2 replies. Last post:

lesrhall
This is only going to back the log files up (am I correct)? Confused I need to acctually move the files. I am trying to improve performance by seperating the log files from the databases. Thanks in advance! Big Grin!
18 years ago
Nothing New Since Your Last Visit
2436
Hits

Thread 3 of 25
Thread Starter  

walker1475
Delphi & MS SQL
Is 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.
18 years ago
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
18 years ago
Nothing New Since Your Last Visit
2458
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
18 years ago
1 Reply:

wpantoja
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2089
Hits

Thread 1 of 25
Thread Starter  

cancane1
SQL 7.0 query conversion to XML
Hi,, 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., '


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech