Hi,
Can I use VB.NET 2003 with SQL Everywhere on desktop?
Is it possible to create and populate data into .sdf with VB.NET 2003?
Please advice, thank you very much.
Best Regards,
Gabriel
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
I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA
View 2 Replies View RelatedWill ADO.NET 2.0 connect to MS SQL 2003 ? From within VWD Express ?
View 1 Replies View RelatedWindows 2003 came in the market already.
Yukon is going to release soon.
Will SQL Server 2003 run better on Windows 2000 Server, or it will run better on Windows Server 2003?
Anybody know?
I am in the process of creating another database for one of our departments, I'm creating a diagram of the structure in visio 2003. I'm done with the diagram but when I try to export to sql it wont let me. Anyone ever had this problem before??
This is the Error message I'm getting
ODBC Error: 01000
[Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'Audit_Tbl' has been created but its maximum row size (20070) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
I built a form in infopath 2003 ...now I want that the information
will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
We are running SQL 7, using Access 2000 as a front end. Our network personis wanting to migrate to Windows 2003 (we're currently on Windows 2000), andwants to know if we should migrate to SQL 2003 at the same time. Are theremajor changes between SQL 7 and SQL 2003, and how hard of a task would it beto migrate our single database to a new version of SQL?Thanks,Neil
View 11 Replies View RelatedHas anyone heard of any problems running SQL 7 under Windows Server 2003?We're upgrading to 2003 and are wondering if we can keep SQL 7 with the newOS.Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7mode? Or would it be better to just convert it to SQL 2005?Thanks!Neil
View 2 Replies View Relatedhi to one and all ,
i've installed the SSRS 2000 ENT Edition i trying to add reportviewer dll in my webapplication but i haven't find that dll so could any help in this issue ?
Thanks in Advance
by,
Veera Vinod.
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
Writing an installer to handle switching the DLLs depending on OS version is somewhat of a pain. The SQL CE dlls that we are told to install for PocketPC 2003 and WM5 PPC are different... but I noticed that the 2003 DLLs seam to work fine on a WM5 PPC. Is there a perf hit or some other problems I will run into for doing this that I just haven't hit yet? Will this work for any WM5 PPC?
thanks
How do i execute a SSIS package (dtsx) in vb.net 2003
i've tried
Dim app As Application = New Application
Dim p As Package = app.LoadPackage(pkg, Nothing)
p.Variables("varFileDirectory").Value = FileDirectory
p.Variables("varUserID").Value = UserID
p.Execute()
but it does not recognize Package. what do i have to import for Package to be recognized.
Is there another way to execute a SSIS package from vb.net 2003?
I dont know if i am in the right place to post this.
Is there any release of SQL server called SQL server 2003. I came accross this in a couple of job descriptions and also in a couple of interviews that i had. I Have been working on SQL Server since SQL Server 6.5, but hadnt heard about any release by that name. I really appreciate it if some one could provide some information on this. Thanks in advance.
Hy,
View 1 Replies View Related
I have run into this issue repeatedly when installing applications on SBS 2003. The application needs a database and looks for one when installing. It sees the SQL 2000 databases pre-installed on SBS 2003 for monitoring and reporting and assumes it can use them. Ultimately the program grinds to a halt because these instances cannot be used for the application (I'm assuming). The program should install it's own instance of SQL . I end up spending quite a bit of time mending the installation by manually installing some "lite" version of SQL and piecing it to the application.
Is there anyway to use the existing SBS 2003 SQL databases for a new app, like a backup program? There is no SQL management software on SBS 2003, so how is that done? Should I always install a new instance of SQL server for a new application?
I would love to see some official documentation on how to do this.
Thanks!
Is there any way to make MIIS 2003 install with SQL 2005, or do I have to stay with SQL 2000 SP3 for all new MIIS 2003 implementations?
View 5 Replies View RelatedWe have a DTS package that imports data from a client's Excel file. Previously our client was using Excel 2000, but recently they upgraded to Office 2003, and now suddenly when I try to view the transformation task properties I get a Jet Database Engine error: "External table is not in the expected format".
Everything else with the file appears the same (layout, formatting, etc.).
Any suggestions?
I built a form in infopath 2003 ...now I want that the information will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
Hello;
I am new to the CE Edition. I am using Visual Studio 2003 and VB.NET.
I downloaded all the components to install SQL Server CE. I am running on Windows Media Center and have IIS working OK as I can do ASP.NET and connect to the localhost. I have Visual Studio.NET 2003 and the IIS. I also applied service pack 4 to SQL Server 2000 which is also running and working properly on my local machine. In other words, all the components are on one PC.
After the download, I then navigate to and run Sqlcesql2ksp2.exe and get the following message:
SQL Server CE Tools is compatible only with SQL Server 2000 SP1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000, ensure the installer for SQL Server CE Server Tools corresponds to the version of SQL Server 2000.
Can anyone help and tell me what I am doing wrong??
Thanks.
John
We have began to use Windows AUthentication for our SQL 2000 Server. When we llok atthe groups in AD we do not see any Domain Local groups? Is there a reason for that? Can I just add the group without browsing? I assume DLG will work with SQL for security.
Thanks
Brent
I am trying to install MSDE according to:
http://www.siue.edu/~dbock/cmis460/msde.htm
But it says I need to go to control panel to install components, but it is not listed on the VS.NET 2003 install.
In VS.NET 2002 it worked fine as per instructions, but now i can't seem to get it to work in VS.nET 2003
Can I host web application with SQL server using win 2003 web edition?
View 6 Replies View RelatedHi,
I temporarely want to have a duplicate table from a sql database, but I got errors.
The next code I use in the codebehind of a webapplication:
"CREATE TABLE TempFile SELECT * FROM Projects WHERE ID =" & variable
I use ExecuteNonQuery, but got the error: Incorrect syntax near the keyword 'SELECT'.
What can be wrong??
Help is appreciated....
Is there anyway We could install a MSSQL server 2000 32-Bit in the Windows 2003 Server 64-Bit? Or Any Solution? Or is there any Evaluation Copy we could get from microsoft of 64-bit MSSQL Server? Please help i am lost in 64-Bit MSSQL. Coz my company recently upgraded to 64-bit Windows 2003 sit on a Itatium 2
View 6 Replies View RelatedI found an article that stated that there was a limit of 1GB of total user databases for SQL on Small Business Server. I could not tell if that was SBS 2003 or an earlier version. Does anyone know if there is any limitation?
View 1 Replies View RelatedHi,
Got a problem with network access for MSDE on Win2003 SBS. I have tried all the usual stuff (SVRNETCN, firewall check) to get windows to open the port for network access, but I am having no luck.
Thought it maybe something to do with win2003 "increased" security.. so check the IPSec policy but nothing looks like it is assigned, plus I could also be checking the wrong policy.
As you can probably tell I know only little bits about server, policies and everything that goes with it (I normally work with the lovely pre setup database) but guess its time I should learn.
So with my small and probably dangerous knowledge can someone please let me know if I am looking in the right area for allowing port 1433 to open for MSDE? If I am how to I edit the policy to allow something to run accross the network?
Basic Server Stats
O/S: Windows 2003 Small Business Server Standard (all updates +sp)
NIC: One gigabit (know win2003 recommends 2)
Hardware: Hugly over the minimum spec!!
MSDE: 3* instances (2 pre installed - SBSMonitoring, SharePoint and 1 user defined that needs sharing)
Thanks so much for any help, background information on group policies and alike would be nice to know as well, but don't worry too much about that!
I am a newbie to ms sql server. Will sql 7.0 enterprise work correctly on ms 2003 server? thanks
John
Hello, pls Some of my factory guys can log on the same user name at the same time, so I want a situation where a user name may be able to log on, one at a time. Whoever that is reading this, note this is not a misplacement, this is the fact that I don't have means of solving it, I am also of opinion that some have full knowledge of windows 2003 server
View 1 Replies View RelatedHi,
I have been using 'MSXML2.ServerXMLHttp.4.0' to make web requests from SQL server with no problems for about 6 months now (on Win2K Servers).
Now trying to move the databases onto a new 2003 server and getting the well known 'Access denied' error message. I beleive I have sorted out the following:
- Execute permissions on the master database for sp_OACreate, sp_OAGetErrorInfo,.....
- Allowed 'All unkown ISAPI Extensions' - not that I'm happy about that!!
- Uninstalled the 'Internet Explorer Enhanced Security Configuration'
- I have enabled 'Submit nonencrypted form data' for the relevant zones in IE Security Settings
But none of these seem to have had an effect. I have also tried using WinHTTP.WinHTTPRequest.5.1 as suggested in a MS KB article, but this is not suitable as I need to pass authenitication parameters with each request, and it seems as though the response size is limited.
If anyone has any tips/checklists for getting this going I would be very interested.
TIA
Hi
I'm fairly new to this, so bare with me...
I have to make a new installation of an MS SQL 2000 EE on a Windows 2003 Std. Edt.
HW:
---------------------
Dual Xeon 2,4 + 1 GB Ecc
1 x 32 MB Adaptec 2100S RAID Controller
2 x 18 GB 10K HD
4 x 18 GB 15K HD
---------------------
So far I have made following configuration....
---------------------
2 x 18 GB 10K HD / RAID 1
- C:OS
- D:MSSQL program files + System DB's (Master, pubs ect.)
4 x 18 GB 15K HD / RAID 5
- E:TempDB
- F:Data + Logs
---------------------
But I'm not sure that this is the optimal configuration, and I'm willing to start all over :)
So my q's are.......
--------------------
Which RAID configuration would you suggest?
Which partitions on the raids would you suggest?
Which usage would you assign the various partitions?
How do I move the system and temp db's?
--------------------
Thanx!
Regards,
Taras Bredel dk
I have SQL 2k on a W2003 Server.
I have SP3 installed.
My problem is that i cant connect to the server via telnet:
"C:>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port 1433: Connect failed."
I try telnet 127.0.0.1 also.
In the Server Network Utility TCP/IP is ENABLED and the port number is 1433.
Who can help me?
(Sorry for my english)
Hi guys and gals,
Since monitoring blocks on the server, I have noticed that when I have a whole lot of users thrown out of their apps, it's all because of one PC.
The program name is "Microsoft Office 2003". The user reckons that they haven't opened any Excel files that have any kind of link to the live database.
Is there any known problem that you are aware of where Excel can "remember" connection strings maybe from other files you have opened in the past and would that spuriously throw INSERT, UPDATE & SELECT statements to the database server and that then cause locks?
The idea seem ludicrous to me. I'm stumped.