Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio

[Guest]

I'm having a problem connecting to a sql server database from my pocketpc.

The connection string works fine when I run the program on My Computer.
However, on the pocketpc I get a "SqlException" with no helpful info other
than: -2146233087

The machines can ping each other fine, I've turned off the XP 2 firewall...

I have XP SP 2 on the machine w/ the sql server, along with the latest
updates for sql server. Searching the newsgroups implied that putting on the
latest SP for sql server would fix things...but to no avail.

Any setting suggestions?

thanks,

- Zack

 

[Guest]

Update:
In my data source attribute, I was connecting to:
"192.168.1.103\IERP" since IERP was the name of the database on that
machine. This worked fine when running the program under My Computer but
gave an exception with PocketPC.

I tried connecting to a different data source on another machine:
"192.168.1.101"

NOW it worked fine on the PocketPC. I also tried connecting to yet another
datasource, again using a \IERP to get to the correct database, and it failed.

So the 'link' I'm seeing right now is that I can't have a named (\something)
in the datasource name on PPC.

May be wrong; anybody else had results or workarounds? Is the .1.101
database somehow different? It's XP Sp2 and SP3a for Sql.

thanks...

- Zack

p.s. Note: I do specify the 'database' or 'initial catalog' attribute in the
property string in addition to the \IERP in the datasource.

 

[Guest]

Update:
In my data source attribute, I was connecting to:
"192.168.1.103\IERP" since IERP was the name of the database on that
machine. This worked fine when running the program under My Computer but
gave an exception with PocketPC.

I tried connecting to a different data source on another machine:
"192.168.1.101"

NOW it worked fine on the PocketPC. I also tried connecting to yet another
datasource, again using a \IERP to get to the correct database, and it failed.

So the 'link' I'm seeing right now is that I can't have a named (\something)
in the datasource name on PPC.

May be wrong; anybody else had results or workarounds? Is the .1.101
database somehow different? It's XP Sp2 and SP3a for Sql.

thanks...

- Zack

p.s. Note: I do specify the 'database' or 'initial catalog' attribute in the
property string in addition to the \IERP in the datasource.

 

[Guest]

Update:
In my data source attribute, I was connecting to:
"192.168.1.103\IERP" since IERP was the name of the database on that
machine. This worked fine when running the program under My Computer but
gave an exception with PocketPC.

I tried connecting to a different data source on another machine, just:
"192.168.1.101"

Now it worked fine on the PocketPC. I also tried connecting to yet another
datasource, again using a \IERP to get to the correct database, and it failed.

So the link I'm seeing right now is that I can't have a named (\something)
in the datasource name on PPC.

May be wrong; anybody else had results or workarounds? Is the .1.101
database somehow different? It's also XP Sp2 and SP3a for Sql.

thanks...

- Zack

p.s. Note: I do specify the 'database' or 'initial catalog' attribute in the
property string in addition to the \IERP in the datasource.

 

[Guest]

Apologies for the multiple posts; MS said there were errors when submitting.

Anyway -- it works fine now.

Change
"192.168.1.103\IERP"
to
"NAME-OF-MACHINE\IERP"

On My Computer the IpAddress + db name works fine...on PPC I get the error I
mentioned before.

peace,

- Zack