Does anyone know of any shareware tools out there that can connect to
sql server 2000 from Unix(specifically Sun Solaris) and perform
queries and return result sets ? Appreciate your help.
Steve Chiang
Is there anything (other than the JDBC / ODBC) to get access to SQL Server from UNIX?
View 1 Replies View RelatedAnybody please help me !
i was tried to install SQL Server 2k Client tools connectivity to my win 95, i was follow the installation procedure, 1). install common library updates for win 95, and then 2). install the server component (client connectivity tools), the installation is running well till copying "Microsoft Data Access Components - MDAC", i got error message : "Installation of the MDAC package failed (-1)". (so the installation doesn't complete).
please anybody help me, what's happen to my computer ?????????
:confused:
thanks for the help.
Andre.
First, let me start by saying I know the answer to this, but due to politics any answer I give will be viewed with some disdain and disbelief.
A Unix/Network [rtdpmin one our sister agencies is trying to solve a problem that really does not need to be solved, but ....
The sister agency uses Information Builder's WebFocus on Unix. When they try to read my data warehouse in SQL Server 2000 it times out on them (on their end and they claim they cannot fix it) (This is using the supplied WebFocus ODBC/JDBC driver for SQL Server). This has lead to accusations of us not letting them read the data.
After much gnashing of teeth over "if you do data and data analysis for a living, why do I have to show you how to set-up an ODBC connection" we have shown them how to connect to the data, read it, and transfer it using MS-ACCESS, EXCEL, and more importantly SPSS. This is not good enough because they cannot figure out how to put it into WebFocus.
Their network person has come-up with the brilliant idea of reading the .mdf directly by installing Windows for Unix on the Unix side and then just pointing to the .mdf file and "reading it ".
Unless I have missed something somwhere (I will admit possible), I know you need a driver to read MS-SQL and that driver in every example I have seen could care less about the physical location of the .mdf file. It wants to know what database, what server (ip or name) and what security/login to use.
Could someone give me a more "technical answer" or even Microsoft's party line so I do not have this person mucking around with my production server trying to acomplish the impossible.
Hi,I am having a problem accessing SQL Server 2000 via UNIX. I amaccessing SQL Server 2000 from Solaris using Sybase Open Client(CT-Lib). Here is the error message:CT-LIBRARY error:ct_connect(): network packet layer: internal net libraryerror: Net-Library operation terminated due to disconnectI have another SQL server 6.5 and I do not have any problems accessing6.5 using the same strategy. Can someone tell me how I shouldconfigure to access SQL Server 2000 from UNIX?Thanks,Amy
View 1 Replies View RelatedI have a situation where I might want to pull(select) some information from a DB2 database, and possibly push(insert) some data to the same DB2 database. I am sure this is being done in the real world. WHat software, infrastrucure, etc would I need to accomplish this. Is it as simple as using DTS and the proper drivers, or are their better products and solutions. ANy
input appreciated.
Hi, I have installed SQL 2000 on my system and when I try to start it gives me an error saying 'ordinal 29 cant be found in the dynamic link library odbcbcp.dll.
Please advice!!
i need write a Feasibility report about MS SQL 2000
Easy of use?
Cost?
Development speed?
Features
Hi all,
I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.
Now is there a way to reinstall 2000 and just getting the files that the server is missing?
Is there any guidelines or steps for reinstalling 2000 out there?
Thanking you in advance.
Lystra
I am upgrading our SQL 2000 Server hardware. I am looking for a way to "mirror" this server. The only items that we are changing are updating the hardware and the OS will be Server 2K3 instead of Server 2k
Does anyone have a reliable method, or suggested processes for migrating one server to another?
Knowing that web synchronization is a new feature comes with SQL Server 2005.
View 1 Replies View RelatedHi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine. I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict. The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name). I need to connect to a database on the HARDYSQL5 registration but I am not connecting. I have tried various connection strings but none have worked. I get a Login failure. I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;" I'm gon go nuts. What am I doing wrong? Thanks.
View 10 Replies View RelatedWe want to run Unix Scripts on SunSolaris which Connected to MS SQLServer 2000.We would like to connect to SQL Server 2000 from Solaris. Is there anyway to connect to Sql Server 2000 natively (just like isql we use inwindows which has the client) with the help of third party ct library?or any other drivers or tools???TIA
View 5 Replies View RelatedHi all,
I have an aplication in VB6 that uses an ODBC to link to a SQL database.
Until today all my clientes had SQL Server2000 and my aplication worked fine.
Some of my cliente have now SQL 2005 and my application still woks fine except in one of them.
In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column.
This column is data type BIT and my code is
...
Myrs("Servida")= true
...
Any idea why the error appens? And why only in a particular machine and not all of them with SQL2005?
What can I do? I changed the code for
myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want to change thousands of line of code where I read/write a column in the database data type BIT.
Is there a way to configure SQL Server 2005 the way that it controls data type BIT?
Regards
Luis
Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"
Thanks
Hi, i'm very new to Web Matrix. I've been following the C# end-end application tutorial exactly but i can't seem to run my application.
The code given in the link below is for MS Access but I'm using MS SQL 2000, so i'm not sure of the syntax for the code provided below (string connectionString...)
Please help..thank u!!
http://www.asp.net/webmatrix/guidedtour/section91/bookrequestcontrol.aspx
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:TempProjectsLibraryDatabase.mdb";
public void LoadRequestedBooks(){
try
{
string mySelectQuery = string.Format("SELECT books.* from books, requests where books.bid = requests.bid and requests.mid = {0}", Session["userid"]);
System.Data.OleDb.OleDbConnection myConnection = new System.Data.OleDb.OleDbConnection(connectionString);
System.Data.DataSet myDataSet = new System.Data.DataSet();
System.Data.OleDb.OleDbDataAdapter myOleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(mySelectQuery, myConnection);
myOleDbDataAdapter.Fill(myDataSet);
DataGrid1.DataSource = myDataSet.Tables[0];
DataGrid1.DataBind();
myConnection.Close();
}
catch(Exception exp)
{
Label2.Text = "<br>Error: " + exp.Message + "<br>";
}
}
I installed SQL Server 2000 Develloper version and I am wondering what are the limitation of this version compare to the other versions available? Like how many connections can I have open at the same time? Can I use it for my intranet application? etc...
Thanks
Hi all,
I'm currently trying to connect my ASP page with an SQL server 2000 DB. I already know, how to connect with Access, through the the cobnnection object...
examlpe:
---------------------------
Dim objConn
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.ConnectionString = "DSN=cb_access_db"
'objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:dbCB_database.mdb"
objConn.Open
---------------------------
Now, i have SQL 2000 running on my local syste, and i'v ecreated a DSN..
How would i connec to it???
any input, or exampkles would help.Thanks!
DAve
I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:
ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07
hoainit (3): ; hoainit Exited with retcode = 0.
hoalgon (7): ; hoalgon Entered. name = edw.
DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login
failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL
Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220
nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220
hoalgon (7): ; hoalgon Exited with retcode = 28500.
We have a SQL Server 2000 and want to migrate to SQL Server 2005 Express.
It's possible?
SQL Server 2005 Express have support to do this?
I've recently upgraded a server from sql 7 to sql 2000. The server has two
network cards, so developers can connect through our private network or the public network. Everything works fine now except that we cannot connect through the public network via tcp/ip. i cannot figure out why. in the sql server log, it claims to be listening on both ips. Both ips are using the same port number(1433), is this bad? I did not change any network settings, i just upgraded sql, so i believe it's a sql 2K issue. any ideas?
thanks.
I have an application which is under development in VS 2005 but the database is in SQL Server 2000. We are facing some strange problem with the connectivity between VS 2005 - SQL Server 2000.
I have tried all the possible ways or solutions i found when searching in google but unable to find a solution.This had become a major challenge for us now to identifiy the root cause of the problem
Error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
Please suggest.
Thanks,
Hemant
A user upgrades her machine to Vista
She was able connect a sql server which is 2000 version but unable to connect another server which is also running in 2000 version
Please help to find solution
Given than once SQL Server 2005 is installed, SQL Server Studio has to
be used instead of Enterprise manager, can both SQL 2000 and 2005 be
used on the same machine, be it development or production? (The second
one to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.
We have an OLD vbscript process that is running on a Windows 2000 box. The box has Sql Server 7.0 on it (not sure if relevant). The process used to hit a Sql Server 2000 database, but that database was recently migrated to 2005 (on different server). Now the connection string obviously no longer works, and we can't even add a DSN to 2005 (does not recognize new server). The machine pings the new SQL server without any problem, but cannot connect for data access.
I assume there should be some driver that I can install to fix this, but have yet to find one on the web. Does anyone have a recommended download to remedy this?
Thanks in advance.
hi all. i m looking for help in Java - SQL Server 2000 Connectivity.i worked on Java- Oracle & Java - MS Access format.now i m looking to work on Java - SQL Server 2000. I m using JBuilder 2005. what sort of configuration needed in JBuilder or SQL Server 2000, like adding JAR files and all other stuffs? or what to do? lemme know quickly. thanx in advance.
View 5 Replies View RelatedI have a 500-MB full installation CD for SQL Server 2000. All I needis to install "Client Connectivity" component (about 272K) on a bunchof workstations for users across the nation.How do I reduce the installation file size, by eliminating most of theunwanted files?Thanks.
View 2 Replies View RelatedHi,
We are running one shopping site for our organisation, which includes Tomcat 5.0.28 , IIS & SQL Server 2000 SP3 hosted on platform Microsoft Windows Server 2003 Enterprise Ed. , we are running jsp pages server side and site is hosted on internet,
but it is observed that after every 1/2 days , page will throw following exception, and site get blocked.
javax.servlet.ServletException: Network error IOException: No buffer space available (maximum connections reached?) : connect
Can anybody help please?
I am beginner with JDBC - SQL Server Connectivity ,
I am giving our configuration details:
Driver Used - Microsoft SQL Server Driver 2000 SP3
Protocol Used - TCP/IP which open socket connection on default port 1433
Authentication - Mix Mode Authetication ( using sa account login)
Even setting done within LOCAL instance running on server to allow max. connections i.e 32767
My observation is that some kind of virus threat may causing this error, because if server will be rebooted, we doesn't
get any error and everything works fine.
Waiting for your suggestions and advise.
Thanks a lot.
Regards,
Mandar Velankar
Hello,
I am trying to install the SQL Server 2000 client tools on my XP desktop and after the install I get the erroe message:
Snap-in failed to initialize
when I launch the enterprise console.
I applied service pack 3a but I get the exact same error.
Any one know how I can fix this?
Thanks!
Hello,
I currently use Toad 7.5 for Oracle as GUI admin tool. Are there any good tools for SQL 2000 like Toad that provide an easy to use GUI.
I did check out Toad for MSSQL and it seems limited compared to the Oracle version.
Thanks,
Cbarone@dca.net
I am looking for best blogs/articles on Debugging, performance for SQL server 2000/2005.
Please provide me links
According to MS Knowledge Base Article 269824, "[SQL Server 2000 ClientTools] ... must be installed ... on any computer on which someone may makedesign changes in an Access project to a SQL Server 2000 database".This is the situation I'm facing. Can I download these Client Tools andinstall them for free, or are they only available on the SQL Server 2000Installation CD?Thanks for any help!
View 1 Replies View RelatedIs the Web Download to install SQL Server 2000 DTS tools available yet? If so where?
View 17 Replies View Related