how to use oracle in  2000 server without using hoststring?
606004
Ask NEO.. He's the one!
873528
Yes you *can* but it's probably not the greatest idea.\n\nHere's Microsoft's TID on the subject\n\nhttp://support.microsoft.com/kb/327928/en-us?spid=1773&sid=951\n\nThe first thing you'd want to check is your hardware and software levels. To get the full benefit of you AD environment, you want to fun in AD 2003 native mode, which means no 2000 servers of any flavor.\n\nYou're also going to want to get a good backup of your domain controller configs, mailboxes and post office. If you were really thinking ahead, you start a fresh Server 2003 R1 install, get it patched, join it to your domain (hopefully a 2003 native), install your exchange, and then make your new server a member of the 5.5 postoffice. After you have a good copy of the data on your '03 box, then promote it inside the domain to full functionality. This way, if it takes a dump, you still have your 5.5 box waiting in reserve.\n\nHere's Microsoft's Exchange 2003 Migration page (scroll down below the 07 content):\nhttp://www.microsoft.com/technet/prodtechnol/exchange/2003/migrate.mspx\n\nHere's their deployment guide. Whatever you decide to do, you would be well served to read up on the best practices and recommended settings. A few hours of preparation could mean the difference between a relatively simple migration and days and days of trying to figure out what went wrong.\n\nGood luck,\nOdd
1012399
1st try to restart i hope i will sove problem.\n\n2nd\nThe error occurs because the Oracle client and networking components are not installed. The computer that is running SQL 7.0 requires the Oracle client and networking components to use MS Oracle provider to connect to an Oracle server. \n Back to the top \n\nWORKAROUND\nIf you are on a SQL Server cluster, you must install Oracle client and networking components on each of the nodes (or computers) that are part of the cluster. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation. \n Back to the top \n\nMORE INFORMATION\nWith Microsoft SQL Server 7.0, you can perform queries against OLE DB providers. You do this by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four-part names including a linked-server name. For example: \n\nsp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog'\n\nSELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')\n\nSQL Server 7.0 installs Microsoft OLE DB Provider for Oracle. To query a local or remote Oracle server database from SQL Server query that uses the Microsoft OLE DB Provider for Oracle, you must install Oracle client and networking components on the computer that is running SQL Server.\n\nFor Transact-SQL code examples on setting up and using distributed queries with an Oracle server search on "Microsoft OLE DB Provider for Oracle" in the index of the SQL Server 7.0 Books Online.\n\n\nfor more information follow link below
40947
No you cannot.\n\nit is like trying to use a pc without OS
299674
HI,\n    To setup a network you can do it with xp as well as with windows 2000,2003 with xp you can go for workgroup where each system works as a client and server so there is not much security using this . Better to go with windows 2000 or 2003 where one system will act as a server and all other system will act as client not necessary that all the system must have windows 2000 or 2003 only one is sufficient rest all can have xp operating system. Using this domain/client you can assign password to the user as per your convince .. To assign password follow this\n         \n       right click my computers --clk manage there you can find the option of  user and groups create your users and groups and assign them the password as per your requirements ,..each time a user tries to logon to the network then he need to give the password and user name without which he cant logon..using xp in all the system its not possible to create domain/client environment so go for the above suggested method.\ntry this you can make it dear
174573
If you have a locally running db such as Oracle start it up before opening a new project in VB.\n\nOnce the bd service is running VB has a wizrd to help you locate the db server.  \n\nYou'll need to specify to Oracle and also VB that you want to use ODBC connectivity.\n\nYou'll also need to define how your db information is organized.\n\nFor your needs MS Access might be much easier.\n\nIn any case PHP with MySQL is deifinitely easier.\n\nHope this helps, please vote for me!\n\nJIm
112835
You use Xen Virtual machine.....\nhttp://www.linuxjournal.com/article/8540
1091749
Oracle Enterprise Manager 10g
682514
Please visit the oracle technet web site:\n\nhttp://www.oracle.com/technology/index.html
143941
1) Oracle has a program call SQL Loader that loads tables from external data.  You can write a module in Access to create a flat fiel from your data and put it in a form where SQL Loader understands.\n\n2) A solution that works with almost any RDBMS is to write a module in Access to create SQL Insert statement for each record in your Access table, and write them to a file.  Then, using the RDBMS's batch execution engine (SQL PLus for Oracle, OSQL for SQL Server, MySQL command prompt, etc, ISQL for Sybase, etc), simply create yout table and run those insert statements.\n\nAn example of 2) would be ...\n\nFunction doIt()\n\nDim rs As Recordset\n\nSet rs = CurrentDb.OpenRecordset("Select f1, f2 from t1;")\nOpen "c:&#92;statements.sql" For Output As #1\nWhile Not rs.EOF\n    Print #1, "Insert into T1 (F1, F2) values ('" & rs("f1") & "', '" & rs("f2") & ")';"\n    rs.MoveNext\nWend\nClose\nrs.Close\n\nEnd Function
1137580
try:\n<add key="dbConn.ConnectionString" value="workstation id=YOURSERVERNAMEHERE;packet size=4096;\nuserid=YOURUSERIDHERE;\npassword=YOURPASSWORDHERE;data source=YOURSERVERHERE;persist security info=False;initial catalog=THEDBNAMEHERE" />
704338
i recommend against using these, you can get in truble...\nbut if you absolutely have to: http://www.tim2009.bravehost.com/psites.html
775699
Yes, though it is not going to be as efficient.  It should not have any problems.  Server 2003 is pretty much the same as W2K except is has more features.  Hard to find out exactly what you are looking for, but feel free to follow up.
50443
You can't--at least not unless you know the protocol and telnet from a shell to that server.  Otherwise, try a site like http://www.dslreports.com/whois or http://dnsstuff.com
175039
You can't. Microsoft is a proprietorship company. There are other options. BSD ClarkConnect, Yellow dog, Solaris, SuSE, Red Hat, Fedora Core. Apache type configurations are free and usually come with open source services.\nWhat are you using the server for?\nLinux/Unix servers have an advantage seeing that they are compatible with all OS server/non-server while Microsoft servers may need extra software.
888756
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...'
461228
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=58