Access A Database From A Client Application

Oct 18, 2006

Hi all...

I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated)

The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site.

Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data.

So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure.

Is there a way to secure this password? I am worried about a user somehow extracting the password from the application and connecting directly.

Am I on the right track here? Any ideas appreciated!

Thanks,

Forch

View 4 Replies


ADVERTISEMENT

How To Access Output (Inserted.ColName) From Client Application ?

Nov 6, 2006

I am using SQL Express 2005 and VB .net Express.

Question 1:

How can I get the result stored in Inserted.ColName (by Output clause of insert command). In the documentation (BOL) for SQL 2005, there is written "returned to the processing application for use" in Output clause (first paragraph).

Question 2:

How to store Inserted.ColName into local variable when insert command is running in stored procedure.:

View 8 Replies View Related

How To Set My ASP.NET Application To Access SQL Server 2005 Using Client's User Credentials?

Jan 29, 2007

Hi guys,I'm not sure if I'm just bad at googling but I can't seem to find a way to set an ASP.NET 2.0 web application to connect to SQL Server 2005 using the current client's user credentials. My web application is using Integrated Windows Authentication so its Page.User.Identity is set to a DOMAINusername value... I want to pass that to my connectionstring or have my connections pick up the identity automatically and use that Identity when accessing the db server.Oh and another thing, my IIS Application Pool is using a specific Identity itself, so I don't know if that might affect the above.Hope someone could help. 

View 2 Replies View Related

Deploy Database Application To Client Computer?

Oct 1, 2015

I want to deploy my database application to my client's computer. My application uses SQL Server 2014. My client has to run that software on a single PC. I was looking to download a lightweight version of SQL Server that can fulfill my requirements, so when I was looking for SQL Server downloads, I saw these files there, which file should I use in my situation

Express 32BIT WoW64SQLEXPR32_x86_ENU.exe
Express 32BITSQLEXPR_x86_ENU.exe
Express 64BITSQLEXPR_x64_ENU.exe
ExpressAdv 32BITSQLEXPRADV_x86_ENU.exe
ExpressAdv 64BITSQLEXPRADV_x64_ENU.exe
ExpressAndTools 32BITSQLEXPRWT_x86_ENU.exe
ExpressAndTools 64BITSQLEXPRWT_x64_ENU.exe
LocalDB 32BITSqlLocalDB.msi
LocalDB 64BITSqlLocalDB.msi
MgmtStudio 32BITSQLManagementStudio_x86_ENU.exe
MgmtStudio 64BITSQLManagementStudio_x64_ENU.exe

View 7 Replies View Related

Urgent - Client Application Database Choice

Oct 31, 2006

We have a small accounting application which is currently based using DBASE database. We need to change the DB and considering SQL Express. However, is some one can clarify following, it would be very helpful:

1) Application is used mostly by standalone non-technical users. There are cases where more than one user will need to connect to DB.

2) We need to ensure that user can not modify database outside of our application. This is needed to ensure database does not get currpted or passwords lost and then no one can open the database.

3) Installation needs to be simple without providing any options to users except where to install database or point to already installed DB in case its a network environment where 2-3 users can be working on the same database.

4) Application is usually installed on normal desktop machines. So, DB should not load the PC heavily.

Please advice if SQL Express is the right direction even with these constraints? What are the other alternatives? We are open to have a small consulting project as well with someone who can guide us through these issues. Email to contact is rkabra101@yahoo.com



rick

View 1 Replies View Related

Cant Get Access Database Synchronizer Set Up On Client Machine

Apr 17, 2007



I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.



His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"



However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".



There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".



His current config.xml file looks like this.



<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>



He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error



"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"



I dont know what else to try! Anybody have any suggestions?

View 5 Replies View Related

My Published Application Can't Access The Database

Jun 8, 2007

Hi

I am nearing the end of creating my Windows App for work. So I tried to publish it, that was fine until I ran the app, from the same PC as I use to develop, with the same login etc. However when I use the published app I can't connect, to the database, return to VS2005 and run my app from within there and no problems. It is SQLEXPRESS (SQL Server 2005), but I have checked the settings there are correct (I assume VS wouldn't connect otherwise).

Help please.

Details...

Server = FRED database =Joe

Connection string (Data Source=FREDSQLEXPRESS;Initial Catalog=JOE;Integrated Security=True

Server (Win2003) and my PC (Win2K) are on the same domain

Using TCP/IP

I can't see how to enable JiT debugging despite the 'help' at the end of this error details...
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at TrainTrack.frmAddCompetency.frmAddCompetency_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
TrainTrack
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/graham.yetton/Local%20Settings/Apps/2.0/4GZWZKGB.4O3/9XXGWKLB.MTQ/trai..tion_75116344273b6719_0001.0000_b44ce39f580948f8/TrainTrack.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

View 4 Replies View Related

ADS: Sample Application Cannot Access Desktop Database

Nov 1, 2006

The sample application provided with Access Database Synchronizer fires a "A request to send data to the computer running IIS has failed. For more information, see HRESULT." exception on my WinCE 4.2 device.

I debugged it with VS2005 to see what was going on and found that the problem resides in the line:

m_connDesktop.Pull("MSysObjects","SELECT Name FROM MSysObjects WHERE Type=1 and flags=0",accessSysConnectString,RDATrackOption.TrackingOff,"Err_MSysObjects");

It seems that connection m_connDesktop is ok but calling Pull method fails.

I've verified that SSEvAccessSync service is started when ActiveSync detects device connection and that firewall rules are correctly updated.

Also, i verified my System.mdw and i discovered that there is no "MSysObjects" table (only MSysGroupList, MSysGroupMembers, MSysUserList and MSysUserMemberships queries are there).

Do you think the problem is there?

How can i solve it without damaging System.mdw?

I cannot figure out what's the purpose of this line of code, can you help me?

View 8 Replies View Related

User Is Rejected To Access Database From Crystal Report Client And Services...!

Dec 18, 2007

We are using Crystal Report Services XI to generate reports from SQL Server 2000 database running on server within the same domain (LAN).

for some reason, SQL Server is rejecting the Credentials that is provided to CR Services, the user has right to that database. When We run the report manual, it works fine, but when we run Automatic on schedule , it fails.

The Authentication mode is set to Mixed.

The Startup Service accoutn is set to "This Account"

Any idea, why would this failure on User is encoutered.

Thanks,

View 1 Replies View Related

SQL Database In My Application With Windows Authentication Rejects Accessing After Deploying And Remote Access

Dec 13, 2007

SQL Database in my application with windows authentication rejects accessing after deploying and remote access
1- My web applications databese access is windows authentication
2- In developing area there is no problem for accessing database
3- After deploying to another server there is problem accessing database:
Cannot open user default database. Login failed.Login failed for user 'BRCK231ASPNET'.
 How can I solve this problem?
Thanks.

View 1 Replies View Related

VB.net Application For Client-Server

Apr 16, 2007

Hi folks,
I have an application designed in vb.net and it needs to Communicate with MS SQL 2005 database which resids on SERVER and The applicaton needs to run from Client PCs... When i install the Application on Server itself it works fine.... But when i Install it on any of the client Pcs it gives me the following error....

Unable to install or run the application. The application requires that assembly Microsoft.sqlserver.ConnectionInfo version 9.0.242.0 be installed in Global Assembly Cache (GAC) First.

Any help guys ???

View 3 Replies View Related

Client/Server Application

Sep 12, 2007

hie,
have a question. what tool is available to develop client/server application with db as ms sql server? is it only visual studio.
for example: i was using oracle 9i db with 9i developer as a total package to build applications. very easy with creating update, delete or new forms.
is it possible with visual studio or am i missing something?
i need to feel comfortable since i know sql server but dont know what to use for developing application.
many thanks,
farouque

View 2 Replies View Related

Use Reportiing Services From Client Application ???

Dec 11, 2007

Dear all,

I need to develop fro my customer a WinForm application which will display a list of report name available fro my customer, who will be free to select the desire report to print.
For that I was previously using Crystal report but as now I am in an environment where report services is included and can be used I have decide to test it and see if it cover my customer need.

I have use reporting service in one of my customer project but by dircetly accessing it through the ReportServer default interface but never from a WinFrom application.

How can I implemented the connection to reporting service, accessing report template and have access to print function as well as export to different format in my application ?

Is there any step by step procedure somewhere ? could not found

thnaks for your help
regards
serge

View 6 Replies View Related

Converting An Application To SQL Native Client

Oct 19, 2007

I am currently modifying an existing application (which uses OLE DB Consumer Templates to access a remote SQL db) to utilize SQL Native Client instead. Does anyone have any experience making this change?
Am I correct in my assumption that all I have to do is:
change my included headers from 'sqloledb.h' to 'sqlncli.h'
and
change CLSID_SQLOLEDB to CLSID_SQLNCLI?
I am still including the 'atldbcli.h' header and therefore still using the OLE DB Consumer Templates.
Can I continue to use the Consumer Templates along with SQL Native Client?


View 4 Replies View Related

ReportBuilder.Application Will Not Work On Client On Network

Apr 10, 2006

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [4/10/2006 11:34:29 AM] : Activation of http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [4/10/2006 11:34:29 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://webdev.ci.lubbock.tx.us/ReportServer$SQL05/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

Does anyone know how that I can get the reportbuilder.application to run on a client on the network. It seems that if I have to remote into the actual server to get the report builder to work would be pointless for users on the network. I get the 401 Unauthorized all the time. Any comments would help.

Jordanb412

View 3 Replies View Related

List Groups That Have Access To Application And Use Grid Format To Show Access To Specific Tables

Jun 23, 2014

i am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project. I need to list the groups that have access to my application and use a grid format to show access to specific tables.

I am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project. I need to list the groups that have access to my application and use a grid format to show access to specific tables.

Role Loans Payments Transactions Accounts Customer Emplo
Database Admin SUID SUID SUID SUID SUID SUID
Branch Manager SUI SUI SUI SUI SUI SUI
Internal Auditor S S S S S S
Loan Officer SUID SUI SUI S S
Tellers S S S S SU
Customers U

View 1 Replies View Related

Where To Build Client Application For SQL 2005 Standard Edition

Jul 24, 2006

Hi,
I have a database working on SQL Server 2005 Standart Edition and i want to create a client windows form aplication.
My problem is where to do it? Im trying to use MS visual basic 2005 express edition but it doent support SQL Server 2005 Standart Edition, it only supports SQL 2005 express edition.
What should i do ?
And in the visual studio 2005 that comes with the package of SQL Server 2005 standart edition there is no project of a winodws form.
Please help

View 8 Replies View Related

Does MS Access Installation Is Required For Running Application That Uses Access Mdb File

Nov 28, 2006

Hi,

I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?



Thanks,

Rao

View 3 Replies View Related

SQL Server 2012 :: Return Multiple Messages To Client Application?

Jun 9, 2014

I have a procedure where after processing, i am required to send multiple message to calling application.

For ex:

create procedure test as
(@a as int,
@b as int
@c as int )
/*
some transformations */
print 'variable a is' + @a;
print 'variable b is' + @b;
print 'variable c is' + @c;

I am only providing a sample of return messages, but in reality there a lot more messages where a string and a parameter value need to concatenated.Unfortunately print is not allowing to concatenate parameter value.I can use RaiseError, but these messages are not really any error messages.

i tried to concatenate all message and output it using OUT type parameter, but the length of all messages combined exceeds 10000 characters.

Is there any other alternate to send these messages out to application?

View 1 Replies View Related

SQL Server Runs Out Of Resources Or Is It My Client Application. Handle Count = 96k

Jul 20, 2005

SServer PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAMSQL Server 2000 v 2000.8.00.76 (sp3)MS Office 2k3MSJet ms04-014 (latest ost sp8)MDAC v2.8 RTMADO 2.1vb6.exe / ADO 2.0I think this is a SQL Server/ADO problem as I have 2 applications withsame problem.My access database uses a timer based function to insert records intoSQL Server using ADO and stored procedures. Access also uses DAO ,Jet/ odbc to linked tables on SQL Server for many other tasks/forms.All is well when Access 1st run but after a few hours or so the Accessapp grinds to a halt.Upon checking the task manager the mem usuage upto 160MB and handlecount upto 86,000 ! (cpu process % is low).After the "Access Fail" if I stop/start access only, performance isnot returned, I have to stop/start SQL Server.It would seem that allconnections from this PC to SQL server are badly affected, it is nottied to the client application that had the problem.As I could not work out where the problem was I took the Accessfunctionality into a VB6 app, using ADO 2.0, thinking this shouldsimplify matters with Jet and ODBC out of the way.I now have the same problem with the number of handles increasing withevery new timer based function.* code snippet example *If Not OpenConnection Then 'we have not been able to open aconnection to SQL serverCall procLog("Connection failed to SQL server")Exit FunctionEnd If'gVar.cnnSQL is my public ADODB.ConnectionSet cmdSQL = New ADODB.CommandWith cmdSQL.ActiveConnection = gVar.cnnSQL.CommandText = "MyDB.dbo.insert_tblMyData".CommandType = adCmdStoredProc.Execute RecordsAffected:=lngRecs, _Parameters:=Array(lngID, dtDate,intCategory,strNationality,strNotes,strName)End With* code snippet *** After the "Access Fail" if I look at one of my clients, running thesame Access app on another PC, it seems normally responsive when usingone my bound forms to browse the data from same SQL Server **Any ideas anyone ?

View 3 Replies View Related

SQL_SSMEE Failed And Trying To Repair While Lauching Our Mobile Client Application.

Jul 24, 2006



Event ID - 1001 and Event ID - 1004.

Source - MsiInstaller

Error Description for Event ID - 1001:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE' failed during request for component '{6EC5DFBD-F6B5-4F02-8432-BFB8B03562B8}'

Error Description for Event ID - 1004:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE', component '{180F515D-F56C-40DD-9D71-CC532EA8E286}' failed. The resource '' does not exist.

While opening our SAP Mobile Client Application, in the task manager MSIEXEC.EXE is running and trying to repair the application and this will cause our application to take time to lauch. In the Event viewer, whenever we try to lauch our application we are getting this event id's. Can you please kindly provide a solution for this msg.

Regards,

Thiyagarajan.R

View 1 Replies View Related

Installting Sqlserver 2005 On The Client Machine For Windows Application

Oct 24, 2006

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

View 3 Replies View Related

SQL 2012 :: Connections Not Getting Closed By Client Application And Impact Feedback Request

Mar 31, 2014

I have been investigating the number of connections activeinactive to a certain database server and I have stumbled across an application which seems to not be clearing its database connections.For one instance of a client there was >70 sql connections which eventuated from the closing and reopening one 1 screen in the culprut app. Once the application was closed all of the connections are recycled but its evident that within the application itself it is not correctly reusing already existing open connections.

I have raised a point with the main programmer that we need to investigate more into how the application is managingot managing its ADO .NET connections to SQL.

I am starting with doing some reading here URL... and I was hoping to get some more information about the possible impact of excessive sql connections on the SQL Server itself. Our organization is quite lucky in that our SQl Servers are Overspecced given their workload, bearing that in mind I would like to dig a bit deeper to get some stats if I can to highlight the scope of the issue to the managementprogrammers.Our SQL server peaks at 6500 processes and a good 70% of those are due to this applications mis-management of its sql connections.

View 6 Replies View Related

ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer

May 5, 2006

Hi All,

I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.

I would now like to install my application on another workstation and connect remotely to the database located on my development machine.

The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?

Thanks!

View 6 Replies View Related

Sql Server To Access An Application In MS Access

Dec 6, 2000

Hi,
Can anyone tell me how i can access an application or open tables in MS sql server that are in MS Access. Its urgent and any help will be appriaciated.

View 2 Replies View Related

Client Access Lisences

Dec 14, 2000

Hi,

My department has some questions about Client Access Lisences. Specifcally, they want a definition of what does and does not require a CAL,
and they want something somewhat official. I checked the MSKB, and looked on their sales website, but all I can find is the EULA, and that doesn't help
me all that much.

Does anyone else have this information?

Joe

View 2 Replies View Related

VERY Slow Client Access

Jan 28, 2002

I am experiencing VERY slow connectivity between client and server SQL 2000. I have checked the network activity and it is low. It also takes Enterprise manager ages to load, and then browsing tables and trees is impossible!

HELP!!

View 1 Replies View Related

Access Client Problem

May 9, 2001

Hello everybody,



I recently made a DTS-package from importing external data in my sql2k
server.
I linked my access file to the sql server to make some reports.

Right now, my clients run the dtsrun utility through a batch file
themselves. I gave them permissions to be the dbase owner.

Now when you link from access to sql server as admin, your names are :
dbo_Tablename.
If it's another user, the names get pvanmoer_Tablename and for another user
it's cvanho_Tablename.
(Validation through NT)
So my linked tablenames aren't valid anymore in my access file. So I need
to relink them each time.

How can I avoid this problem ? I've been trying to create tables without
dbaseowner, but this doesn't seem to work.

Can anyone help me ?

Thanks,


Bjorn

View 2 Replies View Related

Restrict Client Access

May 27, 2005

Hello Everybody,

I need some help.
When we install the Database at the clients end, the client can see all
the SQL tables, views and stored procedure in the Enterprise Manager.
Is there a way via which you can restrict the client from viewing the
tables in SQL Enterprise manager?

I hope you understand my question.
I would be oblidged if my friends could help me...

Thanks

View 1 Replies View Related

Refresh Access Client

Nov 18, 2005

Is there a way to update data on a MS Access 2000 client from SQL Server without polling a table using the form's onTimer event?

It would be much more elegant if I could push the data to the clients every 15-30 minutes when the data on SQL Server gets refreshed.

Can DTS do this? The forms I'm talking about are select only, no editing.

I know I can do this with java and multicasting, should work with MM Flash as well with listeners. I would really like to take this app to Flash, but we have a 1 month timeline to port from Access to SQL Server.

Thanks,
Carl

View 5 Replies View Related

Question Regarding Client Access

Jan 21, 2008

Hi,
We're *very* new to using SQL Server and are just getting it up and running. We're only running simple queries right now, but we're doing so by connecting to our server via 'Remote Desktop' to run the management studio to run the queries.

Is there an SQL client that can be installed on a user's workstation that will allow them to run queries without having to use a 'Remote Desktop' connection on the server?



Thanks,
James

View 3 Replies View Related

How Do I Allow Access To SQL Server On A Different NT Domain From The Client?

Jul 6, 2001

I want to give a client access to a SQL Server 7 database sitting on a different NT domain without setting up a trust relationship between the two domains. Has anyone tried doing this?

View 2 Replies View Related

DTS Scheduling OLE Db Error - DB2 Client Access

Feb 13, 2000

I have a DTS package that executes when run manually. It is a OLEdb (ODBC) to client access (db2). When I try to schedule it the package fails.

Other packages SQL - SQL are fine to schedule or to run man.

I have played with the Persist Security Info advanced properties of the connection to no avail.

Any assistance would be great.

Thanks

Robb M Sinclair
Newcomp Solutions Inc

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved