Accessing The Database Remotely From Non-microsoft Platform

Jul 23, 2005

I have a query of the kind brains of this group.

Is it possible to access a microsoft sqlserver database (for select, insert,
update, delete, and for miscellaneous administrative actions such as table
and index creation and deletion) remotely from a compiled C program (and/or,
from Perl) running on a NON microsoft platform, such as Sun's Solaris and/or
Linux?

What toolset(s) could be used (on the UNIX/Linux end) for such a purpose?
Would it require a corresponding special toolset to be installed on the
Windows server end as well? (I'd prefer not to have to do that if
possible.)

If you are not now rolling on the floor laughing at the "heresy" of such a
notion, thanks in advance.

Dan
Join Bytes! (replace 'glowing' with 'lucent')

View 1 Replies


ADVERTISEMENT

Remotely Accessing Database

Oct 15, 2004

I'm developing a VB app to manipulate data in a table. I've created an SQL server (local) and have successfully connected to and manipulated data in a database that I created. I would like to be able to run the app on another machine and connect to the same server. I'm having trouble determining what the server name is. Tried a few things but get the "server does not exist" message. Server is set to authenticate SQL server and windows.

Is this happening because my server is (local)? If so how do I change it to permit remote access?

Any assistance would be appreciated.

View 2 Replies View Related

Problems With Accessing Database Remotely

Aug 10, 2007

I'm writing an web app in VS2005.
I've created a product.mdf database through VS2005's Server Explorer (to my knowledge, I'm not using Sql Express). (Side question. The .mdf files are a stand alone xml structure used as a database, correct?).
When I execute locally, everything works great. But when I moved my code to where it is being hosted (remote computer). It's throwing the following error:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
This is my connection string:<add name="MyConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Product.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
 
What is my problem?

View 3 Replies View Related

Accessing A Microsoft Access Database From Within Visual C++

Aug 14, 2006

Hi there guys, I am currently trying to achieve a seemingly simple task in VC++ 2005. I have made a very simple form in Microsoft Access which I wish to serve as the beginnings of something greater. I created a db in MS Access named links.mdb containing on table-> Table1. Table1 contains 1 column, "Links", and i wish to read these strings into variables in my Visual C++ Windows Forms Application.

What I have done so far...

In Visual C++, I clicked on Data->Add new data source, and followed the wizard to add the microsoft access database to my application by the name, "linksDataSet". I can see the table in my left hand "Data Sources" pane in VC++. All I need to know is how to access my database from here so that I can read these strings stored in my table. Also, would be possible to schedule my application to log on to a http server and retrieve these links every time the application is executed? How would I go about doing this?

Thank you very much for your time
Regards
Linden.

View 5 Replies View Related

Accessing Remotely Located SQL Server Via Access

May 18, 2007

Hi,



I need the code to create a connection between the Sql server using ACCESS form.

Can I do this. If yes . can you help mw with it.



Currently I am accessing the server with remote desktop connection



Regards,

Jay

View 3 Replies View Related

Issues About One Application Remotely Accessing Multiple Databases

Nov 22, 2007



Hello,

My next project(in VB.NET 2005) would involve accessing different DBs and tables in remote SQL servers

What are the steps that need to consider first? Are there any settings that needs to be done in the servers?
k

View 1 Replies View Related

Comments On InterSystems Cache Database Platform

Jul 20, 2005

Hi all,We're looking at a vendor who uses the InterSystems Cache DatabasePlatform, but our IT department has zero experience with this system.This software package will have a pivotal and mission critical roll inour organization, so I'd like some comments on what others think ofthis database platform.Mainly I'm curious how easy/difficult it is to query a Cache Database,and does it use standard SQL calls like Oracle and MS SQL? What aboutODBC connections into the database from Crystal, MS Access, and OLAPtools? Any other caviets (backup, maintenance, etc)?Thanks in advance for any suggestions or comments Cache.Sam

View 4 Replies View Related

Connecting Database Engine (SQl Server 2005 File .*mdf) From Win CE 5.0 Platform

Jun 26, 2006

Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?

I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";

SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);

