Equivalent To MySQL's Password() Function? (was MySQL To SQL Server And Password())

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


ADVERTISEMENT

Why I Cant Setup Password In Mysql

Jul 20, 2005

i run mysql in windows server 2000 in LAN and when i want ot seemydatabase with phpmyadmin i recieved a an error that was "Access isdenied for user:root"my password was correct and when i empty the password in phpmyadmin itwork correctwhy?i set password in mysqlbut it doesn't work in phpmyadmin

View 1 Replies View Related

Equivalent Of LIMIT Of MySQL In SQL Server 2005?

Aug 1, 2007

hey all,
i want to know Equivalent of "LIMIT" of MySQL in SQL Server 2005?
in mysql we can direclty get data using LIMIT clause.
my question is how to do this in sql server 2005?
 thanks.

View 6 Replies View Related

Equivalent Of Load Data Infile Of MySQL In SQL Server 2005?

Aug 1, 2007

hey all,
i want to know Equivalent of Load Data Infile of MySQL in SQL Server 2005?
in mysql we can direclty load file with Load Data infile query.
my question is how to do this in sql server 2005?
 thanks.

View 6 Replies View Related

SQL Server 2005 &&>&&> - ? Need Equivalent Command ? - Show Tables&&>&&> (MySql)

Feb 19, 2008

Hi Guys,

well as you can see from my thread SQLServer is new to me i am used to mysql and i c'ant find the equivalent anywhere on the net... Seams easy enough but i have been at it for 6 hrs and i give up... I am just making a quick database view tool. So please tell me.

How do i load the all tables of a database via an sql command?

Since it took me a while to find this i thought migth as well slap ip somewhere so here is the command to load all data bases... In any case worked for me so...

- > select * from master.dbo.sysdatabases;

And where in the ... can you find a reference to all sql server commands? ... Please.

Thanks for your help

View 4 Replies View Related

Linked Server To MYSQL Using OLEDB Provider For MYSQL Cherry

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

Mysql Limit Equivalent

Oct 25, 2005

Hi,

View 9 Replies View Related

MySQL LIMIT Equivalent In MS SQL 2000

Oct 11, 2007

I am looking for the MS SQL equivalent of MySQL LIMIT.

I know that the code in MySQL is

SELECT col_name FROM tbl_name LIMIT x,y

where x = the starting row and y = the offset

E.g. SELECT movie_name FROM my_movies LIMIT 10,5

This will give me the records from 11-15

I would like to know what is the MS SQL equivalent for the above?

View 4 Replies View Related

Transact-SQL Equivalent Of MySQL LIMIT

Sep 12, 2006

In mySQL for example i could have:

ORDER BY ID DESC LIMIT 5,25

where it would start from 5'th row found and return up to 25 rows.

How do i achieve the same in Transact-SQL? The LIMIT 5, 25 part.

View 10 Replies View Related

Mssql Equivalent Of Mysql Merge Storage Engine

May 13, 2008

Hi,

Mysql database provides a storage engine called "MERGE".A "MERGE" table is a collection of identical tables that can be used as one.(Identical meaning same column name,column width, column order etc.) .

The advantage is you can split a really huge table like LOG tables, STATS tables into seperate smaller tables but would still be able to make queries on them like a single table. More details, can be got from here:

http://dev.mysql.com/doc/refman/4.1/en/merge-storage-engine.html

My question is that do we have an equivalent of MYSQL "MERGE" in MSSQL ????

Thanks,
:)

View 2 Replies View Related

SQL Server Agent Job Will Not Retain Package Password (encrypt Sensitive With Password)

Apr 1, 2008

I have a package protected by a password - I am already unhappy that to get it to use the configuration file to change connection strings for the production servers I have had to hardcode the password into the config file - very insecure!
However, the package now deploys correctly to the production server and will run from there OK, but NOT if scheduled as a SQL Server Agent Job. Thus is because however often I edit the command line to include the password after the DECRYPT switch (which it has prompted me for when I click on the command line tab), the Job Step will not retain it.
If I open it up after I have edited it and closed it, the password has disappeared.

