INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Connecting to sqlserver 2000 from windows 7 64 bit OS.

Connecting to sqlserver 2000 from windows 7 64 bit OS.

(OP)
thread144-1694496: Connecting to sqlserver 2000 from windows 7 64 bit OS.

Hi Miguel,
I really appreciate your reply.
I followed your suggestion and changed the trusted connection setting to 0
Now, I get this error message.

SQLstate 42000
Microsoft sqlserver native client 10.0
Cannot open database requested in login 'uap_sql',Provider=, Login
fails.

Any help regarding this issue is greatly appreciated.

Regards,
Dave

P.s. I was out of this project for a while.

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

Have you created a db connection from the PowerBuilder Database painter and connected successfully? If so have you tried those same parameters in the runtime?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

(OP)
Hey Matt,

I am shifting development environment from XP to Windows 7 64 bit operating system.

No, I am unable to create a successful connection from the PowerBuilder Database painter in Windows 7 64 bit operating system.
I installed PB 11.5 on windows 7 and copied the connection parameters created from the PowerBuilder Database painter in Windows xp.

Database connection syntax in preview tab
// Profile QADB
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <***>
SQLCA.ServerName = "NEWSERVER"
SQLCA.LogId = "user_uap_sql"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='uap_sql'"

When I tried to test the connection from preview tab in Database painter I get the following error:
Microsoft SQL server Native client 10.0
The requested properties cannot be supported.

Thanks for trying to help me!
Regards,
Dave

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

Have you tried the native client v.9?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

(OP)
Hi Matt,
Yes, I have tried snc 9.0 but no luck. Do you think is it because of 64 bit trying to connect to 32 bit operating system?
I am trying to find a driver which can communicate b/w 64 and 32 bit os.

I am able connect through ODBC.
// Profile ProdDB
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=NEWSERVER;UID=user_uap_sql;PWD=sql'"

Thanks,
Dave

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

You need to use the 32 bit driver if you are using a 32 bit database.

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

(OP)
Matt,
I have create a 32-bit DSN on 64-bit machine.
These are the steps used,
1. Type %systemdrive%\Windows\SysWoW64\Odbcad32.exe in the Run window
2. Add SQL Server Native Client 10.0 to System DSN
3. On the create a new data source window specified the name of the production server

Thanks for your help!
Dave

RE: Connecting to sqlserver 2000 from windows 7 64 bit OS.

Maybe a dumb question but why are you using newer drivers on an old version of SQL Server?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close