error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

sql

error when trying to browse SSRS on a remote machine

Hi,

I deployed SSRS reports to my local report server and set the connection string to access a server on the network with Analysis Server.

Result:
I can access and use the reports from my computer. But when I use any other computer on the network I can't use the reports. I can access them but they don't find the database ant therefor they don't present any data.

Error message as folows: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'dsAnalys'. (rsErrorOpeningConnection) Get Online Help
Database 'Analys' does not exist. "

This works fine on my local machine, the error comes only when i try to browse on a remote machine. I am using SQL Server 2005

Any help would be appriciated!!!

Thanks in advance,

Chanduu

Can you access the database from a different PC using SQL Server Management Studio?

Possibly the server is not accessible from those PCs? Is it on a different domain?

|||yes, i am able to access|||

Chandu I am just trying to see what is causing this error.

1.) Do you have Shared Datasource in SSRS.

2.) While deploying to the remote server, make sure to include the right TargetServerUrl.

3.) On the Remote Server, go the Home folder and check for the DataSources if it has

a.) Enable this Data Source CheckBox checked.

b.) Connection string

c.) In the Connect Using: Check if the Credentials stored securely in the report server is Checked and the UserName and Password is given.

4.) Check for the permissions.

Hope this helps...

|||

Thanks a lot !!! friends .. I got answer for this error

Steps i followed to reslove this error

1. Goto http://<report server>/reports

2. Select the datasource folder

3. Check "Credentials stored in that report" and give valid user id and password

4. Check the check box"Use as windows credentials when connecting to datasource"

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Hi

I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

I am thinking there is a problem with your deploying RS 2005 reports to a 2000 RS database. I wasn't aware you could deploy 2005 reports to a 2000 RS database. Maybe you can do it if you don't convert (existing 2000) reports, I am not sure; but I doubt you'll be able to deploy them if you have converted them from 2000 to 2005. I especially think and new reports will bomb out since they would be native 2005.

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks for th information but it still gives me the same error, but don't worry too much about it, i'm just going to reinstall SQL 2000 RS with Visual Studio 2003. apparently there is some incompatibility issue between .Net Framework 2.0 and 1.1 that prevent my solutions from working properly, so until i figure out the exact problem and link the Frameworks manually in my solution i doubt that it will work.

Thanks a lot for your effort guys!

|||

Hi

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

When i installed the RS i changed the Virtual Directory Name to Forge too, so when i deployed them i had to deploy them to Forge/Forge instead of Forge/ReportServer which it suppose to be by default. ->PC Name / ReportServer Virtual Directory<--

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Hi

I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

I am thinking there is a problem with your deploying RS 2005 reports to a 2000 RS database. I wasn't aware you could deploy 2005 reports to a 2000 RS database. Maybe you can do it if you don't convert (existing 2000) reports, I am not sure; but I doubt you'll be able to deploy them if you have converted them from 2000 to 2005. I especially think and new reports will bomb out since they would be native 2005.

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks for th information but it still gives me the same error, but don't worry too much about it, i'm just going to reinstall SQL 2000 RS with Visual Studio 2003. apparently there is some incompatibility issue between .Net Framework 2.0 and 1.1 that prevent my solutions from working properly, so until i figure out the exact problem and link the Frameworks manually in my solution i doubt that it will work.

Thanks a lot for your effort guys!

|||

Hi

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

When i installed the RS i changed the Virtual Directory Name to Forge too, so when i deployed them i had to deploy them to Forge/Forge instead of Forge/ReportServer which it suppose to be by default. ->PC Name / ReportServer Virtual Directory<--

Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at t

Hi

I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error

A connection could not be made to the report server http://Forge/Reports.

Additional Information:

The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse my site, it just doesn't want2 deploy.

Please HELP!!!

I suspect the problem lies here:

>I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005

and, considering the error:

>that the report server is a compatible version

I am thinking there is a problem with your deploying RS 2005 reports to a 2000 RS database. I wasn't aware you could deploy 2005 reports to a 2000 RS database. Maybe you can do it if you don't convert (existing 2000) reports, I am not sure; but I doubt you'll be able to deploy them if you have converted them from 2000 to 2005. I especially think and new reports will bomb out since they would be native 2005.

There are threads in this forum that talk about this subject.

|||Try deploying to http://forge/reportserver instead.|||wow. good eye!|||

Thanks for th information but it still gives me the same error, but don't worry too much about it, i'm just going to reinstall SQL 2000 RS with Visual Studio 2003. apparently there is some incompatibility issue between .Net Framework 2.0 and 1.1 that prevent my solutions from working properly, so until i figure out the exact problem and link the Frameworks manually in my solution i doubt that it will work.

Thanks a lot for your effort guys!

|||

Hi

I traced down my problem, but i'll post my solution here just incase some else might battle with the same problem.

When i installed the RS i changed the Virtual Directory Name to Forge too, so when i deployed them i had to deploy them to Forge/Forge instead of Forge/ReportServer which it suppose to be by default. ->PC Name / ReportServer Virtual Directory<--

Error When I try to browse the website for my SQL Mobile 2005 Replication