I know that if I run dtexec plus the code in the Command Line tab (with the password), the package runs OK.

This is driving me insane!
I have read all the other posts and so I tried replacing the SSIS package step with a CmdExec step and pasting that code into there - then I get an OLEDB error..

The code I use is:
DTEXEC /SQL "ImportRateMonitoringTables" /SERVER servername /DECRYPT password /CONFIGFILE "D:Microsoft SQL ServerSSISDeploymentsRateMonitoringImportTasksDeploymentImportRateMonitoringTables_Production.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

and I get

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF

although the same code executes perfectly from a command prompt.

Please does anyone have any experience with a similar problem and if so, how did you get round it?

Thank you

View 9 Replies View Related

The Sa Password Must Meet SQL Server Password Policy Requirements.

Jun 30, 2007

I tried to install an ALLDATA database which run with SQL Server 2005 express edition. The data base fails to install becase of the following code that come up which is related to AS password requirement. The error that come up is:



TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------


I am trying to install this database in a network server operating under Windows Server 2003 R2 with SP2. If anyone knows how to solve this problem, please let me.



Thanks,



Amilcar

View 6 Replies View Related

Data Access :: How To Recover Forgotten Password When Remember Password Option Checked

Jul 24, 2015

I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.

View 3 Replies View Related

SQL 2005 SP2 - Windows 2003 Ent SP1 - Password Does Not Meet The Password Policy DLL

Jun 18, 2007

I am receiving the following error message when attempting to create a new SQL Authenticated login id.



Password validation failed. The password does not meet the requirements of the password filter DLL. (Microsoft SQL Server, Error: 15119)



I have four servers all running SQL Server 2005 SP2 on Windows 2003 Ent. SP1. Of the four servers, only one received the above error message using the same TSQL below.



CREATE LOGIN TEST_LOGIN WITH PASSWORD = 'pvif9dal' MUST_CHANGE, CHECK_EXPIRATION = ON



All four servers are in the same domain, which if I understand correctly, the password policies are therefore inherited at the OS level by the domain. The password being used is within the password policies of the domain.



Any ideas as to a root cause?

View 5 Replies View Related

Function To Test Password Complexity

Feb 11, 2008

My aim is to write a function that returns a bit determining if a varchar(30) argument is "complex enough" to serve as a password. I am open to suggestions of better heuristics, but the rules I was initially planning to use were:

1) Greater than 8 characters long.

2) Contains at least one upper case, lower case, number, and punctuation (loosely defined as anything not in the first three categories).

I can loop over the characters in the PW and use CHARINDEX to test against these three subsets, but I thought there just might be a more clever way to accomplish this.

I also mention the "meta" problem since I am all ears if anyone has a better idea of how to measure complexity.

Cheers,

Lyman Hurd

PS Only a hash gets stored in the DB. This is to be used in the stored proecdure where people set their passwords. Thanks in advance for any thoughts.

View 13 Replies View Related

Remember My Password Is Forgetting Password

Mar 11, 2008

On the login prompt for Report Server, there is a checkbox option to "Remember my Password." I check this, login successfully... but when returning to the Report Server, I am again prompted for the password, although the user name is saved. No matter how many times I do this, the password will not save in IE7. I have tried this on 3 different computers with IE7. In IE 6, I do not even get the checkbox as an option, just the user name/password prompt. In Firefox, the password saves fine. Any ideas what would be causing this?

Thanks,

Brian

View 1 Replies View Related

Export Username / Password To CSV File To Test SP To Output Username / Password

Jun 2, 2014

I put this together to export the user name /password to a csv file to test my SP to output the user name/password.

DECLARE @user_name varchar(50)
DECLARE @psswrd varchar(10)
SELECT @user_name ,@psswrd
FROM ngweb_bulk_enrollments
EXEC master.dbo.xp_cmdshell 'bcp NGDevl.dbo.ngweb_bulk_enrollments out C: est.csv -Sserver1 -T -t, -r
-c'