SqlCeConnectionCE.Open();

but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";

zwraca błąd typu

catch (SqlException ex)
€śLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?

I used
using System.Data.SqlClient;

from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0

can anyone help me?

View 1 Replies View Related

Access SQL Server Database Remotely

Jun 4, 2001

Hi,

Can anyone please tell me how to access a SQL server database remotely. I have
the IP address and login info. of the NT machine that is running SQL server
database, and I want to access the data remotely.

Thanks for any help.

Chetan

View 1 Replies View Related

Building / Modifying An SQL Database Remotely

Jul 23, 2005

Hi Folks,I should begin by saying I'm fairly new to SQL Server. I'm an applicationdeveloper who has built front ends atop Server, but have never done much inthe way of design / development.My question is in two parts;1). What is the best way to remotely "create" an SQL Server database? I'vebeen told that this can be done with SQL Statements, but thought that theremay be a way using XML.2). Can I use this same method to propogate updates to the remote databasewithout affecting the data?To give you a better idea of what I'm trying to do, I have a client thatlives quite a ways up north. I'm building an application that will beinstalled up there. I'd like a method to be able to make changes to thisdatabase on my end (the development copy), create an XML file of the"database structure" and have the other database or application import thisXML file, and add tables, fields and relationships if they don't alreadyexist.Any help would be appreciated.Thanks!Rick

View 1 Replies View Related

Newby: Administer A Database Remotely?

Jul 20, 2005

I'm working on a website remotely through a VPN and my client uses SQLServer. There's a requirement for a database and my client uses SQLServer 2000.Is it possible to administer this database remotely, just like I dowith MySQL/PHP MyAdmin?Please elaborate.Thanks,Marjorie

View 2 Replies View Related

Transaction Not Saved Into Database When Access Remotely

Oct 21, 2007

I have a problem when trying to save a transaction remotely. I'm using my pc as the server and I can save without any problem from local (the same project).
But when I try accessing the project from other pc, the transaction doesn't get saved into the db.
No error displayed. It's just doesn't get saved. What is the problem? Is there any IIS setting that I should put in?

View 3 Replies View Related

Is It Possible To Have A Website Remotely Hosted, Which Would Access Local Database?

Dec 24, 2007

Hi everybody,
Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office.
We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it.
Would it be possible to access our local SQL database from the remote website?
 

View 4 Replies View Related

Want To Access SQL Database To Run Loop To Check Robots.txt Remotely

Jan 22, 2008

One of my tables in the db contains the websites and the location of their link directory. i.e. domain.com/linkdirectory
I want to run a check against every website's robots.txt file to ensure that it doesn't look like this:
user-agent: *
Disallow: /linkdirectory/
so I need a program that does the following:
 For each website in database (start of loop)
  Does robots.txt exist on their site ?(run a remote check)
     if it does
        is their link directory blocked in robots.txt?
          if so, then log their user id and website name into an array for later use
          end if
       endif
end loop
How would I do this in ASP.net 2.0? 

View 3 Replies View Related

Remotely Ending Service In 2003 To Restore Database

Mar 24, 2008

Morning Guys,
I have a database where I need to kill a remote connection.
If I was manually logged into the box i would you a netstat command to stop the service.
I would like to end a process from another machine before starting a restore process

Does anyone have any suggestions?

thanks,
Jonathan

View 3 Replies View Related

Can't Connect Remotely To WSUS Referential MSDE Database

Nov 9, 2006

Hi all,

WSUS is installed on my windows 2003 server. During the install, parameter DISABLENETWORKPROTOCOLS was not specified, and so no remote connection was possible.

I used SVRNETCN.exe to enable TCP/IP remote connection on port 1433. However it seems not to work.

FROM THE SERVER :

osql -E -S MYSERVERWSUS works fine but

osql -E -S 127.0.0.1WSUS doesn't work, i get the famous error

