Probelm In Installing Mysql On Win Xp M/c
Jul 20, 2005
hello ![color=blue]
>
>
> I am trying to intstall Mysql binary version with installor in Windows
> XP machine . But it is not working . i have installed in the default
> path ,in windows service componenet its showing server is running,since
> it is mysqld-nt so name-piped servr is also running.
>
> But still client is able to connect to server.
>
> when i am tring to instal manually it is showing
>
> " service already exists;
> the currect server intstalled is c:mysqlinmysqld-nt.exe
>
> when trying to connect to server
> C:> c:mysqlinmysql test
> ERROR 2003 : cannot connect to MYSQL server on localhost <10061>
>
> C:> telnet localhost 3306
> connecting to localhost.......
> could not open connection to host,on port 3306No connection shb ne made
> because the target machine actibvely refused it.
>
> plz help me in installing ,pls clarify the problem.
> pls reply soon.
>
>
> regards
> Smita[/color]
View 1 Replies
ADVERTISEMENT
Aug 8, 2007
The server in question already has Ms-SQL installed and used. My web-app has been developed for MySQL.
What, if any, conflicts would I encounter by installing MySQL on the server as well?
Would I be better of changing the the web-app to work with MS-SQL?
View 1 Replies
View Related
Feb 15, 2006
I am trying to get mysql 4, php5, and apache to work on my winxp sp2 comp,unfortunately even though php5 and apache seems to work ok I am unable toutilise mysql with php and apache, I have yet to see a guide that has aproblem free installation, if there is such a guide or a fix on how to getphp5, apache and mysql all working on winxp sp2, after having movedlibmysql.dll to the c:php directory as well as the c:windowssystemdirectory,. and amended php.ini to show the path to c:phpext (althoughthis version of php didn't automatically create an ext directory) and havingamended pathn the system environments to point to c:php, as well asnumerous other recommendations, I am stuck as to how to proceed. Any helpwill be greatly appreciated.
View 1 Replies
View Related
May 19, 2007
After downloading Express my SQL erver Express I can't seem to launch it.
From the Start Menu I have Programs -> Microsoft Server 2005 -> Configuration Tools then a choice of 3 programs (none of these seem to be the actual program for creating databases etc)
.
There were no problems / errors during the installation.
Any ideas what might have went wrong?
jpn
View 1 Replies
View Related
Feb 12, 2007
Good Morning
Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.
I can not get it to work.
I've created a UDL which tests fine. it looks like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;
Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";
Initial Catalog=riverford_rhdx_20060822
Can any on help me convert this to corrrect syntax for sql stored procedure
sp_addlinkedserver
I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.
I used SQL server management studio to create the linked server then just scripted this out below.
I seem to be missing the user ID, but don't know where to put it in.
EXEC master.dbo.sp_addlinkedserver @server = N'DATABRIDGE_OLEDB', @srvproduct=N'mysql', @provider=N'OleMySql.MySqlSource', @datasrc=N'databridge', @catalog=N'riverford_rhdx_20060822'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'use remote collation', @optvalue=N'false'
Many Thanks
David Hills
View 7 Replies
View Related
Apr 11, 2005
strsql = " select * from dic where english='" & SearchBox.Text Or TextBox4.Text & "'"The machine said Input string was not in a correct format. How can i select database with or operator in asp.net .Is it possible to select database in sql from more textbox ?
View 1 Replies
View Related
Jun 7, 2005
hi,I wrote this sp :CREATE PROCEDURE ins_AddOrder( @CartId NVARCHAR(50), @CustomerId INT, @OrderDate DATETIME, @OrderId INT OUTPUT)AS
DECLARE @ins_error INT, @sel_error INT, @var_rowcount INT
BEGIN TRAN AddOrder
INSERT INTO tbl_orders( customerId, orderDate)VALUES( @CustomerId, @OrderDate)
-- SET THE @@ERROR VALUE TO @ins_errorSELECT @ins_error =@@ERROR
/*IF INS_ERROR != 0BEGIN ROLLBACK TRAN RETURNEND*/
SELECT @OrderId = @@identity
INSERT INTO tbl_orderDetails( orderId, productId, quantity, productPrice)SELECT @OrderId, tbl_product.productId, quantity, tbl_product.productPriceFROM tbl_shoppingCartINNER JOIN tbl_product ON tbl_shoppingCart.productId = tbl_product.productIdWHERE cartId = @CartId
-- SET THE @@ERROR VALUE TO @sel_errorSELECT @sel_error = @@ERROR
-- SET THE @@ROWCOUNT TO @var_rowcountSELECT @var_rowcount = @@ROWCOUNT
IF @sel_error <> 0 OR @var_rowcount = 0 BEGIN ROLLBACK TRAN AddOrder RETURN ENDELSE BEGIN EXEC del_EmptyShoppingCart @CartId COMMIT TRAN AddOrder ENDGOIn the last few lines i try to prevent adding new row to tbl_orders (first statement), while the SELECT (second statement) does not return any row .It still not work.Can anyone help please?thanks.
View 1 Replies
View Related
Dec 1, 2005
I Have create a trigrer for my table transhd to update something in my detail table..
when i updated one record the trigger works fine..
but when i run command to update a batch of record in header
using command [update XXXX where cont] the trigger only fire for the last record in the batch..
is this the ms sql default behavior.. anyway to the around it
thanks in advance
View 1 Replies
View Related
Dec 1, 2005
I Have create a trigrer for my table transhd to update something in my detail table..
when i updated one record the trigger works fine..
but when i run command to update a batch of record in header
using command [update XXXX where cont] the trigger only fire for the last record in the batch..
is this the ms sql default behavior.. anyway to the around it
thanks in advance
View 1 Replies
View Related
Mar 19, 2004
I have a login in my sql server with windows authentication.When i tried to connet to the sql server with that login its not allowing me to connect even though I was logged on into my system.What should be the reason and what should i do?
View 2 Replies
View Related
Apr 19, 2005
I have met a problem in the ASP.NET project creation with SQL Server Database Connection.
"Can't Login to My ServerName/ASPNET
How to solve the problem?
View 1 Replies
View Related
May 31, 2006
Hi , I just put my files up on a web server. I can view my aspx pages..but when I try to login to the website I get the following;
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Can you help? I can understand that it cannot find the specified instance of sql server, however I don't remember ever configuring it look to at a specific sql server. When i created the site in web dev express edition and added the login controls and set the asp config tool to use internet security it created the database itself and so I didn't have to put a connection string in. I also cannot see a connection string in tthe web.config file.
The aspnetdb.mdf file is there on the server. is this something i need to configure with the hosting company or do i set it in my webconfig file.
Thanks
View 4 Replies
View Related
Jun 15, 2007
I need to create some tables dynamically using sp_executesql. But the problem is the length of sql string is more the 4000 characters. How can I solve this problem?
Thanks
View 3 Replies
View Related
May 18, 2007
We have a config table which has columns like pollingfolder, cop to folder etc.
Data looks like this
Config id polling folder
1 d:dataloadacn
2 d:dataloadship
under ACN and Ship folders we can have more than 1 source files which had to be loaded into target
the load process has to be repeated for each file in all the folders like ACN and ship
I have used for each loop container to poll the folder.
Can we set the directory to be polled at runtime taking from config table.
For doing this I have used the property Directory in expression editor of for each loop. But it is not working.
If I hard code the variable value in variables section , then its working.
How to change the directory to be polled value at runtime?
View 1 Replies
View Related
May 15, 2008
I had installed SQL server 2005 4 bit version. I created on SSIS package through export wizard.
the SSIS packages will transfer data from database to Excel file. But it is giving the below error.
Message
Executed as user: XXXXXSYSTEM. ... Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 07:00:00 Error: 2008-05-14 07:00:00.51 Code: 0xC0202009 Source: Interface Connection manager "DestinationConnectionExcel" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2008-05-14 07:00:00.51 Code: 0xC00291EC Source: Preparation SQL Task Execute SQL Task Description: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 07:00:00 Finished: 07:00:00 Elapsed: 0.344 seconds. The package execution failed. The step failed.
please any one guide me to reolve this issue.
View 4 Replies
View Related
Sep 20, 2007
I have two data sets but from the same data source. I created two different tables from these two data sets. Now I want to include a chart too. But When I insert the chart, it gives a erorr message.
The dinfinition of the report/my report name is invalid.
More than one data set, data region or grouping in the report has the name'chart1_seriesgroup1'. data set, data region and grouping names must be unique within a report.
Does any body know why this happen?
Thanks
View 3 Replies
View Related
Dec 16, 2005
Someone, please help me understand:
I have the following code:
Dim conString As String = ConfigurationManager.ConnectionStrings("WebAllianceConnectionString").ConnectionStringDim dsrc As New SqlDataSource()dsrc.ConnectionString = conStringdsrc.SelectCommandType = SqlDataSourceCommandType.StoredProceduredsrc.CancelSelectOnNullParameter = Falsedsrc.SelectCommand = "sp_GetCustomerInvoiceList"dsrc.SelectParameters.Clear()dsrc.SelectParameters.Add("@QueryType", "DATE")dsrc.SelectParameters.Add("@CustCode", "BAM7")dsrc.SelectParameters.Add("@OrdNumber", " ")dsrc.SelectParameters.Add("@InvStartDate", "1/1/2005")dsrc.SelectParameters.Add("@InvStopDate", "1/31/2005")dsrc.SelectParameters.Add("@PONumber", " ")Return dsrc.Select(DataSourceSelectArguments.Empty)
When this runs, it throws an exception:Prodecure or Function 'sp_GetCustomerInvoiceList' expects parameter '@QueryType', which was not supplied.
I'm confused... I clearly added that using the .Add method?What am I doing wrong?
View 5 Replies
View Related
Jul 3, 2001
has anyone had a problem restoring a SQL 2000 without sp1 to a SQL 2000 sp1 box or vice versa? I have had 2 failures telling me to call MS support in the message?
View 1 Replies
View Related
Feb 17, 2004
Hi
Can i be able to use the DLL which is created in VB for Extended Stored Procedures.
if so how?
View 1 Replies
View Related
May 30, 2007
hi everyone,
How do i declare a global variable in my package which takes a numeric value like User::VAR1 = 200402 and later on work on it
Later in the properties of the Dataflow i want to have this expression..
"select * from " + "TAB1" + " where Date=" + @[User::VAR1]
Here i want to subtract 190000 from @[User::VAR1] to get it in to myformat i.e the DATE format in the table
I can only see String datatype and othe datatypes wont allow me to to do any kind of manipulation in the expression:
and to be more specific what are
Int16
Int32
Int64
Double
I tried to use all of the above but the expression doesnt allow me as once i use any of the above it says :
TITLE: Microsoft Visual Studio
------------------------------
Nonfatal errors occurred while saving the package:
Error at Extract: The data types "DT_WSTR" and "DT_I8" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.
Any help would be appreciated..
thanks,
ravi
View 8 Replies
View Related
May 21, 2007
Hi,
I have the same problem like Ben. Trying to connect to database engine but failed all the time. I use a SQL 2005 Enterprise Eval version. When I connect to database engine, I put <my computer name>SQLEXPRESS, it gives me this message:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
I checked the sqlbrowser and it's running. I also enabled port 1434 in Firewall. But it still doesn't work. However, when I connect to analysis service using just <my computer name>, it lets me connected. I tried many ways to fix this problem but still no luck. Could anyone help me solve this problem please? Thanks so much.
Carl
View 6 Replies
View Related
Mar 3, 2005
I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
View 7 Replies
View Related
Oct 19, 2006
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Andy
View 1 Replies
View Related
Aug 31, 2007
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
-Arjan
View 1 Replies
View Related
May 14, 2007
Hello,I'd noticed when looking at the prices of hosting ASP websites that it was much cheaper if you useda mysql database instead of mssql so this is the way that I coded everything. I've been using the logincontrol too though so does this mean... 1) that I *need* a mssql database?2) that this database will take up my 1 allocated mssql database with the webhost?3) can I use mysql in the same website; it seems to be working ok with the developer server... Many thanks folks,Adam
View 5 Replies
View Related
Nov 29, 2001
Has anyone ever connected to a MySQL DB? If so, did you encounter difficulties? Did you do it through DTS? Can you give me some specifics?
DenverDBA
View 1 Replies
View Related
Apr 27, 2004
puuuuuuuuuuuuuuuleeeeeeeeeeze
Sorry....
View 6 Replies
View Related
Feb 19, 2007
Can anybody see what is wrong with this?
create table transaction
(txn_id int not null IDENTITY(1,1),
txn_date datetime not null,
account_id int not null,
/*txn_type_cd enum('DBT','CDT')*/check(txn_type_cd('DBT','CDT')),
amount double(10,2) not null,
teller_emp_id smallint ,
execution_branch_id smallint ,
funds_avail_date datetime,
constraint fk_t_account_id foreign key (account_id)
references account (account_id),
constraint fk_teller_emp_id foreign key (teller_emp_id)
references employee (emp_id),
constraint fk_exec_branch_id foreign key (execution_branch_id)
references branch (branch_id),
constraint pk_transaction primary key (txn_id)
I'm getting an error when I try and run in, but I can't see what it is!
Incorrect syntax near the keyword 'transaction'.
The code has been generated as mysql, and I am attempting to change it to SQL.
Thank you!
View 3 Replies
View Related
Jan 9, 2006
HiHow is SQL Server 2000 better than MySQL? I need to convince my boss as weare contemplating doing a website with either SQL Server 2000 or MySQL asbackend.ThanksRegards
View 4 Replies
View Related
Jul 20, 2005
Hi all, i've just set up an mysql server on my computer and now i want toconnect to a mysql database with an ASP page but i can't find the correctconnection string. I always get an error that the datasource can not befound.ConnString ="Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID= userID;PASSWORD=pasword"What's wrong with it?
View 1 Replies
View Related
Jul 20, 2005
hellosomeone could tell me how could I insert SQL statement in a C++ code ?If you know online documents easy to read about this subject, it will bevery welcome(in english or in french)..Thanks
View 1 Replies
View Related
Jul 20, 2005
hola! alguno sabe como uso el top en el mysql??? debo hacer lasiguiente consulta y no le gusta al mysqlSELECT TOP 10 * From ControlDeCaja WHERE CodUsuario = "xxx"alguien sabe? Gracias de todas maneras!!
View 1 Replies
View Related
Jan 31, 2006
Is SQL Server Express the same as MySQL?
View 1 Replies
View Related
