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.
ADVERTISEMENT
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
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:
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
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 RelatedFinding The SQL Server Port
Feb 17, 2005Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.
Is there a way I can specify a port for the server to listen to?
Finding The SQL Server Port
Feb 21, 2005Hello. I'm a novice with SQL Server. I set up a SQL Server instance using Enterprise Manager and I want to find out what port that instance is listening to, because it's not listening to the default.
Everything is on my local machine, this is a development database.
Is there a way I can specify a port for the server to listen to?
How To Port SQL Server Data?
Jan 27, 2004Hello!
I have an SQL Server 2000 database at home PC that has several tables and plenty of data in it...also stored procedures.
I want to port all that data so that I can use it at another PC that has SQL Server installed in college.
How to do this?
Thanks in advance!
Lala the don
SQL Server Port.... (Named
Jul 12, 2006I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ....
I knw that we can go to the servers network utility & see it there in the TCP /IP ... but i dont have access to that , neither do i have access to the error logs that tell me , on which port is SQL Server listening to
Can someone help
SQL Server Port Change
Jan 30, 2008
Hello All,
We have default instance "MSSQLSERVER" with Port number 1433. We Installed another Instance "MGMT" on the same windows server, it came as same Port number "1433".
We decided to Change the Port number for Instance "MGMT".
1. We changed the port number for "MGMT" to like "1234"
2. After the change we did telnet to "MGMT" Instance with "1433", it worked.
3. Then we changed the Port number for Instance "MSSQLSERVER" also to like "4321".
4. After change of these setting and followed with rules framed in link as said: http://www.databasejournal.com/features/mssql/article.php/3689846
5. Now we did telnet with changed port number, it works fine.
6. We can not do telnet with Port number 1433 for both Instances "MSSQLSERVER" and "MGMT".. This is fine, what we want, and what we intent to do...
Question to MVP OR SQL Gurus:
A) If you want to change port number to Second Instance, shall we need to change for Default Instance?
B) How the port numbers will be configured? please advice.
Thanks, Jay
(RDA)Accessing Server Via A Port..
Jun 14, 2007Hello,
I connect to the SQL Server with RDA method. there was no problem until I had to use a port to access the virtual path of RDA.
it connects when
rda.InternetUrl = http://ip/rdadir/sqlcesa30.dll ,
but no when
rda.InternetUrl = http://ip:81/rdadir/sqlcesa30.dll .
May someone help,please?
Thanks.
Connecting To SQL Server On A Different Port
Nov 27, 2006I have a server running SQL Server 2005 Dev behind a firewall that blocks the default SQL Server port. So, I changed the port that SQL server uses to another port. How do I connect to the database instance with SQL Server Management Studio. I have tried:
xxx.xxx.xxx.xxxMSSQLSERVER
xxx.xxx.xxx.xxx:portMSSQLSERVER
name.of.machineMSSQLSERVER
On all of these, I get an error 25 - Connection string is not valid. I have the surface area configured correctly (i.e. named pipes and TCP/IP are both turned on), and the sql server browser is running. I can ping the server just fine, and when I go to GRC.com and do a shields up report it lists my port of choice as being open.
What am I missing?
I also set the native client configuration's default port to the port I want to connect to, and it appears that that didn't work either.
Ideas? I would like to get this running ASAP.
Thanks in advance!
Sql 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
Can Not Run SQL Server 2005 Upgrade Advisor On Server That Does Not Use The Standard Port
Jun 7, 2007I tried creating an alias to the server to get it to connect to analyze the server but it will not recognize the SQL 2000 server as a valid server to analyze. I can use the alias to connect in EM or SSMS. Any ideas? The server is not clustered and is at SP4. I've connected to several others in my environment but this one is causing me grief!
Thanks,
Linda
How To Change The Sql-server Port Number?
Aug 7, 2007Hi there,
I want to change the default sql-server port number 1433 to a new one. Can i do that? If yes, how?
Also, i have noticed that there is no port number option in the sql server 2005 management studio login window. So, what if the server has changed its port number?
Any suggestions would be appreciated. thanks
Sql Server Default Port Not Enabled
Mar 17, 2004I am unable to access the default port 1433 on my SQL 2003 server. There is no firewall. I run telnet <ip> <port> and get "Connection failed" which explains my inability to connect to the server for weeks. I have being unable to connect to the server after I uninstalled sql 2000 and reinstalled it on my 2003 server. Some of the things I have checked is Network Configuration in EM. Named Pipes and TCP/IP is installed with port set to 1433. HKLMSoftwareMicrosoftMSSQLServerClientSuperSocketNetLibTcpDefaultPort port is set to 1433. Is there anything I need to configure on the server side to have the default sql server port enabled.
Thanks
How Can I Get The Port Of A Named Instance Of SQL Server
Sep 14, 2004Thanks for Microsoft's Windows XP Service Pack 2 and Windows Server 2003 that make the security much stronger. However, besides the invisible benefit so far, I have become the victim of this security policy.
I have several named instances of SQL 7/2000 installed in my machine. They are not visible out of the Microsoft new fire wall. I need to access the instances from outside the fire wall, but I don't know which port I should open for the instances.
From SQL online, the default instance of SQL server is connected through TCP/IP by default port 1433. I could successful open that port and made the default instance visible to outside. However, the port 1433 doesn't work for the named instances. SQL online said, the port for named instance is dynamically (by default) chosen the first time the instance is started. So, actually, I have no way to know the port.
Is there anyway that I can check the database or somewhere to get the port that is used by the named instance?
Thanks for any input and recommendation.
Installed SQL Server, Yet Not Listening On Any Port
Jan 17, 2005Hi all,
I'm working on a school project on web and mobile applications, and had decided to use MS SQL Server for my backend database.
However, after I've installed MS SQL Server 2000, I ran a port scan and I couldn't find the server running on any ports (MySQL is running on my port 3306, but I guess it doesn't matter) Can something drop some hints on how to debug the problem?
I'm running on Athlon XP 2000+ w/ Windows XP Professional SP2
Thanks a lot!
SQL Server Listening To Specific IP & Port
May 7, 2002Hi all,
I have SQL Server in NT 4.0 which has two IP addresses. How to force the SQL Server to listen to specific IP address ? We can make client to listen to specific port & IP and let me know the way to configure SQL Server to listen only to specific port that will make to ensure that SQL Server can be communicated throught that specific port.
Your answer would be highly appreciated.
regards,
Nana
How Can I Tell Whether SQL Server Is Able To Listen To Port 1433?
Jun 20, 2004I want to know how to check whether SQL Server 2000 can listen to port 1433 or not. If I run netstat -a, am I suppose to see port 1433 regardless of what service pack I have applied to SQL Server 2000?
View 14 Replies View Related