This works but I don't get the headers in the file. How can I include the headers?

View 7 Replies View Related

MySQL To Sql Server 05

Oct 5, 2006

im trying to convert this table for a friend 1 CREATE TABLE adminmessage (
2 adminmessageid INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 varname varchar(250) NOT NULL DEFAULT '',
4 dismissable SMALLINT UNSIGNED NOT NULL DEFAULT '0',
5 script varchar(50) NOT NULL DEFAULT '',
6 action varchar(20) NOT NULL DEFAULT '',
7 execurl mediumtext NOT NULL,
8 method enum('get','post') NOT NULL DEFAULT 'post',
9 dateline INT UNSIGNED NOT NULL DEFAULT '0',
10 status enum('undone','done','dismissed') NOT NULL default 'undone',
11 statususerid INT UNSIGNED NOT NULL DEFAULT '0',
12 PRIMARY KEY (adminmessageid),
13 KEY script_action (script, action),
14 KEY varname (varname)
15 )
  and was wondering how to do it when mssql doesn't have enums :(

View 1 Replies View Related

SQL Server To MySQL

Jul 5, 2004

I just started developing my site locally using SQL Server and am planning to move it to our work's MySQL server. Is there anything that I should be aware of before I continue any furthur? Will I lose any data or is it even an option to move from SQL Server to My SQL???

View 1 Replies View Related

Mysql To SQL Server 7.00

Nov 16, 2000

Hi Guys,

I am working for a client who needs to move database from MySQL application to MS SQL SERVER 7.0.
Is there anybody who has done it before?
I need some help about how to load data from one system to another system.

THanks in advance.

View 1 Replies View Related

New To SQL Server, Old To MySql

Sep 2, 2005

Hi there, I'm hoping someone out there can help me.

At my old job, I developed web applications that were based off of a MySQL server. I used PHPMyAdmin and learned the PHP coding, and although not formally trained in DBA or anything, I became very comfortable with using it and building database applications. I did everything through SQL/PHP script coding or through PHPMyAdmin.

At my new job, I decided to build a database, but only had access to MS Access, which I can use, but don’t necessarily like. One day, in earshot of one of our admins, I grumbled “if I only had access to a SQL server, I’d turn this thing into a very cool web application.� Well, he heard, and gave me access to the SQL server and the web server. Thing is, it’s not MySQL, but MS SQL Server. And I feel like I am at a total loss. I was able to build a basic database in the Enterprise Manager on the SQL server, and create a web site on the web server, but I don’t even know how to begin to connect the two – what is the equivalent of MySQLConnect? I know I would have to learn the VBScript and everything for the advanced stuff, but for right now, I just want to make a simple web page that will do a simple select query from a database and return the rows, and simple forms to input into the database. How do I begin? What do I need to know to begin? I have a feeling the applications already on the server were contracted out, so I don’t actually know if anyone here could help me.

Thanks for your help.

View 3 Replies View Related

SQL Server 2K5 To MySQL 5

Feb 28, 2008

I need to pull data out of SQL Server 2005 and load it into a MySql 5 database, and can't find a way to do this efficiently in SSIS since there's no ODBC destination, and I couldn't find an Oledb driver for MySQL. Any thoughts on the best way to accomplish this, aside from exporting to text, and then loading it into MySql via the mysql client or mysql importer?

-A

View 8 Replies View Related

MySQL Vs SQL Server?

Jul 23, 2005

Hey there,I'm curious about MySQL. Could anyone quickly summarize thedifferences between MySQL and SQL Server and outline why someone mightpick SQL Server over MySQL?(Please post replies here, email address is fake)Cheers,Geoff GlaveVancouver, Canada

View 2 Replies View Related

GoDaddy / MySQL / SQL Server

Dec 29, 2006

