I'm thinking to upgrade SQL6.5 DB to SQL 2000 but do not know
all client access with SQL 6.5 utility will work ???
(The application is a vendor canned package using SQL 7.0 DB
but client can access with 6.5 ---Not using ODBC)
Any experts can help ?
Thank you in advance !!
Lewis
I`m planning on installing sql7 beta on my desktop. Currently I have sql6.5 client tools installed on my desktop for performing DBA tasks against our test and prod. sql6.5 servers. Does anyone know if installing sql7 will conflict with my sql6.5 client tools or cause any other problems?
Thanks
Can my Access 97 db's connect to both a SQL 6.5 and 7.0 without a problem.
has anybody tried this?
Does anyone know how to upload (bulk) data from a client (written in Excel VBA) to a remote SQL2000 database? Of coarse I tried "INSERT INTO" and rst.addnew but I noticed this is much, much slower as downloading from the same remote database.
Thanks.
OK, I'm stumped and could do with some help. I have a laptop running Vista (64bit) with the SQL 2005 client tools. At home, I have SQL Server 2000 running on Windows Server 2003. I cannot get the SQL 2005 to talk to the SQL Server 2000. At work, we have SQL 2000 running on NT 5.0 and it connects fine. I also have a second laptop with SQL 2000 client tools running on XP SP2 which conects fine to the SQL 2000 instance on the 2003 box.
The vista laptop talks to the 2003 server, so it's not simpy that there is no connection. Any ideas why I keep getting an error stating that the Server might not be accepting remote connections every time I try to connect the Vista machine to the SQL 2000 server? I can't connect either from the SQL management tool, nor via ODBC.
Any ideas would be much appreciated.
What is the best way to import or transfer a Access databaseto sql2000, I tried that wizard and for the life of me I cannot getit to work correctly.TIAMichaelPlease answer in the newsgroups so that others may see thieinformation also.
View 2 Replies View RelatedWe have some developers who manage SQL2000 servers from their WinXP workstations using Enterprise Manager. We have now rolled out our first SQL Server 2005.
Can we install the SQL2005 Management Studio side-by-side with Enterprise Manager on these WinXP workstations?
If not, what are most people doing in these cases?
Thanks!
Mike Hiland
Hello. I want to ask about the possibility of copying both a tablestructure and it's contents from aSQL server table to a table within MS access. The problem cannot besolve with a permanent table structure at the target location.The names of the columns are essentially data with the application andso are subject to change. I am targeting a solution using SQL QueryManager.The approach I have tried (with failure) isSELECT *INTO <linkedserver table>FROM <local table>This should create and copy. However, I am not sure if this isachievable with this approach.Refer to the dialogue;-------------------------------------------------------USE MASTERGOEXEC sp_addlinkedserver@SERVER = 'Freddie',@PROVIDER = 'Microsoft.Jet.OLEDB.4.0',@SRVPRODUCT = 'OLE DB Provider for Jet',@DATASRC = 'C: empHMIS_Recipe.mdb'-- I am not sure if this is requiredEXEC sp_addlinkedsrvlogin 'Freddie', false, 'sa', 'Admin', NULLSELECT * FROM Freddie...FRED -- This is OKSELECT * INTO #Temp FROM Freddie...FRED -- This is OK-- This fails - Refer errorSELECT * INTO Freddie.FRED65from #tempServer: Msg 2760, Level 16, State 1, Line 1Specified owner name 'Freddie' either does not exist or you do not havepermission to use it.-- This also fails and I thought reflected the above select with naming- Refer errorSELECT * INTO Freddie...FRED65from #tempServer: Msg 117, Level 15, State 1, Line 2The object name 'Freddie...' contains more than the maximum number ofprefixes. The maximum is 2.EXEC sp_dropserver 'Freddie',@droplogins = 'droplogins'------------------------------------------------------------Thank you.Regards JC...
View 3 Replies View RelatedI am runing Windows 2003 which has both SQL2000 and SQL2005.
The following works in 2000 but not 20005
Code Snippet
DECLARE @sql nvarchar(4000)
set @sql = 'sp_addlinkedserver @server = N''dbAccessPO'',
@provider = N''Microsoft.Jet.OLEDB.4.0'',
@srvproduct = N''OLE DB Provider for Jet'',
@datasrc = N''C:Temppopts.mdb'''
exec sp_executesql @sql
set @sql = 'sp_addlinkedsrvlogin ''dbAccessPO'', FALSE, ''sa'', ''Admin'', NULL'
exec sp_executesql @sql
Running this:
Code Snippetselect * from dbAccessPO...MyTable
Produces this error:
Code Snippet
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "dbAccessPO".
I login using sa for both instances.
I could really use your help.
Thanks.
Hi,
My department has some questions about Client Access Lisences. Specifcally, they want a definition of what does and does not require a CAL,
and they want something somewhat official. I checked the MSKB, and looked on their sales website, but all I can find is the EULA, and that doesn't help
me all that much.
Does anyone else have this information?
Joe
I am experiencing VERY slow connectivity between client and server SQL 2000. I have checked the network activity and it is low. It also takes Enterprise manager ages to load, and then browsing tables and trees is impossible!
HELP!!
Hello everybody,
I recently made a DTS-package from importing external data in my sql2k
server.
I linked my access file to the sql server to make some reports.
Right now, my clients run the dtsrun utility through a batch file
themselves. I gave them permissions to be the dbase owner.
Now when you link from access to sql server as admin, your names are :
dbo_Tablename.
If it's another user, the names get pvanmoer_Tablename and for another user
it's cvanho_Tablename.
(Validation through NT)
So my linked tablenames aren't valid anymore in my access file. So I need
to relink them each time.
How can I avoid this problem ? I've been trying to create tables without
dbaseowner, but this doesn't seem to work.
Can anyone help me ?
Thanks,
Bjorn
Hello Everybody,
I need some help.
When we install the Database at the clients end, the client can see all
the SQL tables, views and stored procedure in the Enterprise Manager.
Is there a way via which you can restrict the client from viewing the
tables in SQL Enterprise manager?
I hope you understand my question.
I would be oblidged if my friends could help me...
Thanks
Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?
It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.
Can DTS do this? The forms I'm talking about are select only, no editing.
I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.
Thanks,
Carl
Hi,
We're *very* new to using SQL Server and are just getting it up and running. We're only running simple queries right now, but we're doing so by connecting to our server via 'Remote Desktop' to run the management studio to run the queries.
Is there an SQL client that can be installed on a user's workstation that will allow them to run queries without having to use a 'Remote Desktop' connection on the server?
Thanks,
James
I want to give a client access to a SQL Server 7 database sitting on a different NT domain without setting up a trust relationship between the two domains. Has anyone tried doing this?
View 2 Replies View RelatedI have a DTS package that executes when run manually. It is a OLEdb (ODBC) to client access (db2). When I try to schedule it the package fails.
Other packages SQL - SQL are fine to schedule or to run man.
I have played with the Persist Security Info advanced properties of the connection to no avail.
Any assistance would be great.
Thanks
Robb M Sinclair
Newcomp Solutions Inc
I have a C# windows app trying to access database based the connection string stored in teh app.config file
Here is my app.config parameters
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="con1" connectionString="data Source=127.0.0.1sinclair;initial catalog=kingsroad;uid=balrock;pwd=123456;integrated security=True" />
</connectionStrings>
</configuration>
The reason I want to put an ip address on connection string i just want to create connection strings as people do in their work. When the app tried access the connection string it gives the error in the attachment.
Because I haven't used this user/password for a long time I'm pretty sure the user name and password is correct but i have the following questions
1. Assume the user and password is incorrect, is there way to reset this?
2. what other configuration that i need to do in order to make teh C# app access this Database?
I have an excel workbook, that has a pivot table in it where the data source is an OLAP cube. My problem occurs on the client machine, logged in as the client. I remote into the PC, and create a pivot table using the OLAP cube connection. I create the pivot table and everything works fine - I am able to browse the data with no issues. Once I exit the Excel Workbook, and come back in - I am no longer able to connect to the datasource. I have tried both saving the password in the connection and not saving it. It has made no difference.
View 1 Replies View RelatedHi there
If I give the user access dbo on 1 of the database, when he logon using SQL Server Management Studio for running query etc, can he only see his database instead of other as well system database?
Is there any best practise in term of setting the SQL client for 2005?
Thanks
Hi all...
I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)
The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.
Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.
So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.
Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.
Am I on the right track here? Any ideas appreciated!
Thanks,
Forch
Hi,
I have SQL Server 2005 installed and functioning (it does everything I've asked it to do locally). I also have the Express and Standard Editions installed on a computer running WinXPPro SP2 with all the WinUpdates applied. I also have VS2005 installed on this computer. I've done some development work on this computer, using VS2005 to create a SQLDB, connect to it, add data, etc. This is all okay.
The problem is I cannot connect to the SQL Server from the client computer. I installed the client tools on this XP Pro box along with all the WinUpdates. Here's what I can do...
I can ping the SQL Server by name (the name gets resolved).
I can copy files between the two computers using Explorer.
I enabled "Allow remote connections to this server" in the Server Properties / Connections page.
I did not change the default port of 1433.
The TCP/IP protocal is enabled in the Configuration Manager.
The Surface Area has been configured to allow local and remote connections using TCP/IP and named pipes.
SQLBrowser surface is running as is the MSSQLSERVER service.
So what's going on? I am new to SQL Server to it may be something very simple / obvious.
Thanks for your help,
Scott
I work at a place that does device testing where the test results are saved in a SQL database. I have an objective to create a plan for a pilot project to place the data on our intranet so our engineering dept can research test results.
I'm trying to find some group I can beg / borrow / pay to look at our schema and help me chart out what tools we should use and how much (ballpark) work is involved.
I'm a VB.NET developer. I did a tutorial on SQL Reporting Services and see potential there. I skimmed a tutorial on SQL Analysis services, and like the idea of being able to trend our data. But it's over my head at this point to get from where I'd like to be to what Microsoft tools to use and how to put them together.
I contacted one local DB/Developer shop and they wanted to bring in a team of engineers for two days and charge us $6000 for a "total solution". Instead of that, I'd like to maybe spend an hour on the phone and some emails to send a schema to someone who knew the tools inside/out and get a pretty good recommendation for a reasonable price.
Any ideas on how I can find such help?
thanks much - Mark
Hi,
I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine.
Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database...? (eg: Net Framework, SQLExpress, etc).
Also, if my machine is called ABC123, in my connectionstring do I just put in
ABC123sqlexpress as the datasource..?. Will this be enough for the other PCs to connect to mine ?
Thanks
we have a sql express - that comes standard with servers.I just wanted to know.....Is there any addition Client access licenses needed for this sql express or not.
View 1 Replies View Related
I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.
His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"
However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".
There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".
His current config.xml file looks like this.
<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>
He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error
"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"
I dont know what else to try! Anybody have any suggestions?
I've installed SQL 2005 Express, enabled local and Remote connections but my client app cannot connect to the SQL server. I'm getting access denied or SQL does not exists. Any idea's on how to resolve this issue?
View 1 Replies View RelatedHi,
I have a quick question regarding domains and workgroups.
Currently I am working on an issue in the office of a small business. Right now there are 3 client computers that connect to a dell server running windows std. server 2003. The server has sql running on it that takes care of the invoicing system. Two out of the three work stations are able to use the database fine, but there is one that is unable to connect to the database. The only different that I could find is that the two workstations that DO work are currently set to use a workgroup, whereas the one workstation that does NOT work is set to use a domain...... I tried switching that computer to workgroup, but then I was unable to login as the normal user that I had always logged in as before.....
What can I do to solve this dilemma?
Any help would be greatly appreciated!
I apologize if this is the wrong forum for this, and if it is, if someone would point me to the correct one I would appreciate it.
Thanks
-steve
Hi,
I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients dont connect to database thru my application. It gives error as follows.
Runtime error
Login Failed for user (null) . Reason: Not associated with a trusted SQL Connection.
Can anyone help me?
Regards
Ahmed Sahib
Hi~.
First, is it possible to access(read/write) to the excel,csv or my-own-formatted file using OLE DB(SQL Native Client)?
If possible, how?
I am using SQL Express 2005 and VB .net Express.
Question 1:
How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph).
Question 2:
How to store Inserted.ColName into local variable when insert command is running in stored procedure.:
Every day between 1AM to 2AM client disconnect happens and it's not too long also...it's about 30secs...nothing is recorded from SQL side and application server side and then we checked the network...there is no disconnect from network side too. How can i find the cause for disconnect.Β
View 4 Replies View RelatedHi guys,I'm not sure if I'm just bad at googling but I can't seem to find a way to set an ASP.NET 2.0 web application to connect to SQL Server 2005 using the current client's user credentials. My web application is using Integrated Windows Authentication so its Page.User.Identity is set to a DOMAINusername value... I want to pass that to my connectionstring or have my connections pick up the identity automatically and use that Identity when accessing the db server.Oh and another thing, my IIS Application Pool is using a specific Identity itself, so I don't know if that might affect the above.Hope someone could help.
View 2 Replies View Related