Hi, I need to connect to a MySQL database via C# express 2008. I think I got the code right apart from the connection string. I obtained this code from a forum but the connection string was for SQLExpress 2005. Can someone please help me on how can I fix this? Here is the code with the SQL Express connection string: //string connection...
I started using the jOra eclipse plugin. The plugin seems pretty robust and I'm hoping to stop using SQLDeveloper for 95% of my database needs. Many of our tables have columns of type TIMESTAMP with LOCAL TIME ZONE. I can connect to the oracle DB using a jdbc string and the plugin seems to function very well. However, when I try to...
I've created a database an a table ("Mail") having 2 columns: id INTEGER, content INTEGER. In my aplication I have tested the connection and it works well. using Finisar.SQLite; ... string db = "mydatabase"; SQLiteConnectionsql_con = new SQLiteConnection("Data Source=" + db + ";Version=3;New=False;Compress=True;"); sql_con.Open(); sql...
Mysql odbc connection string is stored in the windows registry as plain text. So someone can find it and view my database. How can I sort out this security problem. thanks ...
I have a TcpClient object which sends some data to server, using its underlying NetworkStream.Write(). Therefor, I have: TcpClient server = new TcpClient(serverName, 50001); /* ... */ NetworkStream stream = server.GetStream(); Now, when a button is pressed, the connection should close. What is the right way to close the connection? ...
Im experiencing an issue with a production server. I can connect to the server from only one program at a time. Eg, when I connect from SQL Management Studio then nobody else can, and vice versa with a different user. It's like the server is in single user mode, except, it's in multi user mode. Any ideas? I get this error message when ...
-What is difference between connection to SQL Server from ASP.net and Desktop application? Why purchasing a Client Access License (CAL) for every device that accesses your server is not needed in web? If I have a CAL for 10 devices and I need one more device to connect to SQL Server, can I do this using Web service? Thanks ...
Hi, I need to redirect a connection from a game to my custom ip/port. I know that it can be done via detours, or modifying the host file, just wondering if there is any other way? ...
In http transaction for request and response which scenario is occurred ? client (web browser) open connection and send it's request and connection open (keep alive) until server accept and answer then close connection ? client (web browser) open connection and send it's request then connection is closed and server accept and answer a...
I use this code for reading from socket : int n ; char buffer[256]; n = read(newsockfd, buffer, 255); if (n < 0) { error("ERROR reading from socket"); } if the data that must be read bigger than 255 byte (for example 1000) which change must be occured ? I know change char buffer[1000], I need different solution ....
I created one asp.net mvc application using linq to sql, and in the generated code it created this: public ApowDataContext() : base(global::System.Configuration.ConfigurationManager.ConnectionStrings["APOWConnectionString"].ConnectionString, mappingSource) { OnCreated(); } Which worked well, However in my next ...
Hello, I have a queer problem. I was working on a project with firebird 1.5.6 .NET provider and Visual Studio 2005. Everything worked fine. Then I converted the project to a VS2008 project. Now I have the problem that when I'm trying connecting to firebird database I get the an error: Index was out of range. Must be non-negative and le...
im new on informix and i did a webservice on .net c# that calls 3 different store procedures. What i like to know is if Informix or .Net opens 3 different connections to execute this procedures or just opens 1 en re-use it for each of the procedures also if i execute this webservice on different pc's each of the pc's will open a connecti...
I have successfully connected to DB2 database using db2jcc.jar and now facing another issue. When i create a dataset and preview it. BIRT viewer throws following error. Cannot get the decimal value from column: 1. Cannot get BigDecimal value in the result set. SQL error #1: [IBM][JDBC Driver] CLI0610E Invalid column number. SQLSTATE=S1...
Hi All, Please tell me what is the use of TNS_ADMIN parameter in Oracle? I am working on Unix using oracle database. Is this parameter is required to locate the sqlplus. I am executing a script in which a update query is executed on Oracle Database. The script fails with 127 error code when executed with crontab. The script content...
Can you please send me the code regarding treewidget items ,the issue is when we are clicking the list in treewidget we have to a new window in right side,by clicking different list we have to get the particular window according to list in treewidget. ...
I need help tracking something down, I'm getting several connections where in Enterprise Manager it says: OS User Name: Example$ <-- Example is the machine name. Terminal: Example Machine: Domain\Example There is NO user named Example$, where is this coming from?.... I'm using Oracle 11g. Edit: The problem I'm tracking is with an a...
We're seeing ConnectException with message "Connection refused" sporadically appearing at times when connecting to our Tomcat server. Could these be caused by long GC cycles? (We're activating up the relevant JVM flags to get more log messages on GC cycles, but I thought to ask this here anyways) ...
I have a problem using java rmi: When I'm trying to run my server, I get a connectException (see below). Exception happens when executing the rebind method: Runtime.getRuntime().exec("rmiregistry 2020"); MyServer server = new MyServer(); Naming.rebind("//localhost:2020/RemoteDataPointHandler", server); when using rmi://localhost:202...
How to read connection string info from app.config file using .net api? Platform is .net 3.5 <?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add connectionString="" providerName="" name=""/> </connectionStrings> </configuration> ...