Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

problem using oledb + informix

 
   Database Help (Home) -> Programming RSS
Next:  grant restore permission to db_owner  
Author Message
Orso21

External


Since: Sep 22, 2006
Posts: 1



(Msg. 1) Posted: Fri Sep 22, 2006 10:46 am
Post subject: problem using oledb + informix
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi all.
I have a problem writing a table on informix (IDS 10.0) using
a linked server on SqlServer Express:

This is the insert:

INSERT INTO unixdb1.practor.informix.ven_rilcld
(rilcld_rilcld,rilcld_entazi, rilcld_numter, rilcld_codbar, rilcld_qta,
rilcld_prezzo, rilcld_codart)
values( 11,'05019999', 0, '222', 45, 23, '')


And this is the error:

Msg 7343, Level 16, State 2, Line 5

The OLE DB provider "Ifxoledbc" for linked server "unixdb1" could not
INSERT INTO table "[unixdb1].[practor].[informix].[ven_rilcld]".


The same sql run without problem if I use a simple vbs script:
________________________________________________________________
Set cx = CreateObject("ADODB.Connection")
cx.provider = "Ifxoledbc"
cx.connectionstring = "Data
Source=practor@ol_server10_tcp;Server=ol_server10_tcp;Service=1531;Host=10.36.1.102;Protocol=olsoctcp;User
ID=informix;Password=$1nf0rm1x$;Persist Security Info=True;"
cx.Open

cx.Execute ("insert into ven_rilcld values
(0,'09876543',51,'73643234','',0,100)")
________________________________________________________________

Any suggestion?

T.I.A.

Stefano

 >> Stay informed about: problem using oledb + informix 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
openrowset and jet.oledb - Please help, since the introduction of SQL2005 the default mode for opening access mdb databases with Openrowset appears to be in exclusive open mode I wish to open the database in share mode so the other (non net) ADO threads can open the database at....

Microsoft.Jet.OLEDB.4.0 - Error - Hi, I am using SQL Server 2005 (SP1) on Windows Server 2003 EE (SP1). I get following error while accessing Excel or Text file data sources with OPENROWSET or OpenDataSource and Microsoft.Jet.OLEDB.4.0: From SQLAgent Job Log file: Cannot initialize....

Need a deadly row lock through oledb - Hi, I might have asked this before, but since SQL 2005 was there, MS strongly modified locking in favor of scalability. I never got an answer that solved the problem. I have an app that really needs to lock a certain row to be locked so that other..

intermittant OLEDB query failure - I have the following query that I'm using to update pricing from a spreadsheet to a MS SQL(1005) DB Table as we prepare to move to a new quoting system. UPDATE DT SET [BasePrice] = ST.RawPrice ,[BaseCost] = ST.RawCost from..

Launching oracle jobs from oledb - perhaps the wrong group, but I suspect somebody here has tried it... Greetings. I have a vb.net oledb procedure that can schedules an oracle procedure to run and returns to me an oracle job number. It looks like this: FUNCTION CPM_SUBMIT (iprocname i...
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]