Connecting To Informix Dtabase From SQL Server
Jun 14, 2001Hi,
I want to know how to connect to informix from SQL server and how can I run queries for the tables in Informix from sql server.
Thanks
Arun
ADVERTISEMENT
Moving A Dtabase
Dec 2, 1998I have to move a database to a different server. Is it possible to move all users accounts also.
Could the sysusers or syslogins table to moved via bcp ????
another method ??
Thanks
Private Virtual Dtabase
Mar 22, 2000One of our clients controls data for about 150 companies. Each company has the same schema and is running SQL Server 7. The maintenence task is horrible. He would like to put all the data in one large database, but needs to control the access, so a user at one company selecting data in a table cannot have access to another company's data in the same table. I thought about using views for each company but that is 150 companies times 100 tables. With Oracle8i you can make virtual private databases. Can this be done in SQL Server 7? Thanks in advance
View 1 Replies View RelatedDistribution Dtabase Recovery Mode.
Oct 26, 2007
By default, distribution database is set to simple recovery mode. Why ? Should this be changed to full ? how often should transaction logs be taken ? What is the recommendation ?
Thank you
Dtabase Design For Storing True/false Questions
Feb 12, 2007Hai,
I am trying to design a database for storing trule/false questions.
I have no need to store any thing like chapters are topic. I want to just design a bare minimum tables for just storing questions and its responses.
So does the following tables and fields suffice to achieve that?.
Questions_table(id(autogenerated),course_id,Questi on(text type))
id field uniquely identify each question, course_id(ex:CRS235) is used to identify which course a particular question belongs to, and Question filed store actual question.
Response_table(id,response)
Response field is of int type, 1 for correct answer, 0 for wrong answer. I am not storing options for each question because every question has same options that is True/False.
So, will this work. Please advice and I would appreciate if any one can point me to a good resource on the web.
Thanks,
Informix------SQL Server.....URGENT
Feb 21, 2000Hi ,
I am an Informix user who has shifted to SQL Server,,,,I just wanted to know the equivalent of 'ISOLATION TO DIRTY READ' as in Informix in SQL SERVER....
Thanks,
Visitor
Need A Way To Port From Informix To Sql Server
Jan 5, 2001Hi,
Could anyone tell me how the data can be ported from informix to sql server ?
Is there a way to run the informix query from sql server ?
Thanks,
Vijay.
SQL Server Versus Informix
Oct 25, 2000Hi all,
Anyone here ever used the Informix database and can give me some differences between Informix and SQL.
One of our users is thinking about purchasing a COTS product that only supports an Informix database. I need to convince the user to evaluate other rival applications that can support SQL and need some arguments in favor of not going with Informix.
Any ideas appreciated,
Faustina
Link Informix To SQL Server
Oct 6, 2006Hi,
I am considdering to link a Informix database (running on SCO Unix) to a SQL Server 2005. Only problem is ... I have no idea how to do this! The reason I'm attempring this is to try and see if it would fix a problem I'm experiencing when using Reporting Services to generate reports from a Informix data source. I've been told that setting up a linked server might fix the problem. If anyone could perhabs guide me through setting up the linked server I would be very grateful! The ODBC credentials for setting up a connection to the Informix DB as follows:
Servername : pal_tli
Hostname : server_name
Service : pal_ser
Protocal : sesoctcp
Database : db_name
Username : user_name
Password : pword
:confused:
Downloading Data From Our Informix Server
Jan 7, 2004Our entire sales database sits on an Informix server and users run their reports directly to this server.
Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.
My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.
Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).
If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?
Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!
Many thanks
Transfering Data From Informix To Sql Server
Feb 6, 2004I need to transfer seven tables from Informix DB to SQL Server every night. Any suggestions for the best way of doing it? Is DTS the best way? How about through replication?
Thanks in advance.
Linking Informix Database To Sql Server
Sep 7, 2005Can anyone halp me with this?
I want to link/access informix database to Sql Server stored procedure.
Integration Of SQL Server With Cache DB, Informix
Mar 12, 2008we r doing some application and SQL server as backend DB Server. this sql server has to be updated continiously 24*7 with data from 3 external sources Cache DB, Iformix and Oracle DB servers. How to handle this in such away that all changes at 3 external sources to be updated to SQL server and this data will use by our application at frondend.
we though of ODBC., but ODBC is very very slow. It should lke Shadowing.
How to handle this?. any help will greatly appreciated.
REPLICATION FROM INFORMIX 10 TO SQL SERVER 2005
Sep 8, 2005HI..
View 1 Replies View RelatedInformix To SQL Server Stored Procedure Tool
Oct 6, 2005Does anyone know where to get a migration tool for porting Informix stored procedures to SQL Server? I'm not looking forward to hand migrating 111 stored procedures. I can't find a migration tool on the net. :eek:
Thanks for any tips.
Integration Of SQL Server With Cache DB, Informix And Oracle
Mar 12, 2008SUB: pushing data to SQL server from Informix, Oracle and Cache DB
we r doing some application and SQL server as backend DB Server. this sql server has to be updated continiously 24*7 with data from 3 external sources Cache DB, Iformix and Oracle DB servers. How to handle this in such away that all changes at 3 external sources to be updated to SQL server and this data will use by our application at frondend.
we though of ODBC., but ODBC is very very slow. It should lke Shadowing.
How to handle this?. any help will greatly appreciated.
Thanks in advance.
Prasad
vsrprasad16@gmail.com
Import Tables From Informix To Sql Server 2000
Jun 20, 2007hi all ,
i need to import some tables from Infomix database to the sql server 2000.
what is the easiest way to do it as im quite new at this area.
thanks
linda
SSIS Help Loading From Sql Server 2005 To Informix 7.3.1 SE
May 16, 2008HI
I am transferring the data from sql server 2005 to Informix 7.3.1 SE using SSIS .
I am using the OLEDB data connection for both source as well as destination databases.
I am trying to mapping the source and destination tables .I am getting the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [OLE DB Destination [184]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
Error at Data Flow Task [OLE DB Destination [184]]: Opening a rowset for ""srinivas"."company"" failed. Check that the object exists in the database.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
I am using the following ODBC driver for the connecting INFORMIX 7.3.1 which is running on LINUX environment.
Openlink Generic ODBC Driver
It's creates the table in the informix 7.3.1 but it's not mapping the source and destination databases columns.
Please help me any one. it's urgent .
Thanks,
Srinivas Unnam
Integration Of SQL Server With Cache DB, Informix And Oracle
Mar 12, 2008
we r doing some application and SQL server as backend DB Server. this sql server has to be updated continiously 24*7 with data from 3 external sources Cache DB, Iformix and Oracle DB servers. How to handle this in such away that all changes at 3 external sources to be updated to SQL server and this data will use by our application at frondend.
we though of ODBC., but ODBC is very very slow. It should lke Shadowing.
How to handle this?. any help will greatly appreciated.
Thanks in advance.
Prasad
vsrprasad16@gmail.com
Replication Between SQL Server Database And Linked Informix Server
Apr 19, 2004I need help setting up replication between my SQL Server (data warehouse) database and a linked informix database.
Does anyone know the best to accomplish this. I can provide any additional information you require to help you, help me ;-)
Queries Against Linked Server To Informix Via ODBC Errors
Oct 9, 2007What can be the reason(s) why I can't get data from a linked server using an ODBC datasource that works fast & fine from MS Access?
I have an ODBC connection (System DSN) configured for an Informix ODBC driver.
The Test button (belonging to this driver-setup) reports a successfull connection test.
Getting data from this database by linking tables in MS Access works fast and easy.
But I have tried for many days now to setup a linked server from SQL Server (2005)
Creation goes fine, but as soon as I issue a query, (e.g. 'select * from infrem723...remotetable' or using 'openquery')
I get the following error:
---
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "infrem723" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "infrem723".
---
Why is Access able to read what "MSDASQL" cannot?
I am desperate - can anybody help?Thanks a lot!
Connection Problem To Informix From SQL Server 2005 With Unicode Data
Dec 5, 2007I have Informix 9.4TC6 and SQL Server 2005.DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372).First, I created DSN to Informix. Then tried to get data with WinSqltool and it works fine.But when I created linked server in SQL Server 2005 I have problemswith languages other than English.I get a string like:è 'å· åŒ-å|å·¥æ¥æ ªå1/4 ä1/4šç¤3/4It seems to me that SQL Server splits 2-byte characters in 2 1-bytecharacters.If in options of linked server we set Collation Name to exactlanguagewe want --then string data will be correct (of course only oflanguage that we choose).Do you have any suggestions?????????P.S. I don't want to use SSIS (DTS) for extraction from Informix DB
View 1 Replies View RelatedSql Server Linked Server To Informix
Jan 28, 2004Hi, I'm trying to set up a linked server in sql server 2000 (in both win2k an NT) with informix. I've tried using the informix cli driver to ODBC and the OLE DB driver provided by IBM, but I always get errors.
When I try to set the linked server with ODBC the error is : 7399 , It says that the provider did not give any information about the error (..??...) I tested the DSN with the dbping tool and it works fine. I also testet it linking tables with access and also works.
When I try to set up the server using OLE DB, the erro message is Error: 7303 Could not initialize data source object of OLE DB provider "ifxoledbc".OLEDB erro trace [OLE/DB Provider 'Ifxoledbc' IDBInitialize::Initialize returned 0x80040e21: [PROPID=unknown PROPERTY ID VALUE = " .... and so on.....
In both machines, sql server have sp3, the latest MDAC.
The curious thing is that in another machine running windows NT (it's almost a twin of the trouble machine) the linked server works fine and I even can run querys.
I'm desperate!! could anybody help me please!!!!!!!!!!
PD: Attached is an image that shows the error message
Informix Date Type Field To SQL Server Datetime Field Error
Oct 17, 2007
I am trying to drag data from Informix to Sql Server. When I kick off the package
using an OLE DB Source and a SQL Server Destination, I get DT_DBDATE to DT_DBTIMESTAMP
errors on two fields from Informix which are date data ....no timestamp part
I tried a couple of things:
Created a view of the Informix table where I cast the date fields as datetime year to fraction(5), which failed.
Altered the view to convert the date fields to char(10) with the hopes that SQL Server would implicitly cast them
as datetime but it failed.
What options do I have that will work?
Informix
Sep 2, 2004Any SQL Server people out there with Informix experience?
View 7 Replies View RelatedINFORMIX TO SQL
May 16, 2008Please help. I am trying to translate this to SQL 2005. This language is in Informix SQl. I do not know anything about informix. I am especaially confused with the "JOINS". Any help would be appreciated. THANKS.
SELECT ppi.id,
ppi.property_id,
ppi.party_id,
ppi.address_id,
ppi.eff_from_date,
ppi.eff_to_date,
address.line_1,
address.line_2,
address.line_3,
address.city,
state.code_table_cd,
address.zip_postal_code,
country.code_description,
address.line_care_of,
prop_role.code_table_cd
FROM property,
address,
ppi,
outer code_table state,
outer code_table country,
code_table prop_role
WHERE property.id = ppi.property_id
AND ppi.address_id = address.id
{AND (property.eff_to_date IS NULL OR property.eff_to_date >= TODAY)
AND (ppi.eff_to_date IS NULL OR ppi.eff_to_date >= TODAY)
AND ppi.eff_from_date <= TODAY}
AND state.id = address.province_state_cd
AND country.id = address.country_cd
AND prop_role.id = ppi.prop_role_cd
AND prop_role.code_table_cd = "OWNER"
AND property.pact_code <> 'PERS'
ORDER BY ppi.id
Informix OLE DB Provider
Jul 14, 1999I have downloaded the datadirect ole db provider for informix 7.x and am need the correct sp_addlinkedserver syntax to get my sql server 7 and informix hooked up. Can anyone help?
Thanks!
Dean
Informix To SQL 2000
Apr 8, 2004Does anyone have any pointers on how i may import an Informix database into my SQL 2000 server?
What ODBC driver would i need?
Can i connect via DTS to import the data?
The application is not going to be moved, i am only interested in getting the data into a SQL2000 environment.
TIA
OLE DB / ODBC For Informix
Oct 16, 2001Hey everyone,
I'm trying to hit an informix box... I've found two software packages (both priced in the THOUSANDS of dollars)... Looking for a cheap...er, a FREE way to hit this informix box via DTS.
Thank you!
DTS From Informix Database
Jan 14, 2004Hi,
I want to transfer data from an Informix database using DTS. What driver do I need to use for that? What are the settings for the Data Source Name? Has anyone of you accomplished DTS from Informix to SQL Server?
Let me know if you have any ideas that you can share.
Thank you.
Vivek
INFORMIX SQL To SQL 2005
Mar 18, 2008My task is to convert this Informix SQl Script to SQL 2005, unfortunately I am not really familiar with Informix SQL. Below is an example script. I can figure out the "Select" statement and the "Where" statement, but the "From" statement is giving me a hard time. Any assistance would be appreciated.Thanks
set explain on;
UNLOAD TO '/export/home/permit/propinact.txt'
SELECT distinct property.parcel_number,
property.id,
property.eff_from_date,
property.eff_to_date,
property.situs_address_id,
legal_lines.legal_desc_line,
tax_code_area.tca_number,
usecd.value,
ct.code_description,
property_char.value,
property.property_status_cd,
legal_description.section,
legal_description.township,
legal_description.range,
property.pact_code
FROM property,
OUTER (legal_description, legal_lines),
outer property_char,
outer (property_char usecd, code_table ct),
tax_code_area,
prop_valuation
WHERE property.id = prop_valuation.property_id
AND property.id = legal_description.property_id
AND property.eff_to_date <= TODAY
AND legal_description.id = legal_lines.legal_id
AND legal_lines.line_nr = 1
AND tax_code_area.id = prop_valuation.tca_id
AND property.id = property_char.property_id
AND property_char.prop_char_typ_code = "SIZE"
AND property.id = usecd.property_id
AND usecd.prop_char_typ_code = "USECD"
AND usecd.value = ct.code_table_cd
AND property.pact_code <> 'PERS'
ORDER BY id
IBM Informix Ole Db Provider
Apr 4, 2006Hello,
I'm getting the below errors when using sql server's data import wizard. Please Note: My test connection was successful and the error occurs when I click the "Next" button after closing the properties window. For Security reasons I've filled the User Id and DataSource with a bogus account, database, and server i.e. xxxx. Notice the password is blank?... Is that normal? I'm in a jam and appreciate your help.
Thanks,
Matt
===================================
Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=xxx;Data Source=xxx@xxxx". (SQL Server Import and Export Wizard)
===================================
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)
------------------------------
Program Location:
at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.LoadTypeData(OleDbConnection myDestConnection)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.CacheDataSourceInfo(IDbConnection myConnection)
SSIS And Informix
Oct 8, 2007We are using Informx for our transactional DB and want to be using reporting services to provide reports. We have some using ODBC directly to Informix, but need to start extracting data from Infomix
and aggregating it in SS 2005.
Is anybody else doing this?
Where can I find information of how to do this? We are totally new to SSIS.
Thanks
JPS