Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Connect ADODB With Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider For Microsoft SQL Server Compact 3.5)


Hi
 We  are checking VB 9 (Orcas).
 
we connected to database created under with sql server 7. with this code

Public cn As New ADODB.Connection

Public Sub OpenDB()


cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")

End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005  . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
 
Rgds
Pramod


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework
We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
 public bool Replicate()
{ bool ret = true;
 SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
 repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
 repl.PublisherLogin = this.PublisherLogin;
 repl.PublisherPassword = this.PublisherPassword;
 repl.Publication = this.Publication;
 repl.Subscriber = this.Subscriber;
 repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
 }
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent

View Replies !   View Related
Failed To Find Or Load The Registered .Net Framework Data Provider When Using SQL Server Compact Edition
Hello

 

I have recently downloaded Orcas beta VS product and had no previous version of VS before.  The install went clean and I have been able to generate Window apps and web apps with very little issues; however, I have one issue with running a web app using the "view in browser" option for checking an aspx page for validity.  If I use the default Northwind database provided and generate an aspx form using the "DataSet" toolbox widget, the tool prompts for the datasource etc. required to generate the required code.   I can select the Northwind database and select the desired columns from one of the tables.  Once completed, I build the project (clean build) and then select the "view in browser" option to verify the results.    The result is an error page indicating a server error ->
Failed to find or load the registered .Net Framework Data Provider.

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.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.

 

I created on odbc connection to an iSeries(as400) box and was successfull in displaying the table on the webpage!   I looked into the web.config file and it appears that all the required XML data is present.    Any help would be appreciated as I am fairly green when it comes the .NET world.

 

Thanks

 

View Replies !   View Related
Cannot Connect To A Named Instance Of SQL Server From Compact Framework 2.0
I have two instances of SQL Server on the same PC:

Default instance: SQL Server 2000
Named instance with name €œMS2005€?: SQL Server 2005.
Also I have another SQL Server 2005 on another PC.
 
I created a .NET 2.0 Compact Framework application that connects to the database and executes simple query. This application can connect to any instance of the SQL Server when it is executed on the PC (not on the server). But the problem is that when I try to execute the application from the windows CE 5.0 device, the application can only connect to the default instance (SQL 2000 and 2005) and can not connect to the named instance (Name: MS2005).
Is it some kind of limitation of the SqlClient library for the compact framework?
 
Below are the code and connection strings:
 
string connectionString = €œServer=1.1.1.1;Database=DB1;Uid=sa;Pwd=€?
string connectionString = €œServer=1.1.1.1\MS2005;Database=DB1;Uid=sa;Pwd=€?
 
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open(); //This is the point where exception is generated
 
                using (SqlCommand command = connection.CreateCommand())
                {
                    command.CommandText = "select count(*) from users";
                    object result = command.ExecuteScalar();
 
                    Console.WriteLine("Result: [{0}]", result);
                }
 
                connection.Close();
            }

 
Thank you for your time and advice.

View Replies !   View Related
Microsoft SQL Server Compact 3.5 Samples
Hi,

I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere.
The only sample which is available in my local directory below is Northwind.sdf file
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples

The link in the Book Online is pointing to this URL below :
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en

Can anyone help me on this?
Thanks,

View Replies !   View Related
JDBC Driver For Microsoft SQL Server CE / Compact Edition
Hi,

I have a J2EE based web application. There is a requirement where user triggers a process to query a database, and the application needs to save the results to an SDF file (Microsoft SQL Server CE 2.0 / Microsoft SQL Server Compact Edition) database. I need JDBC driver for it, but could not find it anywhere. Please help. Also, if there is any alternate way to do this, please let me know.

Thanks,
Vaibhav

View Replies !   View Related
Microsoft SQL Server 2005 Compact Edition 3.5 And Pocket PC 2002
 

Is there any way to install SQL Server 2005 Compact Edition 3.5 on a Pocket PC 2002 mobile device.
 
Thanks,
 
Peter

View Replies !   View Related
RDA Pull Error Using Microsoft SQL Server Compact Edition 2005
Hello dear all.

 

I am using a Compact Framework 2.0 on a mobile 5.0 with a local Microsoft SQL Compact Edition 2005 database. The backend database is a Microsoft SQL Server 2005 and I am trying to pull a 45000 rows table (the table has 2 varchars(8) forming a primary key and an INTEGER column).

 

The statement I issue is the following:

