Connecting to sqlserver 2000 from windows 7 64 bit OS.

[Dave2012k]

thread144-1694496

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.

 

[mbalent]

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"

http://www.anvil-of-time.com

 

[Dave2012k]

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

 

[mbalent]

Have you tried the native client v.9?

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[Dave2012k]

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

 

[mbalent]

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

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[Dave2012k]

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

 

[mbalent]

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"

http://www.anvil-of-time.com