Problems using Informix .NET provider
A user installing IDS 11.50 on Windows couldn't connect via the Informix .NET provider, getting 'Unspecified System Error = -11048'. Suggestions included using 'User ID'/'Password' keywords (the poster cited docs saying UID/PWD are valid), supplying the port number rather than a service name, configuring the connection with SetNet32, checking CSDK/INFORMIXDIR settings and the .NET framework version. The final tip was that the error typically stems from picking up the wrong DLLs or an overly long PATH, so moving INFORMIXDIR/bin to the front of PATH and restarting the app should fix it. The original poster never confirmed a resolution.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I installed IDS 11.50 using all defaults for the installer. Then I tried to connect to the service that has been created by default through the .NET provider. I used the following connection string: host=localhost;server=ol_ids_1150_1;service=turbo;database=sysmaster;uid=informix;pwd=ifxifxifx0mypassword I get the following exception: ERROR [HY000] [Informix .NET provider]Unspecified System Error = -11048. The docs say it's got something to do with a translation DLL. I can only find some info on the concept of a translation dll for the ODBC driver...? Any help?
On Dec 10, 9:17 am, Peter Laman <peter.la...@gmail.com> wrote: > I installed IDS 11.50 using all defaults for the installer. Then I > tried to connect to the service that has been created by default > through the .NET provider. > > I used the following connection string: > host=localhost;server=ol_ids_1150_1;service=turbo;database=sysmaster;uid=informix;pwd=ifxifxifx0mypassword > > I get the following exception: > > ERROR [HY000] [Informix .NET provider]Unspecified System Error = > -11048. > > The docs say it's got something to do with a translation DLL. I can > only find some info on the concept of a translation dll for the ODBC > driver...? A couple things to check: - "uid" should be "User ID" - "pwd" should be "Password" - use the port numer for the value of service, unless you are sure your windows machine has the port name/number mapping - Did you configure the driver using SetNet32? The ADO.Net driver does not stand alone. It rides on top of the Informix CLI library. Use SetNet32 to set these same values in the Windows Registry.
What's the version of .NET/CSDK? What is the OS version (i.e XP, Vista
etc)? Again there are two versions of Informix .NET Provider shipped, 1.1
and 2.0 frameworks. Which one are you using? Are you able to connect using
"dbaccess" (comes with IDS installation)?
By any chance do you have more than one Informix CSDK installed in your
system? Is your IDS and CSDK on the same machine? If so, what location
(i.e. IDS or CSDK) INFORMIXDIR environment variable is pointing to? It
should be CSDK location.
You can also try supplying entire qualified host name.
-Shesh
Peter Laman <peter.laman@gmail.com>
Sent by: informix-list-bounces@iiug.org
10/12/2008 19:47
To
informix-list@iiug.org
cc
Subject
Problems using Informix .NET provider
I installed IDS 11.50 using all defaults for the installer. Then I
tried to connect to the service that has been created by default
through the .NET provider.
I used the following connection string:
host=localhost;server=ol_ids_1150_1;service=turbo;database=sysmaster;uid=informix;pwd=ifxifxifx0mypassword
I get the following exception:
ERROR [HY000] [Informix .NET provider]Unspecified System Error =
-11048.
The docs say it's got something to do with a translation DLL. I can
only find some info on the concept of a translation dll for the ODBC
driver...?
Any help?
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
> - "uid" should be "User ID" > - "pwd" should be "Password" According to http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.netpr.doc/netpr031008447.htm, UID and PWD are fine. > - use the port numer for the value of service, unless you are sure > your windows machine has the port name/number mapping Check. > - Did you configure the driver using SetNet32? The ADO.Net driver does > not stand alone. It rides on top of the Informix CLI library. Use > SetNet32 to set these same values in the Windows Registry. Yep.
See inline comments:
> What's the version of .NET/CSDK? What is the OS version (i.e XP, Vista
> etc)? Again there are two versions of Informix .NET Provider shipped, 1.1
> and 2.0 frameworks. Which one are you using? Are you able to connect using
> "dbaccess" (comes with IDS installation)?
Installed .Net framework versions are: v2.0 SP1, v1.1
>
> By any chance do you have more than one Informix CSDK installed in your
> system?
No
> Is your IDS and CSDK on the same machine?
Yes
> If so, what location (i.e. IDS or CSDK) INFORMIXDIR environment variable is pointing to? It
> should be CSDK location.
It is.
All of the settings are set up by the installers by default.
On Dec 11, 3:55 am, Peter Laman <peter.la...@gmail.com> wrote:
> See inline comments:
>
> > What's the version of .NET/CSDK? What is the OS version (i.e XP, Vista
> > etc)? Again there are two versions of Informix .NET Provider shipped, 1.1
> > and 2.0 frameworks. Which one are you using? Are you able to connect using
> > "dbaccess" (comes with IDS installation)?
>
> Installed .Net framework versions are: v2.0 SP1, v1.1
>
>
>
> > By any chance do you have more than one Informix CSDK installed in your
> > system?
>
> No
>
> > Is your IDS and CSDK on the same machine?
>
> Yes
>
> > If so, what location (i.e. IDS or CSDK) INFORMIXDIR environment variable is pointing to? It
> > should be CSDK location.
>
> It is.
>
> All of the settings are set up by the installers by default.
Also check your PATH environment variable. The error is caused when
the connection is using the wrong dll files or if there is a really
long path environment setting.
If you move the INFORMIXDIR/bin to the front of the path then restart
the application you are testing with (if it is still open) this should
correct the problem.
HTH