I′m looking for a script (sql transaction, or function) to export MS
SQL(2000) Table to formated excel sheet (cells width, text format, ...).how about using the DTS
to export that to excel
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Milo?" wrote:
> I′m looking for a script (sql transaction, or function) to export MS
> SQL(2000) Table to formated excel sheet (cells width, text format, ...).|||Milo?,
You also can use BCP command. See Books Online.
Regards,
"Milo?" wrote:
> I′m looking for a script (sql transaction, or function) to export MS
> SQL(2000) Table to formated excel sheet (cells width, text format, ...).|||Thank You Jose,
DTS export ist very easy, for my situation is the best, but it has litlle
problem with text encoding.
Milo?
?Jose G. de Jesus Jr MCP, MCDBA" nap_sal (nap_sala):
> how about using the DTS
> to export that to excel
>
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787
>
> "Milo?" wrote:
>sql
Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts
Friday, March 30, 2012
MS SQL Update Error
I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB with 45 users. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records. This table is the master of a table which has more than 200 fields and more than 750000 records. In the detail table I have no problems.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Well when the problem appearead again I tried to edit the locked records by using Access ODBC, Access (adp project), Delphi with ADO-OLEDB and Delphi with native SQL drivers. The result was the same. A Timeout expired message appear. In the application log file of the MS SQLserver machine every time the the update error appears I get the following message: Could not Set Up Listen on Connection '1433'. Operating system Error 10049.
Any ideas??
Best regards,
Manolis PerrakisCan you supply the wording of the update error?
Also, since it tends to happen from 8-10 most mornings, you can check for blocking problems by running sp_who2 in Query Analyzer. If there are numbers in the "BlkBy" column, you have problems. Hopefully you will be able to figure out the blocker by the program- or host-name in the output of sp_who2.|||I don't have a solution for you. But I have experienced more than my share of timeouts and there's one thing I've learned: it's never what it says it is. But it seems to happen more the larger the number of elements there are in an index, and less on more normal databases. And we suspect it may be related to our use of EIDE drives instead of SCSI.
And I strongly suspect it has something to do with resources. For example: If you execute an update query causing SQL Server to execute a series of subqueries, and one of them hits a resource ceiling, one of the others with time out waiting for a thread to finish. The thread never finishes, because it's waiting for resources to be freed before it can continue. This happens all the time on our 1 GHZ server with 1GB of RAM.
I suggest you check all your indexes and make sure they're not clustered. Also, make sure you're not using too many connections if you can avoid it. And if you have too many tables that aren't normalized, try to fix that as well. Finally, you can do what I'm planning to do: change to MySql server or something else. IMNSHO, Sql Server isn't as robust as it could be.
I hope this helps.|||One other thing...Port 1433 is where SQL Server listens for connection requests. You're not opening the database everytime you do an update, are you?|||Thanks for the suggestions. My server is a Compaq ML350 with 3 SCSII hards disks and a Raid Controller, and about 600 MB RAM. I can see from the task manager that it uses all the resources. I might increase the RAM memory and in the next months I might get a new server.
Please tell me if there is a serious problem the fact that I also store in this server about 10000 photos with sizes about 2 GB, that are displayed as product pictures in the database program I've created.
I also have to mention that I use a lot of subqueries in the MSAccess program I use right now.
As far the connections issues, since I now use MSAccess for the clients, each table that is connected (attached) to the MSSQL Server holds internally its connection properies (datasource name, database name, username etc..), and since that I have about 200 tables attached from the SQL Server, this might create a connection problem.
I'm currently moving to Delphi 7, which has a global connection for all the tables of the same server. In this version the subqueries are replaced with optimised queries, and client datasets will be used in order to decrease the server load.
Best Regards,
Manolis Perrakis|||The data I store in image fields is usually quite a bit less than yours, but I don't think that's a problem. But I'm pretty sure the RAM is. You can improve things somewhat by making sure your logfile is on a different disk drive than the database, if you haven't done so already.
Try to get away from holding tables open where you can. Also, if you have a lot of indices on the master table, or a high number of values in the master index, I know from experience that can cause problems. Those problems can be alleviated by adding more RAM, further normalizing your database to reduce the number of keys (if that's possible), or looking at ways to reduce the amount of index storage--making sure you're not using clustered indexes, making sure that you're not using full-text indexing if you don't need it.
But I'm also wondering whether it's the bound controls that are the problem. At 8:00 is when everyone comes into work and launches the app, right? And by 10:00, app use drops down to a manageable level? Tables linked to app forms are almost always in Dynamic mode and I'm assuming that's the case here. If you were to modify your app so that the most common screens were read (releasing the recordset and holding the data in memory), and perform updates as that data was written (creating a new recordset for writing), you'd probably reduce the load on Sql Server significantly.
Not that any of this presents a panacea. I've spent the majority of my bugchasing over the past couple of years on problems with SQL Server/ADO. If I had any time at all, I would switch like a Tareyton smoker. :) But I think this problem can be solved.
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records. This table is the master of a table which has more than 200 fields and more than 750000 records. In the detail table I have no problems.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Well when the problem appearead again I tried to edit the locked records by using Access ODBC, Access (adp project), Delphi with ADO-OLEDB and Delphi with native SQL drivers. The result was the same. A Timeout expired message appear. In the application log file of the MS SQLserver machine every time the the update error appears I get the following message: Could not Set Up Listen on Connection '1433'. Operating system Error 10049.
Any ideas??
Best regards,
Manolis PerrakisCan you supply the wording of the update error?
Also, since it tends to happen from 8-10 most mornings, you can check for blocking problems by running sp_who2 in Query Analyzer. If there are numbers in the "BlkBy" column, you have problems. Hopefully you will be able to figure out the blocker by the program- or host-name in the output of sp_who2.|||I don't have a solution for you. But I have experienced more than my share of timeouts and there's one thing I've learned: it's never what it says it is. But it seems to happen more the larger the number of elements there are in an index, and less on more normal databases. And we suspect it may be related to our use of EIDE drives instead of SCSI.
And I strongly suspect it has something to do with resources. For example: If you execute an update query causing SQL Server to execute a series of subqueries, and one of them hits a resource ceiling, one of the others with time out waiting for a thread to finish. The thread never finishes, because it's waiting for resources to be freed before it can continue. This happens all the time on our 1 GHZ server with 1GB of RAM.
I suggest you check all your indexes and make sure they're not clustered. Also, make sure you're not using too many connections if you can avoid it. And if you have too many tables that aren't normalized, try to fix that as well. Finally, you can do what I'm planning to do: change to MySql server or something else. IMNSHO, Sql Server isn't as robust as it could be.
I hope this helps.|||One other thing...Port 1433 is where SQL Server listens for connection requests. You're not opening the database everytime you do an update, are you?|||Thanks for the suggestions. My server is a Compaq ML350 with 3 SCSII hards disks and a Raid Controller, and about 600 MB RAM. I can see from the task manager that it uses all the resources. I might increase the RAM memory and in the next months I might get a new server.
Please tell me if there is a serious problem the fact that I also store in this server about 10000 photos with sizes about 2 GB, that are displayed as product pictures in the database program I've created.
I also have to mention that I use a lot of subqueries in the MSAccess program I use right now.
As far the connections issues, since I now use MSAccess for the clients, each table that is connected (attached) to the MSSQL Server holds internally its connection properies (datasource name, database name, username etc..), and since that I have about 200 tables attached from the SQL Server, this might create a connection problem.
I'm currently moving to Delphi 7, which has a global connection for all the tables of the same server. In this version the subqueries are replaced with optimised queries, and client datasets will be used in order to decrease the server load.
Best Regards,
Manolis Perrakis|||The data I store in image fields is usually quite a bit less than yours, but I don't think that's a problem. But I'm pretty sure the RAM is. You can improve things somewhat by making sure your logfile is on a different disk drive than the database, if you haven't done so already.
Try to get away from holding tables open where you can. Also, if you have a lot of indices on the master table, or a high number of values in the master index, I know from experience that can cause problems. Those problems can be alleviated by adding more RAM, further normalizing your database to reduce the number of keys (if that's possible), or looking at ways to reduce the amount of index storage--making sure you're not using clustered indexes, making sure that you're not using full-text indexing if you don't need it.
But I'm also wondering whether it's the bound controls that are the problem. At 8:00 is when everyone comes into work and launches the app, right? And by 10:00, app use drops down to a manageable level? Tables linked to app forms are almost always in Dynamic mode and I'm assuming that's the case here. If you were to modify your app so that the most common screens were read (releasing the recordset and holding the data in memory), and perform updates as that data was written (creating a new recordset for writing), you'd probably reduce the load on Sql Server significantly.
Not that any of this presents a panacea. I've spent the majority of my bugchasing over the past couple of years on problems with SQL Server/ADO. If I had any time at all, I would switch like a Tareyton smoker. :) But I think this problem can be solved.
MS SQL Update Error
I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Any ideas??
Best Regards,
Manolis Perrakis
manolo_perrakis@.mail.grDoes the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
blindman|||Does the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
The error occurs both with Access (I'm using an mdb file connected with ODBC with SQL Server) and with the Query Analyser. When this error occurs I cannot edit this table from any computer in the network.
Therefore I'm trying to edit the table using ODBC. I haven't tried by using an ADP project, or by using another program like Delphi which uses another connection method like OLE DB.|||when you get to the point when "this" error occurrs again, can you switch to query analyzer and write an update query for a specific record?
after you get "that" error in query analyzer, paste it here. i suspect you can also get this error from sql server errorlog by double-clicking on the entry with the error. i suspect the error you're getting is referencing the total record length. if this is the case you'll need to either shrink a couple of fields or split the table into two to allow for all your fields to be updateable. to do that seemlessly for the front-end you'll have to write a view and reference this view in your inserts, updates, deletes, and selects.
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Any ideas??
Best Regards,
Manolis Perrakis
manolo_perrakis@.mail.grDoes the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
blindman|||Does the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
The error occurs both with Access (I'm using an mdb file connected with ODBC with SQL Server) and with the Query Analyser. When this error occurs I cannot edit this table from any computer in the network.
Therefore I'm trying to edit the table using ODBC. I haven't tried by using an ADP project, or by using another program like Delphi which uses another connection method like OLE DB.|||when you get to the point when "this" error occurrs again, can you switch to query analyzer and write an update query for a specific record?
after you get "that" error in query analyzer, paste it here. i suspect you can also get this error from sql server errorlog by double-clicking on the entry with the error. i suspect the error you're getting is referencing the total record length. if this is the case you'll need to either shrink a couple of fields or split the table into two to allow for all your fields to be updateable. to do that seemlessly for the front-end you'll have to write a view and reference this view in your inserts, updates, deletes, and selects.
Wednesday, March 28, 2012
MS SQL SERVER WITH JAVA help plz?
What r the pros and conditions of using MSsql server ?
what the effect of data on the performance in case of MS SQL server?is it good enough tohandle data overloads?
how good the java ms sql server combo works in comparison to other databases !!
SQL Server works great with Java! More here:
http://msdn2.microsoft.com/en-us/data/aa937724.aspx
Friday, March 23, 2012
MS SQL Server 2005 data folder
It seems SQL Server 2005 can store data in both C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data. But what's the difference of the 2 folders? I accidentally found identical mdf files in the two folders and got confused. Thanks.This is assuming you have more than one database in your SQL Server if you find all your MDF files and LDF files in one and not the other then the second one was created by VS for SQL Server I will leave it alone. Hope this helps.|||
The difference is that the 2 folders are default data folders of 2 different SQL2005 instance. In SQL 2005 the machanism of resolving instance names has been changed, as well as the file locations. For more information, you can refer to:
File Locations for Default and Named Instances of SQL Server 2005
MS SQL Server 2005 - How to add databases/users/etc.??
I've installed the MS VB Express and WebDev Express and subsequently have MS
SQL Server 2005 installed. I'm at a complete loss as to how to access or
configure this server. In the SQL Server configuration I can only see how to
configure the SQL Express protocols.
How can I add users to the Server? How do I create databases?
At the moment I'm trying to configure Macromedia Dreamweaver to access MSSQL
server.
Any help is appreciated!Get: SQL Server Express Management Studio
Search for this file on the internet: SQLServer2005_SSMSEE.msi
Milan
P.S. Still not the release version.
"Noozer" <dont.spam@.me.here> wrote in message
news:_psUf.174516$H%4.135595@.pd7tw2no...
> I've installed the MS VB Express and WebDev Express and subsequently have
> MS SQL Server 2005 installed. I'm at a complete loss as to how to access
> or configure this server. In the SQL Server configuration I can only see
> how to configure the SQL Express protocols.
> How can I add users to the Server? How do I create databases?
> At the moment I'm trying to configure Macromedia Dreamweaver to access
> MSSQL server.
> Any help is appreciated!
>|||Hi
As I understood you have installed SQL Server Express Edition.
It is supplied without SSMS (Former EM). You will to download SSMS as msi
file if I remeber and install it at your workstation
"Noozer" <dont.spam@.me.here> wrote in message
news:_psUf.174516$H%4.135595@.pd7tw2no...
> I've installed the MS VB Express and WebDev Express and subsequently have
> MS SQL Server 2005 installed. I'm at a complete loss as to how to access
> or configure this server. In the SQL Server configuration I can only see
> how to configure the SQL Express protocols.
> How can I add users to the Server? How do I create databases?
> At the moment I'm trying to configure Macromedia Dreamweaver to access
> MSSQL server.
> Any help is appreciated!
>|||Thanks guys!
Just what I was looking for.
I was hoping that something like this would be built into Dreamweaver, but I
guess not.
"Milan Kosanovic" <milan@.REMOVETHISsoftlakecity.com> wrote in message
news:u8iYQFlTGHA.1672@.tk2msftngp13.phx.gbl...
> Get: SQL Server Express Management Studio
> Search for this file on the internet: SQLServer2005_SSMSEE.msi
> Milan
> P.S. Still not the release version.
> "Noozer" <dont.spam@.me.here> wrote in message
> news:_psUf.174516$H%4.135595@.pd7tw2no...
>sql
SQL Server 2005 installed. I'm at a complete loss as to how to access or
configure this server. In the SQL Server configuration I can only see how to
configure the SQL Express protocols.
How can I add users to the Server? How do I create databases?
At the moment I'm trying to configure Macromedia Dreamweaver to access MSSQL
server.
Any help is appreciated!Get: SQL Server Express Management Studio
Search for this file on the internet: SQLServer2005_SSMSEE.msi
Milan
P.S. Still not the release version.
"Noozer" <dont.spam@.me.here> wrote in message
news:_psUf.174516$H%4.135595@.pd7tw2no...
> I've installed the MS VB Express and WebDev Express and subsequently have
> MS SQL Server 2005 installed. I'm at a complete loss as to how to access
> or configure this server. In the SQL Server configuration I can only see
> how to configure the SQL Express protocols.
> How can I add users to the Server? How do I create databases?
> At the moment I'm trying to configure Macromedia Dreamweaver to access
> MSSQL server.
> Any help is appreciated!
>|||Hi
As I understood you have installed SQL Server Express Edition.
It is supplied without SSMS (Former EM). You will to download SSMS as msi
file if I remeber and install it at your workstation
"Noozer" <dont.spam@.me.here> wrote in message
news:_psUf.174516$H%4.135595@.pd7tw2no...
> I've installed the MS VB Express and WebDev Express and subsequently have
> MS SQL Server 2005 installed. I'm at a complete loss as to how to access
> or configure this server. In the SQL Server configuration I can only see
> how to configure the SQL Express protocols.
> How can I add users to the Server? How do I create databases?
> At the moment I'm trying to configure Macromedia Dreamweaver to access
> MSSQL server.
> Any help is appreciated!
>|||Thanks guys!
Just what I was looking for.
I was hoping that something like this would be built into Dreamweaver, but I
guess not.
"Milan Kosanovic" <milan@.REMOVETHISsoftlakecity.com> wrote in message
news:u8iYQFlTGHA.1672@.tk2msftngp13.phx.gbl...
> Get: SQL Server Express Management Studio
> Search for this file on the internet: SQLServer2005_SSMSEE.msi
> Milan
> P.S. Still not the release version.
> "Noozer" <dont.spam@.me.here> wrote in message
> news:_psUf.174516$H%4.135595@.pd7tw2no...
>sql
Monday, March 19, 2012
MS SQL server & Sybase interoperability
Dear all,
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
SuadDon't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>|||s.isa schrieb:
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
SuadDon't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>|||s.isa schrieb:
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli
MS SQL server & Sybase interoperability
Dear all,
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
Suad
Don't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
|||s.isa schrieb:
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli
I have an application build on Sybase database, and we waant to install MS
SQL 2000 on the same machine for a different apppliction, is there any
interoperablity issues or will the sybase application be affected by any
means.
Please advice
Thanks in advanc,
Suad
Don't think so but you can use VMWare to separate out the instance.
"s.isa" <s.isa@.lycos.com> wrote in message
news:OFm%23%23$aNEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
|||s.isa schrieb:
> Dear all,
> I have an application build on Sybase database, and we waant to install MS
> SQL 2000 on the same machine for a different apppliction, is there any
> interoperablity issues or will the sybase application be affected by any
> means.
> Please advice
> Thanks in advanc,
> Suad
>
We are using Sybase ASA and SQL Server 2000 on the same machine.
Installing SQL Server 2000 AFTER installing Sybase (8.0) did not cause
any problems. Both are working fine.
But installing Sybase ASA 8.0 after installation of SQL Server 2000
caused problems with the ODBC dlls. We had to exchange the ODBC32.dll to
get the SQL Server work again. Obviously Sybase overwrites these dlls
but SQL Server needs them.
Olli
MS SQL Server How to Guide
Ladies / Gentlemen
Is their a Paper / Guide / Book that Explains how to set up a replication
environment using MSSQL Server.
I was thinking of using MS SQL Server Express at all the client locations
with MS SQL Server Standard Edition for the Headquarters.
Any help would be appreciated.
Mark Moss
Mark,
the main resources are books on line (BOL), Hilary's books, a few links on
www.replicationanswers.com have walkthroughs, and this site for
troubleshooting. I'd recommend getting a reasonable grasp of the technology
then just doing lots ot different setups and compliment this by posting
errors/questions to this group.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||check my sig.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mark Moss" <markmoss@.adelphia.net> wrote in message
news:%23xMmfHD$FHA.2608@.TK2MSFTNGP11.phx.gbl...
> Ladies / Gentlemen
>
> Is their a Paper / Guide / Book that Explains how to set up a replication
> environment using MSSQL Server.
> I was thinking of using MS SQL Server Express at all the client locations
> with MS SQL Server Standard Edition for the Headquarters.
> Any help would be appreciated.
>
> Mark Moss
>
>
Is their a Paper / Guide / Book that Explains how to set up a replication
environment using MSSQL Server.
I was thinking of using MS SQL Server Express at all the client locations
with MS SQL Server Standard Edition for the Headquarters.
Any help would be appreciated.
Mark Moss
Mark,
the main resources are books on line (BOL), Hilary's books, a few links on
www.replicationanswers.com have walkthroughs, and this site for
troubleshooting. I'd recommend getting a reasonable grasp of the technology
then just doing lots ot different setups and compliment this by posting
errors/questions to this group.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||check my sig.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mark Moss" <markmoss@.adelphia.net> wrote in message
news:%23xMmfHD$FHA.2608@.TK2MSFTNGP11.phx.gbl...
> Ladies / Gentlemen
>
> Is their a Paper / Guide / Book that Explains how to set up a replication
> environment using MSSQL Server.
> I was thinking of using MS SQL Server Express at all the client locations
> with MS SQL Server Standard Edition for the Headquarters.
> Any help would be appreciated.
>
> Mark Moss
>
>
MS SQL Record Limit
Quick question, is there a record limit in MSSQL assuming that we don't use a identity key. I am going to be using a table to sava mail server logs. It will create about 5000 records a minute. Also are there any perfomrance issues once you reach a certain numberof records, assuiming i am indexing one of the columns.limited by available storage
[Books Online] Maximum Capacity Specifications
look for rows per table
or LINK (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp)
now 5000 rows a minute for how long??|||drop any index before inserting data.
when transaction complished,recreate index.|||Also plan to archive the data in order to manage the database efficiently without any issues. say archive the data after a week or month or so.
This way you can ease the administration of the database on the terms of performance etc.
Refer to http://www.sql-server-performance.com for tips and tricks on performance issues.|||Thanks for all your help, I am going to do some testing and see what happens... the best way to learn is to do.
[Books Online] Maximum Capacity Specifications
look for rows per table
or LINK (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp)
now 5000 rows a minute for how long??|||drop any index before inserting data.
when transaction complished,recreate index.|||Also plan to archive the data in order to manage the database efficiently without any issues. say archive the data after a week or month or so.
This way you can ease the administration of the database on the terms of performance etc.
Refer to http://www.sql-server-performance.com for tips and tricks on performance issues.|||Thanks for all your help, I am going to do some testing and see what happens... the best way to learn is to do.
Monday, March 12, 2012
MS SQL MSDE Quick Question About Databases
Hey,
Im using MSSQL MSDE with the ASP.NET WebMatrix Project to build databases, but i cant find where the database is stored on my hard drive. I am about to format and reinstall Windows and would like to backup these databases so that i can continue to work with them after i reinstall. Can anyone help me?
Im using MSSQL MSDE with the ASP.NET WebMatrix Project to build databases, but i cant find where the database is stored on my hard drive. I am about to format and reinstall Windows and would like to backup these databases so that i can continue to work with them after i reinstall. Can anyone help me?
Thanks in advance, all help is appreciated :)
E.The quick and dirty answer is to look at C:\Inetpubs\wwwroot. That is where mine were stored. A safer, more complete approach is to simply use a Windows Explorer seach for "My Computer".|||I believe that the default installation location for msde data files is:
\\[yourserver]\c$\Program Files\Microsoft SQL Server\MSSQL$[yourserver]\Data
-Sam
MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.
Hello,
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?P?vels Mihailovs (iceravenlv@.gmail.com) writes:
Since I don't work with MySQL myself, it's difficult to say what is
going on. But if MySQL has a notion of collation, and the collation is
ucs2_general_ci, it sounds like MySQL returns Unicode data. One would
expect that to arrive unscathed. What is you collation on the SQL
Server side?
>
Since I don't work with MySQL myself, it's difficult to say what is
going on. But if MySQL has a notion of collation, and the collation is
ucs2_general_ci, it sounds like MySQL returns Unicode data. One would
expect that to arrive unscathed. What is you collation on the SQL
Server side?
>
The stored procedure sp_serveroption permits you to set options for
linked servers, and two of them relates to collations. You could play
around with these and see what happens. Please look in Books Online
for details.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
on the MS SQL server i'm using Latvian_CI_AI, but some databases are
set to Latvian_CI_AS collation (sorry db admin can't explain why they
are using it).
I've tried using different collation option, I've checked all 1257 and
other collation, but result was almost the same. :/
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?P?vels Mihailovs (iceravenlv@.gmail.com) writes:
Quote:
Originally Posted by
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?
Since I don't work with MySQL myself, it's difficult to say what is
going on. But if MySQL has a notion of collation, and the collation is
ucs2_general_ci, it sounds like MySQL returns Unicode data. One would
expect that to arrive unscathed. What is you collation on the SQL
Server side?
The stored procedure sp_serveroption permits you to set options for
linked servers, and two of them relates to collations. You could play
around with these and see what happens. Please look in Books Online
for details.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Jun 22, 1:16 am, Erland Sommarskog <esq...@.sommarskog.sewrote:
Quote:
Originally Posted by
P?vels Mihailovs (icerave...@.gmail.com) writes:
Quote:
Originally Posted by
I have a problem. I've linked MySql server to MsSql, in MySql I have a
table with Latvian data(character set is ucs2, ucs2_general_ci) and
the problem is that when I use openquery to read data from MySQL
server, some characters are not translated correctly! I receive
question symbols instead of Latvian special characters.
Maybe someone had this kind of problem with collation?
>
Since I don't work with MySQL myself, it's difficult to say what is
going on. But if MySQL has a notion of collation, and the collation is
ucs2_general_ci, it sounds like MySQL returns Unicode data. One would
expect that to arrive unscathed. What is you collation on the SQL
Server side?
>
The stored procedure sp_serveroption permits you to set options for
linked servers, and two of them relates to collations. You could play
around with these and see what happens. Please look in Books Online
for details.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
on the MS SQL server i'm using Latvian_CI_AI, but some databases are
set to Latvian_CI_AS collation (sorry db admin can't explain why they
are using it).
I've tried using different collation option, I've checked all 1257 and
other collation, but result was almost the same. :/
MS SQL jdbc driver problem in Connection pool in TOMCAT 5
I have problem in creating connection pool with MS SQL Server JDBC
Driver. I use Apache 2.0.49, Tomcat 5.0.19, windows 2000 server, MS
SQL server 2000 + sp4
My configuration is as following. The error occurs at
envCtx.lookup("jdbc/dbname");
1) I copy the three jar files to \common\lib in %catalina_home% from
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
2) MY webapps/ROOT/web-inf/web.xml is:
...
<resource-ref>
<description> JDBC Driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver</description>
<res-ref-name>jdbc/dbname</res-ref-name>
<res-type>com.microsoft.jdbcx.sqlserver.SQLServerDataSo urce</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
3) my JSP file is in /ROOT/zuo, it contains code:
<%@. page import="java.sql.*" %>
<%@. page import="java.lang.reflect.*" %>
<%@. page import="java.io.*" %>
<%@. page import="javax.naming.*" %>
.....
<%....
envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (ConnectionPoolDataSource ) envCtx.lookup("jdbc/dbname");
if (ds != null){
if(ds instanceof com.microsoft.jdbcx.sqlserver.SQLServerDataSource) {
SQLServerDataSource temp =
(com.microsoft.jdbcx.sqlserver.SQLServerDataSource )ds;
con = temp.getPooledConnection("dzuo","dzuo").getConnect ion();
...%>
4) I add text in apache2/conf/server.xml :
<GlobalNamingResources>
.....
<Resource name="jdbc/dbname" auth="container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataS ource" />
<ResourceParams name="jdbc/dbname">
<parameter>
<name>factory</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerData SourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerData Source</value>
</parameter>
<parameter>
<name>driverName</name>
<value>SQLServer</value>
</parameter>
<parameter>
<name>description</name>
<value>SQL Server DataSource</value></parameter>
<parameter>
<name>serverName</name><value>"serverNmae"</value>
</parameter>
<parameter>
<name>portNumber</name><value>1433</value>
</parameter>
<parameter><name>user</name><value>"dzuo"</value></parameter>
<parameter><name>password</name><value>"dzuo"</value></parameter>
</ResourceParams>
(... other resources ...)
</GlobalNamingResources>
.....
</Host>
</Engine>
</Service>
</Server>
Please forward instruction, or any suggestion. Thanks a lot.
Did you had any luck. I am trying to do the same thing under tomcat. So far no luck with connection pooling.
|||use com.microsoft.jdbc.sqlserver.SQLServerDriver instead of com.microsoft.jdbcx.sqlserver.SQLServerDataSource as the jdbc driver.
I use the admin UI to config
step 1: create context;
step 2: create datasource, like following:
JNDI Name: jdbc/mnr
Data Source URL: jdbc:microsoft:sqlserver://mnrserver:1433;
JDBC Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
User Name: mnr
Password: xxxx
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query: select * from MNR_Estm
step 3: jsp
<%@.page import="java.sql.*"%>
<%@.page import="javax.sql.*"%>
<%@.page import="javax.naming.*"%>
<%
DataSource ds = null;
InitialContext initContext = new javax.naming.InitialContext();
out.print("Getting datasource(jdbc/css)... ");
ds = (javax.sql.DataSource)initContext.lookup("java:com p/env/jdbc/mnr");
out.println("successfully");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rst = stmt.executeQuery(" select * from MNR_Estm");
while(rst.next()){
out.println(rst.getString("Estno"));
}
conn.close();
%>
step 4: access http://127.0.0.1:9000/quartz/scripts/edi/b.jsp
It's ok.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Driver. I use Apache 2.0.49, Tomcat 5.0.19, windows 2000 server, MS
SQL server 2000 + sp4
My configuration is as following. The error occurs at
envCtx.lookup("jdbc/dbname");
1) I copy the three jar files to \common\lib in %catalina_home% from
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
2) MY webapps/ROOT/web-inf/web.xml is:
...
<resource-ref>
<description> JDBC Driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver</description>
<res-ref-name>jdbc/dbname</res-ref-name>
<res-type>com.microsoft.jdbcx.sqlserver.SQLServerDataSo urce</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
3) my JSP file is in /ROOT/zuo, it contains code:
<%@. page import="java.sql.*" %>
<%@. page import="java.lang.reflect.*" %>
<%@. page import="java.io.*" %>
<%@. page import="javax.naming.*" %>
.....
<%....
envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (ConnectionPoolDataSource ) envCtx.lookup("jdbc/dbname");
if (ds != null){
if(ds instanceof com.microsoft.jdbcx.sqlserver.SQLServerDataSource) {
SQLServerDataSource temp =
(com.microsoft.jdbcx.sqlserver.SQLServerDataSource )ds;
con = temp.getPooledConnection("dzuo","dzuo").getConnect ion();
...%>
4) I add text in apache2/conf/server.xml :
<GlobalNamingResources>
.....
<Resource name="jdbc/dbname" auth="container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataS ource" />
<ResourceParams name="jdbc/dbname">
<parameter>
<name>factory</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerData SourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerData Source</value>
</parameter>
<parameter>
<name>driverName</name>
<value>SQLServer</value>
</parameter>
<parameter>
<name>description</name>
<value>SQL Server DataSource</value></parameter>
<parameter>
<name>serverName</name><value>"serverNmae"</value>
</parameter>
<parameter>
<name>portNumber</name><value>1433</value>
</parameter>
<parameter><name>user</name><value>"dzuo"</value></parameter>
<parameter><name>password</name><value>"dzuo"</value></parameter>
</ResourceParams>
(... other resources ...)
</GlobalNamingResources>
.....
</Host>
</Engine>
</Service>
</Server>
Please forward instruction, or any suggestion. Thanks a lot.
Did you had any luck. I am trying to do the same thing under tomcat. So far no luck with connection pooling.
|||use com.microsoft.jdbc.sqlserver.SQLServerDriver instead of com.microsoft.jdbcx.sqlserver.SQLServerDataSource as the jdbc driver.
I use the admin UI to config
step 1: create context;
step 2: create datasource, like following:
JNDI Name: jdbc/mnr
Data Source URL: jdbc:microsoft:sqlserver://mnrserver:1433;
JDBC Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver
User Name: mnr
Password: xxxx
Max. Active Connections: 4
Max. Idle Connections: 2
Max. Wait for Connection: 5000
Validation Query: select * from MNR_Estm
step 3: jsp
<%@.page import="java.sql.*"%>
<%@.page import="javax.sql.*"%>
<%@.page import="javax.naming.*"%>
<%
DataSource ds = null;
InitialContext initContext = new javax.naming.InitialContext();
out.print("Getting datasource(jdbc/css)... ");
ds = (javax.sql.DataSource)initContext.lookup("java:com p/env/jdbc/mnr");
out.println("successfully");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rst = stmt.executeQuery(" select * from MNR_Estm");
while(rst.next()){
out.println(rst.getString("Estno"));
}
conn.close();
%>
step 4: access http://127.0.0.1:9000/quartz/scripts/edi/b.jsp
It's ok.
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Friday, March 9, 2012
MS SQL conflicting with other DB Engines.
Hello All,
I work for a company that packages MSDE and MSSQL 8.0 because our software requires storing client information in a database. The problem is that we've found that if the our users have another DB engine installed (BDE or Paradox usually), our program has trouble using MSDE to access the database and thus making our software inaccessible. It behaves as if this other database engine locks on our database before MSDE can. I'm basically looking for help on either how to uninstall these other db engines or how to get around this problem so that both MSSQL and other db engines can co-exist in one system.I'd try to dump the data out of the other database to some type of file then import it in to sql server. Just a thought|||Thanks for the idea garrydawkins but unfortunately that's not an option we have.|||Does SQL Server have to be installed on everyone's desktop? Can it not be installed on a dedicated server, and everyone who uses your software can utilize this single instance?|||depends on the chosen environment, we have the ability to use a machine as a dedicated server, unfortunately, servers are used as servers. If they are serving our product, they are serving the conflicting product. We also have a lot of "stand-Alone" Clients. Not an option here either. Sorry for being difficult. :(|||Wow.. so the Stand-Alone clients, and the distributed clients both require the full install of SQL Server? Sounds overkill for the Stand-Alone. One idea might be to use Access for the Stand-Alone implementations, and SQL Server for the distributed clients. That might require significant recoding of the install, and the app (to execute SQL vs Access specific statements), but it would probably solve the problem.
At the same time, it would reduce the cost of your Stand-Alone version (since they won't have to purchase a commerical SQL Server license), be cheaper for your clients, giving you an edge over your competators.|||I work with Geeneus,
ok, the MSDE (MSDE 2000) is only running on the server, the workstations are not required to be running the server app(sorry about being unclear about this). This in turn, explains why a stand-alone is required to run it as well. Turning the client app to Access is a leap backwards, and not needed. The symptom we are experiencing, is that another database app is grabbing a hold of our database before MSDE can grab it. I suspect BDE (Borland), Paradox, Delphi (also Borland), etc...is just reacting faster and putting a lock on the database even though it is not using it. I know that this BDE can come from many sources, the most common being things like the "Corel" office suite. Anything from Oracle will be using Delphi. Any suggestions?
Xero|||I don't care for Access either, I understand, just trying to think of an option that wouldn't have you writing your own :). Is it possible this other app is running as a service? In which case you could simply disable the process.|||yea, thats my assumption. I am having huge troubles locating the offending app/service. BDE tends to hide. In most cases the MSDE will install. It is when we try to run the configuration scripts to attach the database is when it blows up. Something allready installed has grabbed ahold of it and locked it.|||Good News!!
Reverend managed to figure out how to work around the problem. I'll let him explain it but just wanted to give you all the good news!!|||I have discovered a conflict btween what was called MQIS (MSMQ), and is now Active Directory. This MQIS thing came with early versions of Windows, i.e. Win95, Win98, and NT4. It has an installed backbone of SQL 6.5. If, throughout its lifetime, any of these components have been removed, then this issue can arise. Identification can be made by Start -> Programs -> Startup. I have noticed that the MSDE will show as "Service Manager" and the other instance will be called simply SQL Server. Remove SQl server from startup and run your configuration scripts. viola. Be advised that the next time this client runs any exe that calls for that old SQL Server (app in the case of win9x) it will be reactivated in startup and cause this nightmare again.
Have also seen strange(same) behavior while trying to install the MSDE after the newest version of quickbooks is installed.|||stupid user tricks:Install MSDE to a win98 machine, upgrade to WIN2k or WINXP. Now the database can not be read by the MSDE.
I believe that the MSDE installes as a application, when you roll up to xp or 2k, you suddenly have services and POOF! we get blown out of the water.
anyone had any experience with this and have a workaround/fix?|||Install MDAC 2.7 then uninstall the MSDE. Then reinstall the MSDE, it will now install as a service rather than an application. (This was tested from 98 to XP, 2000 is still unknown) Then run any attach/repair scripts (ours run auto in our installer).
-Frank
I work for a company that packages MSDE and MSSQL 8.0 because our software requires storing client information in a database. The problem is that we've found that if the our users have another DB engine installed (BDE or Paradox usually), our program has trouble using MSDE to access the database and thus making our software inaccessible. It behaves as if this other database engine locks on our database before MSDE can. I'm basically looking for help on either how to uninstall these other db engines or how to get around this problem so that both MSSQL and other db engines can co-exist in one system.I'd try to dump the data out of the other database to some type of file then import it in to sql server. Just a thought|||Thanks for the idea garrydawkins but unfortunately that's not an option we have.|||Does SQL Server have to be installed on everyone's desktop? Can it not be installed on a dedicated server, and everyone who uses your software can utilize this single instance?|||depends on the chosen environment, we have the ability to use a machine as a dedicated server, unfortunately, servers are used as servers. If they are serving our product, they are serving the conflicting product. We also have a lot of "stand-Alone" Clients. Not an option here either. Sorry for being difficult. :(|||Wow.. so the Stand-Alone clients, and the distributed clients both require the full install of SQL Server? Sounds overkill for the Stand-Alone. One idea might be to use Access for the Stand-Alone implementations, and SQL Server for the distributed clients. That might require significant recoding of the install, and the app (to execute SQL vs Access specific statements), but it would probably solve the problem.
At the same time, it would reduce the cost of your Stand-Alone version (since they won't have to purchase a commerical SQL Server license), be cheaper for your clients, giving you an edge over your competators.|||I work with Geeneus,
ok, the MSDE (MSDE 2000) is only running on the server, the workstations are not required to be running the server app(sorry about being unclear about this). This in turn, explains why a stand-alone is required to run it as well. Turning the client app to Access is a leap backwards, and not needed. The symptom we are experiencing, is that another database app is grabbing a hold of our database before MSDE can grab it. I suspect BDE (Borland), Paradox, Delphi (also Borland), etc...is just reacting faster and putting a lock on the database even though it is not using it. I know that this BDE can come from many sources, the most common being things like the "Corel" office suite. Anything from Oracle will be using Delphi. Any suggestions?
Xero|||I don't care for Access either, I understand, just trying to think of an option that wouldn't have you writing your own :). Is it possible this other app is running as a service? In which case you could simply disable the process.|||yea, thats my assumption. I am having huge troubles locating the offending app/service. BDE tends to hide. In most cases the MSDE will install. It is when we try to run the configuration scripts to attach the database is when it blows up. Something allready installed has grabbed ahold of it and locked it.|||Good News!!
Reverend managed to figure out how to work around the problem. I'll let him explain it but just wanted to give you all the good news!!|||I have discovered a conflict btween what was called MQIS (MSMQ), and is now Active Directory. This MQIS thing came with early versions of Windows, i.e. Win95, Win98, and NT4. It has an installed backbone of SQL 6.5. If, throughout its lifetime, any of these components have been removed, then this issue can arise. Identification can be made by Start -> Programs -> Startup. I have noticed that the MSDE will show as "Service Manager" and the other instance will be called simply SQL Server. Remove SQl server from startup and run your configuration scripts. viola. Be advised that the next time this client runs any exe that calls for that old SQL Server (app in the case of win9x) it will be reactivated in startup and cause this nightmare again.
Have also seen strange(same) behavior while trying to install the MSDE after the newest version of quickbooks is installed.|||stupid user tricks:Install MSDE to a win98 machine, upgrade to WIN2k or WINXP. Now the database can not be read by the MSDE.
I believe that the MSDE installes as a application, when you roll up to xp or 2k, you suddenly have services and POOF! we get blown out of the water.
anyone had any experience with this and have a workaround/fix?|||Install MDAC 2.7 then uninstall the MSDE. Then reinstall the MSDE, it will now install as a service rather than an application. (This was tested from 98 to XP, 2000 is still unknown) Then run any attach/repair scripts (ours run auto in our installer).
-Frank
Wednesday, March 7, 2012
MS SQL 6 yes 6
Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
We have a 6 running that can't be upgraded and now it's in need of some TLC.
Mike
It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA
|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>
|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
We have a 6 running that can't be upgraded and now it's in need of some TLC.
Mike
It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA
|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>
|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
MS SQL 6 yes 6
Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
We have a 6 running that can't be upgraded and now it's in need of some TLC.
MikeIt's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. B
ut EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business.
I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
We have a 6 running that can't be upgraded and now it's in need of some TLC.
MikeIt's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. B
ut EM 7.0 can only
connect to 7.0 instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business.
I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
MS SQL 6 yes 6
Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
We have a 6 running that can't be upgraded and now it's in need of some TLC.
MikeIt's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
--
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
>> We have a 6 running that can't be upgraded and now it's in need of some TLC.
>> Mike
>|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> > Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> > We have a 6 running that can't be upgraded and now it's in need of some
> > TLC.
> >
> > Mike
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
We have a 6 running that can't be upgraded and now it's in need of some TLC.
MikeIt's been a while but i seem to remember. SQL 7 client can connect to SQL
6.5, but SQL 7 EnterPrise Manager can't control SQL 6.5 installs.
If you've got a spare client PC give it a try...
--
HTH. Ryan
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike|||"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> We have a 6 running that can't be upgraded and now it's in need of some
> TLC.
> Mike
I don't remeber or sure, but I don't think you can do it.
You may be stuck with isql and/or osql.
Rick Sawtell
MCT, MCSD, MCDBA|||Correct. The 7.0 QA and the MDAC that came with 7.0 can connect downwards. But EM 7.0 can only
connect to 7.0 instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:utaUTY6FGHA.2652@.tk2msftngp13.phx.gbl...
> It's been a while but i seem to remember. SQL 7 client can connect to SQL 6.5, but SQL 7
> EnterPrise Manager can't control SQL 6.5 installs.
> If you've got a spare client PC give it a try...
> --
> HTH. Ryan
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
>> Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
>> We have a 6 running that can't be upgraded and now it's in need of some TLC.
>> Mike
>|||Thanks all. Unfortunately this application was purchased many years ago and
is only validated on SQL 6.5. The company has since gone out of business. I
may have to write a new app.
Thanks
Mike
"Rick Sawtell" wrote:
> "Mike" <Mike@.discussions.microsoft.com> wrote in message
> news:1AAB45AD-9A72-49AD-A9A5-DC4A08BA69E9@.microsoft.com...
> > Does anyone know if the MS SQL 7 client can connect to a MSSQL 6 database?
> > We have a 6 running that can't be upgraded and now it's in need of some
> > TLC.
> >
> > Mike
> I don't remeber or sure, but I don't think you can do it.
> You may be stuck with isql and/or osql.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
ms sql 2005 developer edition bugs
Hi everyone ,
I am doing application testing using MSSQL 2005 Developer Edition. So ,
I would like to know if there is any site or forums that discuss the
errors in Developer edition that has been fixed so that i can list it
down.
Thanks.This forum is appropriate to discuss SQL Server 2005 issues. You can also
search/submit bugs and enhancement requests at the Product Feedback center
at http://lab.msdn.microsoft.com/productfeedback/.
It's often best to discuss first in case someone has additional input.
Hope this helps.
Dan Guzman
SQL Server MVP
"rynox" <marvin.koh@.orisoft.com.my> wrote in message
news:1147136964.707525.9580@.v46g2000cwv.googlegroups.com...
> Hi everyone ,
> I am doing application testing using MSSQL 2005 Developer Edition. So ,
> I would like to know if there is any site or forums that discuss the
> errors in Developer edition that has been fixed so that i can list it
> down.
> Thanks.
>|||Check the following site:
http://lab.msdn.microsoft.com/ProductFeedback/
-Sue
On 8 May 2006 18:09:24 -0700, "rynox"
<marvin.koh@.orisoft.com.my> wrote:
>Hi everyone ,
>I am doing application testing using MSSQL 2005 Developer Edition. So ,
>I would like to know if there is any site or forums that discuss the
>errors in Developer edition that has been fixed so that i can list it
>down.
>Thanks.
I am doing application testing using MSSQL 2005 Developer Edition. So ,
I would like to know if there is any site or forums that discuss the
errors in Developer edition that has been fixed so that i can list it
down.
Thanks.This forum is appropriate to discuss SQL Server 2005 issues. You can also
search/submit bugs and enhancement requests at the Product Feedback center
at http://lab.msdn.microsoft.com/productfeedback/.
It's often best to discuss first in case someone has additional input.
Hope this helps.
Dan Guzman
SQL Server MVP
"rynox" <marvin.koh@.orisoft.com.my> wrote in message
news:1147136964.707525.9580@.v46g2000cwv.googlegroups.com...
> Hi everyone ,
> I am doing application testing using MSSQL 2005 Developer Edition. So ,
> I would like to know if there is any site or forums that discuss the
> errors in Developer edition that has been fixed so that i can list it
> down.
> Thanks.
>|||Check the following site:
http://lab.msdn.microsoft.com/ProductFeedback/
-Sue
On 8 May 2006 18:09:24 -0700, "rynox"
<marvin.koh@.orisoft.com.my> wrote:
>Hi everyone ,
>I am doing application testing using MSSQL 2005 Developer Edition. So ,
>I would like to know if there is any site or forums that discuss the
>errors in Developer edition that has been fixed so that i can list it
>down.
>Thanks.
ms sql 2005 developer edition bugs
Hi everyone ,
I am doing application testing using MSSQL 2005 Developer Edition. So ,
I would like to know if there is any site or forums that discuss the
errors in Developer edition that has been fixed so that i can list it
down.
Thanks.This forum is appropriate to discuss SQL Server 2005 issues. You can also
search/submit bugs and enhancement requests at the Product Feedback center
at http://lab.msdn.microsoft.com/productfeedback/.
It's often best to discuss first in case someone has additional input.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"rynox" <marvin.koh@.orisoft.com.my> wrote in message
news:1147136964.707525.9580@.v46g2000cwv.googlegroups.com...
> Hi everyone ,
> I am doing application testing using MSSQL 2005 Developer Edition. So ,
> I would like to know if there is any site or forums that discuss the
> errors in Developer edition that has been fixed so that i can list it
> down.
> Thanks.
>|||Check the following site:
http://lab.msdn.microsoft.com/ProductFeedback/
-Sue
On 8 May 2006 18:09:24 -0700, "rynox"
<marvin.koh@.orisoft.com.my> wrote:
>Hi everyone ,
>I am doing application testing using MSSQL 2005 Developer Edition. So ,
>I would like to know if there is any site or forums that discuss the
>errors in Developer edition that has been fixed so that i can list it
>down.
>Thanks.
I am doing application testing using MSSQL 2005 Developer Edition. So ,
I would like to know if there is any site or forums that discuss the
errors in Developer edition that has been fixed so that i can list it
down.
Thanks.This forum is appropriate to discuss SQL Server 2005 issues. You can also
search/submit bugs and enhancement requests at the Product Feedback center
at http://lab.msdn.microsoft.com/productfeedback/.
It's often best to discuss first in case someone has additional input.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"rynox" <marvin.koh@.orisoft.com.my> wrote in message
news:1147136964.707525.9580@.v46g2000cwv.googlegroups.com...
> Hi everyone ,
> I am doing application testing using MSSQL 2005 Developer Edition. So ,
> I would like to know if there is any site or forums that discuss the
> errors in Developer edition that has been fixed so that i can list it
> down.
> Thanks.
>|||Check the following site:
http://lab.msdn.microsoft.com/ProductFeedback/
-Sue
On 8 May 2006 18:09:24 -0700, "rynox"
<marvin.koh@.orisoft.com.my> wrote:
>Hi everyone ,
>I am doing application testing using MSSQL 2005 Developer Edition. So ,
>I would like to know if there is any site or forums that discuss the
>errors in Developer edition that has been fixed so that i can list it
>down.
>Thanks.
Subscribe to:
Posts (Atom)