Using SQL servers located in 7 locations. Want to be able to setup ODBC Connection to all servers using 1 "System Data Source" name so that by clicking on this I will be connected to all 7 servers at once. Is this possible?
Thanks
langston2
Hi,
I have install Microsoft Visual C# Express Editon 2005 from MSDN site. I have follow this step
.
Uninstall beta versions
Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0.
2.
Download and install
Download and install Visual C# 2005 Express Edition!!
Download
Note: Having network issues or need to burn a CD for offline installation?
Follow the manual installation instructions.
3.
Register
Why
register? You€™ll need to get your registration key. Additionally,
you€™ll get a lot of free stuff including royalty-free images from
Corbis, online training from Microsoft Learning, E-books from Microsoft
Press and more. Learn more about registration benefits.
before that i also insatl IIS from windows service pack 2
My problem starting when I'm trying to enable connection to the database with setup the ODBC my step
1.Start>>Control Panel>>Administrative Tools>>Data Sources(ODBC)
2.System DSN>>Add
3.Select>>SQL Server>>Finish
4.Put Name:>>>Choose Server:>>>Next
5.Select>>>With SQL Server authenticationusing a ID and password enter by user>>>Connect to SQL Server>>>put Login ID:sa>>>Next
6. Test Data Source
7.Error
Connection failed:
SQL State:'01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect( )).
Connection faild:
SQL State:'08001'
SQL Server Error: 7
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
Please help me step by step. I'm using C# to build application that can pullout data from card using chip like smartcard or chip based card. The data then save to database in SQL. Using Macromedia I'm build a website that can publish the data to web site. My mission to set up my CPU as Server using SQL Server. I'm build all my project in the same CPU with the server.
tq.
I am trying to setup an ODBC data source for Access. The server I'm trying to connect to is 2008 R2. I have SQL Server Management Studio installed on the computer where I'm trying to make the ODBC Data Source from. I can connect the the remote 2008 server through Management Studio, but in the ODBC wizard I do the following:
"Machine Data Source" tab, click "New"
Select "User Data Source", click "Next >"
Select "SQL Server", click "Next >"
Click "Finish"
Name: remote
Description: remote
Server: type the server name ie "sql.somewhere.com"
[code]....
Hello All
I am trying to use SQL 2005 express as a datasource for a mailmerge with Word 2000.
I have created a ODBC link successfully. I have enabled all the protocols. When I open the ODBC link, all I see is a ODBC drop down. I cant see or select any database tables?
When I open the dsn I get a dialog caled Header Record Delimiters. I accept the defaults and then I get another Dialog called Mail Merge Recipients with a whole lot of connection info, but no sign of any database tables.
Any Ideas?
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
We're doing upgrades from SQL 2008 R2 to SQL 2014. This is blocked due to RS is installed but not configured. Our desired action is to uninstall RS and proceed with the upgrade. But when setuparp.exe is raised, it does not list all the features on the 'Select Features' page. In fact, it only lists the last 2 shared features (SQ Client Connectivity SDK and Microsoft Sync Framework). However, all items appear to be listed on the 'Select Instance' page including RS. I've seen this issue on 2 of our SQL 2008 R2 Servers already.
View 3 Replies View RelatedI'm trying to install SQL Server Management studio 2012 on my Windows 7 (x64) standalone laptop. When I click "New SQL stand-alone installation..." it runs a Setup Support Rules check and always fails "Setup Account Privileges". I've looked into the error and I keep getting that I need to change security rules but I don't have that option in window 7. How do I get around this without having to resort to a computer running Windows Server?
I have Visual Studio 2013 premium installed along with Localdb v11. I just want to connect and manage my database engine through SSMS when developing any application.
This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.
Thanks
I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.
When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650
SQL Server Integration Services  Â
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.
I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938
SQL Server Integration Services  Â
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?
Hi,
I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".
When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.
How can I use DDL statements via ODBC?
I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.
Thanks for help!
Regards,
Stefan D.
I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:
MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2
If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.
I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
Hi all,I am having trouble getting linked Oracle 9 server in MS SQL Server2005 Express to work properly. My machine is running Windows XP.The Microsoft and Oracle OLE DB Providers have problems dealing withOracle's Numeric Data Type, so I decided to use Microsoft's OLE DB forODBC Provider and an Oracle ODBC source. When using the Microsoft ODBCfor Oracle Driver in my ODBC source I have inconsistent behavior.Sometimes my queries are processed properly, then other times I get thefollowing errorOLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttrfailed".OLE DB provider "MSDASQL" for linked server "ODBCBEAST" returnedmessage "[Microsoft][ODBC driver for Oracle][Oracle]".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL"for linked server "ODBCBEAST".I have no idea why sometimes I can connect to the linked server with noproblems andwhy other times it performs like this. I'm not changing anything aboutthe system I can think of. When I use an Oracle client (PL/SQL) I haveabsolutely no problems connecting. TNSPING returns that the connectionis good.This is unacceptable so I decided to try my luck with the Oracle 10gODBC driver. However when I use this and perform an openquery selectagainst the linked server I get back only 11 rows, when I know that thedatabase has over 100 rows (in fact when using the Microsoft ODBCdriver and it works that's what I get). I figured maybe the buffersetting needed to be raised in the ODBC configuration so I took it from64000 to 600000 (a magnitude of 10) but I still get back only 11 rows.I'm at my wit's end.Any suggestions on resolving one or the other problem would be muchappreciated.Thanks much
View 2 Replies View RelatedHi,
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
Any help will be appreciated.
Thanks,
vtluu.
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Hello everyone
I know this is discussed very often, but please indulge me.
I have two hardware/software configurations for the SQL servers,
(1) NT4 + SQL7 on 2HDD's (C/D-drive) and,
(2) NT4 + SQL7 on 3HDD's (C/D/E-drive).
What will be the best configuration for SQL regarding:
a. RAID,
b. placement of the OS,
c. placement of the data & log files(devices),
d. local(hdd) backups
Regards
George
Hello!
I`m new to SQL Server, so excuse this if it`s a well-known
problem with a well-known solution.
I tried setting up SQL Server 6.5 (the box but not the
docs or install claims it`s an
upgrade product) but the install hung at "Setup is now
installing the initial SQL Server configuration" for over
10 minutes. That is, the install kept processing
something but did not appear to be coming to an end until
I killed it. This happened repeatedly, and on a second
server, too.
I then installed 6.0 (over 6.5!), and was able to install
6.5 over 6.0. However, I`m not able to install the 6.5
docs.
SQL Server appears to run (although I`ve not tried any
DB stuff).
Any suggestions? Should I uninstall and start over?
best, paul
Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005
On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Serverinstance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...
On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.
Now I can use the sql 2005 by refering to the serverB name (Not an instance).
In Server A, the applications are using a login name (sql authentication) i.e. username, password.
Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)
2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?
Thanks
Hi All
Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.
My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.
Please can you help.
Many Thanks
Hi All
Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.
My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.
Please can you help.
Many Thanks
I need help with SQL Server 2005 Setup.
View 1 Replies View RelatedHow would I set up a sql server database based on the following problem? I will be creating a poll based on 9 dimensions that compare two companies.
honda yamaha performance features reliability conformance durability serviceability aesthetics safety other perceptives
The values stored would be 1 or 0 so the values can be totalled. The user will be using a web pageand will select a radio button per dimension for either honda or yamaha. Would this work?
tbl_companiescompanyid int pkcompanyname varchar
tbl_resultsresultsid int pkp int --performancef int --featuresr int --reliabilityc int --conformanced int --durabilitys int --serviceabilitya int --aestheticssf int --safteyop int --other perceptivescompanyid int -- fk to tbl_companies.companyiduserid int -- fk to tbl_users.userid
tlb_usersuserid int pkusername varcharuserip varchar
I have an asp 2.0 app that connects to a database in another city.
When I test this app through VS2005 is connects and works great. After I created a web setup project it goes bad.
I ran the setup on 2 different computers, including the dev machine, both start ok and bring up the applications main menu, but when I choose a menu item that is supposed to bring up a datagrid from the sql server I get an error saying it's not a trusted connection.
Any advice on where I should start looking? It's got me beat.
Thanks.
Hi Everybody,
I was trying to install the SQL Server on my machine and I successfully did it because the server is running. I can get into the Enterprise Manager (without password) and I'm able to create new databases. Except, I can not log into those databases with the userid that I also created with full access. It must be somekind of security issue but I can not figure out what. The message says: "Unable to connect to server local - SQL server does not exist or access denied". If I look at my SQL service manager my server name is "NEWONE" , which is also my computer name. So, I'm not sure what's wrong. I tried to log in with the 'sa' account it doesn't work either.
I would appreciate any help you can give me.
Thank you,
Laszlo
I must install web applications on many servers
how can I create a MS SQL database at setup ?
thank you
Hi can you help me with this problem with msde
I have installed MSDE200A and i didn’t gave any password(setup BLANKSAPWD=1).
My configuration code for the connection with msde is:
<appSettings>
<add key="DSN" value="Initial Catalog=dyt_mac;Data Source=localhost;Integrated Security=SSPI;"/>
</appSettings>
When i try to connect with the database this error occurs:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Thank you!
hello everyone,it's first time for me to write here and also to use SQL.While i was installing SQl 2000 i got Setup Message said:" Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client component will be available for installation."Hope to know what's wrong, and please guide me.Thanks alot
View 6 Replies View RelatedHi all
I have a client application which is running winnt4 sp6, sql7 sp1, gives the following error.
Msg 18458, Level 14, State 1, Server Microsoft SQL Server, Line 0
Login failed- The maximum simultaneous user count of 5 licenses for this
server has been exceeded. Additional licenses should be obtained and
registered via the Licensing application in the NT Control Panel.
I have found in technet article no Q180364, which ask to rebuild the registry of sql server. Was wondering anybody had the same experience. I can't shutdown the server more than 30 mins.
Any guidence or suggestion ?
Thanks in Advance
Jaya.
I need to replicate a database which will be updated both sides.Table doesn't have the primary key,and already has data.Please advice which replication will suit and what are the limitations.URGENT!!
Thanks!
Hello all,
What is the hardware configuration for mssql 7.0 in order to achieve best performance. Some people suggest that
1. Dual Processors
2. 1G memory
3. RAID Controller
4. 2x9.2 GB RAID 1 for o/s and log files
5. 3x182. GB RIAD 5 for database
Your input is much appreciated.
Sui S
Ok I have installed SQL 7 on my NT4sp4/MIIS box.
Can someone please tell me how to add a SQL DB to my website? and can I do this remotely?
Amy
We are working on a new Payroll server. Our payroll department wants to lock out MIS and SQL Admins as much as possible. What we would like to do is allow the SQL Admins to still perform admin tasks such as backups, audit tracking, etc, while not being able to get into the tables. Also, we would prefer to do this security at the database level, rather than the server level. Any thoughts on this?
Tim Davis
Hi,
I'm trying to setup SQLAgentMail but received no message.
I have setup my SQL SERVER:
- using Domain Administrator to start SQL SERVER
- using Domain Administrator to start SQL SERVER AGENT
- created a mail profile called Test which has mailbox point to my domain user email account when I logged in my SQL SERVER machine as Domain Administrator
- setup Test as the mail profile in the Mail Session of the SQL SERVER AGENT PROPERTIES
I have clicked the Test button in the Mail Session and it return with the message "Successfully start (and stopped) a mail session with this profile."
But I don't get the testing email in my domain user email account.
Thank you in advance for any help.