Conecting to SQL server 2003 using PB 8.0

[RTR1900]

Hi,

After a 5 year break using PB, I am staring again, this time with version 8.0 (instead of 6.5) and SQL server, instead of an ODBC DB.
My questions are:

1) Any good books recomending me?
2) How can I connect to an SQL server? I tried the next, but no result:

a) Made in SQL server a DB called FARMA2
b) Then In PB8.0 I went to "TOOLS DBPROFILE", created below MMS MICROSOFT SQL SERVER a new profile:

Server: local (IS THIS CORRECT???????)
LOGIN: administrador
Password: XXX
Database: Farma2

When I now go to connect, after a good 30 seconds it tells me:
Connot connect: SQL SERVER is no available or does not exist. Not possible to connect: SQL Server does not exists or network denied (translated from Spanish, sorry)


Any help would be greatfull!!!!

David

 

[mbalent]

We use the OLE DB drivers so we can take advantage of the newer features of SQL Server (varchar 8000 for example). We also use trusted connections. Our DB Profile for this is:

Provider: SQLOLEDB
datasource: <server with database on it>

Extended: database=abcdb;trusted_connection=Yes

Matt


"Nature forges everything on the anvil of time

 

[RTR1900]

Hi Matt,

so what you say is that it is better using OLE DB instead of SQL server?
We have about 10.000 products......

regards,

David

 

[mbalent]

OLE DB is the method of accessing the database (the driver). It was added to Powerbuilder in version 7. Since Sql Server 2000 the 'native' driver does not support the new features of the database.

Matt

"Nature forges everything on the anvil of time