Acces To SQL Guidence?
Feb 3, 2007
OK I have been trying on my own to move from Access to SQL express/Developer. I have not found much in the way of guidence. Any suggestions? I would rank myself as fairly advanced with Access but just a newby to the SQL products... I keep blasting into walls and issues in the SQL world and would rather learn from someone elses' hardship rather than re-invent what has been undoubtably been already discovered.
I do fairly advanced reports and Large imports, Hence the need for developer rather than express, since the express import facility is hopelessly crippled. Even the developer SSIS is not well doccumented and seems pretty buggy and hard to use, even with the wizzards, As for reports.... well I'm expecting that to be a fairly had road to climb also...
View 3 Replies
ADVERTISEMENT
Oct 26, 2005
my colleague is using visual studio (VB) and making windows applications. we used same connection string but i can't connect to the sql server.
i am using visual studio(2003) .net(C#) and making web applications. this is the code.
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection ();
// TODO: Modify the connection string and include any
// additional required properties for your database.
//conn.ConnectionString = "integrated security=SSPI;data source=cerebrum;persist security info=False;initial catalog=dals";
conn.ConnectionString="Server=cerebrum;Initial Catalog=dals;User Id=sa;";
try
{
conn.Open();
// Insert code to process data.
Label1.Text="Connection successful";
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
and i'm getting this error
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 91: throw ex;
Line 92: }
Line 93: finally
View 4 Replies
View Related
Feb 27, 2008
I've got a website with authentication mode "forms". Now I need access to the database to authenticate the user. The SQL Server is located in another domain than IIS.I don't know how to establish a trusted connection with the SQL Server. How can I establish this?
View 2 Replies
View Related
Apr 6, 2008
hi
i have a stored procedure witch Returns 0 or 1 dependig if exists some rows
how can i acces that value in code behind? i tryied all, command.ExecuteScalar(), command.ExecuteNonQuery() but none works
i need something like if(command.GetReurnValue) .... else ....
thanks in advance
View 3 Replies
View Related
Dec 14, 2001
Hi
I would like to acces a SQL Server that is on a web server.
I want to to this to be able to control the sql server and database to create table, trigger...
For "MySql" i use DBTools to acces my database via the web, is there something i can use like BdTools to acces the Sql Server 2000 database
I'm new to SQL so can somebody can tell me what to do!
Thanks
View 4 Replies
View Related
Dec 9, 2005
I am running an Access 2000 front end and MS SQL2000 as a backend and I am having problems with record locking.
I have just found out that If you use ODBC then Access acts as if No Locks are set. In an ideal world I need the record to be locked by a user as soon as they move onto it. If not as soon as they start editing it?
Cheers.
View 2 Replies
View Related
Jul 23, 2005
use this-is-a-stupid-namereturns an errorFor that matterselect *from this-is-a-stupid-name.dbo.anytablereturns an errorI've tried single quoted, double quotes, escaping. In the SQL editor I canselect the name from the dropdown and I'm OK - but I'm writing a perlscript to connect to the database.I didn't create the database and don't know how it was created.--Message posted via http://www.sqlmonster.com
View 2 Replies
View Related
Nov 15, 2006
Hi,
I need to access a table from another server in my procedure...I am now connected to say SERVERA...I need to access another table SERVERB.TABLE2 in the same procedure...
Is there a way to do that...
I need to connect to two servers from the same procedure to get data..
Please get back
Thanks,
View 3 Replies
View Related
Jul 22, 2005
I try to access an OLAP Server from a remote compute, using ADO MD Library with following string conection :
"Datasource=SERVNAME; Provider=msolap; Initial Catalog=FoodMart 2000;"
I recive the following error code: -2147467259 (0x80004005), "Unspecified error"
Can sombody help me
View 4 Replies
View Related
Dec 19, 2005
I have migrated an Access database to SQLserver,
all seems ok,
but I found that an "order by" on a boolean Access field, is reverse under
SQLserver ?
I had to add "desc" to my code "order by field desc" to retrieve the correct display.
Could someone confirm this ? I am very surprised.
Thanks, Pierre.
View 4 Replies
View Related
Apr 30, 2007
Hi, I'm using Sql 2000 and I have a linked server called SRVSRV.
The link works because I can list all tables.
How can I access the data i'm trying:
SELECT * FROM [SRVSRV].Database.Table
And it don't works.
What am i doing bad?
Thanks.
View 4 Replies
View Related
Feb 19, 2008
Hi there.
How can i convert a Ms Access Database file (.mdb) to an SQL Server 2005 Database ????
is there any tools ?? or what ever can help me .
Thank you.
View 2 Replies
View Related
Mar 15, 2006
I am writing a package to process perfmon logs. The issue I have come across is that the perfmon process holds onto the log file and SSIS fails because it wants to exclusive read access. Is there any way of getting SSIS to not take an exclusive read on the file.
I can read the file in notepad fine but not SSIS.
View 1 Replies
View Related
Oct 9, 2007
After an internet search I have some questions regarding SQL Server access from a mobile device via LAN / WLAN.
I will write a application in C that write data to an SQL server. First if I correct that's not possible to acces an SQL server via ODBC on Windows CE? What alternatives are there?
Stef
View 1 Replies
View Related
Mar 28, 2008
Hi All,
I have MS Access 97 database and SQL Server 2005 Express Edition (or SQL Server 2005 Developer Edition).
I want online get data from MS Access and upload to SQL Server.
Help me, which way I select ?
Regards
View 3 Replies
View Related
Jan 25, 2008
Hi friends,
I have developed a website and uploaded the database to Remote server through Export wizard in Sqlserver 2005.everything is working fine in Sqlserver enterprise manager, but when i tried to connect this database via web.config file to my website it is giving me error...
Server Error in '/Sales_offer' Application.
Invalid connection. 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: Invalid connection.Source Error:
Line 29: {
Line 30: SqlCommand mycmd=new SqlCommand("select distinct(city) from master order by city asc",myconn);
Line 31: myconn.Open();
Line 32: SqlDataReader sdr=mycmd.ExecuteReader();
Line 33: ArrayList arr=new ArrayList();Source File: d:inetpubwwwrootsales_offerindex.aspx.cs Line: 31 Stack Trace:
[SqlException: Invalid connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
Sales_offer.WebForm1.bind() in d:inetpubwwwrootsales_offerindex.aspx.cs:31
Sales_offer.WebForm1.Page_Load(Object sender, EventArgs e) in d:inetpubwwwrootsales_offerindex.aspx.cs:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
After that when i tried to access the database through Qury analyzer it is giving me error
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'salecumoffers'. No entry found with that name. Make sure that the name is entered correctly.
But it is showing me the tables and their Contents from Remote server in enterprise manager...
waiting for ur quick response
Neeraj
View 13 Replies
View Related
Mar 10, 2008
This is a part of my project and that are my first steps. I just want to know if there is a user with "username" already in the database. The MSDN Documentation says that the ExecuteNonQuery() Method returns the number of affected rows. But if I run this code I always get x=-1. What does that mean ?
using (SqlConnection sqlcon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["web_db_1"].ConnectionString)) { SqlCommand cmd = new SqlCommand("Select user_id From users Where username = '" + username + "'", sqlcon); cmd.CommandType = CommandType.Text; cmd.Connection.Open(); int x = cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
Thanks,
Party-Pansen
View 5 Replies
View Related
Mar 27, 2008
I am new to SQL Server but have been using Access to provide Multi-User acces to a central data store. We are evaluating the replacement of Access with SQL Server. With Access we don't need any special installation; I believe that the Jet Database Engine installed locally on each user's PC allows them to work with this in a disconnected manner; we use ADO.net 2.0 with VB.net 2005.
If each user has a locally installed SQL Server Express can they all attach to a database that resides on a shared network location?
In another post on the Forum I see the following regarding multi-user access:
Our application You will need to pick a central computer that everyone will be using the access the data and attach the file to the parent instance of SQL Express on that comuter, giving it a name that you can use to access it. Then you will need to modify your connection string to connect to the named database on the central server...
Can multiple locally installed SQL Server Express instances attach to a single data store that resides on a shared network location?
If not, what permissions do I need to create a parent instance of SQL Server Express?
Thank you for helping me understand how to implement our solution.
JudiR
View 13 Replies
View Related
Dec 10, 2006
What is the fastet connection between access 2003 to sql server 2005?
View 2 Replies
View Related
Jul 20, 2005
Hello:I run one process that calls the following the store procedure andworks fine.create PROCEDURE sp_GetHostSequenceNumASBEGINSELECT int_parameter_dbf + 1FROM system_parameter_dbtWHERE parameter_name_dbf = 'seqNum'UPDATE system_parameter_dbtSET int_parameter_dbf = int_parameter_dbf + 1WHERE parameter_name_dbf = 'seqNum'ENDGOIf I run two processes that call the above store procedure, I mightoccasionally get the dirty data of int_parameter_dbt. I guess that iscaused by two processes accessing to the same resource simultaneously.Is there any way to lock the store procedure call from MSSQL Serverand allow only one process to access it at a time?Thanks for help.Best Jin
View 2 Replies
View Related
Apr 28, 2008
I am developing an asp.net app using visual web developer. I am using a sql server 2005 db for the back end. I have learned that I have to restart my machine if I want to work with the db in SQL Server 2005 Express after working with it in Visual Web Developer.
I am wondering why this is. I am assuming that the db is locked when it is used with VWD. Is this correct? Am I refering to it's status of "locked" correctly? Should I call this something else?
-thanks to anyone that can help
View 3 Replies
View Related
Feb 19, 2008
Hi!!
I need some help to importing Acces file to SQL 2005.
Thank's
View 1 Replies
View Related
Feb 12, 2008
Hi,
I m totally new in SSIS Programming.
I want to transfer ABC.mdb table to my oit_imp_temp table.
Can you send me refrence with (above requiments) code that wroks for u !
thanks a lot !
View 3 Replies
View Related
Feb 12, 2008
Hi,
I m totally new in SSIS Programming.
I want to transfer ABC.mdb table to my oit_imp_temp table.
Can you send me refrence with (above requiments) code that wroks for u !
thanks a lot !
View 1 Replies
View Related
Feb 10, 2007
Hi,
Im Designed a Webpage .It consosts of a Button, whenever i click on
Button report must generated.When the report is in my system report
generated successfully.when I try to access a report from other
system.I cudnot able to access report.Can any1 hlp me inthis aspect
.any procedure in order to access the report of other system.wht shud
be url for Reportserverurl and reportpath.In short
When i click on btn i shud get report of other system.what previleges shud be given for other system in other to access
With regards,
mahender
View 3 Replies
View Related
