Vb.net - Cannot Connect To Informix From Application
Jul 13, 2010
I've installed the trial version of IBM Informix Dynamic Server 11.50 on my development laptop, for use with an ASP.NET 2.0 app I'm writing. I have created a couple databases and filled them with sample data but I cannot connect. This is the relevant section of code:
Dim facStr As String = System.Configuration.ConfigurationManager.ConnectionStrings("fact").ConnectionString
conn.ConnectionString = facStr
Try
conn.Open()
Catch ex As Exception
The exception is:
[Informix .NET provider][Informix]Server ol_srv_custom is not listed as a dbserver name in sqlhosts.
The full path to the sqlhosts file is:
C:Archivos de programaIBMInformixClient-SDKetcsqlhosts
Informix's environment variables:
INFORMIXSQLHOSTS=C:Archivos de programaIBMInformixClient-SDKetcsqlhosts
Contents of sqlhosts file:
ol_srv_custom olsoctcp *nb-desarrollo svc_custom
Connect string:
Host=*nb-desarrollo; Service=svc_custom; Server=ol_srv_custom; Database=fact; User Id=informix; password=****
there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.
Below is the information on the server before/after the upgrade.
Before After
--------- -----------
Solaris 8 Solaris 10
IDS 9.40 IDS 11.50
The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.
As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.
The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.
I have gone through many articles and it suggest me to set the environement variable in the server : DB_LOCALE=en_us.819.
I haven't try this solution but i think that this might not be the best solution.
Is it possible to to to have this setting in the web application ?Does anyone has idea on this?Is it true that there is no other solution than setting the environemetn variable DB_LOCALE?
i want to search for data in informix using a like('%Name1%') from my .NET application. The query that i have written is something like this:
select * from tableName where columnName Like CONCAT('%',CONCAT('Name1','%')) ...... this query when run from the front end does not yeild the desired result set ......however when i execute it from the db level i get the correct result .... also an intersting thin that i noted is ...if i do a LIKE('%' || 'Name1' || '%') from the front end i get a syntax error ...however this works just fine when i execute the query from the db...... ive spent over 10 hrs trying to figure this out ......but have not found a solution for it on my own ...... also, the following works perfectly :select * from tableName where columnName LIKE CONCAT('%','Name1') .....from the application... likewise select * from table name where columnName like CONCAT(Name1,'%') works ...........* the vale fields need to be replaced with a '?' in the front end ...informix automatically replaces it when executing the command statement....so the commantext for all informix commands look something like this : select ColumnName from tableName where columnName1 LIKE CONCAT('%',CONCAT(?,'%')) parameter is 'Name1'
We have an ASP.NET application deployed on 2 Application servers with load balancer server. It is using INPROC state management. The ADO.NET connection pooling is enabled with 50 as minimum connections and 100 maximum connections.
In Load testing (using load testing tool) when the application reaches to 50 users no more users can connect (login) to application the TPS reaches zero. No errors are logged in application log related to application or database. The sessions are working fine.
I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it tests it really fast. Does anyone have any idea of what my be causing this? btw the application works fine in another computer with another database
I have created a we application for managing the contacts. I want to save the selected contact to current user's outlook contact list. how to do this? I am using asp.net + c#.net.
its a great and easy to understand windows application for the same. I used Class library. It is running fine locally. but s I deploy my application in IIS and access it from outside network it showing dialog box with message :
" an unhandled win32 exception occurred in outlook.exe [876] "
What should be that ?
Edit 2:
Problem is still there. While i debugging the application I am getting the exception:
Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005. + OUTLOOK
I found this is the User Account Control problem on some blog. Is it true? Or What should be the solution over this. Is any another way rather than Interop services?
I have domain on the [URL]. I have create the database over there.I am able to connect to the database from [URL] site with specified user name and password. but when i am going to use same information in my connection string in my asp.net web application on local machine it is showing "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I am having a ASP.net web application which is hosted in an internet server. Now i got a requirement to integrate this website with a computer telephony infrastructure. The details are as follows.
The user will be located in a building having TAPI standard, LAN - CTE infrastructure enabled telephone system and the logged-in user should be able to connect to the phone line (extension no:) within the same building through the browser. When a call comes to that phone line, a popup should appear in the users browser displaying the number of the caller. I am having the following doubts in implementation of this functionality
How should I connect (communicate) my application with this LAN - CTE infrastructure? The LAN - CTE infrastructre is simply an API having no web services exposed from their side for this purpose. So think I will have to write an extra wrapper class just above the LAN - CTE infrastructure to facilitate this.
Do I really need to connect to the telephone line across the internet as this logged user and the extension no: will be in the same local network?
I have hosted an application on my local system and people on company intranet will be accessing that. I have windowxp SP3. I have heard from someone that only a limited no. of users( around 20) can access my application if I am hosting it on XP.
My application is working correctlywhen I debug it against my sql express. Now i have deployed on IIS on another machine with win2008 web server and changed the database connection string.I would like that the application uses always the same user to connect to the database and not to use the identity of the connected user.
Error: Cannot open database "XXXXXX" requested by the login. The login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE'
I have a project assigned in which whatever mail alerts be generated sent as a sms to the user who is using that web application.I want to know that how to use kannel as a SMS gateway to connect to my Web application and what are the steps required?
I have two PC. In one pc(PC1) i have installed oracle express edition 10g (10.2.0.0 as far as i know). And in another(PC2) i have installed visual studio 2008 sp1. In PC2 the ASP.Net application is running. But i can not connect to the oracle database to PC1. PC1 and PC2 are connected by LAN(TCP/IP {Actually they are connected by wire and given two IP} ) But it was working perfectly while both ASP.net application and database were in the samae PC. ca
I want to develop a three tier architecture app.I have no idea when weplace our BLL and DLL code in different server how to connecct this BLL and DLL code to our Website(UI).
I have an existing windows .net application that has an access database as the backend.
I want to place the access database on a web server and it was suggested that I create a web service in order to communicate with the database.
I've been looking at some tutorials but am still confused about the basic config needed. Here's some questions I have:
1) Does the web service need to be created inside my current project by right clicking on the solution and choosing to add a new web site...and then selecting web service?
2) If it's set up like this, what files do I place onto the web server?
3) Where does the database reside? Do I need to place the database inside the web server that I create?
4) My current project has existing sql that gets data and I'm uncertain how to re-write in order to retreive the data. e.g. which part goes into the client and which part goes to web service pages? here's an example of a procedure that currently exists...I'm getting data to populate a dropdown:
I'm trying to publish an ASP.NET website over an IIS 6.0 (Windows 2003 Server), and I have some troubles trying to connect to the database. Curiously, I have installed another ASP.NET website into the same IIS 6.0 with the same properties and security parameters and can connect without problems with the same database. The application that works fine is almost the same that the one that can't connect with SQL Server (actually is the same but with several modifications).I'll enumarate some information related to the problem:
S.O: Windows 2003 Server SQL Server Engine: SQL Server 2008 SQL Server accept remote connections? Yes. ASP.NET version: 2.0.50727 The connections via TCP/IP are enabled to the SQL Server instance? Yes. The corresponding user that I have in the connection string, actually exists into the database with the "owner" role? Yes. ORM Tool used: nHibernate
I get the following error when I try to run the aplication into the browser:
Error while establishing a connection to the server. When connecting to SQL Server 2005, this failure may occur because the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
I made some test. For example, using the web app that works fine I can connect without any problema with the database that uses the web app that can't. With this evidence I concluded that the problem is within the web app and not into the SQL Server instance.
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr With ConnInfo .ServerName = A.getServerName() .DatabaseName = A.getDBName() .UserID = A.getUser() .Password = A.getPwd() End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
Normally my application is working fine.After I host my asp application on IIS I get an exception "internal error", when I try to execute the below lines of code.
where CertificatePath = C:inetpubwwwroot......
X509Certificate2 cert = new X509Certificate2(CertificatePath, CertificatePassword); var serviceManagment = ServiceManagementHelper.CreateServiceManagementChannel(EndpointConfigurationName, cert); var listServices = serviceManagment.ListHostedServices(SubscriptionId);
I suppose the application is not able to read the IIS certificate.I am trying to connect to windows azure cloud for which the certificate is required to get list of hosted services from cloud.
Stack trace -
StackTrace = " at System.Security.Cryptography.CryptographicException.ThrowCryptographicException(Int32 hr) at System.Security.Cryptography.X509Certificates.X509Utils._LoadCertFromFile(String fileName, IntPtr password, UInt32 dwFlags, Boolean persistKeySet, Safe...
I was just wondering if anyone has ever had to port the schema across? Are there any experts that could pitch their opinions on the achievability of this (mad) idea? I'm using the IBM Migration Toolkit and as expected its throwing a bunch of translation errors some of which were relatively easy to solve (vendor specific function calls for example) and some will take quite a while to pin down and work round.... however this is not my main concern.
If completed I expect I am going to have to basically rework all the System.Web.Profile/Roles/Membership namespace classes etc to work round the SQL limitations of informix (i.e. IDS11.x SQL server doesnt have a DEFAULT (newguid()) so that would have to be put into the calling method) (and any MVP comments really as I can slap my boss round with the weight after he ludicrously agreed to this project for a client without doing any research...)
I have Oracle 10G express edition. I have configured it on windows 7 system. Now I want to make a 64 bit application using visual studio 2010 and connect to oracle 10 g server. If I run my application in VS2010 explecitly in 86 mode then I am connected to database but I want it to happen for 64 bit
