Problems connecting to SQL Server Compact with Powerbuilder

[loz...@hotmail.com]

Hi,

I am having difficulty connecting to SQL Server Compact using
Powerbuilder 9, 10.5 or 11.5

I have tried many ways but can't seem to connect.

Can you please post a sample SQLCA declaration so that I can see how
you connect.

Any help would be much appreciated

Thanks

Loz

[Thomas Rundo]

I am using PB 11.5 and MS SQL Server 2000

Here is my connect string in PB 11.5

// Profile TX2000SQL1 HISTORY
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <***>
SQLCA.ServerName = "TX2000SQL1"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='teoe_history',TrimSpaces=1,AppName='Powerbuilder
11.5.3127',Host='IT19 - Tom Rundo'"

You actually don't need the AppName or Host, we just use it to view on the
MS SQL Server monitor who is using what.

<loz...@hotmail.com> wrote in message
news:cef54ef2-d62b-4cfd...@p6g2000pre.googlegroups.com...

[Laurenc...@hotmail.com]

Thanks Tom,

I have no problem connecting to regular SQL Server databases like SQL
Express/MSDE/SQL 2005, 2000 etc.

I only have problems connecting to SQL Server Compact.

This is my SQLCA declaration....

>> for SQL Server Compact (3.0)...

SQLCA.DBMS = "ADO.Net"
SQLCA.DBParm = "Namespace='System.Data.OleDb',DataSource='C:
\test35.sdf',Provider='Microsoft.SQLSERVER.CE.OLEDB.3.5'"

>> for SQL Server Compact (3.5)...

SQLCA.DBMS = "ADO.Net"
SQLCA.DBParm = "Namespace='System.Data.OleDb',DataSource='C:
\test.sdf',Provider='Microsoft.SQLSERVER.MOBILE.OLEDB.3.0'"

Any help on that would be appreciated

Loz

[R. Pods]

Loz,

for me it looks like (at least in your posting) the code for 3.0 should
be swapped with that for 3.5.

Reimer

[loz...@hotmail.com]

Sorry My mistake,

It should have read......

I have no problem connecting to regular SQL Server databases like SQL
Express/MSDE/SQL 2005, 2000 etc.

I only have problems connecting to SQL Server Compact.

This is my SQLCA declaration....

>> for SQL Server Compact (3.5)...

SQLCA.DBMS = "ADO.Net"
SQLCA.DBParm = "Namespace='System.Data.OleDb',DataSource='C:
\test35.sdf',Provider='Microsoft.SQLSERVER.CE.OLEDB.3.5'"

>> for SQL Server Compact (3.0)...

SQLCA.DBMS = "ADO.Net"
SQLCA.DBParm = "Namespace='System.Data.OleDb',DataSource='C:

\test.sdf',Provider='Microsoft.SQLSERVER.MOBILE.OLEDB.3.0'"

But I am still getting crashes when trying to connect.

[server...@gmail.com]

hello could you connect with powerbuilder sql ce?

please help me

thanks

[server...@gmail.com]

hello i am andres