rda.Pull(table.TableName, table.TableQuery, Program.RdaOleDbConnectionString, RdaTrackOption.TrackingOnWithIndexes, table.TableName + "Errors");

 

The application works perfectly when I am pulling smaller tables (up to 15000 rows) but when I try to pull this one I get the following error details:

 

sqlCeEx
{""}
    base {System.SystemException}: {""}
    Errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
    errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
    HResult: -2147024882
    Message: ""
    NativeError: 0
    Source: "Microsoft SQL Server Compact Edition"


Please have in mind that the handheld on which I deploy does not have an extra storage card.

 

I have done a thorough internet search and I have found no solution to this problem. I truly rely on you to find the solution.

 

Thanks in advance,

 

Steliosvcy.

 

View Replies !   View Related
Microsoft SQL Server Management Studio Express Version To Use For SQL Compact
Hello,

i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:

Microsoft SQL Server Management Studio Express
Date: 19.04.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

but this one:

SQL Server Management Studio Express Service Pack 2 €“ CTP-Version
Date: 19.12.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en

hope this helps.

Nihat

P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of  SSMSe?

View Replies !   View Related
How To Get A Microsoft SQL Server Compact 3.5 Database Multiuser Work On A Network Share
Hello All,
 
I need some advise/help how to deploy a small sql server compact 3.5 database on networkshare where about 8 people have access to it(install de client ) and can modify the database with aprox 3000 records.
I'm using visual basic 2008 and created a compact database and filled it with one table of an export of an access database done with data port console.
And created a new windows forms application and saved the project.
Publish is not the problem but how too set it up......
There is not much info to find on how to get a sql server 3.5 database running on a network share.
Who can help ???
 
 
Thanks
 
 
 

View Replies !   View Related
SQL Compact Edition 3.5 Vs. SQL Server Management Studio 2008, FileNotFoundException Microsoft.SqlServerCe.ManagementUI
Hi,I'm having an exception below when i tried to connect to SQL Server Compact Edition from SQL Server Management Studio (10.0.1075.23 ((SQL_PreRelease).071108-1357 )).I downloaded and installed the SQL Server Compact Edition 3.5 from this link below :http://www.microsoft.com/downloads/details.aspx?FamilyID=38ed2670-a70a-43b3-87f3-7ab67b56cbf2&displaylang=enAnd I downloaded and installed the SQL Server 2008 Development edition from this link below :http://go.microsoft.com/fwlink/?LinkId=104963It seems that the SQL Server 2008 Development edition comes with the these 2 SQL CE below :- Microsoft SQL Server Compact 3.5 SP1 Beta ENU. Product Version: 3.5.5608.0.- Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools ENU. Product Version: 3.5.5608.0I tried to uninstalled these 2 and re-install the SQL Server Compact Edition 3.5 Files, but it didn't help.Currently I'm uninstalling SQL Server 2008 because the command prompt installation instruction page could not be found in the books online, so i'm trying my luck to uninstall SQL Server Compact Edition 3.5 and reinstall the whole SQL Server 2008. The main reason why I was trying to install SQL Server 2008 Developer Edition is only to manage SQL Server Compact 3.5 database file. Since i upgraded the database into 3.5, i was not able to open it anymore using SQL Express 2005 Query Designer in the VS 2008 is just like the sql view query designer which is not as good as sql management studio. I'm reminiscing the good old days with query analyzer Any advice to resolve this issue?
Thanks in advance Steps :1. Choose Database : SQL Server Compact Edition2. Choose Any of the Database file options (New Database or Browse for more)3. Below exception will pop up.See the end of this message for details on invokingjust-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)   at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)   at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)   at System.Reflection.Assembly.Load(String assemblyString)   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Utils.LoadAssembly(String assemblyFileName)   at Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerCeType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType2.CustomNewDatabaseAction()   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.CheckForNewDatabase()   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.OnSIIndexChange(Object sender, EventArgs e)   at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)   at System.Windows.Forms.ComboBox.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

View Replies !   View Related
CompactDatabase In ASP With SQL Server Microsoft SQL Server Compact
I've been playing around with Microsoft SQL Server Compact Edition
v3.1 as a posible replacement for the SQL Server CE 2.0 (can't
remember exactly what the called it). Its working pretty well. I
was able to connect to the database using the same recordset object,
ADODB.RecordSet and connection object, ADOCE.Connection.3.1. However
where I've run into trouble is when I try to compact the database.
This code works on 2.0.

srcConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"
destConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"

Set DBEngine = CreateObject("SSCE.Engine.2.0")

