Sybase, ODBC And Passwords

Mar 20, 2006

I've written an ODBC destination script that connects me with my version 11.5.1.2 Sybase database.

I've read the posts in this forum around Connection Strings and ODBC. It appears that certain drivers (or Integration Services?) have a propensity to drop the password part of the connection string off, which makes connecting rather difficult.

One can get around this by hard coding the password and adding it to the connection string that the connection manager retains.

This is rather unsatisfactory in terms of security and aesthetics.

Perhaps we can squirrel the password away in some dark corner where the system can retrieve it and a support team can change it.

Ideally, I'd prefer to use Integration Security, but as far as I know ODBC doesn't support this.

Any ideas?

Regards

Guy

View 1 Replies

Sybase ASE ODBC Driver

Feb 8, 2005

Hello,

I would be grateful if you could show me where I can download SYbase ASE ODBC Driver. I have searched almost the whole WEB for it but so far to no avail.

Thanks in advance.

Albert

View 2 Replies View Related

How To Use 32-bit ODBC Driver (sybase) At An ETL Application Running (deployed Into SQL Server) On A 64-bit Machine ?

Oct 9, 2006

I am developing an ETL system on a 32-bit machine let's say, called 'dwdev'. The application connects to a Sybase database as a source system using ODBC connection. I am able to run this application directly from Visual studio 2005 and i am able to deploy it into SQL Server 2005 and run it from Server as a job. Both work. At this server i am connecting to a SQL Server instance called 'dwdev'.

When i transfer my application onto a 64-bit machine, let's say called 'dwtest', i am able to run my application from Visual Studio 2005 properly and it works, but when i deploy it into SQL Server (instance is called 'dwtest') and try to run it as a job just like the development machine, it gives an error and stops executing.

I was facing 'data source' type of error when i was first trying it from Visual Studio, but i solved this problem by setting Run64bitRunTime settings to FALSE on the Project's properties Debugging Page, at 64-bit machine. now it uses 32-bit runtime then 32-bit Sybase ODBC driver. But i cannot force the application to use 32 bit runtime when i am executing it from SQL Server as a job.

How can i do that? is there an alternative method?

Thanks for your help...

View 1 Replies View Related

SQL 2005 Passwords, Can It Be Configured To Accept Case-insensitive Passwords???

Jul 7, 2006

Users were able tolog on to our SQL 2000 servers with their passwords being case-insensitive.

Now with SQL 2005 some users can't logon because SQL 2005 passwords are case-sensitive.

Can SQL 2005 be configured so that passwords are NOT case sensitive???

Thanks!

View 6 Replies View Related

Sybase 15.xxx Version (linking Sybase To Sqlserver 2005)

May 18, 2008

hi,

i tried the document below pertaining to linking sybase 12.5 to sqlserver 2000 and sqlserver 2005

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=311875&SiteID=17
http://www.sybase.com/content/1029118/1029118.doc

but when our company upgrade the sybase to 15.x i can't find the oledb configuration stated on the document.

so i can't linked the sybase 15.x now to sqlserver 2005. can somebody help me.!!!please...

where i can find the oledb configuration in sybase 15.xx..

tnx..

View 1 Replies View Related

Integration Services :: Unable To See 64bit ODBC Driver From SSIS Odbc Connection?

Jun 1, 2015

I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.

When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.

I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0

why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?

View 9 Replies View Related

How Can I Use Create Or Alter Statements With ODBC And Microsoft Access ODBC Driver (*mdb)?

May 13, 2007

Hi,

I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".

When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.

How can I use DDL statements via ODBC?

I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.

Thanks for help!

Regards,

Stefan D.

View 14 Replies View Related

Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)

Feb 13, 2007

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?

View 4 Replies View Related

Passwords

Feb 5, 1999

Is there a way I can enable my end users to change
their own passwords within SQL 6.5 every 30 days to
something unique?

Currently, I don't see that they have the option to change
it anywhere.
Any thoughts?
Thanks!
Toni

View 1 Replies View Related

Passwords In SQL 6.5

Mar 24, 1999

I have to create some type of an sp that will force users to change
their passwords every 30 days. It sounds like I should be able to
create a simple table with the login and the password expiration date.
Then, I should create some type of function to check the expiration, get
the new password and run sp_password. Has anyone done this before?
Where would this table be created? In Master? Would that also be where
I should create this sp? Should this be an xp?

I'm fairly light on creating sp's. Can anyone suggest a starting point
for me or give any suggestions?
I would appreciate any help.
Thanks!
Toni E.

View 3 Replies View Related

Sql/nt Passwords

May 28, 1999

Does some one know of a way to use windows passwords in sql w/o having to enter them in? Like a program or sql statement?
As of now, we are having to enter them in ourselves , and would like to make our jobs easier....Thanks!!

View 2 Replies View Related

Need Help With Passwords

Feb 6, 2005

hey guyz
in the database, is there anyway to chnage the password field to * instead of showing what is inside?

View 5 Replies View Related

Passwords

Sep 30, 2007

Hi

I have SQL Server 2000 and in one of the databases we store the Application passwords as a Clear text. we would like to encrypt
these passwords so that we will pass the auditing.

Can some one please suggest a good way to encrypt these passwords.

Thanks

View 12 Replies View Related

[HELP]passwords

Jan 7, 2007

for example i will set the password as chicken

http://img515.imageshack.us/my.php?image=chickenqs6.gif

