The error message states: "Died in UCI::SQLConnect() with SQLSTATE 08001, Native error:0[IBM][SQLClient][UNIDATA]Database "dbname" doesn't exist"  This occurs in the Visual Schema Generator when I attempt to connect to this database.  The database does exist.  Any help would be greatly appreciated.
123733
The most common reason that this connection attempt failed is that this DSN or ODBC data source attempted to make a connection using the TCP/IP sockets Net-Library, which is Dbmssocn.dll. Because the SQL Server is not listening for incoming connections for TCP/IP sockets clients, the connection fails. From ISQL/w, the second error message stated above would be returned. The OS Error is 10061, and the function call that failed was ConnectionOpen(connect()). By default, SQL Server will listen for incoming connections made by Named Pipes clients. Named Pipes is the default IPC mechanism for clients to connect to a SQL Server version 4.2, 6.0, and 6.5 server. The Named Pipes DLL is Dbnmpntw.dll, and it should be located in the Windows&#92;System or Winnt&#92;System32 directory. The TCP/IP sockets netlib DLL is Dbmssocn.dll, and also should be in the Windows&#92;System or Winnt&#92;System32 directory.The most common resolution to this problem is to configure the client computer to connect using Named Pipes.\nIf the Microsoft Data Access Components (MDAC) ODBC drivers have been installed on the computer, you can make this change in the second step of the Create New Data Source wizard.\nYou can download MDAC drivers from http://tinyurl.com/8xxm\nTo configure the client, start the Create New Data Source wizard, click the Client Configuration button, and perform the following steps, based on the version of the SQL Server ODBC driver you are using:\nFor SQL Server ODBC Driver version 3.50\n1.Click the Net Library tab and use the drop down list box to set the default network (Net Library) to Named Pipes.\n2.On the Advanced tab, remove any advanced entries that reference the server you are connecting to.\n3.Click Done.\nFor SQL Server ODBC Driver version 3.70\n1.In the Network Libraries section of the Edit Network Library Configuration dialog box, select Named Pipes.\n2.Click OK.\nIf you do not have the MDAC ODBC drivers installed, you can use the SQL Server Client Configuration Utility tool to set the default Net-Library to Named Pipes. You can install the client utilities from the SQL Server CD from the i386 directory.
391883
go to this page and it has detailed instructions.\nI will warn you ahead of time...  you may have to run the sqlinstaller piece twice to get it to work.\n\nhttp://itdomino.act.com/act.nsf/docid/19408
611842
Can you install a seperate named instance?  You should be able to run multiple servers under different named instances.  Uninstallations that dont complete are usually pretty hairy but this feature of Sql 2k5 should at least give you some workaround.
9956
Yep, their database servers have some serious problems sometimes. I've voted on answers before and gotten no points for it, which was very sad.
119819
Taht looks good, but I'd try this instead.\n\n&#92;&#92;code start\nDataColumn[] keys=new DataColumn[1];\ndataSet11.Tables["Orders"].Con... UniqueConstraint("ck_constrain...\nkeys[0]=dataSet11.Tables["Orde...\ndataSet11.Tables["Orders"].Pri...\nDataRow findrow = dataSet11.Tables"Orders"].Rows...\n&#92;&#92;code end
169548
Flash doesn't have direct connectivity with databases; you have to push everything out into XML in order to work with it in ActionScript.\n\nMaybe a future incantation of Flash will have actual ODBC connectivity or the like. For now, it doesn't.
244431
try the ibm website... or call them and they usually can tell you or send you a copy
331452
Yeah, 8i runs on XP. Make sure you have the oracle instance running, as well as the listener (go into admin tools from control panel, run Services, find the name of the instance and a listener for the instance, and start them).\nThen create an ODBC connection using the Oracle driver (there's a wizard - just follow the steps). Hopefully you know VB well enough to figure out what to do with the ODBC connection once it's created.
451203
A longer term solution would be to use database aliases / synonyms so that the schema and table names could remain the same across environments.
392251
To learn about this, you would be best off checking out the API of the java.sql package.\n\nIf you do not have a copy locally on your computer, you can go here;\nhttp://java.sun.com/j2se/1.5.0/docs/api/\n\nAfter opening the API, it is best if you choose the 'java.sql' package from the top left frame.  This will open the classes in this package in the lower left frame.\n\nThere is also a 'javax.sql' package, with sub packages inside it.\n\nYou will probably want to check this tutorial on JDBC (Java DataBase Connectivity) out as well.\nhttp://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/JDBC20.html
298912
First of all... EEEK Oracle 9i! Sorry, had to get that out of my system. Anyways, you should first take a look at your indexes. You are not attempting to rebuild indexes and then fetch a particular row ID are you?\n\nAnother thing you might try is dropping the index and recreating it on the table. \n\nLastly, could another session deleted the row before you attempt to delete it? I would strongly look at how you are using indexes and make sure you are not doing something improper just before you attempt to fetch the rowID.\n\nThis error basically is saying that it can't find the row. (Could be changed, reindexed, or simply not there).
85613
Are you connecting it via MySQL Connector/J or not? If No then connect to Mysql with the Connector/J and make sure your database is up and running!
196196
If you have the ability to enter a direct SQL statement into UltraDev when you are binding this data, your SQL statement would look something like this:\n\nSELECT a.*, b.* FROM troubleshootingtable a INNER JOIN servertable b ON a.servernamecolumn = b.servernamecolumn WHERE a.recordidcolumn= 'recordid'\n\nIn the statement above:\n\nReplace "troubleshootingtable" with the name of the troubleshooting table\n\nReplace "servertable" with the name of the table that holds your server info\n\nReplace "servernamecolumn" with the names of the columns that hold your server names. For example, if that's called server in the troubleshooting table, then a.servernamecolumn would be changed to a.server; if it's called servername in the servers table, you'd change b.servernamecolumn to b.servername\n\nReplace "recordidcolumn" with the name of the primary key column in your troubleshooting table.\n\nReplace "recordid" with the name of the variable you will be using to get the right record.\n\nIf this doesn't help, follow up and I will try to clarify.
482305
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'
364399
Hai Shaam,\n     I assume that you are successful in obtaining aconnection to the \nOracle Table, If not please code as necessary like\ntry{\nClass.forName("sun.jdbc.odbc.JdbcOdbcDriver")\nConnection con=DriverManager.getConnection("jdbc:odbc:<dsnname>", "<userid>","<password>");\nStatement stm = con.createStatement();\nResultSet rs = stm.executeQuery(<sql query>);\n// you will get each value by using\n//rs.getString(<index>) then store it in an array\n//display it to output,\n//if you need to display it in an output table in java\n//you can use JTable in the swing library.\n}\ncatch(Exception e){}\n\nfor further details you can contact me\n\nemail:ananthasivanvk@gmail.com\ncell:+919995403653
507806
Did you create the database or did someone else?  If someone else did, they most likely used a non-standard Active X control.  You have to get a copy of it and register it in order to make it work.\n\nIf you are unclear on how to do this, check with the originator of the database and see how they did it.\n\nThe other possibility is that you have an incomplete installation of Access.  You might want to reinstall it and make sure that all of the standard ActiveX components get installed.\nEmail me if you run into difficulties.
181377
You can use the System.Data.OleDb namespace, which is supported in the .NET Compact Framework 2.0:\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclasstopic.asp\n\nTo use that, you'll need the OLE DB provider from Oracle:\n\nhttp://www.oracle.com/technology/software/tech/windows/ole_db/index.html\n\nPersonally, I'd use the .NET Framework 1.1, which includes the System.Data.OracleClient namespace:\n\nhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclient.asp\n\nThe only problem there being, eventually that framework won't be supported by Microsoft any more.