DBEngine.CompactDatabase srcConn, destConn

But now when I try to run it vor v3.1

srcConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=myDB.sdf"
destConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=mDB1.sdf"

Set DBEngine = CreateObject("SSCE.Engine.3.0")

DBEngine.CompactDatabase srcConn, destConn

I get this error message:

Info: Object required: 'DBEngine'

As I understand it SSCE.Engine.3.0 is still an ActiveX
object. Is it no longer posible to run this directly from
asp?

View Replies !   View Related
Failed To Generate ResultSet Code. Typed ResultSets Are Only Valid For Microsoft SQL Server Compact 3.5 Databases
 

I get the error above when I do the following.
 
Using VS 2008 I got a Windows Smart Device project targeting WM6 Standard and using .NET CF 3.5.
I add a new database file = creating an empty Compact 3.5 database (creates an sdf-file in my project).
Then create an empty dataset in the wizard (creates an xsd-file in my project).
Then I add a couple of tables in the database.
After that I want to use my earlier created dataset.
I mark the xsd-file and looks in Poperties.
I get the error when I try to change Custom Tool value from 'MSDataSetGenerator' to 'MSResultSetGenerator'.
Why????

View Replies !   View Related
Creating A New Connection With Microsoft SQL Server 2005 Compact Edition From Visual Studio 2005 IDE
 

Hello, How are you?   
I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en.  In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?   

 

I appreciate your help€¦

View Replies !   View Related
Does 64-bit Version Of SQLServer Compact In Microsoft's Develop Schedule?
 

I am looking forward to a native 64-bit file-based database solution on Microsoft Windows platform. And I don't know why Microsoft didn't release the native 64-bit solution for JET engine (MDB file).
 
So, before I using this light-weight and file-based version of SQL Server, I will like to ask the question that the 64-bit version has been put into develop schedule?
 
Thanks.
Alva

View Replies !   View Related
System.Data.SqlServerCe Desktop Vs Compact Framework
How can I tell if the System.Data.SqlServerCe assembly I am referencing is meant for Desktop use as opposed to Compact development?  We are using NUnit as our testing framework and I get the following error when I attempt to execute nunit-console on my test fixture referencing SqlServerCe:

System.IO.FileLoadException : Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) ---->

 System.IO.FileLoadException : Could not load file or assembly 'System.Data.SqlServerCe, Version=3.0.3600.0, Culture=neutral, PublicKeyToken=3be235df1c8d2ad3, Retargetable=Yes' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)


The unit tests run fine from inside of Visual Studio using the Resharper Unit Test Runner...

Matt

View Replies !   View Related
Limit On Blob/image Data Type In SQL Compact 3.5 SP 1 BETA For ADO Entity Framework?
Hi! I tried to save some image data, but it get truncated at 8000 (the table column is defined as Image). I then wrote a converter to try ntext-datatype instead, but it gets truncated at 4000.


Error message:
System.Data.SqlServerCe: @3 : String truncation: max=4000, len=4168


The code uses only ADO entity framework for database access. Is there a way to store binary data larger than 8000 bytes? I am running SQL Compact 3.5 sp 1 BETA.


Henning



 

View Replies !   View Related
Microsoft .Net Framework 3.0 With Sql Server Report
Hi ,

 

Iam using .Net framework  3.0 .i created sql server report ..how to connect sql server report in .Net framework 3.0..i have to install reportviewer..but how to display sql server report in .Net framework3.0.

View Replies !   View Related
How To Connect Remote SQL Server Using Microsoft SQL Server Web Data Administrator
I want to connect to company's SQL Server from home and to connect to home's SQL server from company remotely.
The new released SQL Server Web Data Administrator by Microsoft seems solving my issue.
I use it to connect to different SQL servers in different domains company wide successfully, but I failed to connect to home from company( I have static IP on the home server).
Also I want to know how to configure the sever name if I want to connect to company's SQL Server from home. The company SQL server is inside the firewall with a internal IP. How it works?

Any ideas?

Thanks!

View Replies !   View Related
Microsoft Ole Db Provider For Db2 Vs Db2 Connect
Do you get better performance by installing db2 connect on a Windows 2003 server running sql server 2005 and have your application hit a db2 database or do you get better performance setting up a linked server that uses an ole db connection to a db2 database?  At first, I thought it would be the OLE DB connection, but I have confused myself now and need some clarification.

Thanks

