Hi,
I'm using SqlExpress on a SBS2003, and have the Sql data in the Program Files on the C: drive.
I would like to have the data on a Share, and do not know if this is practical or possible.
Would I need to (and can I) move the whole Sql program to the Share.?
The reason I ask, is that the C: root is on a 4gb partition.
Cheers
Tailor
Hi,
I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000.
The string I need to import is composed by 5 different several blocks and looks like:
Code Snippet
CommandLine01 = "USE mydb"
CommandLine02 = "SELECT Block ..."
CommandLine03 = "GO
ALTER TABLE Block...
GO"
CommandLine04 = "UPDATE Block..."
CommandLine05 = "SELECT Block..."
The detail of the SQL string is at:
http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1
I am trying to implement OJ's suggestion:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1
to use multi - batch processing to import the string to SQL SERVER, something like:
Code Snippet
Dim SqlCnt, cmd1, cmd2, cmd3
'set the properties and open a connection
cmd1="use my_db"
cmd2="create table mytb"
cmd3="insert into mytb"
SqlCnt.execute cmd1
SqlCnt.Execute cmd2
SqlCnt.Execute cmd3
Below is the code (just partial) I have, and I need help to complete it.
Thanks in advance,
Aldo.
Code Snippet
Function TestConnection()
Dim ConnectionString As New ADODB.Connection
Dim RecordSet As New ADODB.RecordSet
ConnectionString = "Driver={SQL Server};Server=myServer;Database=myDBName;Uid=UserName;Pwd=Password"
ConnectionString.Open
CmdLine01 = " USE " & myDB
CmdLine02 = " SELECT ACCOUNTS.FULLNAME FROM ACCOUNTS" ...
CmdLine03 = "GO
ALTER TABLE Block...
GO"
CmdLine04 = "UPDATE Block..."
CmdLine05 = "SELECT Block..."
RecordSet.Open CmdLine01, ConnectionString
RecordSet.Open CmdLine02, ConnectionString
ConnectionString.Execute CmdLine01
ConnectionString.Execute CmdLine02
'Retrieve Field titles
For ColNr = 1 To RecordSet.Fields.Count
ActiveSheet.Cells(1, ColNr).Value = RecordSet.Fields(ColNr - 1).Name
Next
ActiveSheet.Cells(2, 1).CopyFromRecordset RecordSet
'Close ADO objects
RecordSet.Close
ConnectionString.Close
Set RecordSet = Nothing
Set ConnectionString = Nothing
End Function
Hi
I would like to install SQL express on a PC which already has SQL 2003 - I use enterprise manager to manage a database. I require express as part of a teaching role (my students have installed it). Is is possible to do this or should I remove the full version
Regards
Eddie
Hy,
View 1 Replies View RelatedHello,
My backup copy of SQL Server Express 2003 has been corrupted, and I can't find anywhere to download the older version.
I can't move to 2005, as the requirements say that I need to have .Net Framework of 2.0 or above, but - I'm working with an older system that uses 1.1
So - if someone could point me to a location that I could download this, I'd really appreciate it.
Thanks,
Robert
I have been trying to setup SharePoint Services 3.0 on 2003 Server (Advanced) and when I run the setup for it I get this error:
SharePonit Products and Technologies Configuration Wizzard
"Failed to start the database service MSSQL$Microsoft##SSEE. Repair this product by selecting it from the Add/Remove Programs menu."
I have run a repair on all of the SQL products in the Add/Remove Programs menu and I continue to get the same error as above.
Please advise as I have un-installed and re-installed SQL Express 2005 and SharePoint Services 3.0 prior to this posting.
I have installed Sql Server 2005 express and Visual Basic. Net 2003 standard edition.
How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 standard edition?
I tried to use sqlnative client to connect, but it gave an error message saying this is not supported in this version of Visual studio.
Looking for an answer ...
thanks.
Mainly I think that sql express is totaly stand alone and thus does not need you to be running VS2005 but Id like some clarification on if it will work with someone running visual C# 2003.
I run 05 myself but I know some people having to tie into the school server due to they are running 03.
If they DL SQL Server Express and the management tool can they use it with thier C# 2003?
Is there a way to integrate Access 2003 as the Front End for SQL Express?
I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow.
As you can see, I am totally new to SQL and any help would be appreciated.
Thank You,
James
Hello, I'll start by saying that I don't know the first thing about SQL.
I have product that I am trying to setup on a windows 2003 R2 SP2 server that requires SQL Server Express 2005. I have this same setup installed under Windows XP Pro SP2 and it works fine.
The product uses a PHP script to talk to the SQL Server to create the orginal DB but I get the following errors:
*******************************************************************************************************************************************
Creating initial MFP Database...
Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: localhost,1444 in C:Inetpubwwwrootdbwrap.php on line 15
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: SELECT * FROM master.dbo.sysdatabases WHERE name = 'MFPACS'
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:Inetpubwwwrootdbwrap.php on line 55
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE DATABASE MFPACS
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 26
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Logs ( username varchar(32) not null, accesstime datetime not null, message varchar(32) not null )
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Users ( username varchar(32) not null, passmd5 char(32) not null, fullname varchar(64) not null, access int not null, interface int not null, timeout int not null, loggedin bit not null, remoteip varchar(16) null, lastaction datetime null )
*********************************************************************************************************
I have enabled the running of PHP scripts under IIS in Windows 2003 R2 (along with all of the other listed web executables). But I am stuck. For some reason the PHP scripts seem to either not have permission to talk to the DB, or Windows has some extra security in it that I need to know how to work correctly with.
I also am checking my ODBC > System DSN
when I try to craete my datasource, I get:
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
Connection failed;
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login timeout expired
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client] An error has occurred while establishing a connection to the server. When connecting to the SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
FYI I have set TCP/IP properties for SQL under Protocol > General > Enable - YES.
Thanks for any assistance.
Hi all,
I have SQL Server 2005 Express running and I am creating a database through access (Access 2003 SP2) and no problem it creates the database...
But when I try to create other objects like views and database diagrams, I get the message below which is quite detailed but I just don't know where to get the service packs or updates needed to have this problem solved. Can anyone point out what the problem and the fixes are?
Here is the message that I get:
"This version of MS Office Access doesn't support design changes with the version of MS SQL Server
your access project is connected to. See MS Office Update Website for the latest information and
downloads (on the Help menu, click Office on the Web). YOur design changes will not be saved.
You have connected to a version of SQL server later than SQL Server 2000. This version of Visual Studio
or Access that you are using was released before teh version of SQL Server to which you are connected.
For this reason you might encounter problems.
Please check with MS to see if there is a service pack that you should apply to Visual Studio or Office
in order to get support for the version of SQL Server to which you are connected.
You can continue but any new object types might not be enumerated, and it will not be possible to
save any objects or database diagrams thatyou create using the Visual Database Tools."
Thanks
I am a fresher in using SQL with access.
I am using a code in Ms access to link a table that is in Sql express 2005.
I use this linked table name to download records to the local Access table.
The link is then dropped in Access.
Is there any way to write back records into the linked Sql table from Access.
It does not allow me to delete / add / modify records of a linked table.
How can I do this.
Thanks
Sjohn
I would really like to be using SQLServer Express 2005 for some desktop database applications and replace MSDE. However, I am using VS.NET 2003 and so far I have not been able to discover if that combination will work.
Thanks,
Sid.
Does anybody know if there is and update for access 2003 which could make it compatible with SQLServer Express. Actually XML Field are not supported, Diagram too, and surely much more.
Any help would be appreciate.
I recently started developing a new Access project for a client, and decided to try out Access 2003 with SQL Express 2005. Everything was going fine until I tried to modify a table from within Access. I got an error message that SQL Express is incompatible with Access 2003, and it suggested I go to the Microsoft website and search for a patch/upgrade to solve this.
I tried to ignore it, and it started warning me that none of my table edits would be saved.
I looked around, but I can't find anything about this.
Is this true? Is there a patch to fix this?
Does SQL Server Express work *easily* with Office 2003? I'm especially interested in using Access 2003 & Excel 2003 with SQL Server Express.
I did a search here, but found nothing.
I see Oracle is now giving away their "Express" Oracle 10g; I'm weighing options...
I have a vb6 program running fine on a domain on SBS 2003 with the backend connected to sql express. I have added a third computer to the domain and I am unable to run the program on the third computer. I am almost certain that it is not a user, login, or role issue. I would appreciate ideas on how to localize this problem.
Thank you
How can make link to a table stored in an sql express 2005 database in access 2003 ? the classic method doesen't work. i tried to use odbc databases as file type to link, then build a data source using SQL native clint driver, but in the combo for default database i don't have the database created before, only master,msdb, model, tempdb. If i try to use the attach database filename text box i receive an error "the datadase entered is not valid". Any suggestions ?
Thx
I am just starting to work with Visual Studio and SQL. I have Visual Studion 2003 with .net Framework 1.1. I want to download the SQL 2005 Express version and it requires the upgrade to .NET Framework 2.0
Will this affect my Visual Studio 2003? And can I use SQL 2005 with Visual Studio 2003?
Any help would be appreciated.
Thanks,
Hello,
how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003?
I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express?
Thanks a lot.
Christian
Access 2003 Data exported to SQL Express , great.
How do I then link the tables to the new database, I only seem to be able to link to system tables etc ??
Any ideas ?
Hi, I've a problem to install SQL Server Express 2005 on Win 2003 SP1.
Do you know how to solve the problem ??
It displays error message after I click the setup file:
SQL Server Setup unexpetedly failed. For more information, review the Setup summary log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
Then I open the Summary.txt, it contains:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790)
Time : Thu Sep 21 11:17:18 2006
And review the SQLSetup0001_PCNAME_Core.txt in the Log Files directory:
Microsoft SQL Server 2005 Setup beginning at Thu Sep 21 11:17:18 2006
Process ID : 688
D:MasterSQLExpress2005setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/8/21 11:17:18
Complete: LoadResourcesAction at: 2006/8/21 11:17:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18
Loaded DLL:D:MasterSQLExpress2005xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "688"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/8/21 11:17:18
Complete: ValidateWinNTAction at: 2006/8/21 11:17:18, returned true
Running: ValidateMinOSAction at: 2006/8/21 11:17:18
Complete: ValidateMinOSAction at: 2006/8/21 11:17:18, returned true
Running: PerformSCCAction at: 2006/8/21 11:17:18
Complete: PerformSCCAction at: 2006/8/21 11:17:18, returned true
Running: ActivateLoggingAction at: 2006/8/21 11:17:18
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00D3CFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "688"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
I'm attempting to connect to my SQL Server Express instance through Visual Studio 2003. When I go to Data Connections, I choose the Microsoft OLE DB Provider for SQL Server, then fill in all the parameters for my server (server name, username, password, database). When I click "Test Connection" it goes through successfully. When I click "Ok" to create the Data Connection, it fails saying that the username and password should be checked. I changed the username and password to the "sa" account I created when I installed SQL Server Express, and got the same successful connection test, but failure when it tries to create the connection. Any suggestions? Thanks!
View 3 Replies View RelatedHi
I have conntected an Access 2003 project to a database in SQL Express and when I try to create a new view or stired procedure I get the message
This version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your project is connected to. See the Microsoft Office Update Web site for the latest information and downloads (on the Help menu, click Office on the Web). Your design changes will not be saved.
Is it a limitation or have I not got the appropriate permissions set up
And if it is a limitation does it matter
Thanks in advance
Gordon W
Getting error 1326.
I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).
I'm trying to connect from SQL Studio Express on Vista.
TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.
I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?
Thanks, John
Is it possible to upsize an Access 2003 database to SQL Server Express without actually installing Access 2003 on my server....I would prefer to not have to do that. Currently, I only have the Access mdb file on the server...it is the backend to my ASP application. Can I download and run the Upsizing Wizard on it's own?
Thanks in advance,
Kris.
Hi, is it possible to use SQL server express 2005 with visual studio 2003?
i've some problems...
Thanks
I have a Sql Server Express Edition instaled in a Windows 2003 Server. I will use SQL Authentication. Need I Cal's for Windows 2003 server to each user that will access the SQL Express ? If yes, why ?
View 5 Replies View RelatedHi,
How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 ?
Kumar
I'm trying to integrate office accounting 2008 express w/outlook 2003 w/BCM. I'm able to add items created in accounting to a BCM opportunity, but cannot convert an opportunity into... (I don't know what, the button is ghosted out) Oultook or BCM doesn't see customers added in accounting. I have no problem establishing a connection from BCM, with the above results. In accounting, the wizard cannot see theany BCM databases, nor will it accept data entry. Any help?
View 4 Replies View Related
I have been experiencing troubles since I was decided to install SQL Server Expr 2005 in my PC, first I needed to remove the .NET framework 1.1 in my computer because it is suggested before installing sql server expr 2k5 that cause my vs.net 2003 to stop loading because sql express runs in .NET framework 2.0 and vs.net 2003 is in .Net Framework 1.1 then what I did is to install .Net Framework 1.1 in my PC together with .Net Framework 2.0 and my vs.net started runnning again.
My problem now is when I try to connect to a database using Data Link Properties in the Server Explorer it says "[DBNETLIB][ConnectionOpen](Connect()).]Sql server does not exist or access denied." how could this happen if I can see the sql server in the Server Explorer in my VS.net environment?
Please somebody help me I am just learning to this language and I think I cannot proceed to the next few chapters remaining because of this.
Thank you very much!
Is this supported on Windows 2003 sp2 and does anyone know how to do a silent install of this using Altiris?
Thanks!
Is it possible to upsize an Access 2003 database to SQL Server Express without actually installing Access 2003 on my server....I would prefer to not have to do that. Currently, I only have the Access mdb file on the server...it is the backend to my ASP application. Can I download and run the Upsizing Wizard on it's own?
Thanks in advance,
Kris.