Hi K.Babu!
This is Ramesh and i have a qury for u,i have developed a DLL in VB and registered it for usein asp and vb and i aslo want to make use of this DLL in Crystal Reports without VB/ASp as Interface for Reports
Please tell me how to call the functions written in DLL in Crystal Reports directly
i have put my DLL in the directory where other Crystal Reports DLL are and registered but dont know how to call this dll in reports
Waiting for ur reply soonHi,
You need to have your DLL name start with CRUFLxxxx where xxxx is the rest of the DLL name i.e. CRUFLmyStuff.DLL, then copy into Crystal dir and then register from DOS prompt with: -
regsvr32 c:\winnt\crystal\CRUFLmyStuff.DLL)
after this restart CR and you should find your DLL function's from
formula workshop / functions / additional functions / Visual Basic UFL's and there should be your DLL functions.
If this don't work check out Crystals white paper SCR_User_Defined_Functions.pdf
good luck!|||Hello mramesh73,
Just curious to know whether phil's resolution helped. I have plans of creating dll for the same purpose down the road.
Thanks
Showing posts with label developed. Show all posts
Showing posts with label developed. Show all posts
Sunday, March 11, 2012
Dll error
Hello,
I have developed an vb.net windows application, which uses SQLXMLBulkload3class. For this, I added references to Microsoft SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe in my development pc. While building windows installer
(package and deployment) through setupwizard, says "cannot automatically detect dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that, went ahead and built the WindowsInstaller i.e. msi file. In the target pc, I installed .net framew
ork first and while installing the application package got an error "xblkld3.dll failed to register. HRESULT-2147023782." still went ahead and installed the application. Says "COM object with CLSID{.....} is either not valid or not registered" when it c
omes to SQLXMLBulkload module. Anything should I add in the references? Or Install any components or missing any dlls? Pls. Help me.
Thanks for all your help.
Rgds,
Padmaja.
Suggested way to redistribute SQLXML is to ask the user install SQLXML
themselves. The installer is available from MSDN.
FYI, these are the dependencies for SQLXML
a.. This release is installed using the Microsoft Windows Installer 2.0. You
might need to upgrade your installer to Windows Installer 2.0 prior to
installing SQLXML 3.0.
a.. SQLXML requires Microsoft SOAP Toolkit 2.0 to be installed to run Web
Services. Users not using Microsoft Windows XP must download the toolkit to
use Web Services.
a.. MDAC 2.6 or later must be installed before the installation can be run.
a.. This release also has a dependency on MSXML version 4.0 SP2. This
version of MSXML is included with the download.
Soap toolkit is not needed for SQLXML Bulkload (xblkld3.dll)
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Padmaja" <anonymous@.discussions.microsoft.com> wrote in message
news:796EAED4-E157-44B7-BE52-8B0F6A73F2EC@.microsoft.com...
> Hello,
> I have developed an vb.net windows application, which uses
SQLXMLBulkload3class. For this, I added references to Microsoft
SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe
in my development pc. While building windows installer (package and
deployment) through setupwizard, says "cannot automatically detect
dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that,
went ahead and built the WindowsInstaller i.e. msi file. In the target pc,
I installed .net framework first and while installing the application
package got an error "xblkld3.dll failed to register. HRESULT-2147023782."
still went ahead and installed the application. Says "COM object with
CLSID{.....} is either not valid or not registered" when it comes to
SQLXMLBulkload module. Anything should I add in the references? Or Install
any components or missing any dlls? Pls. Help me.
> Thanks for all your help.
> Rgds,
> Padmaja.
>
|||I checked for SQLXML SP3 & MDAC 2.7. They are already installed. I am getting the error of 'not detecting the dependencies' while building the windows installer. Any help is appreciated.
|||I checked for SQLXML and MDAC2.7. They are already installed. I am getting the error of 'cannot automatically detect dependencies xblkld3.dll' while creating windows installer. Any help is appreciated.
Thanks,
Padmaja.
I have developed an vb.net windows application, which uses SQLXMLBulkload3class. For this, I added references to Microsoft SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe in my development pc. While building windows installer
(package and deployment) through setupwizard, says "cannot automatically detect dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that, went ahead and built the WindowsInstaller i.e. msi file. In the target pc, I installed .net framew
ork first and while installing the application package got an error "xblkld3.dll failed to register. HRESULT-2147023782." still went ahead and installed the application. Says "COM object with CLSID{.....} is either not valid or not registered" when it c
omes to SQLXMLBulkload module. Anything should I add in the references? Or Install any components or missing any dlls? Pls. Help me.
Thanks for all your help.
Rgds,
Padmaja.
Suggested way to redistribute SQLXML is to ask the user install SQLXML
themselves. The installer is available from MSDN.
FYI, these are the dependencies for SQLXML
a.. This release is installed using the Microsoft Windows Installer 2.0. You
might need to upgrade your installer to Windows Installer 2.0 prior to
installing SQLXML 3.0.
a.. SQLXML requires Microsoft SOAP Toolkit 2.0 to be installed to run Web
Services. Users not using Microsoft Windows XP must download the toolkit to
use Web Services.
a.. MDAC 2.6 or later must be installed before the installation can be run.
a.. This release also has a dependency on MSXML version 4.0 SP2. This
version of MSXML is included with the download.
Soap toolkit is not needed for SQLXML Bulkload (xblkld3.dll)
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Padmaja" <anonymous@.discussions.microsoft.com> wrote in message
news:796EAED4-E157-44B7-BE52-8B0F6A73F2EC@.microsoft.com...
> Hello,
> I have developed an vb.net windows application, which uses
SQLXMLBulkload3class. For this, I added references to Microsoft
SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe
in my development pc. While building windows installer (package and
deployment) through setupwizard, says "cannot automatically detect
dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that,
went ahead and built the WindowsInstaller i.e. msi file. In the target pc,
I installed .net framework first and while installing the application
package got an error "xblkld3.dll failed to register. HRESULT-2147023782."
still went ahead and installed the application. Says "COM object with
CLSID{.....} is either not valid or not registered" when it comes to
SQLXMLBulkload module. Anything should I add in the references? Or Install
any components or missing any dlls? Pls. Help me.
> Thanks for all your help.
> Rgds,
> Padmaja.
>
|||I checked for SQLXML SP3 & MDAC 2.7. They are already installed. I am getting the error of 'not detecting the dependencies' while building the windows installer. Any help is appreciated.
|||I checked for SQLXML and MDAC2.7. They are already installed. I am getting the error of 'cannot automatically detect dependencies xblkld3.dll' while creating windows installer. Any help is appreciated.
Thanks,
Padmaja.
Wednesday, March 7, 2012
Distribution server restore on standby server
Hi,
we have developed an application using transactional replication, with
several publication servers (push) and a distribution server (which is
the only subscriber too). It seems to work fine.
Now we would "protect" the distribution/subscriber server by using a
standby server (note: only the distribution/subscriver server must be
protected, not publication servers) which should replace the working
server in the case it crashes.
Could someone suggest us the best strategy to do this? Thanks in
advance...
Marco
You can manually set this up. Have a look at Strategies for Backing Up and
Restoring Transactional Replication in BOL.
The problem is that this adds to the latency. Transactions remain in your
tlog until the log is dumped. Then they are read from the tlog and written
to the distirbution database.
"Marco69" <marcosindona@.virgilio.it> wrote in message
news:ce7beb14.0403250541.5f374a8f@.posting.google.c om...
> Hi,
> we have developed an application using transactional replication, with
> several publication servers (push) and a distribution server (which is
> the only subscriber too). It seems to work fine.
> Now we would "protect" the distribution/subscriber server by using a
> standby server (note: only the distribution/subscriver server must be
> protected, not publication servers) which should replace the working
> server in the case it crashes.
> Could someone suggest us the best strategy to do this? Thanks in
> advance...
> Marco
we have developed an application using transactional replication, with
several publication servers (push) and a distribution server (which is
the only subscriber too). It seems to work fine.
Now we would "protect" the distribution/subscriber server by using a
standby server (note: only the distribution/subscriver server must be
protected, not publication servers) which should replace the working
server in the case it crashes.
Could someone suggest us the best strategy to do this? Thanks in
advance...
Marco
You can manually set this up. Have a look at Strategies for Backing Up and
Restoring Transactional Replication in BOL.
The problem is that this adds to the latency. Transactions remain in your
tlog until the log is dumped. Then they are read from the tlog and written
to the distirbution database.
"Marco69" <marcosindona@.virgilio.it> wrote in message
news:ce7beb14.0403250541.5f374a8f@.posting.google.c om...
> Hi,
> we have developed an application using transactional replication, with
> several publication servers (push) and a distribution server (which is
> the only subscriber too). It seems to work fine.
> Now we would "protect" the distribution/subscriber server by using a
> standby server (note: only the distribution/subscriver server must be
> protected, not publication servers) which should replace the working
> server in the case it crashes.
> Could someone suggest us the best strategy to do this? Thanks in
> advance...
> Marco
Sunday, February 19, 2012
Distributing Data with an App
I have developed an application which will be distributed. I know how to
create a SQL script which will create the table structure for the DB. Is
there an easy/recommended way to export the default data from my tables in a
way which will be easy and/or automatic for the installer to load into their
DB after the tables are created?
I could write C# into my app which will notice empty tables and populate
them but this seems tedious. Is there a better way?
thanks
charles
You could BCP or BULK COPY your data or you could create insert statements
with a tool like one of these:
ObjectScripter -- http://www.rac4sql.net/
QALite -- http://www.rac4sql.net/
Lockwood Tech -- http://www.lockwoodtech.com/
Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
construction at the moment)
Keith
"charles" <spam@.synthigence.com> wrote in message
news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> I have developed an application which will be distributed. I know how to
> create a SQL script which will create the table structure for the DB. Is
> there an easy/recommended way to export the default data from my tables in
a
> way which will be easy and/or automatic for the installer to load into
their
> DB after the tables are created?
> I could write C# into my app which will notice empty tables and populate
> them but this seems tedious. Is there a better way?
> thanks
> charles
>
|||Thank you so much... QALite looks like it does exactly what I need,
creating a SQL INSERTs script from my existing data
charles
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:epWH5BBnEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You could BCP or BULK COPY your data or you could create insert statements
> with a tool like one of these:
> ObjectScripter -- http://www.rac4sql.net/
> QALite -- http://www.rac4sql.net/
> Lockwood Tech -- http://www.lockwoodtech.com/
> Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
> construction at the moment)
> --
> Keith
>
> "charles" <spam@.synthigence.com> wrote in message
> news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
Is[vbcol=seagreen]
in
> a
> their
>
create a SQL script which will create the table structure for the DB. Is
there an easy/recommended way to export the default data from my tables in a
way which will be easy and/or automatic for the installer to load into their
DB after the tables are created?
I could write C# into my app which will notice empty tables and populate
them but this seems tedious. Is there a better way?
thanks
charles
You could BCP or BULK COPY your data or you could create insert statements
with a tool like one of these:
ObjectScripter -- http://www.rac4sql.net/
QALite -- http://www.rac4sql.net/
Lockwood Tech -- http://www.lockwoodtech.com/
Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
construction at the moment)
Keith
"charles" <spam@.synthigence.com> wrote in message
news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> I have developed an application which will be distributed. I know how to
> create a SQL script which will create the table structure for the DB. Is
> there an easy/recommended way to export the default data from my tables in
a
> way which will be easy and/or automatic for the installer to load into
their
> DB after the tables are created?
> I could write C# into my app which will notice empty tables and populate
> them but this seems tedious. Is there a better way?
> thanks
> charles
>
|||Thank you so much... QALite looks like it does exactly what I need,
creating a SQL INSERTs script from my existing data
charles
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:epWH5BBnEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You could BCP or BULK COPY your data or you could create insert statements
> with a tool like one of these:
> ObjectScripter -- http://www.rac4sql.net/
> QALite -- http://www.rac4sql.net/
> Lockwood Tech -- http://www.lockwoodtech.com/
> Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
> construction at the moment)
> --
> Keith
>
> "charles" <spam@.synthigence.com> wrote in message
> news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
Is[vbcol=seagreen]
in
> a
> their
>
Distributing Data with an App
I have developed an application which will be distributed. I know how to
create a SQL script which will create the table structure for the DB. Is
there an easy/recommended way to export the default data from my tables in a
way which will be easy and/or automatic for the installer to load into their
DB after the tables are created?
I could write C# into my app which will notice empty tables and populate
them but this seems tedious. Is there a better way?
thanks
charlesYou could BCP or BULK COPY your data or you could create insert statements
with a tool like one of these:
ObjectScripter -- http://www.rac4sql.net/
QALite -- http://www.rac4sql.net/
Lockwood Tech -- http://www.lockwoodtech.com/
Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
construction at the moment)
--
Keith
"charles" <spam@.synthigence.com> wrote in message
news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> I have developed an application which will be distributed. I know how to
> create a SQL script which will create the table structure for the DB. Is
> there an easy/recommended way to export the default data from my tables in
a
> way which will be easy and/or automatic for the installer to load into
their
> DB after the tables are created?
> I could write C# into my app which will notice empty tables and populate
> them but this seems tedious. Is there a better way?
> thanks
> charles
>|||Thank you so much... QALite looks like it does exactly what I need,
creating a SQL INSERTs script from my existing data
charles
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:epWH5BBnEHA.3472@.TK2MSFTNGP09.phx.gbl...
> You could BCP or BULK COPY your data or you could create insert statements
> with a tool like one of these:
> ObjectScripter -- http://www.rac4sql.net/
> QALite -- http://www.rac4sql.net/
> Lockwood Tech -- http://www.lockwoodtech.com/
> Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
> construction at the moment)
> --
> Keith
>
> "charles" <spam@.synthigence.com> wrote in message
> news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> > I have developed an application which will be distributed. I know how
to
> > create a SQL script which will create the table structure for the DB.
Is
> > there an easy/recommended way to export the default data from my tables
in
> a
> > way which will be easy and/or automatic for the installer to load into
> their
> > DB after the tables are created?
> >
> > I could write C# into my app which will notice empty tables and populate
> > them but this seems tedious. Is there a better way?
> >
> > thanks
> > charles
> >
> >
>
create a SQL script which will create the table structure for the DB. Is
there an easy/recommended way to export the default data from my tables in a
way which will be easy and/or automatic for the installer to load into their
DB after the tables are created?
I could write C# into my app which will notice empty tables and populate
them but this seems tedious. Is there a better way?
thanks
charlesYou could BCP or BULK COPY your data or you could create insert statements
with a tool like one of these:
ObjectScripter -- http://www.rac4sql.net/
QALite -- http://www.rac4sql.net/
Lockwood Tech -- http://www.lockwoodtech.com/
Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
construction at the moment)
--
Keith
"charles" <spam@.synthigence.com> wrote in message
news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> I have developed an application which will be distributed. I know how to
> create a SQL script which will create the table structure for the DB. Is
> there an easy/recommended way to export the default data from my tables in
a
> way which will be easy and/or automatic for the installer to load into
their
> DB after the tables are created?
> I could write C# into my app which will notice empty tables and populate
> them but this seems tedious. Is there a better way?
> thanks
> charles
>|||Thank you so much... QALite looks like it does exactly what I need,
creating a SQL INSERTs script from my existing data
charles
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:epWH5BBnEHA.3472@.TK2MSFTNGP09.phx.gbl...
> You could BCP or BULK COPY your data or you could create insert statements
> with a tool like one of these:
> ObjectScripter -- http://www.rac4sql.net/
> QALite -- http://www.rac4sql.net/
> Lockwood Tech -- http://www.lockwoodtech.com/
> Largo SQL Tools -- http://www.largosqltools.com/ (seems to be under
> construction at the moment)
> --
> Keith
>
> "charles" <spam@.synthigence.com> wrote in message
> news:eoeNK4AnEHA.556@.tk2msftngp13.phx.gbl...
> > I have developed an application which will be distributed. I know how
to
> > create a SQL script which will create the table structure for the DB.
Is
> > there an easy/recommended way to export the default data from my tables
in
> a
> > way which will be easy and/or automatic for the installer to load into
> their
> > DB after the tables are created?
> >
> > I could write C# into my app which will notice empty tables and populate
> > them but this seems tedious. Is there a better way?
> >
> > thanks
> > charles
> >
> >
>
Subscribe to:
Posts (Atom)