View Replies !   View Related
Sqlceoledb35.dll - Error 25123 - A SQL Server Compact Edition DLL Could Not Be Loaded. Reinstall SQL Server Compact Edition.
Hello,
 
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
 
Why is this error happening and how can we resolve this?
 
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
 
Thanks,
Markus

View Replies !   View Related
SQL Server 2008 CTP Feb With Compact 3.5 - Can't Connect
I need to be able to manage my Compact 3.5 database (script tables, edit columns etc).
 
As far as I understood, only way to do this is to install SQL Server 2008 CTP. So I did that, installed the February release. But when I try to connect to my Compact 3.5 database, I get this error:
Cannot connect to %path to my db%
Could not load file or assembly 'Microsoft.SqlServerCe.Client, Version 10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ...'
 
Any ideas?
 
Or do anyone know an other way to handle Compact 3.5 databases?
 

View Replies !   View Related
Cannot Connect Using ADO With Excel Microsoft Jet Provider 4.0
Hi:

I have a vb 6 app that exports data from sql to excel.  The user has the ability to select either local or server.  When they select server, the connection string is modified to include the server name instead of the local msde instance to look like this:

"provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase"

I'm using Microsoft Jet Provider 4.0 and  OpenDataSource.

SELECT * INTO TempXL FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C: estxltest.xls;Extended Properties=Excel 8.0')...[Sheet1$]

This code works fine when user is accessing msde on local, but when using above DSN, I receive the following message:

"2147217900 - OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEdB.4.0' IDBInitialize:: Initialize returned 0x800040005: The provider did not give any information about the error.]

When I trace the connection, these error messages occur:

Failed to set proper user name ('NT AUTHORITYSYSTEM') for the connection

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot alter table 'TblXMyTable' because this table does not exist in database 'master'. (State 42S02) (Code 4902)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TblxMytable'. (State 42S02) (Code 208)

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error. (State 42000) (Code 7399)

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.]. (State 01000) (Code 7300)

I am especially puzzled by the second message because I am specifying the database name in my connection string as:

"provider=sqloledb;data source=MyServer;initial catalog=MyDatabase;user id=UserX;password=PasswordX;database=MyDatabase"

I can read from the server copy and copy to Excel, but I cannot write back to SQL.  Can someone please tell me what I'm doing wrong?

Thanks in advance for any help.,





 




 

 




 

View Replies !   View Related
How Can I Connect To Microsoft SQL Server 2005 CTP With Microsoft SQL Server 2005 Express Manager?
I installed Microsoft SQL Server 2005 Express Manager and connect to SQL 2000 normally

View Replies !   View Related
SQL Server Compact Edition Cannot Connect To Big Databases
In my IPAQ, I have been using SQL CE for databases with various sizes without any problem. I am creating the databases on my desktop using VS 2005. After I moved to VISTA, I have upgraded my VS 2005 to SP1 and SQL CE to 3.1. My databases which were created before worked without any problem. After I have created my databases via 3.1 on the desktop and moved them to Mobile, I had problems.

1. I specify Max database size parameter as the size of the database
2. If the size of the database is smaller than 16 then I specify 128
3. If the database is old version then program runs without any problems whatever the database size is
4. If the database is created with 3.1 and size is small  (20MB, 60MB, etc)  no problems arise
5. Ä°f the databse is created with 3.1 and size is large (133MB, 174MB)  then  dbconnection.Open()  command  runs indefinitely and program hangs up .

My IPAQ runs "Microsoft Pocket PC Version 4.20.1081" and desktop runs VISTA Home Premium.  I have installed  VS 2005 SP1.

Thanks for any help

View Replies !   View Related
Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]
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

View Replies !   View Related
SqlServerCEResultSet To XML?? In Compact Framework 3.5?
you can, with a dataset  do something like myDataSet.WriteXml(m_XmlFile, XmlWriteMode.IgnoreSchema) and get XML for a record....
 is it possible to do something like that with SQLserverCeresultset?
i know i could probably loop thru the columns and create the xml manually...  but using somethinglike writexml will give better performance?
 right now im not using anything from the XML class... from my previous exp with using XML classes on the Compact framework gives slow performance...

View Replies !   View Related
Compact Framework SqlClient Classes Don't Actually Inherit From System.Data.Common.Db* Classes?
As you all know, in Framework 2.0 on the desktop platform you have the convenient "abstract" Db* classes that can be used to write more generic code. For instance System.Data.SqlClient.SqlConnection inherits from System.Data.Common.DbConnection, and so forth. Now the docs clearly say that this applies to the corresponding classes in the Compact Framework. And i have seen this implied by other web searchs I've done. However this does not seem to be the case -- or, I'm missing something somewhere.

The following simple code on the desktop platform compiles OK:

using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
DbConnection conn = new SqlConnection();

However it doesn't compile in a compact framework project: "Cannot implicitly convert type 'System.Data.SqlClient.SqlConnection' to 'System.Data.Common.DbConnection'".

Reflector also indicates that the Compact Framework class doesn't inherit from DbConnection.

OK, so am I missing something here, or what was the reason that Microsoft did it differently??

View Replies !   View Related
A Sql Server Compact Edition DLL Could Ot Be Loaded Reinstall SQL Server Compact Edition [ DLL Name = Sqlceca30.dll]
 

Hi there,
 
everything is ok for first run. but i leave the program relogin 
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?


VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded
 
machine 1
SQL 2005 loaded
 
machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine
 
pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
 
.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.
 
my code
---------------------------------------------

Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"

Dim rda As SqlCeRemoteDataAccess

Try

rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception

MsgBox(ex.ToString)

Application.Exit()

End Try

Try

rda.InternetLogin = [String].Empty

rda.InternetPassword = [String].Empty

rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"

rda.LocalConnectionString = ConnectString

Catch ex As Exception

MsgBox("Bağlantı hatası..")

Application.Exit()

End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device
 

Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
 

Dim pt As IntPtr

pt = LoadLibrary("\windowssqlceca30.dll")

pt = LoadLibrary("\windowssqlceoledb30.dll")

pt = LoadLibrary(\windowssqlcecompact30.dll)

 
-----------------------------------------------------------------------------

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server 2000
Hi,
I have a question about the OLE DB provider for SQL Server 2000, Someone may can help me answer the question.

I use following OLE DB connection string to connect sql server and asp
----------------------------------------------------------------------------
objConn.Open "Provider=SQLOLEDB;Data Source=Computer Name;" & _
"Initial Catalog=DB Name;User ID =sa; Password=;"

objRS.Open "DB table", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable
-----------------------------------------------------------------------------
This connection string is working in SQL server 7.0. When I update the SQL server 7.0 to 2000. I use this connection string show following error message:

Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

I search for Microsoft knowdage base support and get information that should include Integrated Security=SSPI; in the connection string.

I modify the connection string following:
----------------------------------------------------------------------------
objConn.Open "Provider=SQLOLEDB;Data Source=Computer Name;" & _
"Initial Catalog=DB Name;User ID =sa; Password=;Integrated Security=SSPI; "

objRS.Open "DB table", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable
-----------------------------------------------------------------------------
So the connection string is working. I use Window NT Authentication.the username is "sa" and passwrod ="". I just want to know why need to add Integrated Security=SSPI

Thanks

View Replies !   View Related
Can't P/Invoke Sqlceme35.dll With Headless Compact Framework
I am aware of the many posts that have addressed this issue in the past - I resolved this issue many months ago when it first happened to me. However, I have recently created a headless version of my Windows CE 6.0 based project that uses the Headless versions of the Compact Framework and this problem has suddenly re-surfaced. As in my UI equipped versions, the SQL CE cab files are copied to the device and have been installed. I have also tried copying the sqlceme35.dll to the application folder. The only real difference I can see is that the device is using the headless version so I suspect that there may be some incompatibility.

Has anyone successfully deployed a SCQL CE aplication to a headless device and if so were there any special steps that had to be taken to make it work?

Thanks

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005'
Hi friends,

Can anyone help me in connecting sql server and asp.
Wheneever try to do the connection, I am getting following error. All the connection string which i am using are correct.

can you help me.

Following are the error line

----------------------------------------------------------------

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid connection string attribute

/MAsteringASP/test2.asp, line 21
------------------------------------------------------

Please ckeck my code which I am using for connection


Thank you

Graceson MAthew

----------------------------------------------------------------
<%@ Language =VBScript %>
<% option explicit %>

<Html>
<head>
<title> Database Connection </title>
</head>
<body>
<%

<!-- #INCLUDE FILE="adovbs.inc" -->

dim conn
dim sql
dim r
dim aConnectionString

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="Provider=SQLOLEDB;UID=Administrator;Password=passw d;Initial Catalog=nrth;Datasource=server ip;Port Number= 80"


Response.Write (" Database Connectivity")

%>
</body>
</html>

View Replies !   View Related
Microsoft OLEDB Provider Error (with SQL Server And ASP)
Dear all,

