I 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
Does anyone know of any shareware tools out there that can connect tosql server 2000 from Unix(specifically Sun Solaris) and performqueries and return result sets ? Appreciate your help.Steve Chiang
View 1 Replies View RelatedI 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?
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.
Hello, I'm trying to locate the Sql Server MyCompany database. Does anyone one know where I can get a copy for download? Thanks in advance for your help.GreaseLightning
View 2 Replies View RelatedHello,I'm wondering if someone could help me to find the answer for this questionI'm connecting to SQL server database using the server name. When i remove or type the server name in wrong spelling, no errors being catched or even rised!!!!!How can i catch if the server name is incorrect?regards
View 3 Replies View RelatedHi
I am able to connect to an sql server from my server explorer. Can't seem to connect
to an sql server from my code.
this is what i am doing
String strConnection = "server=FRANK;database=Northwind;integrated security=true;";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open
objConnection.Close();
error Login Failure for user FRANK
I know that my server name is FRANK because thats what it says on my Sql Service manager.
And i use that same server name when i connect from my Server Explorer(using Visual Studio.NET) and then i get a listing of the the Databases that are associated with my SQL Server.
I have no problems coonecting to an Access dataBase using OLedbConnection
I did not use Sql server for 2 weeks and now it shows the red small square on the server icon for SQL Server indication it is stopped. I can not now start it, it says access denies or not exist. Can you please help me to connect to it again as i do not want to re-install and los the databases. I have done nothing to it apart from i change my windows password as the system in the company you have to change it every 3 months, Do you think that might affects?
Please help!!!!!
hi, I do have a couple of database and store procedures in 6.5... I want to confirm that I will not run into any problems before I upgrade to 7.0 .
Is the upgrade pain free?
By using the wizard, I will make sure that all upgrade will go right?
any feedback from guys who have already upgraded.. Please give me feeback
Thanks
Ali
After restarting the SQL Sever agents, I can not connect to the server from my desktop via Enterprise manager or analyzer, but everything seems find on the server side. the error message is as follows: "a connection could not be established to [servername]
reason: SQL Server does not exist or access denied ConnectionOpen (Connect())..
I have not attempted to reboot the server yet, I would like to try to resolve the problem withoutout having to do this (last alternative)
setup:
SQL Server 2000 Service pack 3
running on Server 2000.
any help would be appreciated, thank you
Does anybody recomand me good book for sql server administrator and programmer?
View 1 Replies View RelatedWhen i try 2 start the sql mail server
i am unable to do so as it throws the following error
MAPI login failure
wat shld i do now??
I am trying to create a SQL Agent job with 3 steps.
I want to delete three tables.
Step 1 ...delete table "X"
Step 2 ...delete table "X"
Step 3 ...delete table "X"
problem is that afer i create the three steps and start the job it never seems to finish the first steps and non of the other steps run, the job looks like is executing and never finishes. I break the job into three jobs each completes fine. I need this to runs one job, any ideas?
perplexed for sure.....
I don't have any errors to share, but I have a question.
What kind of problems (if any) would I encounter if the computer name where SQL Server 2000 or 2005 was installed included special characters? An example would be FNB_(1).
Hi everyone,I need help in inserting a date time string to sql sever. For example, how do you insert textbox1.text="2006-08-30 09:00:00" into a datatable column names starttime (type datetime) in sql sever? How do I covert the format of this string before I do the insert?Thanks.a123.
View 2 Replies View RelatedHi everyone,How do you insert this string value lable1.text="2006-08-30 09:00:00" into a data column like startdate (type: datetime) in sql sever?How do I convert this string value before I insert it into sql sever? Thank you very much.a123.
View 1 Replies View RelatedI have a problem with the connection to the DB…
I wrote this connection string in the web.config
<add name="dbConnectionString" connectionString="server=(local);database=2C2M;Trusted_connection = True" providerName="System.Data.SqlClient"/>But then when I creat ( SQLdataSource ) and chose this connection , this message is appeared
DataBase schema could not be retrieved for this connection . Please make sure the connection setting are correct and that the database is online. An error has occurred while establishing a connection to the sever . When connection to SQL Server 2005 , this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. ( provider : Named Pipes provider , error : 40 – Could not open connection to SQL Server )
How I can solve this problem ?
Note : I use SQL EXRESS SERVER
hi
I have two questions:
1. I want a code to save data typed in a textbox during runtime using SQL server database. The database has a table with several colums where i have to reference the necessary column.
2. Can i use a Gridview to enter data during runtime and save the same data to the database? that is, INSERTING data to the database.
The error is:
Connection failed:
SQL State '37000'
SQL Sever Error: 18452
[Microsoft][ODBC SQL Sever Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have verified in Enterprise Manager that the concerened login is using a Windows 2000 Authentication and has the correct grant access permissions set up for the default database. Also switching to SQL Server Authentication or disabling security are not the options available in this case.
How to resolve this please-any help is welcome.
thanks
Sanjeev
One of my developers is trying to register a SQLServer server (Win 2000,
SQL 2000) using Enterprise Manager. He receives the message below;
A connection could not be established to sever_name.
Reason: "EXECUTE permission denied on objedt 'sp_MSSQLDMO80_version'.
His login is in an NT group and I added the login the way I've always
done. I even tried adding his login alone. No luck.
He can register other servers, just not this one. He can connect and
run queries on this server using Query Analyzer without issue.
I tried granting explicit execute rights to the sp but the error pops
up again but on a different sp this time.
This is not my server and is under the direct control of another dba
and IT group. I spoke with them and they were clueless about any
security setup/configuration that may have been done.
I'm clueless. If you have a clue please advise.
Thanks in advance.
I am currently investigating tools that are available that would enable us to performance test SQL tables/databases- can anyone recommend any?
Thanks