then i press ok and it seems like it works i open it right away and

http://img295.imageshack.us/my.php?image=notchickenao0.gif

^^clearly not chicken......

then,ontop of that when i open the login name is a query script its some 15 character password that everytime u open in script the code changes..

http://img401.imageshack.us/my.php?image=screenhunter04jan062317zu0.gif

any help would be greatly appreciated

View 3 Replies View Related

PGP Files And Passwords

May 2, 2001

I have a pgp file requiring a password that is emailed to me. Is it possible to set up a DTS package that will open the file (using the password), and insert the data into a table, file, etc.
TB

View 1 Replies View Related

User Passwords

Oct 8, 2001

Hello,

Is there a way to pull user id's and passwords from a database?

TIA,
Anita

View 3 Replies View Related

Changing Passwords

Dec 5, 2000

I have a problem where our developers would like to change the passwords of the SQL Logins without knowing the users old password.

The only way they can use the below syntax is that they must be a member of the SYSAdmin Server Role.

sp_password NULL, 'newpassword',Max

I need a way to allow them to change the passwords without making a user a member of the SYSAdmin Server Role.

Any thoughts would be greatly apprecitated. Thanks in advance.

Max

View 1 Replies View Related

Sqlserver Passwords

Dec 1, 2004

Hello all,

Is there anyway to tell in sqlserver when a users' password has been changed?

View 3 Replies View Related

User Passwords

Apr 27, 2004

Is there a way that I can prevent SQL Authenticated users from changing their passwords?

View 6 Replies View Related

Passwords For The Logins

Jun 1, 2004

Hi All,
Sql server 7

There are set of logins in sql server some are NT authentication and some are sql server authentication. How can i retrieve the passwords for both these logins.

TIA
Adil

View 1 Replies View Related

Users And Passwords

Apr 11, 2008

How can we change the passwords of users in 2005 and in 2000

View 2 Replies View Related

Passwords And Usernames

Mar 15, 2006

i have been reading many asp.net books

where is a good place to hold user name and password while the user is on your side in a cookie or applicaion user variable?

and if the user closes the navigator..what command removes the log in information ?

View 1 Replies View Related

Encrypting Passwords

Feb 22, 2006

A friend of my self asked me how he can save a password not as clear text. He wanted to encrypt the password and save the encrypted string in the database.

How can he do this? Maybe somebody can help me here.

Regards Markus

View 7 Replies View Related

Asking For Userid And Passwords On 28

Feb 28, 2008

I have installed Sql Server 2000 Reporting Services.
I desinged report in VS 2003.When press F5 key.Every time it is asking for user id password then only it is giving List of Report Names.

Is there any way to avoid giving user id and pwd every time.
Regards.

View 1 Replies View Related

Update Passwords Every 10days

Apr 22, 2004

I'm looking for a way to upgrade the passwords of all users in a database every 10 days.

What I have is, generating random passwords, md5 encryption etc... but still clueless about how I should update em every 10 days.

Thanks in advance

View 3 Replies View Related

Store Encrypted Passwords In SQL

Jan 14, 2005

Hello,

I have a simple .NET page that asks the user to create a new account. One of the fields on that page is 'Password'. I store the password in a SQL 2000 Database. However, it appears in the database as clear-text.

Is there a way to encrypt this so it doesn't appear as clear-text in the DB?

Thanks!
Jason

View 1 Replies View Related

Transfer Passwords Between Boxes

Nov 10, 2001

Wondering on how to script over the passwords from one 2000 box to another. We are cutting a box over from dev to production and need to copy userids and passwords from another box.

Any suggestions?

Thanks,

Steve

View 1 Replies View Related

Moving Logins And Passwords

Feb 5, 2002

Hi,
WE are moving one of our applications to oracle from sql server.For this migration is there any way I can move passwords from sql server syslogins table to oracle or extract the passwords.
thanks in advance
Mohan

View 1 Replies View Related

Encrypt Stored Passwords

Sep 18, 2001

I'm running SQL 70 SP 3 on Nt4.

We store passwords of users of our website. They need to be autenticated and based on that it gives them access to what they are entitled. But its not like NT or server authentication.

This has been setup so that we have a user table and it stores the password. However, it stores it in plain text. Is there any way I can encrypt this field so it is unreadable? Is there a property or a datatype that I can't find? Is there a way to simulate the encryption?

Any ideas or help are appreciated.

Thanks
Kelsey

View 1 Replies View Related

Case-sensitive Passwords?

Mar 10, 2000

Is it possible in SQL Server 7.0 sp1 to have a
password that is case-sensitive on a case-insensitive
installation of SQL server?

Toni

View 1 Replies View Related

How To Restore Logins With Passwords

Oct 9, 2002

Hi,

I want to delete N number of logins today and restore them 5 days later.

What steps should be done beside backup of master.

what whould be the way to restore logins with passwords (with or without permissions )without restoring master?

I gess just running sp_resolve_logins
will not help.

thank you
Alex

View 2 Replies View Related

How To Script Logins And Passwords

Sep 17, 1999

How do I generate a script of my users logins and passwords?

View 2 Replies View Related

Viewing Passwords In Version 6.5

Oct 22, 1998

Hi,

Can anybody tell me is it possible to view user passwords in SQL Server v6.5 as the syslogins table shows the passwords as encrypted.

Thanks,

Phil

View 1 Replies View Related