Power Builder 11.5 and sqlserver2008 conection

italohg · Post by **italohg** » Thu Dec 15, 2011 4:41 pm

i have a client application building power builder 11.5, i want connect with a server sql2008
I cant make this connection, i need help please...
I have other application building power builder 9 and no have problem connection with sql2000 because use a driver odbc old

lahmbi5678 · Post by **lahmbi5678** » Sat Dec 17, 2011 10:50 am

First of all, I'm not an expert in running databases under wine, just a few general hints:

Please update to the latest wine version, if you haven't already.

Run your app from command line and post the output.

Did you follow the instructions from
http://wiki.winehq.org/NativeOdbc ?

Maybe you need to declare DSNs for sql2008.

Which odbc driver are you using for sql server 2000, and how did you install it in wine?

italohg · Post by **italohg** » Mon Dec 19, 2011 3:42 pm

lahmbi5678 wrote:First of all, I'm not an expert in running databases under wine, just a few general hints:

Please update to the latest wine version, if you haven't already.

Run your app from command line and post the output.

Did you follow the instructions from
http://wiki.winehq.org/NativeOdbc ?

Maybe you need to declare DSNs for sql2008.

Which odbc driver are you using for sql server 2000, and how did you install it in wine?

Nothing, i cant make this connection. other solution?

lahmbi5678 · Post by **lahmbi5678** » Mon Dec 19, 2011 3:59 pm

Do you get any error messages when running your app from command line? Please post the output.

Can you build an application with power builder with minimum functionality, just enough to show the connection failure? If so, please file a bug in the bugzilla and attach your minimum app there.

jjmckenzie · Post by **jjmckenzie** » Mon Dec 19, 2011 4:37 pm

On Mon, Dec 19, 2011 at 1:42 PM, italohg <[email protected]> wrote:

lahmbi5678 wrote:
First of all, I'm not an expert in running databases under wine, just a few general hints:

Please update to the latest wine version, if you haven't already.

Run your app from command line and post the output.

Did you follow the instructions from
http://wiki.winehq.org/NativeOdbc ?

Maybe you need to declare DSNs for sql2008.

Which odbc driver are you using for sql server 2000, and how did you install it in wine?
Nothing, i cant make this connection. other solution?

Can you make the connection using the SQL Tools included with the ODBC
driver package (If I remember this correctly, there are tools you can
download and install for testing connections with the ODBC DSN.)

James

italohg · Post by **italohg** » Wed Dec 21, 2011 8:44 am

maybe , this problem is because y use ubuntu in spanish and wine in spanish

italohg · Post by **italohg** » Thu Dec 22, 2011 12:27 pm

my connection is this:

[DB]
DBMS = "SNC SQL Native Client(OLE DB)"
LogPass = xnw965<pnw
ServerName = "172.168.201.11"
LogId = "neocomerc"

[DBrentas]
DBMS = SNC SQL Native Client(OLE DB)
LogPass = xnw965<pnw
ServerName = 172.168.201.11
LogId = neocomerc

[DBteso]
DBMS = SNC SQL Native Client(OLE DB)
LogPass = lis6=9ddd
ServerName = 172.168.200.11
LogId = tesoropal

[DBtramite]
DBMS = SNC SQL Native Client(OLE DB)
LogPass = lis6=9ddd
ServerName = 172.168.200.11
LogId = sistdoc

[otravez]

I installed sql native client
When running the application shows me this message:

SQLSTATE = 08001
Microsoft SQL Native Client
SQL Network Interfaces:

italohg · Post by **italohg** » Thu Dec 22, 2011 12:30 pm

show this message when run application for console:

usuario03@PCPRUEBA03:~/.wine/drive_c/Sistemas/neocomerc$ wine neocomerc.exe
err:ole:CoGetClassObject class {ecabb0c0-7f19-11d2-978e-0000f8757e2a} not registered
err:ole:CoGetClassObject no class object {ecabb0c0-7f19-11d2-978e-0000f8757e2a} could be created for context 0x1
fixme:ntlm:ntlm_AcquireCredentialsHandleW AcquireCredentialsHandle: SECPKG_CRED_BOTH stub

lahmbi5678 · Post by **lahmbi5678** » Thu Dec 22, 2011 1:58 pm

Probably a bug or unimplemented functionality in wine. Please file a bug in the bugzilla and provide a testcase, if possible.

vitamin · Post by **vitamin** » Sun Dec 25, 2011 1:45 pm

italohg wrote:i want connect with a server sql2008

Did you configure your server to talk over TCP/IP not just named pipes?