I don't know if this is unique to GoDaddy: I found the program for working with a MySQL database very intuitive (to the point of compliments).  Today I started work with ASP.NET and SQL, and when I went to work with SQL Server (on GoDaddy), it wasn't intuitive, and there was almost nothing on which to click.  By chance might there be a tutorial that would help a person who needs to work with SQL Server on a provider like GoDaddy?

View 4 Replies View Related

Migrate From MySQL To SQL Server

Mar 6, 2008

Hello all,
I have an application in which the database is currently in MySQL.  The app is being re-written(in .net 3.5) and I would like to move the data to SQL Server 2005.  What is the best may to get the data from MySQL to SQL Server.  Any good tools out there?  Idealy, I would be able to manipulate the data during the move, as I have plans for some schema changes, but I suppose I could always make them after migrating. 
Please suggest any tools or methods, with your thoughts.  I will evaluate any suggested tools.  Also, SSIS is available for me, is that the best way?

View 3 Replies View Related

SQl Server 2000 Vs. MySQL 5 .0

Apr 7, 2006

hi !
i am using SQL Server 2000...someone told me the new version of Mysql 5.0 is very powerfull and it is better than MS products?!!! any good resources about the benefit of using SQL server 2000 rather than open source?!!
Thanks!

View 10 Replies View Related

Linked Server To MySQL

Mar 7, 2001

I have created a linked server to a MySQL database using a DSN. Does anyone know how to run a select statement against a table in the MySQL database? The usual 4 part naming convention does not work.

I can run SELECT *
FROM OPENQUERY(Top50, 'SELECT * FROM orders') which does return records successfully. (Top50 being the name of the linked server)

My objective is to be able to insert records into the MySQL database and I am not sure how do to that using OPENQUERY. Any thoughts on that would be appreciated as well.

Thanks in advance.

View 2 Replies View Related

MySql Linked Server

Jul 14, 2002

Anyone know how to go about getting data from MySql to MS SQL server? Im a little confussed as to what ODBC driver is needed and all that. Is it possible to this all through enterprise manager? Thanks a lot.

View 1 Replies View Related

Limit In Mysql = Top In Sql Server ?

Jul 20, 2004

I have used this mysql code in my programm before:

select * from address order by vorname asc limit 0, 10

It works fine. But now I want to use sql server, and it doesn't recognize the term limit.
So I have found out that I can use top instead.
I have changed my code into this:

select top 0 * from (select top 10* from address order by vorname) order by vorname asc

But it gives me an error message:

wrong syntax near the word Order.

Can anyone give me a solution?
Thank you.

View 5 Replies View Related

Migrating From SQL Server To MySQL

Aug 4, 2004

Hello, anyone knows a good way to export a data base from MSSQL Server 2000 to MySQL? Any suggestion is accepted. Thanks

View 3 Replies View Related

Linking From SQL Server To MySQL

Dec 13, 2004

Hi all, hoping someone can help.
I have created an ODBC connection to a remote MySQL database.
I can then go into DTS wizard and specify this ODBC connection, it all goes through fine and I can see the tables on the remote server and import data.
The problem arises when I try and create a linked server using the same ODBC connection. I get the following error, when I try to view the tables.
I am so stuck. Any help would be very much appreciated.

View 3 Replies View Related

Linked Server To MySQL

Jan 18, 2005

We are trying to do a linked server to MySQL from MS SQL2k. We downloaded MyODBC drivers, setup the system dsn successfully but then SQL errors out using both the GUI and the stored proc to add the linked server to mysql. Does anyone have a good site to reference or any words of advice. An hr or so of google didn't really give up any helpfully information.

Thanks,
DMW

View 3 Replies View Related

Migrating MySQL To SQL Server

Nov 5, 2005

What is the difference between the SQL used in MySQL and on the MS SQL 2000 server?

Can anyone recommend a good reference on translating a mySQL dump to a format that could be easily uploaded to a MS SQL server?

Thanks!!!!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved