I have a number of machines connecting to SQL server.
When using Enterprise Manager, half of them take around 5
minutes to expand the database tree, while the other half
are fine. The only difference in the computer I can find
is that the slow ones are running Delphi. Is there a
known issue with EM and Delphi? If not, can anyone
suggest things I can try to sort out this problem?
"Graeme" <anonymous@.discussions.microsoft.com> wrote in message
news:1ba201c49a3e$27b13030$a501280a@.phx.gbl...
> I have a number of machines connecting to SQL server.
> When using Enterprise Manager, half of them take around 5
> minutes to expand the database tree, while the other half
> are fine. The only difference in the computer I can find
> is that the slow ones are running Delphi. Is there a
> known issue with EM and Delphi? If not, can anyone
> suggest things I can try to sort out this problem?
As a troubleshooting step, if you de-install Delphi on one of the problem
clients, then EM loads faster?
Steve
Showing posts with label connecting. Show all posts
Showing posts with label connecting. Show all posts
Friday, March 9, 2012
Sunday, February 26, 2012
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>> Check to see if you have the Auto-Close option turned on any of your
>> databases. and check to see if OBDC tracing is turned on.
Did you check all your databases for Auto-Close?
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!
Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!
Check to see if you have the Auto-Close option turned on any of your databases.
and check to see if OBDC tracing is turned on.
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your databases.
> and check to see if OBDC tracing is turned on.
>
|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
Enterprise Manager connection to Local server very sloooow.
Hi,
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databas
es.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
I'm having a problem connecting to a local copy of SQL server 2000 using
enterprise manager (on Win2k). Doing anything, connecting, refreshing
list of tables etc. takes a very long time (>10secs) slower even than
remote connections.
Also, the enterprise manager itself becomes doggedly slow - eg. tringing
to move a window across the screen is difficult becuase it is so
stuttery. I have checked task manager, and it's not using much CPU time
though.
One other clue is that when you use something like the DTS wizard, the
local server is not explicitly displayed as one of the available servers.
This has only started happening recently. Any ideas on what is going on?
Thanks!Check to see if you have the Auto-Close option turned on any of your databas
es.
and check to see if OBDC tracing is turned on.|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Thanks. Auto-Close was turned on, ODBC tracing was not.
I've turned auto-close off now, and this seems to have helped quite a
lot. Still a bit slow though, so makes me think there is something else
going on.
Any idea why the local server would not be displayed in the 'select
server' dropdown?
> Check to see if you have the Auto-Close option turned on any of your datab
ases.
> and check to see if OBDC tracing is turned on.
>|||Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Also check to make sure that none of the network components between you and
the server have their network connections set to Auto-negotiate, especially
through a switch. The protocol is not standardize and oftentimes will set
everything to 10 Mb, Half-duplex.
Also check your SQLEM Options to NOT reconnect to last connection on
relauch.
Sincerely,
Anthony Thomas
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:%23BhAFC7ZFHA.3620@.TK2MSFTNGP09.phx.gbl...
Sosh123 wrote:[vbcol=seagreen]
> Thanks. Auto-Close was turned on, ODBC tracing was not.
> I've turned auto-close off now, and this seems to have helped quite a
> lot. Still a bit slow though, so makes me think there is something
> else going on.
> Any idea why the local server would not be displayed in the 'select
> server' dropdown?
>
Did you check all your databases for Auto-Close?
David Gugick
Quest Software
www.imceda.com
www.quest.com
Enterprise Manager Connection Issues
Hello,
I am having trouble connecting from enterprise
manager to a sql 2000 box. I can connect to all of our
other production boxes. This is a new box that we built
and I cannot connect. When I go to register it in
Enterprise Manager the error message says "Driver Not
Capable". I'm not sure exactly what this means. All I'm
trying to do is connect to the box. Is there a driver
either on my local laptop or on the server side that
isn't set up right or maybe needs to be updated? I can
open up the database locally on the server and I can
register other servers on it and have that server
registered to other servers. I know other people on my
team are not able to connect to it as well, so I know
it's not just me. Any help would be greatly
appreciated. Thanks.
-Craig CoffaroHello -
The error message "Driver not capable" indicates the problem
to be with the SQL driver. Check the registry entry
HKEY_LOCAL_MACHNE\Software\ODBC\ODBCINST
.INI
Check the driver location in the above registry entry. Check for
SQLsrv32.dll version. If the registry location is pointing to incorrect
file, change it and make it point to the correct one.
Have you installed Crystal reports after installing SQL server?
Regards,
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig Coffaro" <craig.coffaro@.kroger.com> wrote in message
news:902d01c4052c$5d59e990$a501280a@.phx.gbl...
> Hello,
> I am having trouble connecting from enterprise
> manager to a sql 2000 box. I can connect to all of our
> other production boxes. This is a new box that we built
> and I cannot connect. When I go to register it in
> Enterprise Manager the error message says "Driver Not
> Capable". I'm not sure exactly what this means. All I'm
> trying to do is connect to the box. Is there a driver
> either on my local laptop or on the server side that
> isn't set up right or maybe needs to be updated? I can
> open up the database locally on the server and I can
> register other servers on it and have that server
> registered to other servers. I know other people on my
> team are not able to connect to it as well, so I know
> it's not just me. Any help would be greatly
> appreciated. Thanks.
> -Craig Coffaro|||Chandra,
Yes I did install Crystal Reports 6 last week and ever since then
I have had problems with my SQL connections. Thanks for the advice and
I will give this a try. Thanks again.
Craig
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Chandra,
One other question I have is when I go to the registry:
HKEY_LOCAL_MACHNE\Software\ODBC\ODBCINST
.INI and I go down to SQL Server
I see in the window on the right, Driver and Setup both have the same
path with the sqlsrv32.dll in it. I also see DrverODBCver being
03.50...what exactly am I looking for or what do I need to be doing
witht this info? Is there a version of the ODBC driver that I should be
updating? Where exactly can I find this? Or is it the path
C:\WINDOWS\SYSTEM\sqlsrv32.dll that is the problem, if this is the
problem what path should it be? How does the installation of Crystal
Reports affect SQL? Any help you have for me Chandra is greatly
apprecaited. Thanks.
-Craig Coffaro
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||I'm not clear on what your question is. Do you need to find the version of
MDAC? If so, you can download the MDAC Component Checker from
microsoft.com/downloads.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
I am having trouble connecting from enterprise
manager to a sql 2000 box. I can connect to all of our
other production boxes. This is a new box that we built
and I cannot connect. When I go to register it in
Enterprise Manager the error message says "Driver Not
Capable". I'm not sure exactly what this means. All I'm
trying to do is connect to the box. Is there a driver
either on my local laptop or on the server side that
isn't set up right or maybe needs to be updated? I can
open up the database locally on the server and I can
register other servers on it and have that server
registered to other servers. I know other people on my
team are not able to connect to it as well, so I know
it's not just me. Any help would be greatly
appreciated. Thanks.
-Craig CoffaroHello -
The error message "Driver not capable" indicates the problem
to be with the SQL driver. Check the registry entry
HKEY_LOCAL_MACHNE\Software\ODBC\ODBCINST
.INI
Check the driver location in the above registry entry. Check for
SQLsrv32.dll version. If the registry location is pointing to incorrect
file, change it and make it point to the correct one.
Have you installed Crystal reports after installing SQL server?
Regards,
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig Coffaro" <craig.coffaro@.kroger.com> wrote in message
news:902d01c4052c$5d59e990$a501280a@.phx.gbl...
> Hello,
> I am having trouble connecting from enterprise
> manager to a sql 2000 box. I can connect to all of our
> other production boxes. This is a new box that we built
> and I cannot connect. When I go to register it in
> Enterprise Manager the error message says "Driver Not
> Capable". I'm not sure exactly what this means. All I'm
> trying to do is connect to the box. Is there a driver
> either on my local laptop or on the server side that
> isn't set up right or maybe needs to be updated? I can
> open up the database locally on the server and I can
> register other servers on it and have that server
> registered to other servers. I know other people on my
> team are not able to connect to it as well, so I know
> it's not just me. Any help would be greatly
> appreciated. Thanks.
> -Craig Coffaro|||Chandra,
Yes I did install Crystal Reports 6 last week and ever since then
I have had problems with my SQL connections. Thanks for the advice and
I will give this a try. Thanks again.
Craig
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Chandra,
One other question I have is when I go to the registry:
HKEY_LOCAL_MACHNE\Software\ODBC\ODBCINST
.INI and I go down to SQL Server
I see in the window on the right, Driver and Setup both have the same
path with the sqlsrv32.dll in it. I also see DrverODBCver being
03.50...what exactly am I looking for or what do I need to be doing
witht this info? Is there a version of the ODBC driver that I should be
updating? Where exactly can I find this? Or is it the path
C:\WINDOWS\SYSTEM\sqlsrv32.dll that is the problem, if this is the
problem what path should it be? How does the installation of Crystal
Reports affect SQL? Any help you have for me Chandra is greatly
apprecaited. Thanks.
-Craig Coffaro
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||I'm not clear on what your question is. Do you need to find the version of
MDAC? If so, you can download the MDAC Component Checker from
microsoft.com/downloads.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, February 15, 2012
Enterprise class not registered 6.5
Today morning i tried connecting to sql 6.5 through enterprise edition got the following error
SQL ole object could not be registered class not registered (80040154)
I did shut down and restart, stopped and restarted the servicesAs obvious this is a problem with the class or the associated OLE dll not being registered in the registry properly . You can use the regsvr32 utility to re-register it :-
regsvr32 (path)\binn\sqlole65.dll
And replace (path) with the full drive/directory that SQL Server is installed into.|||Thanks works very good
One more question
How best to display data on web without knowing any language|||I think its not possible to work if you don't know any language ( in terms of IT). Can you rephrase your question agian.|||I just know sql and html the basic
any one language i can use to represent data on web and easy too learn
like combination or reporting tools ( crystal report) and something else too|||Then no issues in representing the data on a web page.
ASP with SQL is best combination I've seen so far (as I'm concerned).
Refer to MSDN & Technet for SQL for further information.|||Representing data using sql and asp is enough
I mean will it allow the user to choose say dates if i represent it on a drop down menu ( can asp do it i mean)
In short will i be able to represents most of the data using ASP (JUST)
OFCOURSE BESIDE SQL IN PROCEDURE OR FUNCTION
SQL ole object could not be registered class not registered (80040154)
I did shut down and restart, stopped and restarted the servicesAs obvious this is a problem with the class or the associated OLE dll not being registered in the registry properly . You can use the regsvr32 utility to re-register it :-
regsvr32 (path)\binn\sqlole65.dll
And replace (path) with the full drive/directory that SQL Server is installed into.|||Thanks works very good
One more question
How best to display data on web without knowing any language|||I think its not possible to work if you don't know any language ( in terms of IT). Can you rephrase your question agian.|||I just know sql and html the basic
any one language i can use to represent data on web and easy too learn
like combination or reporting tools ( crystal report) and something else too|||Then no issues in representing the data on a web page.
ASP with SQL is best combination I've seen so far (as I'm concerned).
Refer to MSDN & Technet for SQL for further information.|||Representing data using sql and asp is enough
I mean will it allow the user to choose say dates if i represent it on a drop down menu ( can asp do it i mean)
In short will i be able to represents most of the data using ASP (JUST)
OFCOURSE BESIDE SQL IN PROCEDURE OR FUNCTION
Subscribe to:
Posts (Atom)