Still i am having problem with connecting sql server with ASP (Intranet).

Following is the code which i am using for the connection now,

Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=aspfirst;Uid=;PWD=;"


The error mesage , generated by this code is attached with this mail. Please check the attachment and hel me in the same


Graceson

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error &#39;80004005&#39;
Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'TestMan'. Reason: Not associated with a trusted SQL Server connection.

/Default.asp, line 75


Please help me to solve this error. Thanks.

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80040e37'
I get Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name '#t_testTemp484883646'. 
 when I run the following  ASP code:

------------------------------------------------------------Code is below---------------------------------------------------------

<!---#Include File="../includes/adovbs.inc" -->

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>

<%
 '----- Setup database connection
 Set DataCmd = Server.CreateObject("ADODB.Connection")
 Set rsData = Server.CreateObject("ADODB.RecordSet")
 Dim varTempTableName
 
 DataCmd.Open Application("DB")
 
 '----- Use a Temp Table so that it gets destroyed automatically in case the page times out
 '----- Use a Global Temp Table so that it is available across scopes when I open the record set below
 '----- Append a semi unique number to the end because its global it could conflict with another browser running the same report
 
 'varTempTableName = "##t_TestTemp" & Minute(Now()) & Second(Now())
 varTempTableName = "#t_TestTemp" & Session.SessionID
 
 
 strSQL = "Create Table " & varTempTableName & "(TestColumn2 int)"
 DataCmd.Execute strSQL
 

 strSQL = "select * from t_Test"
 rsData.Open strSQL, DataCmd, adOpenForwardOnly,adLockReadOnly
 
         
    
 Do While Not rsData.EOF
  varTestColumn2 = rsData("TestColumn2")
  
'Error occurs when I place the following insert statement. Code works with the global variable

  strSQL = "Insert into " & varTempTableName & " (TestColumn2) values (" & varTestColumn2 & ")"
  DataCmd.Execute strSQL
  
  rsData.MoveNext
 Loop
 
 rsData.Close

 strSQL = "Drop Table " & varTempTableName
 DataCmd.Execute strSQL

     
 Set rsData = Nothing
 Set DataCmd = Nothing
 %>
 
</BODY>
</HTML>


 

View Replies !   View Related
How Can I Get My Desktop App To Talk To My Windows CE Device In Vb.net Compact Framework?
HI all,

Que 1.

M doing PDA Project in Vb.net Compact framework [ CF ]. In tht I need to do synchronization My PDA's database with Desktop Computer's database manually.
So Plz Suggest me some options .....
One of them I know & Its RAPI..
--> "RAPI allows desktop based applications to talk with CE devices while they're connected to the desktop via ActiveSync".

but M confused regarding ActiveSync Bcoz i want to do it Manually.

Thnx & Regards

Amit B. Master

View Replies !   View Related
I-Mate JasJar And Compact Framework Installation Problem ?
Hi everyone here

 

i have a little problem :

i tried to install the compact framework onto my pocket pc with windows mobile 5.0

but the installation fiailed and gave me an error .

the error message said that :

 the version of installation is not specified for this version of

 operating   system  ..

so what can i do to install compact framework on the device ?

 

please help !

View Replies !   View Related
Microsoft OLE DB Provider For Oracle 64-Bit, SQL Server 2008: Does It Exist?
 

Does anyone know if the "Microsoft OLE DB Provider for Oracle" in 64-Bit Windows exists in SQL Server 2008 64-bit?  It only existed in 32-bit SQL 2005,  which was a big problem.    Needed for Linked Server creation.  We do not want to use OPENQUERY calls with the native Oracle 10G driver,  too many coding changes.
 
Thank You

View Replies !   View Related
HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)
 

Hi all,

 

I am trying to access my SQL Server database through SqlCeConnection:

 

cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();

 


I am getting the following error:

 

System.Data.SqlServerCe.SqlCeException was unhandled
  Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
  HResult=-2147467259
  NativeError=25009
  Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
  StackTrace:
    at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at nddbpda.frmCeMain.frmCeMain_Load()
    at System.Windows.Forms.Form.OnLoad()
    at System.Windows.Forms.Form._SetVisibleNotify()
    at System.Windows.Forms.Control.set_Visible()
    at System.Windows.Forms.Application.Run()
    at nddbpda.Program.Main()

 

 


When I tried to get the path from which the database file is being accepted, I got a different path:

 

string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
 

 

 

This code gives me this path:

 

Program Filesddbpda

 

 


