RE: Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio
From: Zwyatt (Zwyatt_at_discussions.microsoft.com)
Date: 10/08/04
- Next message: Zwyatt: "RE: Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Previous message: Peter Foot [MVP]: "Re: opennetcf"
- In reply to: Zwyatt: "Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Next in thread: Zwyatt: "RE: Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 10:43:02 -0700
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.
"Zwyatt" wrote:
> 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
>
>
>
- Next message: Zwyatt: "RE: Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Previous message: Peter Foot [MVP]: "Re: opennetcf"
- In reply to: Zwyatt: "Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Next in thread: Zwyatt: "RE: Compact Framework 2.0 to Sql Server 2000 -- can't Open() connectio"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