I tried posting this in the SQL CE group but I haven't gotten any responses
so I am trying it here.
When I try to browse the website:
http://localhost/quickgoldmobile/sqlcesa30.dll
I get this error:
%1 is not a valid Win32 application.
This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked permissions
and everything looks correct the anonymous user has READ access to the
replication folders. I even tried giving it full permissions but that
didn't work either.
Anyone have any ideas?
Eric Renken
Hi Eric,
Welcome.
As for the problem you mentioned, based on my experience, it is likely a 32
bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine. Is
your IIS currently configured to running as 32 bit or 64 bit and is it
running under IIS worker process isolation model or IIS5 compatible model?
And the "%1 is not a valid Win32 application." error is likely occur when
the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
process in IIS. Here is a kb article discussing on this:
#Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
applications in IIS 6.0
http://support.microsoft.com/?id=895976
I suggest you first check whether the IIS is configured to use worker
process isolation model(applciation pool model), it's a global setting (not
site specific) on a certain machine. then, check whether the current IIS is
running in 32 bit (WOW) or 64 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| Subject: Error When I try to browse the website for my SQL Mobile 2005
Replication
| Date: Tue, 10 Jan 2006 15:16:26 -0500
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I tried posting this in the SQL CE group but I haven't gotten any
responses
| so I am trying it here.
|
| When I try to browse the website:
|
| http://localhost/quickgoldmobile/sqlcesa30.dll
|
| I get this error:
|
| %1 is not a valid Win32 application.
|
| This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
permissions
| and everything looks correct the anonymous user has READ access to the
| replication folders. I even tried giving it full permissions but that
| didn't work either.
|
| Anyone have any ideas?
|
| Eric Renken
|
|
|
|
|||Well that seemed to do it. Is there any way to run 32bit apps and 64bit
apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
version into IIS once I made the change.
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>
|||Is there any talk or discussion on making sqlcesa30.dll a 64-bit DLL?
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>
|||Thanks for your response Eric,
For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
running 32 bit application is a global setting for all application pools ,
so we can not make separate worker process(w3wp) running different bit
applications(or loading different bit dll...). For 32 bit or 64 bit dll
of the replication service's ISAPI filter or extension, they're shiped with
the 32 bit or 64 bit SQLServer...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Wed, 11 Jan 2006 19:14:16 -0500
| Lines: 89
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Well that seemed to do it. Is there any way to run 32bit apps and 64bit
| apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| version into IIS once I made the change.
|
| Eric Renken
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > Hi Eric,
| >
| > Welcome.
| > As for the problem you mentioned, based on my experience, it is likely
a
| > 32
| > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
machine.
| > Is
| > your IIS currently configured to running as 32 bit or 64 bit and is it
| > running under IIS worker process isolation model or IIS5 compatible
model?
| > And the "%1 is not a valid Win32 application." error is likely occur
when
| > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
bit
| > process in IIS. Here is a kb article discussing on this:
| >
| > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > applications in IIS 6.0
| > http://support.microsoft.com/?id=895976
| >
| > I suggest you first check whether the IIS is configured to use worker
| > process isolation model(applciation pool model), it's a global setting
| > (not
| > site specific) on a certain machine. then, check whether the current
IIS
| > is
| > running in 32 bit (WOW) or 64 bit model...
| >
| > Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | Subject: Error When I try to browse the website for my SQL Mobile 2005
| > Replication
| > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | Lines: 22
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I tried posting this in the SQL CE group but I haven't gotten any
| > responses
| > | so I am trying it here.
| > |
| > | When I try to browse the website:
| > |
| > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > |
| > | I get this error:
| > |
| > | %1 is not a valid Win32 application.
| > |
| > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > permissions
| > | and everything looks correct the anonymous user has READ access to the
| > | replication folders. I even tried giving it full permissions but that
| > | didn't work either.
| > |
| > | Anyone have any ideas?
| > |
| > | Eric Renken
| > |
| > |
| > |
| > |
| >
|
|
|
|||I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
2005 SQL server running. The MSI install for SQL Mobile sqlce30setupen.msi
was only installed with my Visual Studio install and that appears to be a 32
bit version of the DLL.
Eric
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
> Thanks for your response Eric,
> For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
> running 32 bit application is a global setting for all application pools ,
> so we can not make separate worker process(w3wp) running different bit
> applications(or loading different bit dll...). For 32 bit or 64 bit dll
> of the replication service's ISAPI filter or extension, they're shiped
> with
> the 32 bit or 64 bit SQLServer...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
> | Subject: Re: Error When I try to browse the website for my SQL Mobile
> 2005 Replication
> | Date: Wed, 11 Jan 2006 19:14:16 -0500
> | Lines: 89
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Well that seemed to do it. Is there any way to run 32bit apps and 64bit
> | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
> | version into IIS once I made the change.
> |
> | Eric Renken
> |
> | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> | > Hi Eric,
> | >
> | > Welcome.
> | > As for the problem you mentioned, based on my experience, it is likely
> a
> | > 32
> | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
> machine.
> | > Is
> | > your IIS currently configured to running as 32 bit or 64 bit and is it
> | > running under IIS worker process isolation model or IIS5 compatible
> model?
> | > And the "%1 is not a valid Win32 application." error is likely occur
> when
> | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
> bit
> | > process in IIS. Here is a kb article discussing on this:
> | >
> | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> | > applications in IIS 6.0
> | > http://support.microsoft.com/?id=895976
> | >
> | > I suggest you first check whether the IIS is configured to use worker
> | > process isolation model(applciation pool model), it's a global setting
> | > (not
> | > site specific) on a certain machine. then, check whether the current
> IIS
> | > is
> | > running in 32 bit (WOW) or 64 bit model...
> | >
> | > Thanks,
> | >
> | > Steven Cheng
> | > Microsoft Online Support
> | >
> | > Get Secure! www.microsoft.com/security
> | > (This posting is provided "AS IS", with no warranties, and confers no
> | > rights.)
> | >
> | >
> | >
> | > --
> | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | > | Subject: Error When I try to browse the website for my SQL Mobile
> 2005
> | > Replication
> | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | > | Lines: 22
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | > | X-RFC2646: Format=Flowed; Original
> | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.server
> | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | > | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
> | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | > | X-Tomcat-NG: microsoft.public.sqlserver.server
> | > |
> | > | I tried posting this in the SQL CE group but I haven't gotten any
> | > responses
> | > | so I am trying it here.
> | > |
> | > | When I try to browse the website:
> | > |
> | > | http://localhost/quickgoldmobile/sqlcesa30.dll
> | > |
> | > | I get this error:
> | > |
> | > | %1 is not a valid Win32 application.
> | > |
> | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> | > permissions
> | > | and everything looks correct the anonymous user has READ access to
> the
> | > | replication folders. I even tried giving it full permissions but
> that
> | > | didn't work either.
> | > |
> | > | Anyone have any ideas?
> | > |
> | > | Eric Renken
> | > |
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>
|||Thanks for your response Eric,
I'll do some further research to check whether there is 64 bit version of
the sqlce's replication web component(dll). Also, so far we can confirm
that 32 bit or 64 bit component can not work side by side in IIS6(on 64 bit
machine), only one can be configured to use at one certain time...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Thu, 12 Jan 2006 14:27:01 -0500
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
| 2005 SQL server running. The MSI install for SQL Mobile
sqlce30setupen.msi
| was only installed with my Visual Studio install and that appears to be a
32
| bit version of the DLL.
|
| Eric
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| > Thanks for your response Eric,
| >
| > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| > running 32 bit application is a global setting for all application
pools ,
| > so we can not make separate worker process(w3wp) running different bit
| > applications(or loading different bit dll...). For 32 bit or 64 bit
dll
| > of the replication service's ISAPI filter or extension, they're shiped
| > with
| > the 32 bit or 64 bit SQLServer...
| >
| > Regards,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| > | Subject: Re: Error When I try to browse the website for my SQL Mobile
| > 2005 Replication
| > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| > | Lines: 89
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Well that seemed to do it. Is there any way to run 32bit apps and
64bit
| > | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| > | version into IIS once I made the change.
| > |
| > | Eric Renken
| > |
| > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > | > Hi Eric,
| > | >
| > | > Welcome.
| > | > As for the problem you mentioned, based on my experience, it is
likely
| > a
| > | > 32
| > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| > machine.
| > | > Is
| > | > your IIS currently configured to running as 32 bit or 64 bit and is
it
| > | > running under IIS worker process isolation model or IIS5 compatible
| > model?
| > | > And the "%1 is not a valid Win32 application." error is likely occur
| > when
| > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by
64
| > bit
| > | > process in IIS. Here is a kb article discussing on this:
| > | >
| > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > | > applications in IIS 6.0
| > | > http://support.microsoft.com/?id=895976
| > | >
| > | > I suggest you first check whether the IIS is configured to use
worker
| > | > process isolation model(applciation pool model), it's a global
setting
| > | > (not
| > | > site specific) on a certain machine. then, check whether the current
| > IIS
| > | > is
| > | > running in 32 bit (WOW) or 64 bit model...
| > | >
| > | > Thanks,
| > | >
| > | > Steven Cheng
| > | > Microsoft Online Support
| > | >
| > | > Get Secure! www.microsoft.com/security
| > | > (This posting is provided "AS IS", with no warranties, and confers
no
| > | > rights.)
| > | >
| > | >
| > | >
| > | > --
| > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | > | Subject: Error When I try to browse the website for my SQL Mobile
| > 2005
| > | > Replication
| > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | > | Lines: 22
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | > | X-RFC2646: Format=Flowed; Original
| > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.server
| > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | > | Path:
| > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| > | > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.server:417088
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > | > |
| > | > | I tried posting this in the SQL CE group but I haven't gotten any
| > | > responses
| > | > | so I am trying it here.
| > | > |
| > | > | When I try to browse the website:
| > | > |
| > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > | > |
| > | > | I get this error:
| > | > |
| > | > | %1 is not a valid Win32 application.
| > | > |
| > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > | > permissions
| > | > | and everything looks correct the anonymous user has READ access
to
| > the
| > | > | replication folders. I even tried giving it full permissions but
| > that
| > | > | didn't work either.
| > | > |
| > | > | Anyone have any ideas?
| > | > |
| > | > | Eric Renken
| > | > |
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|
|||Hi Eric,
I've confirmed with SQL guys and so far since the SQLServre Mobile only
shiped the 32 bit ones so the server tools also limited to 32bit. So we
have to configure server tools on a server of 32 bit OS or can be
configured for running IIS under 32 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| X-Tomcat-ID: 200169184
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
<u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: stcheng@.online.microsoft.com (Steven Cheng[MSFT])
| Organization: Microsoft
| Date: Fri, 13 Jan 2006 10:21:35 GMT
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <szG6rsCGGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 180
| Path: TK2MSFTNGXA02.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417487
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Thanks for your response Eric,
|
| I'll do some further research to check whether there is 64 bit version of
| the sqlce's replication web component(dll). Also, so far we can confirm
| that 32 bit or 64 bit component can not work side by side in IIS6(on 64
bit
| machine), only one can be configured to use at one certain time...
|
| Thanks,
|
| Steven Cheng
| Microsoft Online Support
|
| Get Secure! www.microsoft.com/security
| (This posting is provided "AS IS", with no warranties, and confers no
| rights.)
| --
| | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| <FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| | Subject: Re: Error When I try to browse the website for my SQL Mobile
| 2005 Replication
| | Date: Thu, 12 Jan 2006 14:27:01 -0500
| | Lines: 153
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
| | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | I didn't see the 64bit DLL at all with the 64 bit SQL server. I have
SQL
| | 2005 SQL server running. The MSI install for SQL Mobile
| sqlce30setupen.msi
| | was only installed with my Visual Studio install and that appears to be
a
| 32
| | bit version of the DLL.
| |
| | Eric
| |
| | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| | news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| | > Thanks for your response Eric,
| | >
| | > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| | > running 32 bit application is a global setting for all application
| pools ,
| | > so we can not make separate worker process(w3wp) running different bit
| | > applications(or loading different bit dll...). For 32 bit or 64 bit
| dll
| | > of the replication service's ISAPI filter or extension, they're
shiped
| | > with
| | > the 32 bit or 64 bit SQLServer...
| | >
| | > Regards,
| | >
| | > Steven Cheng
| | > Microsoft Online Support
| | >
| | > Get Secure! www.microsoft.com/security
| | > (This posting is provided "AS IS", with no warranties, and confers no
| | > rights.)
| | >
| | >
| | >
| | > --
| | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| | > | Subject: Re: Error When I try to browse the website for my SQL
Mobile
| | > 2005 Replication
| | > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| | > | Lines: 89
| | > | X-Priority: 3
| | > | X-MSMail-Priority: Normal
| | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | X-RFC2646: Format=Flowed; Original
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | > | Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | Well that seemed to do it. Is there any way to run 32bit apps and
| 64bit
| | > | apps on the same instance of IIS? I had to reinstall .net 2.0
32-bit
| | > | version into IIS once I made the change.
| | > |
| | > | Eric Renken
| | > |
| | > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| | > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| | > | > Hi Eric,
| | > | >
| | > | > Welcome.
| | > | > As for the problem you mentioned, based on my experience, it is
| likely
| | > a
| | > | > 32
| | > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| | > machine.
| | > | > Is
| | > | > your IIS currently configured to running as 32 bit or 64 bit and
is
| it
| | > | > running under IIS worker process isolation model or IIS5
compatible
| | > model?
| | > | > And the "%1 is not a valid Win32 application." error is likely
occur
| | > when
| | > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded
by
| 64
| | > bit
| | > | > process in IIS. Here is a kb article discussing on this:
| | > | >
| | > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit
Web
| | > | > applications in IIS 6.0
| | > | > http://support.microsoft.com/?id=895976
| | > | >
| | > | > I suggest you first check whether the IIS is configured to use
| worker
| | > | > process isolation model(applciation pool model), it's a global
| setting
| | > | > (not
| | > | > site specific) on a certain machine. then, check whether the
current
| | > IIS
| | > | > is
| | > | > running in 32 bit (WOW) or 64 bit model...
| | > | >
| | > | > Thanks,
| | > | >
| | > | > Steven Cheng
| | > | > Microsoft Online Support
| | > | >
| | > | > Get Secure! www.microsoft.com/security
| | > | > (This posting is provided "AS IS", with no warranties, and
confers
| no
| | > | > rights.)
| | > | >
| | > | >
| | > | >
| | > | > --
| | > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | > | Subject: Error When I try to browse the website for my SQL
Mobile
| | > 2005
| | > | > Replication
| | > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| | > | > | Lines: 22
| | > | > | X-Priority: 3
| | > | > | X-MSMail-Priority: Normal
| | > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | > | X-RFC2646: Format=Flowed; Original
| | > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > | > | Newsgroups: microsoft.public.sqlserver.server
| | > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net
24.11.238.51
| | > | > | Path:
| | > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| | > | > | Xref: TK2MSFTNGXA02.phx.gbl
| microsoft.public.sqlserver.server:417088
| | > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > | > |
| | > | > | I tried posting this in the SQL CE group but I haven't gotten
any
| | > | > responses
| | > | > | so I am trying it here.
| | > | > |
| | > | > | When I try to browse the website:
| | > | > |
| | > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| | > | > |
| | > | > | I get this error:
| | > | > |
| | > | > | %1 is not a valid Win32 application.
| | > | > |
| | > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| | > | > permissions
| | > | > | and everything looks correct the anonymous user has READ access
| to
| | > the
| | > | > | replication folders. I even tried giving it full permissions
but
| | > that
| | > | > | didn't work either.
| | > | > |
| | > | > | Anyone have any ideas?
| | > | > |
| | > | > | Eric Renken
| | > | > |
| | > | > |
| | > | > |
| | > | > |
| | > | >
| | > |
| | > |
| | > |
| | >
| |
| |
| |
|
|
sql