Then I changed the path in my connection string to this:

 

cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();

 

 


 When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

 

 

What should I do now to correct this?

 

Thanks in advance.

 

Saswata.

View Replies !   View Related
HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)
 

Hi all,

 

I am trying to access my SQL Server database through SqlCeConnection:

 

cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");

cecon.Open();

 

I am getting the following error:

 

System.Data.SqlServerCe.SqlCeException was unhandled
  Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
  HResult=-2147467259
  NativeError=25009
  Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
  StackTrace:
    at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at nddbpda.frmCeMain.frmCeMain_Load()
    at System.Windows.Forms.Form.OnLoad()
    at System.Windows.Forms.Form._SetVisibleNotify()
    at System.Windows.Forms.Control.set_Visible()
    at System.Windows.Forms.Application.Run()
    at nddbpda.Program.Main()

 

 

When I tried to get the path from which the database file is being accepted, I got a different path:

 

string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);

 

This code gives me this path:

 

Program Filesddbpda

 

 

Then I changed the path in my connection string to this:

 

cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");

cecon.Open();

 

When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

 

 

What should I do now to correct this?

 

Thanks in advance.

Saswata.

 

 

View Replies !   View Related
ANN: VistaDB 3 As World's First Managed SQL Database Engine For .NET And Compact Framework
VistaDB 3 CTP has been released as the world's first fully managed SQL database engine for Microsoft .NET, Compact Framework, Windows Vista and Mono. Unlike the new SQL Everywhere, .NET developers can use VistaDB 3.0 to build 100% managed WinForms and ASP.NET database applications that run on desktops, mobile devices and web servers. VistaDB's small 600KB assembly includes a built-in ADO.NET Provider, which means that it can be embedded into any .NET application. VistaDB 3.0 also makes mobile development and deployment easy since the same VistaDB 3.0 assembly will run on all mobile devices.

Read more:
http://www.vistadb.net/Press_060801_VistaDB3_CTP_Released.asp?ref=200608forum

View Replies !   View Related
Error :(provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server) (Microsoft SQL Server, Error: 53)
Hi,

   I am trying to connect to my SQL Server 2005 but it gave me following error message.

 


TITLE: Connect to Server
------------------------------

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

 

So, Please help me to solve this problem.

 