[DBNETLIB]Serveur SQL spécifié non trouvé.
[DBNETLIB]ConnectionOpen (Connect()).

If i user "osql -L" command, my instance doesn't appear in the list

FROM A CLIENT COMPUTER

osql -E -S MYSERVERWSUS and

osql -E -S MY_SERVER_IPWSUS don't work, i get the same error

I've tried tried to understand for hours, and i'm lost. I thought there may be a problem between SQL and 2003, and read SQL sp3a was required. I ran

select @@version from osql and got result

Microsoft SQL Server 2000 - 8.00.881 (Intel X86)

8.00.881 is not referenced in ms support as a patched version number !!!!!

Can anyone help me please ?



View 1 Replies View Related

Provider Error On Using Database Tuning Advisor Remotely

Dec 5, 2007

Hi,

I am experiencing a Named Pipes Provider error 40 message as detailed below. I get this when I'm running the dta utility on a production server which is trying to remote onto a test server to use the metadata and optimizer there.


The error reported is...

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)


(note: there is no (Microsoft SQL Server, Error: xxx) reported at the end of the error string)


The error results from the following cmdline syntax run from the production server.

dta -A 0 -E -e C:TuningLog.xml -F -ix C:DTA.xml -N OFF -of C:outputdta.sql -rl ALL -s DTA_20071205


Prod box: 64bit SQL2005 SP2 Std Ed Named instance, TCPIP and Named Pipes enabled, SQL Browser service running.
Test box: 32bit SQL2005 SP2 Std Ed Default instance, Listening for local and remote connections on TCPIP and Named Pipes (configured through the SAC), SQL Browser service running. From the SQL Log on the test box I can see TCPIP is listening & Named pipes is listening on \.pipesqlquery


There is no firewall configured on either box.

I can connect to the test server from the prod box using sqlcmd -E -S<servername>
I can ping the test server from the prod box


Would you have any idea what I'm doing incorrectly? The genericity of the error message doesn't give me much of a clue and the resolutions I've read all revolve around SQLBrowser, surface area config, and SQL Express which I've covered off.


many thanks

Matthew Eames

View 1 Replies View Related

Backup Database Database Remotely

Apr 5, 2007

i have a stored procedure that backups database on server A which i execute this SP from server B in a scheduled job. when i run this job it gives me an error:
Executed as user: domainuser_name. Could not relay results of procedure 'usp_BackupDBOnServerA' from remote server 'ServerB'. [SQLSTATE 42000] (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
i searched MS KB, everywhere but could not find the solution or even explanation why this happenning.
both sql servers are 2000 and they are linked.

View 3 Replies View Related

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

Dec 13, 2007



Hi,

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.

Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."

Please help me

thanks in advance

Srinivas



View 1 Replies View Related

SQL Database User Account Access Remotely Via SQL Management Studio Express

Aug 20, 2007

Hi, I hope you can help.I have configured a Windows 2003 web server and SQL 2005 Server (on same box) to successfully allow remote connections and to allow access via SQL Server Management Studio Express 2005.The problem I have is that I want to restrict access to the databases on the server via the Management Studio to specific databases e.g. 1 database user "sees" only 1 database.I can configure it so that the user's remote  access permissions do not allow access to other databases but they can still "see" the database listed in the Management Studio explorer.I can also configure it so that the users cannot see all the databases (by disabling View All Databases on SQL Server), but this means that they cannot not see their own database which they have permissions for.Is it impossible to have the desired behaviour of only displaying the database which the remote user accessing has permissions for and hiding all other databases?I have MSN'd,Googled and Yahoo'd this one to no avail :(Many thanksFergus 

View 6 Replies View Related

Microsoft SQL Server Database File (SqlClient) Vs Microsoft SQL Server

Aug 30, 2006

In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server?

I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose?

Thanks very much for your information.

View 1 Replies View Related

Accessing Tables Of A Different Database From The Current Database

Apr 15, 2008



Hi,

In a stored procedure is there a way of accessing a table presend in another database.

Please provide pointers on how i can do this.

Thanks,
Raj

View 4 Replies View Related

Help With Accessing Database

May 25, 2007

Hello,



I just switched to a host that allows database connections so that I can now upload my database to their server.



When I test my site on my personal PC it works great. I upload everything to the server and nothing. I know that I need to load the database to the server. I have Microsoft SQL Server 2005 Express and can make the connection but how do i load my database from my personal PC to the host computer?



I would be greatful if someone was able to walk me thou the steps on how to transfer the database. I am really very new with the database thing and ASP.



Thank You



Chris

View 1 Replies View Related

Accessing Data In Different Database

Jan 22, 2007

Hello Everyone,
  Is it possible to write a query that can access data in differnt database so I have "trainee" and "training" databases. In want to access one training  table in trainee database through a query. How can I  do this.
 
Thanks.

View 1 Replies View Related

Accessing Database Users

Feb 8, 2007

Hi,
 I would like to know if there is any way of Accessing database users from frontend and changing their persmissions.
Thanks
Niranjana. 
 

View 10 Replies View Related

Accessing A Database From Another Project

Aug 30, 2007

 Hay there,I have an asp.net project website with an sql Database. I need to access this same database from another project (a class library that needs to access this database). In fact i want to be able to use the tableadapters that I have implemented for  my database in this new class library.. I guess it has to do something with making my database not part of the website but and independemt entitiy that can be seen by others..... I cannot seem to find a way to do that can anyone help meee ????Thanks for your time! 

View 6 Replies View Related

Accessing Database Problem

Oct 24, 2007

Hello friends when I am working in VWD and accessing sql data this error came?I am using asp.net visual web developer edition and sql server 2005 expressedition.  plz check it  out and help me.The log scan number (588:85:1) passed to log scan in database
'D:GCAPAPP_DATAGRIET_IT.MDF' is not valid. This error may indicate data
corruption or that the log file (.ldf) does not match the data file (.mdf). If
this error occurred during replication, re-create the publication. Otherwise,
restore from backup if the problem results in a failure during startup.
Could not open new database 'D:GCAPAPP_DATAGRIET_IT.MDF'. CREATE DATABASE
is aborted.An attempt to attach an auto-named database for file
D:GCAPApp_DataGRIET_IT.mdf failed. A database with the same name exists, or
specified file cannot be opened, or it is located on UNC share.
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.Data.SqlClient.SqlException: The log scan number (588:85:1) passed to
log scan in database 'D:GCAPAPP_DATAGRIET_IT.MDF' is not valid. This error
may indicate data corruption or that the log file (.ldf) does not match the data
file (.mdf). If this error occurred during replication, re-create the
publication. Otherwise, restore from backup if the problem results in a failure
during startup. Could not open new database 'D:GCAPAPP_DATAGRIET_IT.MDF'.
CREATE DATABASE is aborted.An attempt to attach an auto-named database for
file D:GCAPApp_DataGRIET_IT.mdf failed. A database with the same name exists,
or specified file cannot be opened, or it is located on UNC
share.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:



[SqlException (0x80131904): The log scan number (588:85:1) passed to log scan in database 'D:GCAPAPP_DATAGRIET_IT.MDF' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Could not open new database 'D:GCAPAPP_DATAGRIET_IT.MDF'. CREATE DATABASE is aborted.An attempt to attach an auto-named database for file D:GCAPApp_DataGRIET_IT.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +171 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2406 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +34 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +223 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +371 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +184 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +510 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +159 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +118 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +82 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1653 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +82 System.Web.UI.WebControls.ListControl.PerformSelect() +18 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.Control.PreRenderRecursiveInternal() +88 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5684

Version Information: Microsoft .NET Framework Version:2.0.50727.832;
ASP.NET Version:2.0.50727.832

View 1 Replies View Related

Problem In Accessing The Database.. Please Help!!

Oct 14, 2004

Hi There !!

CAn you please help me to solve my probelm and i will appreciate it if you help me. I installed SQL server on my machine and i installed tables in a database called "otters" when i run the application, i got an error message on the browser as shown below although in the application it says that it recognise the source of the dastabase. CAn you please help me to sort out tis problem and please try to look back to this thread after givingf me the soultion as it might not work and i need more assistant. I really, appreciate your help and thank you in advance. Please read the error message below
**************************************************

Server Error in '/Otters' Application.
--------------------------------------------------------------------------------

SQL Server does not exist or access denied.
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.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:


Line 403: Dim conn As New SqlConnection(connStr)
Line 404: cmd.Connection = conn
Line 405: conn.Open()
Line 406:
Line 407: ' Allocate an empty array list to hold the performance objects found


Source File: C:CSE506TheaterPerformance.vb Line: 405

Stack Trace:


[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Theater.Performance.Find(SqlCommand cmd) in C:CSE506TheaterPerformance.vb:405
Theater.Performance.FindByDateRange(DateTime st, DateTime et) in C:CSE506TheaterPerformance.vb:369
Otters.admin.Page_Load(Object sender, EventArgs e) in C:InetpubwwwrootOtterssecureadmin.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET

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

View 7 Replies View Related

Tutorial; Accessing MS SQL Database Using C++!

Jul 20, 2005

hey!Im looking for a db tutoral which covers accessing a Microsoft SQL databaseon windows. I will be using VC++ if it matters. NO details just a basicintroduction!Oracle DB access using C++ is also of interest!Thanks!-- Majk

View 1 Replies View Related

Accessing An Existing Database

Jan 23, 2008

I have a MSSQL database from a pre-existing app. The data files do not have an MDF exension, they have a .dat extension. I can however use Microsoft SQL Server Management Studio Express to run queries against the files, but I can not get VB 2005 to connect. When I attemp to add it as a project data source, I get the following error:

"An attempt to attach an auto-named database for file c:dataMSSQL$DATA_SQL....dat* failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."

*Database names = company names are omitted to 'protect the innocent'.

Does anyone have any ideas? Since Microsoft SQL Server Management Studio Express worked so cleanly with the database I was expecting to easily get to the same data using VB.

View 5 Replies View Related

Accessing My Database From Home

Feb 29, 2008

Hi,

I have an sql express server which contains a single database. Three users access this database using a C# application I have writen. I use Integrated Security for these three users.

The problem is that one of my users wishes to use my application from home.

What are my options in letting this user use my application from home?

Thanks for your help,

Barry.

View 1 Replies View Related

Accessing A Database File

Sep 5, 2006

Hi,

I'm a hobby C# programmer, and when at university there are a few machines that have SQL Server 2005 installed on them (i think it's standard ed).

From looking around at sql 2005 free edition and DNN (dot net nuke) it's apparently possible to have the database file in the execution directory of your application.

My question is this, if i have a C# win app, is in possible for me to store the database files, in the executable directory of that app, and not in the default sql database store of C:prog filessql server90 data etc...?

Ie, what i want to do, is for the C# win application on start up to "mount" the database, use it normally like any other sql database, and then "unmount" it at the end.

The reason for "mounting" and "unmounting" is that i don't want the database to be accessible or even visible to sql server when the c# app isnt running.

I hope I've explained myself clearly, and thanks a lot in advance.
pro-logic

View 3 Replies View Related

Accessing Another Database On The Same Server

Aug 10, 2006



Let's assume we have 2 databases db1 & db2

and we have a table named "MyTable" which is located in db2 database

in the db1 database I create a stored procedure by using following code:

<<

use db1

create procedure myproc

as begin

select * from db2.dbo.MyTable

end;

>>

this code does not execute successfuly and I face an error which says << invalid object db2.dbo.MyTable>>

and as you know we are not allowed to use USE database key word in stored procedures

I can's access a table which is located in another database, whithin a stored procedure which is located in different data base but on the same server

thanks



View 3 Replies View Related







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