Error When I try to browse the website for my SQL Mobile 2005 Replication

I tried posting this in the SQL CE group but I haven't gotten any responses
so I am trying it here.
When I try to browse the website:
http://localhost/quickgoldmobile/sqlcesa30.dll
I get this error:
%1 is not a valid Win32 application.
This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked permissions
and everything looks correct the anonymous user has READ access to the
replication folders. I even tried giving it full permissions but that
didn't work either.
Anyone have any ideas?
Eric RenkenHi Eric,
Welcome.
As for the problem you mentioned, based on my experience, it is likely a 32
bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine. Is
your IIS currently configured to running as 32 bit or 64 bit and is it
running under IIS worker process isolation model or IIS5 compatible model?
And the "%1 is not a valid Win32 application." error is likely occur when
the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
process in IIS. Here is a kb article discussing on this:
#Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
applications in IIS 6.0
http://support.microsoft.com/?id=895976
I suggest you first check whether the IIS is configured to use worker
process isolation model(applciation pool model), it's a global setting (not
site specific) on a certain machine. then, check whether the current IIS is
running in 32 bit (WOW) or 64 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| Subject: Error When I try to browse the website for my SQL Mobile 2005
Replication
| Date: Tue, 10 Jan 2006 15:16:26 -0500
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I tried posting this in the SQL CE group but I haven't gotten any
responses
| so I am trying it here.
|
| When I try to browse the website:
|
| http://localhost/quickgoldmobile/sqlcesa30.dll
|
| I get this error:
|
| %1 is not a valid Win32 application.
|
| This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
permissions
| and everything looks correct the anonymous user has READ access to the
| replication folders. I even tried giving it full permissions but that
| didn't work either.
|
| Anyone have any ideas?
|
| Eric Renken
|
|
|
||||Well that seemed to do it. Is there any way to run 32bit apps and 64bit
apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
version into IIS once I made the change.
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>|||Is there any talk or discussion on making sqlcesa30.dll a 64-bit DLL?
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>|||Thanks for your response Eric,
For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
running 32 bit application is a global setting for all application pools ,
so we can not make separate worker process(w3wp) running different bit
applications(or loading different bit dll...). For 32 bit or 64 bit dll
of the replication service's ISAPI filter or extension, they're shiped with
the 32 bit or 64 bit SQLServer...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Wed, 11 Jan 2006 19:14:16 -0500
| Lines: 89
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Well that seemed to do it. Is there any way to run 32bit apps and 64bit
| apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| version into IIS once I made the change.
|
| Eric Renken
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > Hi Eric,
| >
| > Welcome.
| > As for the problem you mentioned, based on my experience, it is likely
a
| > 32
| > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
machine.
| > Is
| > your IIS currently configured to running as 32 bit or 64 bit and is it
| > running under IIS worker process isolation model or IIS5 compatible
model?
| > And the "%1 is not a valid Win32 application." error is likely occur
when
| > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
bit
| > process in IIS. Here is a kb article discussing on this:
| >
| > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > applications in IIS 6.0
| > http://support.microsoft.com/?id=895976
| >
| > I suggest you first check whether the IIS is configured to use worker
| > process isolation model(applciation pool model), it's a global setting
| > (not
| > site specific) on a certain machine. then, check whether the current
IIS
| > is
| > running in 32 bit (WOW) or 64 bit model...
| >
| > Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | Subject: Error When I try to browse the website for my SQL Mobile 2005
| > Replication
| > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | Lines: 22
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I tried posting this in the SQL CE group but I haven't gotten any
| > responses
| > | so I am trying it here.
| > |
| > | When I try to browse the website:
| > |
| > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > |
| > | I get this error:
| > |
| > | %1 is not a valid Win32 application.
| > |
| > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > permissions
| > | and everything looks correct the anonymous user has READ access to the
| > | replication folders. I even tried giving it full permissions but that
| > | didn't work either.
| > |
| > | Anyone have any ideas?
| > |
| > | Eric Renken
| > |
| > |
| > |
| > |
| >
|
|
||||I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
2005 SQL server running. The MSI install for SQL Mobile sqlce30setupen.msi
was only installed with my Visual Studio install and that appears to be a 32
bit version of the DLL.
Eric
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
> Thanks for your response Eric,
> For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
> running 32 bit application is a global setting for all application pools ,
> so we can not make separate worker process(w3wp) running different bit
> applications(or loading different bit dll...). For 32 bit or 64 bit dll
> of the replication service's ISAPI filter or extension, they're shiped
> with
> the 32 bit or 64 bit SQLServer...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
> | Subject: Re: Error When I try to browse the website for my SQL Mobile
> 2005 Replication
> | Date: Wed, 11 Jan 2006 19:14:16 -0500
> | Lines: 89
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Well that seemed to do it. Is there any way to run 32bit apps and 64bit
> | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
> | version into IIS once I made the change.
> |
> | Eric Renken
> |
> | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> | > Hi Eric,
> | >
> | > Welcome.
> | > As for the problem you mentioned, based on my experience, it is likely
> a
> | > 32
> | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
> machine.
> | > Is
> | > your IIS currently configured to running as 32 bit or 64 bit and is it
> | > running under IIS worker process isolation model or IIS5 compatible
> model?
> | > And the "%1 is not a valid Win32 application." error is likely occur
> when
> | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
> bit
> | > process in IIS. Here is a kb article discussing on this:
> | >
> | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> | > applications in IIS 6.0
> | > http://support.microsoft.com/?id=895976
> | >
> | > I suggest you first check whether the IIS is configured to use worker
> | > process isolation model(applciation pool model), it's a global setting
> | > (not
> | > site specific) on a certain machine. then, check whether the current
> IIS
> | > is
> | > running in 32 bit (WOW) or 64 bit model...
> | >
> | > Thanks,
> | >
> | > Steven Cheng
> | > Microsoft Online Support
> | >
> | > Get Secure! www.microsoft.com/security
> | > (This posting is provided "AS IS", with no warranties, and confers no
> | > rights.)
> | >
> | >
> | >
> | > --
> | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | > | Subject: Error When I try to browse the website for my SQL Mobile
> 2005
> | > Replication
> | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | > | Lines: 22
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | > | X-RFC2646: Format=Flowed; Original
> | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.server
> | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | > | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | > | X-Tomcat-NG: microsoft.public.sqlserver.server
> | > |
> | > | I tried posting this in the SQL CE group but I haven't gotten any
> | > responses
> | > | so I am trying it here.
> | > |
> | > | When I try to browse the website:
> | > |
> | > | http://localhost/quickgoldmobile/sqlcesa30.dll
> | > |
> | > | I get this error:
> | > |
> | > | %1 is not a valid Win32 application.
> | > |
> | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> | > permissions
> | > | and everything looks correct the anonymous user has READ access to
> the
> | > | replication folders. I even tried giving it full permissions but
> that
> | > | didn't work either.
> | > |
> | > | Anyone have any ideas?
> | > |
> | > | Eric Renken
> | > |
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Thanks for your response Eric,
I'll do some further research to check whether there is 64 bit version of
the sqlce's replication web component(dll). Also, so far we can confirm
that 32 bit or 64 bit component can not work side by side in IIS6(on 64 bit
machine), only one can be configured to use at one certain time...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Thu, 12 Jan 2006 14:27:01 -0500
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
| 2005 SQL server running. The MSI install for SQL Mobile
sqlce30setupen.msi
| was only installed with my Visual Studio install and that appears to be a
32
| bit version of the DLL.
|
| Eric
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| > Thanks for your response Eric,
| >
| > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| > running 32 bit application is a global setting for all application
pools ,
| > so we can not make separate worker process(w3wp) running different bit
| > applications(or loading different bit dll...). For 32 bit or 64 bit
dll
| > of the replication service's ISAPI filter or extension, they're shiped
| > with
| > the 32 bit or 64 bit SQLServer...
| >
| > Regards,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| > | Subject: Re: Error When I try to browse the website for my SQL Mobile
| > 2005 Replication
| > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| > | Lines: 89
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Well that seemed to do it. Is there any way to run 32bit apps and
64bit
| > | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| > | version into IIS once I made the change.
| > |
| > | Eric Renken
| > |
| > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > | > Hi Eric,
| > | >
| > | > Welcome.
| > | > As for the problem you mentioned, based on my experience, it is
likely
| > a
| > | > 32
| > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| > machine.
| > | > Is
| > | > your IIS currently configured to running as 32 bit or 64 bit and is
it
| > | > running under IIS worker process isolation model or IIS5 compatible
| > model?
| > | > And the "%1 is not a valid Win32 application." error is likely occur
| > when
| > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by
64
| > bit
| > | > process in IIS. Here is a kb article discussing on this:
| > | >
| > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > | > applications in IIS 6.0
| > | > http://support.microsoft.com/?id=895976
| > | >
| > | > I suggest you first check whether the IIS is configured to use
worker
| > | > process isolation model(applciation pool model), it's a global
setting
| > | > (not
| > | > site specific) on a certain machine. then, check whether the current
| > IIS
| > | > is
| > | > running in 32 bit (WOW) or 64 bit model...
| > | >
| > | > Thanks,
| > | >
| > | > Steven Cheng
| > | > Microsoft Online Support
| > | >
| > | > Get Secure! www.microsoft.com/security
| > | > (This posting is provided "AS IS", with no warranties, and confers
no
| > | > rights.)
| > | >
| > | >
| > | >
| > | > --
| > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | > | Subject: Error When I try to browse the website for my SQL Mobile
| > 2005
| > | > Replication
| > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | > | Lines: 22
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | > | X-RFC2646: Format=Flowed; Original
| > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.server
| > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | > | Path:
| > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.server:417088
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > | > |
| > | > | I tried posting this in the SQL CE group but I haven't gotten any
| > | > responses
| > | > | so I am trying it here.
| > | > |
| > | > | When I try to browse the website:
| > | > |
| > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > | > |
| > | > | I get this error:
| > | > |
| > | > | %1 is not a valid Win32 application.
| > | > |
| > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > | > permissions
| > | > | and everything looks correct the anonymous user has READ access
to
| > the
| > | > | replication folders. I even tried giving it full permissions but
| > that
| > | > | didn't work either.
| > | > |
| > | > | Anyone have any ideas?
| > | > |
| > | > | Eric Renken
| > | > |
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
||||Steve,
I cannot find sp1 for an x64 2003 version.
When I try to set the enable32bitapponwin64 setting, my web server fails
to start. A SERVICE UNAVAILABLE response is sent to the client. When I look
into the event logs I see 5 warnings with an event id of 1009 and the message:
"A process serving application pool 'DefaultAppPool' terminated
unexpectedly. The process id was '2628'. The process exit code was
'0xffffffff'."
followed by an error with an event id of 1002 stating the defaultapppool
has been disabled from w3svc. If I remove the setting the server sends
responses except when trying to instantiate a 32bit control.
Any Ideas ?
--
Timothy Jewett
Jewettware@.online.nospam
"Steven Cheng[MSFT]" wrote:
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine. Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting (not
> site specific) on a certain machine. then, check whether the current IIS is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>|||Hi Eric,
I've confirmed with SQL guys and so far since the SQLServre Mobile only
shiped the 32 bit ones so the server tools also limited to 32bit. So we
have to configure server tools on a server of 32 bit OS or can be
configured for running IIS under 32 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| X-Tomcat-ID: 200169184
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
<u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: stcheng@.online.microsoft.com (Steven Cheng[MSFT])
| Organization: Microsoft
| Date: Fri, 13 Jan 2006 10:21:35 GMT
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <szG6rsCGGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 180
| Path: TK2MSFTNGXA02.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417487
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Thanks for your response Eric,
|
| I'll do some further research to check whether there is 64 bit version of
| the sqlce's replication web component(dll). Also, so far we can confirm
| that 32 bit or 64 bit component can not work side by side in IIS6(on 64
bit
| machine), only one can be configured to use at one certain time...
|
| Thanks,
|
| Steven Cheng
| Microsoft Online Support
|
| Get Secure! www.microsoft.com/security
| (This posting is provided "AS IS", with no warranties, and confers no
| rights.)
| --
| | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| <FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| | Subject: Re: Error When I try to browse the website for my SQL Mobile
| 2005 Replication
| | Date: Thu, 12 Jan 2006 14:27:01 -0500
| | Lines: 153
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | I didn't see the 64bit DLL at all with the 64 bit SQL server. I have
SQL
| | 2005 SQL server running. The MSI install for SQL Mobile
| sqlce30setupen.msi
| | was only installed with my Visual Studio install and that appears to be
a
| 32
| | bit version of the DLL.
| |
| | Eric
| |
| | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| | news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| | > Thanks for your response Eric,
| | >
| | > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| | > running 32 bit application is a global setting for all application
| pools ,
| | > so we can not make separate worker process(w3wp) running different bit
| | > applications(or loading different bit dll...). For 32 bit or 64 bit
| dll
| | > of the replication service's ISAPI filter or extension, they're
shiped
| | > with
| | > the 32 bit or 64 bit SQLServer...
| | >
| | > Regards,
| | >
| | > Steven Cheng
| | > Microsoft Online Support
| | >
| | > Get Secure! www.microsoft.com/security
| | > (This posting is provided "AS IS", with no warranties, and confers no
| | > rights.)
| | >
| | >
| | >
| | > --
| | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| | > | Subject: Re: Error When I try to browse the website for my SQL
Mobile
| | > 2005 Replication
| | > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| | > | Lines: 89
| | > | X-Priority: 3
| | > | X-MSMail-Priority: Normal
| | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | X-RFC2646: Format=Flowed; Original
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | > | Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | Well that seemed to do it. Is there any way to run 32bit apps and
| 64bit
| | > | apps on the same instance of IIS? I had to reinstall .net 2.0
32-bit
| | > | version into IIS once I made the change.
| | > |
| | > | Eric Renken
| | > |
| | > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| | > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| | > | > Hi Eric,
| | > | >
| | > | > Welcome.
| | > | > As for the problem you mentioned, based on my experience, it is
| likely
| | > a
| | > | > 32
| | > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| | > machine.
| | > | > Is
| | > | > your IIS currently configured to running as 32 bit or 64 bit and
is
| it
| | > | > running under IIS worker process isolation model or IIS5
compatible
| | > model?
| | > | > And the "%1 is not a valid Win32 application." error is likely
occur
| | > when
| | > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded
by
| 64
| | > bit
| | > | > process in IIS. Here is a kb article discussing on this:
| | > | >
| | > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit
Web
| | > | > applications in IIS 6.0
| | > | > http://support.microsoft.com/?id=895976
| | > | >
| | > | > I suggest you first check whether the IIS is configured to use
| worker
| | > | > process isolation model(applciation pool model), it's a global
| setting
| | > | > (not
| | > | > site specific) on a certain machine. then, check whether the
current
| | > IIS
| | > | > is
| | > | > running in 32 bit (WOW) or 64 bit model...
| | > | >
| | > | > Thanks,
| | > | >
| | > | > Steven Cheng
| | > | > Microsoft Online Support
| | > | >
| | > | > Get Secure! www.microsoft.com/security
| | > | > (This posting is provided "AS IS", with no warranties, and
confers
| no
| | > | > rights.)
| | > | >
| | > | >
| | > | >
| | > | > --
| | > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | > | Subject: Error When I try to browse the website for my SQL
Mobile
| | > 2005
| | > | > Replication
| | > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| | > | > | Lines: 22
| | > | > | X-Priority: 3
| | > | > | X-MSMail-Priority: Normal
| | > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | > | X-RFC2646: Format=Flowed; Original
| | > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > | > | Newsgroups: microsoft.public.sqlserver.server
| | > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net
24.11.238.51
| | > | > | Path:
| | > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | > | > | Xref: TK2MSFTNGXA02.phx.gbl
| microsoft.public.sqlserver.server:417088
| | > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > | > |
| | > | > | I tried posting this in the SQL CE group but I haven't gotten
any
| | > | > responses
| | > | > | so I am trying it here.
| | > | > |
| | > | > | When I try to browse the website:
| | > | > |
| | > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| | > | > |
| | > | > | I get this error:
| | > | > |
| | > | > | %1 is not a valid Win32 application.
| | > | > |
| | > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| | > | > permissions
| | > | > | and everything looks correct the anonymous user has READ access
| to
| | > the
| | > | > | replication folders. I even tried giving it full permissions
but
| | > that
| | > | > | didn't work either.
| | > | > |
| | > | > | Anyone have any ideas?
| | > | > |
| | > | > | Eric Renken
| | > | > |
| | > | > |
| | > | > |
| | > | > |
| | > | >
| | > |
| | > |
| | > |
| | >
| |
| |
| |
|
|

Error When I try to browse the website for my SQL Mobile 2005 Replication

I tried posting this in the SQL CE group but I haven't gotten any responses
so I am trying it here.
When I try to browse the website:
http://localhost/quickgoldmobile/sqlcesa30.dll
I get this error:
%1 is not a valid Win32 application.
This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked permissions
and everything looks correct the anonymous user has READ access to the
replication folders. I even tried giving it full permissions but that
didn't work either.
Anyone have any ideas?
Eric RenkenHi Eric,
Welcome.
As for the problem you mentioned, based on my experience, it is likely a 32
bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine. Is
your IIS currently configured to running as 32 bit or 64 bit and is it
running under IIS worker process isolation model or IIS5 compatible model?
And the "%1 is not a valid Win32 application." error is likely occur when
the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
process in IIS. Here is a kb article discussing on this:
#Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
applications in IIS 6.0
http://support.microsoft.com/?id=895976
I suggest you first check whether the IIS is configured to use worker
process isolation model(applciation pool model), it's a global setting (not
site specific) on a certain machine. then, check whether the current IIS is
running in 32 bit (WOW) or 64 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| Subject: Error When I try to browse the website for my SQL Mobile 2005
Replication
| Date: Tue, 10 Jan 2006 15:16:26 -0500
| Lines: 22
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I tried posting this in the SQL CE group but I haven't gotten any
responses
| so I am trying it here.
|
| When I try to browse the website:
|
| http://localhost/quickgoldmobile/sqlcesa30.dll
|
| I get this error:
|
| %1 is not a valid Win32 application.
|
| This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
permissions
| and everything looks correct the anonymous user has READ access to the
| replication folders. I even tried giving it full permissions but that
| didn't work either.
|
| Anyone have any ideas?
|
| Eric Renken
|
|
|
||||Well that seemed to do it. Is there any way to run 32bit apps and 64bit
apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
version into IIS once I made the change.
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>|||Is there any talk or discussion on making sqlcesa30.dll a 64-bit DLL?
Eric Renken
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hi Eric,
> Welcome.
> As for the problem you mentioned, based on my experience, it is likely a
> 32
> bit/64 bit incompatiable issue of the IIS server on yoru 64 bit machine.
> Is
> your IIS currently configured to running as 32 bit or 64 bit and is it
> running under IIS worker process isolation model or IIS5 compatible model?
> And the "%1 is not a valid Win32 application." error is likely occur when
> the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64 bit
> process in IIS. Here is a kb article discussing on this:
> #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> applications in IIS 6.0
> http://support.microsoft.com/?id=895976
> I suggest you first check whether the IIS is configured to use worker
> process isolation model(applciation pool model), it's a global setting
> (not
> site specific) on a certain machine. then, check whether the current IIS
> is
> running in 32 bit (WOW) or 64 bit model...
> Thanks,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | Subject: Error When I try to browse the website for my SQL Mobile 2005
> Replication
> | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | Lines: 22
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I tried posting this in the SQL CE group but I haven't gotten any
> responses
> | so I am trying it here.
> |
> | When I try to browse the website:
> |
> | http://localhost/quickgoldmobile/sqlcesa30.dll
> |
> | I get this error:
> |
> | %1 is not a valid Win32 application.
> |
> | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> permissions
> | and everything looks correct the anonymous user has READ access to the
> | replication folders. I even tried giving it full permissions but that
> | didn't work either.
> |
> | Anyone have any ideas?
> |
> | Eric Renken
> |
> |
> |
> |
>|||Thanks for your response Eric,
For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
running 32 bit application is a global setting for all application pools ,
so we can not make separate worker process(w3wp) running different bit
applications(or loading different bit dll...). For 32 bit or 64 bit dll
of the replication service's ISAPI filter or extension, they're shiped with
the 32 bit or 64 bit SQLServer...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Wed, 11 Jan 2006 19:14:16 -0500
| Lines: 89
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Well that seemed to do it. Is there any way to run 32bit apps and 64bit
| apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| version into IIS once I made the change.
|
| Eric Renken
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > Hi Eric,
| >
| > Welcome.
| > As for the problem you mentioned, based on my experience, it is likely
a
| > 32
| > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
machine.
| > Is
| > your IIS currently configured to running as 32 bit or 64 bit and is it
| > running under IIS worker process isolation model or IIS5 compatible
model?
| > And the "%1 is not a valid Win32 application." error is likely occur
when
| > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
bit
| > process in IIS. Here is a kb article discussing on this:
| >
| > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > applications in IIS 6.0
| > http://support.microsoft.com/?id=895976
| >
| > I suggest you first check whether the IIS is configured to use worker
| > process isolation model(applciation pool model), it's a global setting
| > (not
| > site specific) on a certain machine. then, check whether the current
IIS
| > is
| > running in 32 bit (WOW) or 64 bit model...
| >
| > Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | Subject: Error When I try to browse the website for my SQL Mobile 2005
| > Replication
| > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | Lines: 22
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I tried posting this in the SQL CE group but I haven't gotten any
| > responses
| > | so I am trying it here.
| > |
| > | When I try to browse the website:
| > |
| > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > |
| > | I get this error:
| > |
| > | %1 is not a valid Win32 application.
| > |
| > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > permissions
| > | and everything looks correct the anonymous user has READ access to the
| > | replication folders. I even tried giving it full permissions but that
| > | didn't work either.
| > |
| > | Anyone have any ideas?
| > |
| > | Eric Renken
| > |
| > |
| > |
| > |
| >
|
|
||||I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
2005 SQL server running. The MSI install for SQL Mobile sqlce30setupen.msi
was only installed with my Visual Studio install and that appears to be a 32
bit version of the DLL.
Eric
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
> Thanks for your response Eric,
> For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
> running 32 bit application is a global setting for all application pools ,
> so we can not make separate worker process(w3wp) running different bit
> applications(or loading different bit dll...). For 32 bit or 64 bit dll
> of the replication service's ISAPI filter or extension, they're shiped
> with
> the 32 bit or 64 bit SQLServer...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
> --
> | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
> | Subject: Re: Error When I try to browse the website for my SQL Mobile
> 2005 Replication
> | Date: Wed, 11 Jan 2006 19:14:16 -0500
> | Lines: 89
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | Well that seemed to do it. Is there any way to run 32bit apps and 64bit
> | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
> | version into IIS once I made the change.
> |
> | Eric Renken
> |
> | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> | > Hi Eric,
> | >
> | > Welcome.
> | > As for the problem you mentioned, based on my experience, it is likely
> a
> | > 32
> | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
> machine.
> | > Is
> | > your IIS currently configured to running as 32 bit or 64 bit and is it
> | > running under IIS worker process isolation model or IIS5 compatible
> model?
> | > And the "%1 is not a valid Win32 application." error is likely occur
> when
> | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by 64
> bit
> | > process in IIS. Here is a kb article discussing on this:
> | >
> | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
> | > applications in IIS 6.0
> | > http://support.microsoft.com/?id=895976
> | >
> | > I suggest you first check whether the IIS is configured to use worker
> | > process isolation model(applciation pool model), it's a global setting
> | > (not
> | > site specific) on a certain machine. then, check whether the current
> IIS
> | > is
> | > running in 32 bit (WOW) or 64 bit model...
> | >
> | > Thanks,
> | >
> | > Steven Cheng
> | > Microsoft Online Support
> | >
> | > Get Secure! www.microsoft.com/security
> | > (This posting is provided "AS IS", with no warranties, and confers no
> | > rights.)
> | >
> | >
> | >
> | > --
> | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
> | > | Subject: Error When I try to browse the website for my SQL Mobile
> 2005
> | > Replication
> | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
> | > | Lines: 22
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | > | X-RFC2646: Format=Flowed; Original
> | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.server
> | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
> | > | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
> | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417088
> | > | X-Tomcat-NG: microsoft.public.sqlserver.server
> | > |
> | > | I tried posting this in the SQL CE group but I haven't gotten any
> | > responses
> | > | so I am trying it here.
> | > |
> | > | When I try to browse the website:
> | > |
> | > | http://localhost/quickgoldmobile/sqlcesa30.dll
> | > |
> | > | I get this error:
> | > |
> | > | %1 is not a valid Win32 application.
> | > |
> | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
> | > permissions
> | > | and everything looks correct the anonymous user has READ access to
> the
> | > | replication folders. I even tried giving it full permissions but
> that
> | > | didn't work either.
> | > |
> | > | Anyone have any ideas?
> | > |
> | > | Eric Renken
> | > |
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Thanks for your response Eric,
I'll do some further research to check whether there is 64 bit version of
the sqlce's replication web component(dll). Also, so far we can confirm
that 32 bit or 64 bit component can not work side by side in IIS6(on 64 bit
machine), only one can be configured to use at one certain time...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| Date: Thu, 12 Jan 2006 14:27:01 -0500
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I didn't see the 64bit DLL at all with the 64 bit SQL server. I have SQL
| 2005 SQL server running. The MSI install for SQL Mobile
sqlce30setupen.msi
| was only installed with my Visual Studio install and that appears to be a
32
| bit version of the DLL.
|
| Eric
|
| "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| > Thanks for your response Eric,
| >
| > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| > running 32 bit application is a global setting for all application
pools ,
| > so we can not make separate worker process(w3wp) running different bit
| > applications(or loading different bit dll...). For 32 bit or 64 bit
dll
| > of the replication service's ISAPI filter or extension, they're shiped
| > with
| > the 32 bit or 64 bit SQLServer...
| >
| > Regards,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --
| > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| > | Subject: Re: Error When I try to browse the website for my SQL Mobile
| > 2005 Replication
| > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| > | Lines: 89
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | Well that seemed to do it. Is there any way to run 32bit apps and
64bit
| > | apps on the same instance of IIS? I had to reinstall .net 2.0 32-bit
| > | version into IIS once I made the change.
| > |
| > | Eric Renken
| > |
| > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in messa
ge
| > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| > | > Hi Eric,
| > | >
| > | > Welcome.
| > | > As for the problem you mentioned, based on my experience, it is
likely
| > a
| > | > 32
| > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| > machine.
| > | > Is
| > | > your IIS currently configured to running as 32 bit or 64 bit and is
it
| > | > running under IIS worker process isolation model or IIS5 compatible
| > model?
| > | > And the "%1 is not a valid Win32 application." error is likely occur
| > when
| > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded by
64
| > bit
| > | > process in IIS. Here is a kb article discussing on this:
| > | >
| > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit Web
| > | > applications in IIS 6.0
| > | > http://support.microsoft.com/?id=895976
| > | >
| > | > I suggest you first check whether the IIS is configured to use
worker
| > | > process isolation model(applciation pool model), it's a global
setting
| > | > (not
| > | > site specific) on a certain machine. then, check whether the current
| > IIS
| > | > is
| > | > running in 32 bit (WOW) or 64 bit model...
| > | >
| > | > Thanks,
| > | >
| > | > Steven Cheng
| > | > Microsoft Online Support
| > | >
| > | > Get Secure! www.microsoft.com/security
| > | > (This posting is provided "AS IS", with no warranties, and confers
no
| > | > rights.)
| > | >
| > | >
| > | >
| > | > --
| > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| > | > | Subject: Error When I try to browse the website for my SQL Mobile
| > 2005
| > | > Replication
| > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| > | > | Lines: 22
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | > | X-RFC2646: Format=Flowed; Original
| > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.server
| > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| > | > | Path:
| > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.server:417088
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > | > |
| > | > | I tried posting this in the SQL CE group but I haven't gotten any
| > | > responses
| > | > | so I am trying it here.
| > | > |
| > | > | When I try to browse the website:
| > | > |
| > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| > | > |
| > | > | I get this error:
| > | > |
| > | > | %1 is not a valid Win32 application.
| > | > |
| > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| > | > permissions
| > | > | and everything looks correct the anonymous user has READ access
to
| > the
| > | > | replication folders. I even tried giving it full permissions but
| > that
| > | > | didn't work either.
| > | > |
| > | > | Anyone have any ideas?
| > | > |
| > | > | Eric Renken
| > | > |
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
||||Hi Eric,
I've confirmed with SQL guys and so far since the SQLServre Mobile only
shiped the 32 bit ones so the server tools also limited to 32bit. So we
have to configure server tools on a server of 32 bit OS or can be
configured for running IIS under 32 bit model...
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| X-Tomcat-ID: 200169184
| References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
<OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
<FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
<u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: stcheng@.online.microsoft.com (Steven Cheng[MSFT])
| Organization: Microsoft
| Date: Fri, 13 Jan 2006 10:21:35 GMT
| Subject: Re: Error When I try to browse the website for my SQL Mobile
2005 Replication
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <szG6rsCGGHA.3944@.TK2MSFTNGXA02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 180
| Path: TK2MSFTNGXA02.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417487
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Thanks for your response Eric,
|
| I'll do some further research to check whether there is 64 bit version of
| the sqlce's replication web component(dll). Also, so far we can confirm
| that 32 bit or 64 bit component can not work side by side in IIS6(on 64
bit
| machine), only one can be configured to use at one certain time...
|
| Thanks,
|
| Steven Cheng
| Microsoft Online Support
|
| Get Secure! www.microsoft.com/security
| (This posting is provided "AS IS", with no warranties, and confers no
| rights.)
| --
| | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| <FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl>
| | Subject: Re: Error When I try to browse the website for my SQL Mobile
| 2005 Replication
| | Date: Thu, 12 Jan 2006 14:27:01 -0500
| | Lines: 153
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | Message-ID: <u2pXr46FGHA.3864@.tk2msftngp13.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417409
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | I didn't see the 64bit DLL at all with the 64 bit SQL server. I have
SQL
| | 2005 SQL server running. The MSI install for SQL Mobile
| sqlce30setupen.msi
| | was only installed with my Visual Studio install and that appears to be
a
| 32
| | bit version of the DLL.
| |
| | Eric
| |
| | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
| | news:FjnW37zFGHA.3680@.TK2MSFTNGXA02.phx.gbl...
| | > Thanks for your response Eric,
| | >
| | > For the IIS6 on 64 bit machine, the Enable32bitAppOnWin64 setting for
| | > running 32 bit application is a global setting for all application
| pools ,
| | > so we can not make separate worker process(w3wp) running different bit
| | > applications(or loading different bit dll...). For 32 bit or 64 bit
| dll
| | > of the replication service's ISAPI filter or extension, they're
shiped
| | > with
| | > the 32 bit or 64 bit SQLServer...
| | >
| | > Regards,
| | >
| | > Steven Cheng
| | > Microsoft Online Support
| | >
| | > Get Secure! www.microsoft.com/security
| | > (This posting is provided "AS IS", with no warranties, and confers no
| | > rights.)
| | >
| | >
| | >
| | > --
| | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | References: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > <OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl>
| | > | Subject: Re: Error When I try to browse the website for my SQL
Mobile
| | > 2005 Replication
| | > | Date: Wed, 11 Jan 2006 19:14:16 -0500
| | > | Lines: 89
| | > | X-Priority: 3
| | > | X-MSMail-Priority: Normal
| | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | X-RFC2646: Format=Flowed; Original
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | Message-ID: <Oq9Hh0wFGHA.140@.TK2MSFTNGP12.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net 24.11.238.51
| | > | Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | > | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417295
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | Well that seemed to do it. Is there any way to run 32bit apps and
| 64bit
| | > | apps on the same instance of IIS? I had to reinstall .net 2.0
32-bit
| | > | version into IIS once I made the change.
| | > |
| | > | Eric Renken
| | > |
| | > | "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in mes
sage
| | > | news:OeWLMtnFGHA.3696@.TK2MSFTNGXA02.phx.gbl...
| | > | > Hi Eric,
| | > | >
| | > | > Welcome.
| | > | > As for the problem you mentioned, based on my experience, it is
| likely
| | > a
| | > | > 32
| | > | > bit/64 bit incompatiable issue of the IIS server on yoru 64 bit
| | > machine.
| | > | > Is
| | > | > your IIS currently configured to running as 32 bit or 64 bit and
is
| it
| | > | > running under IIS worker process isolation model or IIS5
compatible
| | > model?
| | > | > And the "%1 is not a valid Win32 application." error is likely
occur
| | > when
| | > | > the 64 bit dll is loaded by 32 bit process or 32 bit dll loaded
by
| 64
| | > bit
| | > | > process in IIS. Here is a kb article discussing on this:
| | > | >
| | > | > #Windows Server 2003 SP1 enables WOW64 compatibility for 32-bit
Web
| | > | > applications in IIS 6.0
| | > | > http://support.microsoft.com/?id=895976
| | > | >
| | > | > I suggest you first check whether the IIS is configured to use
| worker
| | > | > process isolation model(applciation pool model), it's a global
| setting
| | > | > (not
| | > | > site specific) on a certain machine. then, check whether the
current
| | > IIS
| | > | > is
| | > | > running in 32 bit (WOW) or 64 bit model...
| | > | >
| | > | > Thanks,
| | > | >
| | > | > Steven Cheng
| | > | > Microsoft Online Support
| | > | >
| | > | > Get Secure! www.microsoft.com/security
| | > | > (This posting is provided "AS IS", with no warranties, and
confers
| no
| | > | > rights.)
| | > | >
| | > | >
| | > | >
| | > | > --
| | > | > | From: "Eric Renken" <EricRRenken@.newsgroup.nospam>
| | > | > | Subject: Error When I try to browse the website for my SQL
Mobile
| | > 2005
| | > | > Replication
| | > | > | Date: Tue, 10 Jan 2006 15:16:26 -0500
| | > | > | Lines: 22
| | > | > | X-Priority: 3
| | > | > | X-MSMail-Priority: Normal
| | > | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| | > | > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| | > | > | X-RFC2646: Format=Flowed; Original
| | > | > | Message-ID: <#F6hFLiFGHA.3176@.TK2MSFTNGP12.phx.gbl>
| | > | > | Newsgroups: microsoft.public.sqlserver.server
| | > | > | NNTP-Posting-Host: c-24-11-238-51.hsd1.mi.comcast.net
24.11.238.51
| | > | > | Path:
| | > TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| | > | > | Xref: TK2MSFTNGXA02.phx.gbl
| microsoft.public.sqlserver.server:417088
| | > | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > | > |
| | > | > | I tried posting this in the SQL CE group but I haven't gotten
any
| | > | > responses
| | > | > | so I am trying it here.
| | > | > |
| | > | > | When I try to browse the website:
| | > | > |
| | > | > | http://localhost/quickgoldmobile/sqlcesa30.dll
| | > | > |
| | > | > | I get this error:
| | > | > |
| | > | > | %1 is not a valid Win32 application.
| | > | > |
| | > | > | This is SQL 2005 x64 running on Windows 2003 SP1 x64. I checked
| | > | > permissions
| | > | > | and everything looks correct the anonymous user has READ access
| to
| | > the
| | > | > | replication folders. I even tried giving it full permissions
but
| | > that
| | > | > | didn't work either.
| | > | > |
| | > | > | Anyone have any ideas?
| | > | > |
| | > | > | Eric Renken
| | > | > |
| | > | > |
| | > | > |
| | > | > |
| | > | >
| | > |
| | > |
| | > |
| | >
| |
| |
| |
|
|