tnks.

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server (0x80040111)[DBNETLIB][ConnectionOpen (Conne
Hi Friends,

I am trying to connect to sql server 2000 using ASP & VB. The logic what i am using is as follows:

I have a VB componet which reads the Sqlserver name, user name and password. I have an INI file with the following details:

Server_Name = abc
User_Name = sa
Password = sa

In vb class i have a function which builds the connection string like the following:

mstrServerName = GetFromINI("SQL", "Server_Name", "", App.Path & "ADOConnection.INI")
mstrServer_UserName = GetFromINI("SQL", "User_Name", "", App.Path & "ADOConnection.INI")
mstrServer_Password = GetFromINI("SQL", "Password", "", App.Path


mobjConn.ConnectionString = "Provider=SQLOLEDB;Password='" & mstrServer_Password & "';User ID='" & mstrServer_UserName & "';Initial Catalog=ACDB;Data Source='" & mstrServerName & "';"

My ASP page will call this dll and gets connected to the sql server 2000.
I have sql server 2000 and ASP application running on different machines.

Now i have got the running setup working fine. But now we want to move our existing db to another server.(ex: abc system to bcd system).

so for that it's enough to change the Server_Name ,User_Name,Password in INI file. If i am trying to do that i am getting the following error:

Microsoft OLE DB Provider for SQL Server (0x80040111)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


I am not able to find where the problem is. Can any one help me?

Thanks in advance.

Friendly,
Bharat.

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005' On Load Balancing
 

I have posted this also in one forum. Somebody might have idea here.

We have four Windows 2003 advance servers with SP 3 configured on NLB.
Each of them has one NIC.
Recently we started to get frequent time-out error messages from web applications on those servers when they try to establish the connection with the SQL 2005. If you run web pages application to connect to sql server 10 times, 9 times you will get good connection results and 1 time you will get time-out.

Microsoft OLE DB Provider for SQL Server error '80004005'
Timeout expired
/common/mypage.asp, line 20

Connection to sql server is established with the connection string. Any idea how to solve this problem? Is there a connectionproblem? from NLB to Web to SQL?


We have tried doing some suggestions (e.g. LMHOST, IP, domain account for WEb to SQL connection, the Query Wait in SQL advance property.), but seems this timeout expired still exist  

 

Thanks in advance...

View Replies !   View Related
Microsoft OLE DB Provider For SQL Server Error '80004005' On The Local Machine
 

Hi,
 
I using SQL 2005 on Vista machine.

 
After disconnected from VPN (Cisco) , I am not able to connect to my SQL. Getting the error Microsoft OLE DB Provider for SQL Server error '80004005'  Timed Out.
 
Restarting the SQL Server or Reset IIS, nothing works.
 
If I restart the machine, it works fine again.
If I don't connect to VPN, I have no problem. 
 
I am wondering that might be the problem. I enabled all the protocols.
 
Thanks
Venkat
 
 
 
 

View Replies !   View Related
Sql Server Compact Edition Data Source Missing In Server Explorer
Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there.  I have uninstall all of the Sql Ce stuff and reinstalled it.  So I'm missing some key link. What are the magic incantations to get to first base?

 

Ed Warren

View Replies !   View Related
Add A New Data Source To A SQL Server Compact Edition
I have installed SQL Server 2005 CE on my computer, but when I try to add a data connection to a CE database in Visual Studio 2005, I cannot find the option "SQL Server 2005 Combact Edition". Why?

 

View Replies !   View Related
Question About Data Access To SQL Compact DB / Server
I am used to work with relational SQL Server databases in other editions and am fairly new to SQL compact. I have installed the compact edition and successfully opened a connection and worked with DB objects in the Compact edition, using Server Management Studio.

I have 2-3 questions:
- Are there any means / drivers / data access installations that would allow me to connect to a SQL Compact database using the data access means that I am used to in other editions of SQL Server? In other words, can I install a data-access "converter" that would know how to talk to the SQL Compact databases over the usual TCP/1434 protocol (or any other port)? I am looking for this feature in order to connect to the SQL Compact the same way I connect to any other relational database. Right now, I am using Toad for SQL Server and it would be nice if I could connect to a SQL Compact.

- With other (non-Compact) editions, I can create an alias to a SQL Server and then specify the means to connect to the server. Can I create an alias to a SQL Compact database/server? I tried but unsuccessfully. This relates to my previous question- If I could create an alias, then I could (I imagine) connect to the Compact databases/server the same way I connect to any relational database using the alias.

- Are there any tutorials for people who are used to working with other (non-Compact) editions that are starting to work with Compact? Any BOL sections that explain the differences between other editions and Compact, from a management-tools/connectivity standpoint? I found some literature; wondering if there's something more detailed out there.

Thank you in advance.

View Replies !   View Related
Microsoft.AnalysisServices.Viewers.DLL Microsoft SQL Server 2005 Datamining Viewer Controls
 

 

Hi

I am trying to use Association Viewer Control in

Microsoft.AnalysisServices.Viewers.DLL dll in VS 2005 but sometimes it gives an error.

"Code generatio for property 'ConnecitonManager'" failed. Error was:'Property accesor 'ConnectionManager' on object 'AssosiactionViewer1' threw the following exception:'Object referance not set to instance of an object"


Is there anyone here who use
"Microsoft SQL Server 2005 Datamining Viewer Controls" in SQLServer2005 FeaturePack ?
http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

i am using VS2005 Version 8.0.50727.762 (SP.050727-7600)
and SQL Server 2005 SP2

thanks from now.

Cem Ãœney

 

 

 

 

View Replies !   View Related
Microsoft Access Doesn't Support Design Changes To The Version Of Microsoft SQL Server
Dear All,Access adp on sql-server 2000After upgrating to A2003 updating data with 1 perticular combobox causes theprogram to hangs without any error-msg.Traying to change te combobox recordsource i get this error:This version of Microsoft Access doesn't support design changes to theversion of Microsoft SQL Server your project is connected to. See theMicrosoft Office Update Web site for the latest information and downloads(on the Help menu, click Office on the Web). Your design changes will not besaved.The solution in :http://support.microsoft.com/defaul...kb;en-us;313298tolks about SP 'dt_verstamp007' but I have SP 'dt_verstamp006'What should I do.Is the failure of the combobox also caused by the absence of dt_verstamp007???Filip

View Replies !   View Related
Copy Data From SQL Server Compact To SQL Server 2005
Is there a way to use SSIS to copy data from a SQLServer CE database to a SQL Server 2005 database?
 
I have a database that has only been used on a mobile device, but now I want to use it among several devices, so I want to copy the structure and data to a SQL Server 2005 database and expand it's scope.
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved