Showing posts with label vbnet. Show all posts
Showing posts with label vbnet. Show all posts

Monday, March 19, 2012

Deploying vb.net english query application

Hi,
I'm attempting to distribute a vb.net english query application to a
client, however, when the client runs the application, it crahses when
it tries to create an instance of the "Mseq.Session" object.
As far as I can tell, the interop and the original dll are being
included in the setup correctly - are there any special settings (such
as com registration, system etc), or other files that I should be
including? Or are there any other prerequisits for the client's pc
before I can expect the software to run?
Cheers,
Tinium.
you are still going to need to install the EQ engine on the target
platform.. There's an awful lot of work done by the engine before the query
is shipped off the Server. EQ is a client function..
Guy
"Tinium" <tin@.ium.com> wrote in message
news:eWfltpaQFHA.132@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm attempting to distribute a vb.net english query application to a
> client, however, when the client runs the application, it crahses when it
> tries to create an instance of the "Mseq.Session" object.
> As far as I can tell, the interop and the original dll are being included
> in the setup correctly - are there any special settings (such as com
> registration, system etc), or other files that I should be including? Or
> are there any other prerequisits for the client's pc before I can expect
> the software to run?
> Cheers,
> Tinium.

Friday, March 9, 2012

Deploying from VB.NET Report Designer to Report Server fails

quote:

>--Original Message--
>I would like to know what protocol / port Report Designer

uses when performing the "Deploy " function from the IDE
of Report Designer. For some reason it cannot connect with
the report server. I can browse the /rs/reportserver
directory and can upload the RDL file through the IE.
quote:

>This is probably some kind of security related issue, but

I need to know what to look for...
quote:

>Thanks
>.
>

I believe reporting services-type issues should be posted
here; microsoft.public.sqlserver.reportingsvcs (although
to be fair the newsgroup isn't available via the HTML
viewer).
Having said that, when you 'deploy' an RS report all its
doing is posting XML (ie the RDL) to a web site (in this
case a web service) so the protocol is HTTP and the port
is usually 80. The fact that you can browse to the
directory and upload using the Report Manager suggests to
me that the problem is with your VS config. In the report
project properties check that you've set
the 'TargetServerURL' for the RS web service correctly.Thank you for your comment. The TargetServerURL is correct. It was working u
ntil the headquarters IT changed some kind of security policy, blocking spec
ific ports. I do not know thus which port the Report Server is listening for
the RDL files.
Thanks.
MP|||The Report Server is a web service so it is listening on port 80. Can you
connect to the URL directly? We should move the discussion over to the
reporting services newsgroup.
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Minas Papageorgiou" <anonymous@.discussions.microsoft.com> wrote in message
news:92DC3C18-5F09-4366-AA80-38DE26B879E9@.microsoft.com...
> Thank you for your comment. The TargetServerURL is correct. It was working
until the headquarters IT changed some kind of security policy, blocking
specific ports. I do not know thus which port the Report Server is listening
for the RDL files.
> Thanks.
> MP
>|||I'm having the same problem.. I can browse to the target url fine, but I ca
n't deploy from IDE. I can open a browser and upload the RDL through the we
b interface from the same machine. I've verified target URL is correct. I
can't find any mesages in t
he client event log or the server event log indicating what the problem migh
t be... suggestions?|||What is the message you get in the Report Designer? Are you using HTTP or
HTTPS?
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:4F51D39A-BEAC-43AB-817A-D894CBB0A74E@.microsoft.com...
> I'm having the same problem.. I can browse to the target url fine, but I
can't deploy from IDE. I can open a browser and upload the RDL through the
web interface from the same machine. I've verified target URL is correct.
I can't find any mesages in the client event log or the server event log
indicating what the problem might be... suggestions?

Saturday, February 25, 2012

Deploy VB.Net application with SQL Database

Hello,
I have an application with SQL data. I want to deploy this application with
data. How can I ?
Harsha
Harsha,
presumably you are talking about deploying publications/subscriptions? If
so, have a look at some of these scripts:
http://www.replicationanswers.com/Scripts.asp
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Because the To: list is so large perhaps you may be able to use
BACKUP/RESTORE?

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OLaoZEKdFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Harsha,
> presumably you are talking about deploying publications/subscriptions? If
> so, have a look at some of these scripts:
> http://www.replicationanswers.com/Scripts.asp
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||I just use Detach / Attach. Include the database in the distribution (not in
the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it. Very fast and simple
as the 'issue' database is copied directly off the CD once to the required
location then attached. Only issue with this is if you want to specify the
location of the ldb file, but thats easy enough.
- Tim
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||Another method is to create the database, objects and data using SQL
scripts. We use this technique in our application installers with
source-controlled scripts and it works quite nicely, especially when time
comes to upgrade our clients to a new version while retaining existing
customer data.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||FIX YOUR CLOCK
|||Tim wrote :
> I just use Detach / Attach. Include the database in the distribution (not
in the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it.
Harsha wrote :
Thank you for your reply.
Please kindly explain me in brief how detach/atach works.
Harsha.
|||http://msdn.microsoft.com/library/en...da-di_83fm.asp
http://msdn.microsoft.com/library/en...ae-az_52oy.asp
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:espsmYXdFHA.796@.TK2MSFTNGP09.phx.gbl...
> Tim wrote :
> in the MSI) and have an application that Moves the database (if a move is
> required) to a user choice location then attaches it.
> --
> Harsha wrote :
> Thank you for your reply.
> Please kindly explain me in brief how detach/atach works.
> Harsha.
>
|||test
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
with
> data. How can I ?
>
> Harsha
>
>
|||hi Harsha,
Harsha Shah wrote:
> Hello,
> I have an application with SQL data. I want to deploy this
> application with data. How can I ?
>
have a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Deploy VB.Net application with SQL Database

Hello,
I have an application with SQL data. I want to deploy this application with
data. How can I ?
Harsha
Harsha,
presumably you are talking about deploying publications/subscriptions? If
so, have a look at some of these scripts:
http://www.replicationanswers.com/Scripts.asp
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Because the To: list is so large perhaps you may be able to use
BACKUP/RESTORE?

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OLaoZEKdFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Harsha,
> presumably you are talking about deploying publications/subscriptions? If
> so, have a look at some of these scripts:
> http://www.replicationanswers.com/Scripts.asp
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||I just use Detach / Attach. Include the database in the distribution (not in
the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it. Very fast and simple
as the 'issue' database is copied directly off the CD once to the required
location then attached. Only issue with this is if you want to specify the
location of the ldb file, but thats easy enough.
- Tim
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||Another method is to create the database, objects and data using SQL
scripts. We use this technique in our application installers with
source-controlled scripts and it works quite nicely, especially when time
comes to upgrade our clients to a new version while retaining existing
customer data.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||FIX YOUR CLOCK
|||Tim wrote :
> I just use Detach / Attach. Include the database in the distribution (not
in the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it.
Harsha wrote :
Thank you for your reply.
Please kindly explain me in brief how detach/atach works.
Harsha.
|||http://msdn.microsoft.com/library/en...da-di_83fm.asp
http://msdn.microsoft.com/library/en...ae-az_52oy.asp
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:espsmYXdFHA.796@.TK2MSFTNGP09.phx.gbl...
> Tim wrote :
> in the MSI) and have an application that Moves the database (if a move is
> required) to a user choice location then attaches it.
> --
> Harsha wrote :
> Thank you for your reply.
> Please kindly explain me in brief how detach/atach works.
> Harsha.
>
|||test
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
with
> data. How can I ?
>
> Harsha
>
>
|||hi Harsha,
Harsha Shah wrote:
> Hello,
> I have an application with SQL data. I want to deploy this
> application with data. How can I ?
>
have a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply