Coming From Paradox
Dec 4, 2006Does anyone know of a good tool that will convert a Paradox 11 Database to SQL 2005 with ease? Looking around and really unable to find anything...
Thanks in advance
ADVERTISEMENT
The Paradox
Feb 18, 2000hi all,
The PATINDEX function is not working with the image datatype in SQL Server.
The books online says that you can use PATINDEX with the image datatype.
Unfortunately it seems to be big lie.
How can I get the functionality of PATINDEX worked.
This is how I placed my SQL Query
declare @p binary(16)
select @p =0xFFFFF30A000000008400000001000000
select patindex('%DEFG%',image) from image where textptr(image) = @p
The error I am getting was
Server: Msg 288, Level 16, State 1, Line 4
The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and
ntext data types only.
Why this is not working, according to Books online
Thanks for your time
bye
ranjith
Import PARADOX Problems
Jul 20, 2005Hello,I've the following problem. I've to read out the data of a customapplication. I think (I'm not sure) this application is using aParadox DB to store it's information. I don't know it exactly causeI'm not familar with paradox at all, but I've found files like *.db,*.mb, *.px, *.xg*, *.yg* !!!I need the infomation from this files to combine it with other datastored in SQL 2000. I'm tried DTS to import the Data but I've got an"Microsoft JET Database" Error telling me that the table could not befound or that the table has not the asumed format. It depends on which*.db File i try to open. Description: Error calling the OPENROWSETmethod on the provider.My Questions, are there some special drivers i need, not included inMS MDAC Components or must I use a complete Databaseserver in theBackgroud hosting the DB Files. My developer station has the customapplication NOT installed. The db files seems to have no password set.I've got the same error when using MS Access to import the data. Ionly set the path to the dictionary where the files are in but leaveusername and password blank.HOW TO GET THIS DATA OUT ???Thank youTony
View 4 Replies View RelatedSSIS OLE DB Jet Paradox Memo
Feb 10, 2006I am updating a Sql Server 7.0 DB to Sql Server 2005 Standard
I have to update Sql Server tables with Paradox 4.5 (DOS) data,
with DTS in 7.0 this was no problem.
In Visual Studio I use the OLE DB Jet 4.0 driver with the extended property "Paradox 4.x"
The package runs well if there is no Memofield or the Memofield has only a few characters.
If there is an Memofield filled with more than 250 Characters the preview and the data flow faults.
If I use "DBASE IV" on a dBase-table there is no error, but the NTEXT-Field in Sql Server has only one character " "
What can I do to get Paradox-data with Memofields?
Other problem:
I am missing the OLE DB Jet 4.0 Data Source in the Import/Export-wizard in
Sql Server Management Studio.
Dirk Sander
Importing Data From Paradox Into SQL
Apr 30, 2007I have a Paradox file which has 270 thousand records. If I open this db file through a paradox viewer it shows the correct number of rows.
I have an SSIS package which is suppose to read this db file and insert it into the SQL 2005 table. But when I execute this package it goes into a loop, reading the file over and over again. The package fails after inserting some 10 million rows giving the error msg 'Not enough space on temporary disk'.
On examing the data transfered into SQL there are duplicate rows.
I also used the import export wizard (thinking there might be some error in Package code) provided by SQL to transfer the data from .db to SQL but it has the same result(goes in a loop).
I would appreciate any help in this problem. Let me know if you have any other questions.
Thanks
Best Way To Read A Paradox File?
Oct 17, 2006We used to use DTS to read Paradox files. This is something we do regularly. DTS has a native Paradox driver. This seems to have disappeared in SSIS.
Can anyone recommend the best way to read Paradox Files with SSIS?
Linked Servers And Paradox 7.
Oct 1, 2007I'm fairly new to SQL Servers and have Paradox 8 installed. Does anyone know how to setup a linked server in the Microsoft SQL Server 2005 so that the SQL server can access Paradox 7 tables?
View 1 Replies View RelatedParadox To Sql Server 2005
Feb 13, 2007Hi,
I have been told, I will have to transfer some paradox data into sql server 2005.
What is the best way to do this? i.e. if SSIS can be used, then what will be the source? I ask because there does not seem to be a source for Paradox.
Any thoughts please?
Thanks
Access / SQL Server Or Filemaker From Paradox?
Nov 16, 2005I've been programming in Paradox since DOS, but one mail-order database is getting rather large (100K client records, and associated orders, etc).
Our client wants us to move to Filemaker. In fact he'd like to have a 3rd party write the programme and me maintain it. The current package has been written & maintained by myself, with an awful lot lot going on in the Object PAL code.
I already have a copy (legal) of SQL Server & 10 licences for Access, and think that's a better option to re-develop in (although I could do with some training in both).
What are the pros & cons for each app, and what would people recommend. I'm going to cross-post into Access, Paradox & Filemaker forums to get an equal view.
Thanks
Mark
Import Paradox 8 DB Into SQL Server 2000 Using DTS
Dec 28, 2003Hi,
I'm trying to import a Paradox 8 db into SQL Server 2000 using DTS but the list of data sources in the connections dialog only caters for version 5.x or older. Does anybody know how to get the data source for v8?
If not, is there any other quick and efficient way to import a paradox 8 db as I have to import around 15 of them to do.
Thanks
Paradox Conversion - Front End View
Feb 10, 2007Hello All,
I know nothing.
I am helping a friend, current database Paradox 7.x, custom app as I am sure they all are. I wanted to convert this DB to SQL or Access(MS)I do not have Access, but I have SQL 2000. I used the import/ convert tools within SQL, looked good to me, no errors etc.
I thought life was good. Now try to view, look at the data the way
users could. In the SQL manager, I can see tables, and stored procs, and lotsa cool stuff. I try and install SQL client on a PC to view. It basically extends the Admin tools to the deskop PC. How do I use an SQL conversion to realize the needs of the user interface. I think I need what is called a front end. You can stop laughing now.....
Anyway what direction should I take
to update this antique, no support Paradox DB.
Thanks, Dan T
Can SQL Server Work With A Paradox Table?
Feb 18, 2006I've never really setup or used MS SQL Server (just a couple hours, oneday, several months ago). I think MS SQL Server has the ability to use"linked tables", like MS Access does. Is this correct? What I want todo is have an MS SQL Server setup, which compatible applications cantalk with, but I want the data to come from a Paradox database. I canuse any MS SQL version, whatever would work best. I'm not sure aboutthe Paradox version, I know it is an old DOS version. I can't justconvert the data to another format, because Paradox still needs to useit.I tried using MS Access before, with ODBC drivers it *should* be ableto work with the Paradox data. However, I ended up with lots of datacorruption. I'm hoping MS SQL Server may work better, and not corruptthe Paradox data everytime it is updated.
View 4 Replies View RelatedMigrating From Paradox Into Sql Server Using SSIS
Oct 10, 2007
Hi All,
Can anyone suggest me a way to migrate data from paradox tables to sql server tables using SSIS.
Paradox tables are having millions of rows.
Any help on this is greatly appreciated.
Thanks,
SVGP
Issue With Importing Paradox Blob Data
Sep 11, 2006Hello,
I have SQL Server 2000 and I'm trying to import data from a paradox v5 database. Everything has moved over fine but the data from the blob fields. When I use the import tool and try connect to a paradox blob field, the import wizard does not "see" the paradox blob field. here is and example.
If I have a table with the following fields.
id char(20)
description char(120)
image blob
the ms-sql import wizard sees
id char(20)
description char(20)
I find this very odd, but I do need a solution. Any Ideas?
TY
Package Goes Into Loop While Reading Paradox File
Apr 30, 2007
I have an SSIS package which is suppose to read this db file and insert it into the SQL 2005 table. But when I execute this package it goes into a loop, reading the file over and over again. The package fails after inserting some 10 million rows ( actual rows are not more then 270,000) giving the error msg 'Not enough space on temporary disk'.
On examing the data transfered into SQL there are duplicate rows.
I also used the import export wizard (thinking there might be some error in Package code) provided by SQL to transfer the data from .db to SQL but it has the same result(goes in a loop).
I would appreciate any help in this problem. Let me know if you have any other questions.
Thanks
Insert Data By OLE DB Destination For Paradox Table Problem
Aug 23, 2007
Dear all -
iam facing a problem to insert data to paradox table by using OLE DB Destination ,
Briefly i built a simple data flow the has OLE DB Source from paradox Table1 and it linked to OLE DB Destination for another Paradox Table2 (i use query to get the table2 data in OLE DB Destination because it refuse to get data Directly) .
The problem that when i start debugging an error raise as the following:
Error: 0xC0202009 at Data Flow Task 1, OLE DB Destination [554]: An OLE DB error has occurred. Error code: 0x80040E09.
Error: 0xC0047022 at Data Flow Task 1, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (554) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task 1, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
i hope someone help soon because i need to handle this problem as soon as possible
thanks ,
Maylo
Passing Parameter To OLE DB Command To Perform Update On Paradox Table
Aug 23, 2007
Dear All -
iam facing a problem for passing a parameter to update paradox table statment in the OLE DB Command
Briefly an OLE DB Command exist between OLE DB Source and OLE DB destination , all i want it to send the data that flow from the OLE DB Source to the update paradox table statment in OLE DB Command ,
i use the parameter annotation which is "?" to refer to the parameter in the update where clause and it sucess when i use the OLE DB Command to connect to SQL Server DB but when i use it with the Paradox Table an error appear saying that there is more than one data source column with the name "?" The data source column names must be unique.
i dont know what that means is it means that "?" it consider "?" as a column or what or is there another way to send parameter to Update statment for the paradox table differ from the SQL Server Update statment which is the "? "
i hope someone help me as soon as possible because i need it in work sOOon
Thanks,
Maylo
Coming From Sybase
Oct 6, 2004Coming from Sybase env. I would like to know the equivalent of sp_showplan. What it does is, it shows the showplan for the query being run by spid, which is passed as a parameter to sp_showplan.
Thanks for your help.
List Up-coming Birthdays
Feb 26, 2004I've got an employee table with a date of birth field in it. i need a query that will a allow me to list all employees who's birthdays are coming up the next 30 days (or 1 month, if easier). I've tried several approaches & am getting nowhere... Any help would be greatly appreciated.
Regards,
Jacques Matthee.
Select All Coming Back In SP2 - Not Again
Jan 6, 2007I just read the release notes for SQL 2005 SP2 CTP and the 'Select All' on multi-select parameters is coming back EXACTLY as it was in the first release. If this is not the case then I apologise for the rant and request that someone clarify the situation but otherwise ....
I had to change loads of reports because it was removed in SP1, now I'll have to change them again for SP2.
Please Microsoft, stop doing this to us!
At least make it a check box option somewhere. The reasons for it's removal in SP1 still exist, but it is a nice feature to have, so just make it configurable.
I will probably have to delay installing SP2 at various customer sites because it will make my parameter lists look stupid.
This is a shame because there are some useful updates in it.
Problems Grasping Ado.net - Coming From Asp Background
Oct 22, 2006Hi, i've downloaded a membership and roles provider but i am very new to ado.net. I have come from asp background. Here's my code:public override void AddUsersToRoles(string[] usernames, string[] rolenames) { // Validate arguments foreach (string rolename in rolenames) if (!this.RoleExists(rolename)) throw new ProviderException("Role name not found"); foreach (string username in usernames) { if (username.IndexOf(',') > 0) throw new ArgumentException("User names cannot contain commas."); foreach (string rolename in rolenames) { if (IsUserInRole(username, rolename)) throw new ProviderException("User is already in role."); } } SqlConnection db = this.OpenDatabase(); SqlCommand cmd = new SqlCommand("INSERT INTO UsersInRoles (UserName, RoleName) VALUES (@UserName, @RoleName)", db); cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 100); cmd.Parameters.Add("@RoleName", SqlDbType.VarChar, 100); SqlTransaction tran = null; try { tran = db.BeginTransaction(); cmd.Transaction = tran; foreach (string username in usernames) { foreach (string rolename in rolenames) { cmd.Parameters["@UserName"].Value = username; cmd.Parameters["@RoleName"].Value = rolename; cmd.ExecuteNonQuery(); } } tran.Commit(); } catch { tran.Rollback(); throw; } finally { db.Close(); }}private SqlConnection OpenDatabase() { SqlConnection DB = new SqlConnection(this.connectionString); DB.Open(); return DB;}
View 6 Replies View RelatedResults Coming Through In Violation Of Criterion
Mar 6, 2002I'm baffled by the results of the following query:
__________________________________________________ ______
select events.[report number], [microfilm number], [crash date]
into lowspeed
from events inner join vehicles
on events.[report number] = vehicles.[report number]
where [dummy record] = 'N'
and [estimated mph] between 1 and 10
and ([1st harmful event] = 01
or [2nd harmful event] = 01)
and [type of vehicle] in
('01','02','03','04','05','06','07','08','10','11' ,'12')
and [crash injury severity] = 5
select events.[report number], [microfilm number], [crash date]
into notlowspeed
from events inner join vehicles
on events.[report number] = vehicles.[report number]
where [dummy record] = 'N'
and [estimated mph] > 10
and ([1st harmful event] = 01
or [2nd harmful event] = 01)
and [type of vehicle] in
('01','02','03','04','05','06','07','08','10','11' ,'12')
and [crash injury severity] = 5
select distinct [report number], [microfilm number], [crash date]
into truelowspeed
from lowspeed where [report number] not in (select [report number] from
notlowspeed)
select [report number]
into pedtable
from pedestrians
select [report number],[microfilm number], [crash date]
as [Lowspeed Fatal Crashes - 1994]
from truelowspeed
where [report number] not in (select [report number] from pedtable)
drop table pedtable
drop table truelowspeed
drop table lowspeed
drop table notlowspeed
_______________________________________________
Let me explain what I'm trying to do.
In the first temp table "lowspeed," I'm trying to lump all crashes where a vehicle was doing between 1 and 10 mph.
In "notlowspeed," I'm setting up a table of crashes in which at least one vehicle was going over 10 mph.
By the third gyration, I'm trying to generate "truelowspeed;" which I thought would contain only crashes in which all of the criterion in the first two queries were satisfied and all of the vehicles involved in the crashes were doing between 1 and 10 mph (NO vehicles exceeding the 1 to 10 mph parameter).
The "pedtable" maneuver is simply to pull out any of these crashes in which a pedestrian was involved.
What I'm getting is a lot of crashes in which I have dummy records, several crashes in which one of the vehicles was going over 10 mph, and types of vehicles involved in the crash that should have been excluded by the criterion I specified.
Thoroughly stumped. Would be most grateful for any kind insight/advice.
Warnig Coming In Server Error Log..
Aug 29, 2001I am getting a warning message in my SQL Server 6.5 Error log file .
The warning is
Lazywriter: WARNING, LRU LIST IS EMPTY (177 FREE BUFS,358 TOTAL BUFS)
Please help to resolve this problem.
T-SQL (SS2K8) :: SUM OVER Coming Up With Different Values Than CTE Query
Mar 6, 2015I am currently reading through Itzik Ben-Gan's "Microsoft SQL Server 2012 High-Performance T-SQL using Windows Functions." In attempt to test the SUM OVER() function in SQL 2008 because that's what I've got. I do not currently have sample data (trying to generate it has become a major PITA), but I have some pseudocode.
My current code (actual production code) pulls a bunch of ITD (inception to date) contracts then calculates a certain dollar amount based on monthly changes. Not all contracts have values during a given month, so here's what I cobbled together a few months ago. (Per our finance team, these numbers ARE accurate).
WITH MonthlyVals AS
(SELECT ContractID, SUM(Col1 - (Col2 + Col3 + Col4 + Col5)) AS MyTotal
FROM MyTable
WHERE MyDate >= @ThisMonthStartDate AND MyDate <= @ThisMonthEndDate
AND StatementType IN (8,4,2)
[code]....
To test the totals, I also added a COMPUTE SUM(MyTotal) to the end of each query. (Yes, I know COMPUTE is deprecated. Just wanted a quick check.). The difference between the two bits of code was over 68k, with the SUM OVER() code coming up with a total higher than the CTE code. I know CTE code is correct for a fact. It went through extensive testing before getting put in Production. Is it the way I joined the table for the SUM OVER()? Or is it the use of PARITION BY?
Coming To Grips With Data Warehouses
Mar 18, 2007Hi again,
How's everyone doing with 2005? I still feel like my heals are dragging a bit. The "knowledge" out there still seems a bit sparse. Am I right?
I'm about 1/5 the way through a BI book and decided the course will probably be necessary as well:
http://www.kimballgroup.com/html/kucourseMDWD.html
There seems to be a lot to come to grips with.
So that's all paid for.
It's been years since I've been on a course of any kind. Too busy working! What's the etiquette? Trousers and T-shirt? Tie? Sandles & three quarter lengths?
This particular course seems to cover the "general overall approach" - which I am pretty sure is a necesary part of what you need to be able to do. The book that is related to the course (which I have already bought) seems really helpful and valuable.
But I don't think it will cover the nitty gritty of SSIS - where most of the grunt work happens. They have another course for that. But I can't wait that long. You can spend your whole life just reading books!
Are all the new little things in 2005 SSIS just a little to specialised? A little too clever? Does it limit us? Or empower us? Can we use it to get the job done? Or will it be a case again of "clever workarounds" when we travel far down a road that we find out (when it's too late and we are committed) can't provide us with what we want. Is it really saving us time? Are we better off writing the scripts ourselves?
------------------------
Me: What do you want to know from your data warehouse?
Client: Err...Emm...Everything
Me: OK, that's great. That's all I need to know. I'll see you when it's done.
Subtracting Two Dates And Coming Up With A Number
Jul 20, 2005I have two date fields, start_date and end_date.I'd like to subtract the two dates, and come up with a number (thenumber of difference between the two dates).What function is there to do this? I haven't been able to find anythingin BOL.Start_date = 6/1/03End_date = 6/8/03End_date - start_date = 7*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedAnother DB2 Issue In SSIS - Text Coming Across As ?hex?...
Feb 15, 2008I've tried setting the "Process Binary as Character" setting to true on the data source. I've tried cast and convert statements in the queries. I've tried conversion steps... Am I missing something simple, or is it really this difficult to get text values pulled from DB2 as text?
I'm using Microsoft's OLE DB provider for DB2.
Anyone have experience with conversion problems pulling text from DB2 databases?
Thanks in advance...
Laura
Strange Packages In MSDB - Where Are They Coming From?
Aug 10, 2007Hello:
I see some packages in the MSDB folder in Mgmt. Studio that I cannot figure out where they are coming from. The SSIS project in BIDS does not contain them, I do not see it in the Deployment folder, nor do I see it in the destination folder to which the manifest file deploys the packages. Which folder location am I missing? Each time I delete them they keep reappearing when I deploy.
SSIS Variables Window Not Coming Up
Dec 13, 2007
I'm not sure if this is the right forum, but i'm having an issue where SSIS Variables window will not come up. The most i get is a gray bar that looks like it is supposed to hold the variables.
I've tried getting it to show by:
1) Menu --> SSIS --> Variables
2) Right Click --> Variables
3) Menu --> View --> Other Windows --> Variables
The same thing seems to happen for "log events" in Menu --> View --> Other Windows --> Log Events.
Does anyone know how to fix this? Is anyone else having this problem?!?!?!
-Thanks Thames
Why The Results Of Cluster Alogotytm Are Coming In The Following Way
Jul 28, 2006 Hi
I have data in the following format
Custid Age Product
101 25 ProdA
101 25 ProdB
102 25 ProdA
103 50 ProdC
104 55 ProdA
105 50 ProdC
when I am using Clustering algorithm with 2 clusters and trying to perdict the product column the results are coming as below
Custid Age Product PerdictProd
101 25 ProdA ProdA
101 25 ProdB ProdA
102 25 ProdA ProdA
103 50 ProdC ProdC
104 55 ProdA ProdC
105 50 ProdC ProdC
Why so pl let me know where I am going wrong and is the data is not proper
Thanks
Rajesh Ladda
Connection Managers Area Not Coming Up
Oct 4, 2007
When I brought up the BI DEV studio first tiem the Connection Managers area showed up, but after I closed it by mistake from next time on wards it is not coming up.
Can some one from this form help me how to get the Connection Managers area(pane) back?
Thanks in advance.
Regards
Mamidi
Coming Out Of Single User Mode
Mar 18, 2008
How to come out of single user mode in sql server
Any Good Conferences Or Training Coming Up..
Dec 11, 2006I would like to attend a good sql server training conference here in USA. What would you recommend? My areas of interest are:
OLTP, SSIS, SSAS, Data warehousing etc..
I googled for some excellent training or conference events but could not find one.