SQL SRVR 2008 And Vb6
Dec 3, 2007
Hi
i am new to sql2008 and coming from vb6,sql2000 background. We tried Orcas. we dont want to move our project to dotnet for atleast one year. we want to makie it tune with windows vista also. so kindly tell us which version of adodb can be used with vb6 and sql2008. i am pasting our old code from vb6 here.
Code Block
dim cn as new adodb.connection
cn.open "Provider=SQLOLEDB.1;password=NETECH0507;Persist Security Info=False;User ID=sa;Initial Catalog=" & dbname & ";Data Source=" & gStrSQLServerName
Let me know what are the changes required while connecting with vb6 and sql 2008 express edition
Rgds
Pramod
View 6 Replies
ADVERTISEMENT
Sep 24, 2001
Hi!
I have tried installing SQL Server 7.0 on my Win 98 machine. My machine has all the latest service packs and I think it is reasonably up to date. I've tried installing from the disc 3 times and it fails to install:
the Server Network Utility and Service Manager.
As a result, I am unable to register my local machine as a SQL server.
Any ways around this? Quick fixes?
Thanks!
--Michelle
View 4 Replies
View Related
Sep 19, 2000
Our network people changed our machine name one character without our permission, they say their naming standards can't handle an "underscore" we put in our name...now the SQL Server won't run because it doesn't recognize the name of the machine.
Is there a way of bypassing or telling SQL server that we changed the name without having to reload all of our information?
View 2 Replies
View Related
Oct 11, 1999
We have a development server that will only run SQL Server from a DOS command prompt. Each time I reboot the server the services don't autostart, and I am unable to start them manually using Service Manager. Does anyone know what I can do to fix this problem?
Thanks
View 1 Replies
View Related
Feb 12, 2004
Whenever I am trying to put my secondary server operational as my primary (primary is not available) by running
sp_change_secondary_role
@db_name = 'TX_ACCT',
@final_State = 1,
@access_level = 1,
@terminate = 1
I am repeatedly getting this message
Server: Msg 3021, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
Cannot perform a backup or restore operation within a transaction.
Server: Msg 3013, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
RESTORE DATABASE is terminating abnormally.
Server: Msg 226, Level 16, State 1, Line 1
ALTER DATABASE statement not allowed within multi-statement transaction.
Can you please help? This is urgent
View 6 Replies
View Related
Jun 3, 2008
Hi all,
Hope someone can help: by default, there's an entry for 'public' in server permissions (right-click server in Management Studio > Properties > Permissions), which has 1 selection: 'View All Databases' is set to 'grant'. I wanted to disable this permission, and so unfortunately unchecked the 'grant' tickbox but forgot to tick the 'deny' tickbox. What appears to have happened is the entire 'public' entry has been removed, meaning I can't go back and reselect 'grant' (or 'deny') for 'View All Databases'. I'd really like to get the 'public' role to reappear... Is that possible?
A very big thanks for any help!
View 1 Replies
View Related
Jan 15, 2008
Dear all,
We've a denormalised database (SQL Server 05) with around half a million rows, feeding a fairly simple Analysis Services cube. We were hoping to use the Excel 07 DM add-in as a user-friendly interface to lots of people, but as far as I can tell we need to first import the data into an Excel 07 worksheet. I realise 2007 has a 1mn limit, but the rows are wide, downloading GBs is not possible, and I have concerns about Excel performance and reliability at these volumes, especially on a desktop.
Is there any way to use the data mining functionality without having the data in Excel?
If not, what would be the simplest/quickest/cheapest way of providing this functionality (or subsets of it) to people who know Excel but not data mining?
Thanks for any guidance or corrections,
Chris
PS. Would downloading subsets of the data work, along the lines of the article entitled Sampling Nested Tables ( http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=14 )?
View 8 Replies
View Related
Dec 17, 2006
Posted - 12/17/2006 : 07:23:22
Hi,
I have just started to learn SQL Server 2005, and am currently using the MCTS SQL Server 2005 Self-Paced Training Kit. I am literally at the very start, and already seem to have hit a snag and can't figure it out. From browsing here in the past I recall people here seemed quite clued up, and I was hoping someone might be able to assist.
I am using SQL Server 2005 Ent. Edtn. (trial) on Win XP Pro (SP2). I am basically trying to run a sample script copied from book to create a database and primary, secondary and log files. Whilst I have the theory down, and thought I understood the SQL (have used other DBMSs in the past, MySQL/ACCESS etc.) I am getting an error when trying to run the following code when connected to the default instance on my PC. The code I am trying to run is:
create database Sales
ON
primary
(name = SalesPrimary,
filename = E:Sales_DataSalesPrimary.mdf,
size = 50mb,
MAXSIZE = 200,
filegrowth = 20),
Filegroup SalesFG
( name = SalesData1,
filename = F:Sales_DataSalesData1.ndf,
size = 200mb,
maxsize = 800,
filegrowth = 100),
( name = SalesData2,
Filename = F:Sales_DataSalesData2.ndf,
Size = 400mb,
Maxsize = 1200,
Filegrowth = 300),
Filegroup SalesHistoryFG
( name = SalesHistory1,
filename = F:Sales_DataSalesHistory1.ndf,
size = 100mb,
maxsize = 500,
filegrowth = 50)
LOG ON
(name = Archlog1,
Filename = G:Sales_DataSalesLog.ldf,
size = 300mb,
maxsize = 800,
filegrowth = 100)
I find I get the following error message:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'E'.
Msg 132, Level 15, State 1, Line 16
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 22
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.
Anyone have any ideas? Your help is greatly appreciated!
Thanks,
Will
View 8 Replies
View Related
Dec 30, 2005
The install went smoth with no error messages. But when I try to open report manager, I am getting the following message:
"The report server is not responding...."
When I try to access the report server, I get:
"The report server has encountered a configuration error. Access denied to the path c:program filesmicrosoft sql servermssql.3
eporting services
eportserver
sreportserver.config' is denied"
I have two partitions on win xp. These are C and D. C is a system drive and this is where sql server 2005 is installed as well.
Any ideas?
View 2 Replies
View Related
Mar 31, 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
View 1 Replies
View Related
Dec 23, 2007
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008
View 1 Replies
View Related
Feb 25, 2008
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
View 1 Replies
View Related
Mar 7, 2008
Hi all,
New to this so please be patient and please help.
I have developed an SQL 2005 Express command line option install for our company which has been working seamlessly for the last 18 months.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
I downloaded the €œMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €œSQLEXPR.EXE€? with the 2008 file €œ€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €œsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €œnext€? than €œback€? it now allows me to add the €œsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €œMicrosoft SQL Server 2008 CTP, February 2008€? installation?
2. If so is this causing the command line install options to fail?
3. How do I obtain a version of €œMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
Thanks in advance.
View 1 Replies
View Related
Apr 23, 2008
Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
Any pointers to documentation or any advice?
Thanks,
A Brown
View 1 Replies
View Related
Apr 15, 2008
Hello,Is SQL Express 2008 already available for download? Where can I get it?Is it shipping already with VS 2008?Thanks,Miguel
View 5 Replies
View Related
Jun 4, 2008
Hi All
Im trying out connecting to a SQL Server database.
Ive got a Web Application and have Dragged and Dropped a SQLDataSource on the page.
Ive Selected the "Configure Data Source" option on the component.
Ive then selected the "New Connection" button on the "Configure Data Soure - SQLDataSource1" pop-up window.
Choose Data Source Ive then selected the "Microsoft SQL Server" then pressed continue.
On the "Add Connection" Window Ive then:-
Selected the Server Name from the drop down list
Selected the "Use Windows Authentication"
Selected "Select or enter a database name" and put a path in like "C:DataMyDatabase.mdf"
then pressed the "Test Connection" and get "Test Connection Succeeded" (this is the same whether a DB path exists or not ???)
then pressed ok and the following message appears:-
"Unable to find the requested .Net Framework Data Provider. It may not be Installed"
Any ideas why ?
tia
Andrew
View 1 Replies
View Related
Apr 9, 2008
Hi this is srinivasa rao ,installation problem server configuraions sqlserver 2008 express edition username and password do not match the error
View 1 Replies
View Related
Jun 18, 2007
Hi,
does anyone have some information about the further developments of bi in the next release SQL 2008? Does anyone have a kind of timetable for the release?
Thanks in advance,
hs
View 7 Replies
View Related
Mar 11, 2008
Howdy,
With SQL 2008 do out in the near future, I need to know the specs on SQL CE 2008.
I have been digging around on the net but it looks like mum is the word thus far... so I am going to ask you straight out.
Please give us all a taste of the spec for SQL CE 2008 including the following:
Will Linq be supported?
What Proc limit will be supported?
What DB size limit will be supported?
How many concurrent connections will be supported?
Will .net types be supported?
Will the new filestream type be supported?
One last question on SQL CE 2005. As I am sure you are aware - Server Manager (2005) will not pick up a sdf created with 3.5. Since we (the developers out there) have to wait for SQL CE 2008 for an unanounced amount of time, will you give a hot fix so we can look at a 3.5 sdf in Server Manager (2005)?
Thanks, Johnathan
View 4 Replies
View Related
Apr 7, 2008
Hi,
Can some one give some links for reporting and notification better explanation in sql 2008
View 5 Replies
View Related
Jan 17, 2008
Anyone know when about SQL 2008 will be released, trying to plan upgrades.
View 2 Replies
View Related
Feb 26, 2008
Hello, I am currently running Visual Studio 2005, and I also have SQL Server 2005 Express Edition Advance series where I have FULLTEXTSEARCH working. I have just bought a new computer and I will like to install Visual Studio 2008 on it, what do I need to do in order for me to migrate my database to my new computer? Do I need to install a different SQL Server? Thanks Louis
View 2 Replies
View Related
Apr 7, 2008
is there a version of SQL express 2008 ??
View 1 Replies
View Related
Apr 22, 2008
I want to use VWD 2008 and MS SQL 2005 with SP2 for my app.
I can't make a connection to a database !!!
I created a new mdf database using SQL Server Management Studio.
When I try to connect to the new database from VWD 2008 I get the following error :
An error has ocurred while establising a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.( provider SQL Network Interfaces,Error 26 - Error Locate Server/Instance Specified)
I read over the internet many articles about but still the same result.
From this link I followed every step :
http://www.sql-server-performance.com/faq/establishing_remote_connection_seetings_not_allow_remote_connection_p1.aspx
My SQL Server and SQL Server Browser are exempted by the firewall on the server machine. My SQL server and VWD are installed on localhost and allow remote connections are checked on database properties - connections and SQL Server Surface Area Configuration - local and remote connections.
What can I do?
Thank You !
View 11 Replies
View Related
Jun 10, 2008
Hello all,
I just wanted to share my happiness with the Microsoft's release of the new version of SQL Server 2008, MS SQL Server 2008 RC0.
You can download and install the evaluation versions from Microsoft Downloads.
http://download.microsoft.com/download/2/0/c/20cf6e18-0448-4e7b-8d8c-60a3c4802671/Download_Instructions_ENU.htm
I liked the new logo very much!
Eralper
MS SQL Server Articles
View 1 Replies
View Related
Jun 4, 2007
The best mail today was, witout doubt, the one from Grant Dickinson at Microsoft telling that SQL Server 2008 June CTP is available from the SQL Server (http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx) pages at Microsoft. :)
It's time to play. :cool:
View 9 Replies
View Related
Sep 18, 2007
Hi all I have a question, has anyone tried the new ACT Premium 2008 apparently it runs off of SQL Server and can support 31-50 Users.
Has anyone tried it??
We are trying to get rid of Access and have a database that has a customizeable front end and will run off SQL Server 2005
View 7 Replies
View Related
Apr 23, 2008
Hello,
I just installed SQL Server 2008, i'm not certain if I am missing a step or theory...
just ran a simple command:
USE master
GO
For some reason, the process simply keeps on running.
Correct or incorrect statement, the results shouldnt appear any longer than a few seconds...
Does anyone know why this is taking a lot longer than it should?
View 3 Replies
View Related
May 22, 2008
I have a Actual_dt column that is a type of date. I am trying to get all the values from the table that have the date less than 2008/01/01.
Please help.
Thanks
View 6 Replies
View Related
Oct 2, 2007
I would like to buy SQL server 2008 book. I need it badly. would you please tell me where I can find it? thanks. and I look forward to hearing from you as soon as possible.
thanh
View 5 Replies
View Related
Aug 28, 2007
I just downloaded the SQL Server 2008 CTP. Anyone here check it outyet? Thoughts?
View 1 Replies
View Related
Nov 21, 2007
The RTM bits provide an upgrade capability.
My first stab at this with a 450mb .sdf was illuminating.
The process grinds away, writes out the new .sdf and then, just as it completes and raises it's 'successfully completed' banner, it deletes the new .sdf!
Tried both with and without encryption. Made no difference. No, it's not in the recycle bin either, or anywhere else on the drive.
How cool of an upgrade feature is that?
Using VS2008 Pro installed on XP
SSCE team: Time to bring out a separate upgrade tool?
View 1 Replies
View Related
Jul 15, 2007
Dear Sirs.
I have Client Server Application
on Client Side i have .NET 1.1 WinForm Application
on Server Side i have SQL Server 2000
I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access
1)
I'd like to upgrade Server Side to SQL Server 2005 (I will copy same database with users to sql2005)
Should i update Clients to .NET 2.0 too ?
Do i need install Native Client Lib on Client ?
2)
when SQL Server 2008 is Relesed
Can i connect to it from .NET 1.1 Application ?
Thank you in Advance.
View 6 Replies
View Related
