I'm trying to create a drop down select option using PHP, MySQL, and ajadx I have the PHP and ajax pretty much figured out but I'm stumped on how I should organize my tables I couldn't decide so I created it both ways: The first way the tables are: CourseTbl containing (CourseID*, and CourseName) DateTbl, (DateID*, and DatesOffered(en...
What is the best approach to connection management in a key data operator (kdo) type data entry (C# Winform) application with regards to database as well as client app performance? let's say the kdo is reading, editing, and writing back a table row every 5-10 seconds; should we open the connection and leave it open for the session (1000...
I'm following a tutorial for constructing a PHP and MySQL ecommerce driven website, and I'm uploading them to my server at the moment, but in need of some assistance determining how to proceed. In the README of the tutorial, are the following instructions: INSTALLATION INSTRUCTIONS 1.) Unzip plaincart.zip to the root folder under your...
I wanna connect to aspnetdb but it makes an error says "Login failed for user" this is the connection string in web config : <add name="UserProfiles" connectionString="Data Source=KIA;Initial Catalog=aspnetdb;Integrated Security=True;" providerName="System.Data.SqlClient" /> and this is my code: SqlConnection connection = new SqlC...
I need to let my Rails app connect to a MS SQL Server database and do a simple query to do a lookup. The main DB for the app is MySQL. It just needs to do this SQL Server thing on the side. What's the best way to do that? I could write an entirely separate app in Java that connects to the DB and dumps some XML data to the filesystem fo...
Let's say we've got a web application or web service on an application server supporting JDBC connection pooling. Should I be grabbing a new Connection on a per-thread or per-query basis? Thanks! ...
Hello, I'm looking for a well designed, efficient and robust C++ cross-database and cross-platform database communication library. I need support for Oracle MySQL PostgreSQL Firebird (optional) MSSQL (optional) When I say cross-platform I really mean cross-platform, I need something similar to boost. Currently I'm researching soci,...
I'm migrating some code from Python to Jython, and it currently uses MySQLdb.cursors.SSCursor to fetch the rows one by one instead of loading them into memory in bulk. In Jython, I'm using zxJDBC to connect to the database, but I see no reference to SSCursor, and very few search results for zxJDBC and TYPE_FORWARD_ONLY, which is the Jav...
This is a little wierd, but I want to check if connection to my database is already open or not? How do I check that? and if open I want to be able to work with it straightaway without going through all the statements: sqlconnection conn = new sqlconnection("string ..."); Can this be done? I know the connection string and the connecti...
Hi experts, I am making an application which have to be used in different pc's, and it has to share the same database. I have no idea how to do it. I am using the java as programming language and mysql as database. Please help me to do this task... ...
Hi, I have the correct entries in the web.config file in my asp.net project. How do I make sure that the connection has been established successfully? I want to pull an image form my database and then display it on my aspx page. Some things to note: I am using visual studio 2010, sql server 2008, .NET 4.0 Thanks Here is the relevant p...
Hi, I'm working on a project where we're gonna fetch data from a DB2 database. I've been testing with both the ibm provider and simple odbc and with both approaches the connection open method is very very slow. If I try doing the same thing with Java and the IBM jdbc driver, it is a lot faster. Does anyone have any tips on how to i...
I am working on designing a SQL Server database connection class in VB.net 2005. The idea behind doing this will be so a developer can can call the class, pass it a stored procedure name along with the parameters, and get return values back (if any). My question is, how would I design the class so the stored proc parameters are dynamic?...
Hi, I have two separate appliations running on the separate infrastructure. app-a is using MYSQL as it's database server and, app-b is using MS SQL Server as database server. I have got requirement to constantly read some tables in the MS SQL server and populate some table in MYSQL server. I got clue about setup a communication environ...
I am having serious issues setting up a proper tunnel in paramiko to enable a database connection. I have reviewed the example 'forward.py', but am not understanding how to then link the database connection to it. Any pointers woudl be much appreciated. I think I need something the following: t = paramiko.Transport((hostname, port)) ...
Hi stackies, I recently read that the content provider content://sms shouldn't be used to access the SMS store, as there could be some mobile phones that might not know how to deal with it. So, what would be the best way to access the SMS database in Android? How can I access mmssms.db (this should be the database I need to deal with, ...
Hi , I just wanted to know the concept of database pooling.How it is achieved. ...
I am trying to connect to SQL Server 2005 express edition from SQL Server Management. From the server configuration manager, I found the SQL Server Service to be running and within bracket, it's written(SQLEXPRESS). I understand SQLEXPRESS is the instance name, therefore I have to use following string for server name: \SQLEXPRESS. I am...
Hi, I am getting Exception while connecting to database: The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception. My Code: Con = New OdbcConnection(ConnectionString) Con.Open() ' **Geeting Exception here** tmpdt.Clear() Cmd = New OdbcCommand(Str) Cmd.CommandType = Command...
I am really confused about the .dbo schema thing. Here is my issue: I have a website I'm building in VWD and I connected it to a database that I built in SQL Server Management Studio. The website works to pull up items from the database. However, I made changes to the database and they didn't show up in the website. I looked in the Datab...