can someone point me to the differences in the datatypes between access
and sqlserver?
I've writen a program that creates a table in access using an sql create
query. However, if I point to a sqlserver odbc datasource the query
bombs
Hi Friends,
Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0
Ok, I know it's a really basic question but I'm hoping someone will humor me. Not being a database expert I am wondering what the basic security differences are between a SQL server db and an Access db. What makes SQL a more secure choice for confidential information over Access.
I know from a useability SQL is the better choice being a multiuser access platform but I am not familar with security mechanisms employed.
I appreciate any info on this.
Thank you.
I want to knew the sql query to return differences between two tables from two different database.
View 3 Replies View RelatedHello Expert!
I have 2 Database €“ Access & SQLServer(ver 7)
I need to Import Data TblShift from Access to SQLServer €“ using DTS I€™ve done this successfully!
Now I want to use parameter so I only importing record within range (e.g. ShiftDate BETWEEN 05-24-2006 AND 06-23-2006)
In SQLServer, I have created table to store the date range as following:
TblParameter
DateFrom: 04/24/2006
DateTo: 05/23/2006
How do I use the date range from TblParameter(SQLServer) to import record from TblShift(Access) using DTS?
Is this possible or any better solution for this?
TIA
Regards,
I am using Asp.net 2.0 with C# and sql server 2000. I need to download the file which is stored in sql server database table as image datatype. So I need to download from cs page. Pls reply,Arun.
View 2 Replies View RelatedDoes anyone know what datatype I could use to store a large amount of text? I just started using sql two days ago and still trying to become familar with it. Took me a whole day to set up a damn trusted connection.....newbie
View 3 Replies View Relatedhi, what would be the data type for entering the following information to a field . 2 3/4 or 1/2 .. ... Here what I want to do, I want to be able to enter such value into that field.
Thanks
Ali
I have to do a lot of inporting from Access files. Is there a place where I can change the default datatype conversion for Access Text from nvarchar to varchar?
Thanks.
Kato
which is to parse a create table script using Microsoft.SqlServer.TransactSql.ScriptDom namespace..I get a list of statements : StatementList SQLStatement = parser.ParseStatementList(StreamReader, out errors);then I cast a relevant statement to the CreateTableStatement type which gives me access to the ColumnDefinition class.
foreach (TSqlStatement T in SQLStatement.Statements)
{ if (T is CreateTableStatement) { CreateTableStatement  TC= (CreateTableStatement)T}}
with foreach (ColumnDefinition CD in TC.Definition.ColumnDefinitions)
I am ready to loop through the columns so far so good. I can get to the column name using CD.ColumnIdetifier.Value, to the data type using CD.DataType.Name.BaseIdentifier.Value, but can't seem to get to the length definition. Meaning, I can get column1 , varchar; but I need column1, varchar(40). where do I get (40) from?I tried using ScriptTokenStream under C.DataType, but it seems to iterate through all tokens not just ones relevant to that fragment.
Hi,
on a migration from access 97 to SQL Server 7.0 columns in access like 'hyperlink' are converted to datatype 'text' on the SQL Server 7.0. Now I miss the function in the access application I had before with fields like 'hyperlink'. Now I can't start e.g. a word document with a click and I have to type in the hyperlink manualy.
Does anyone had the same problem an possibly have a resolve?
Thanks.
Michael from Frankfurt, Germany
Hello,
My datalayer of C# code is invoking a stored procedure that returns a varchar(max) SQL data type. In my ASP.NET code, I have:
SqlCommand myCommand = new SqlCommand("usp_GetTestString", myConnection);
myCommand.Parameters.Add(new SqlParameter("@TestString", SqlDbType.Text));
myCommand.Parameters["@TestString"].Direction = ParameterDirection.Output;
myConnection.Open();
myCommand.ExecuteNonQuery();
return Convert.ToString(myCommand.Parameters["@TestString"].Value);
The query fails to execute and returns an error: String[1]: the Size property has an invalid size of 0. If I change the SqlDbType.Text parameter type to SqlDBType.Varchar, 100 (or any other fixed varchar length), it works but limits the length my unlimited field text. Any suggestions on how I can use db type text or varchar(max)? The field I need to retrieve is string characters of unlimited length and
hence the datatype varchar(max).
with this message
Cannot open database "hayat" requested by the login. The login failed.Login failed for user 'NT AUTHORITYIUSR'.
but i have 'NT AUTHORITYIUSR' user n my sql srver and my db how can i mak th permission right and i don't to us user and passwordx
Hi all,
I have to transfer an Access Database to SQLserver. There're hundred of tables in the original DB which use True, False value. Those will be translated to -1, 0 in SQLserver. I need them to be 0 , 1 instead (-1=>1).
Is there a way to tell SQLServer to process this modification during the transfer or is there a store procedure which can go through all tables and modify those values ?
Any help will be appreciate..
Thank you all
I am having Access database in my local system . Values in the access database will be updated for every 5 min . I am also having Sqlserver database online with the same structure database of Access in my local system . What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
View 3 Replies View RelatedWe are using MS Access as a front end to a SQL Server 6.5
Database using ODBC & linking tables in Access.
We are unable to edit certain records using access. We
get the following error message:
"This record has been changed by another user since you started
editing it. If you save the record, you will overwrite the changes
the other user made.
Copying the changes to the clipboard will let you look at the values
the other user entered, and then paste your changes back in if you
decide to make changes."
What the message says is untrue in our case. Worse, there is
no way to recover and have the desired change posted. This error
occurs only with certain records. This error occurs when there are
no locks active (and only 1 client logged in).
I am inclined to think that this error may be the fault of ODBC.
Updating the same change directly into ISQL works fine. SQL Server Permissions
have beeen checked & double checked.
If you have suggestions as to how this error can be rectified, please contact
me:
Mark Blackburn
mark@mbari.org
http://www.mbari.org/~mark
Hello
i have one prob . i m using sql server 2000 . and i have write a store procedure to fetch data from multiple table using cursor . this query exculate in sql server . but i can't fetch this data from in our page . how to fetch data from using multiple table .plz help
thnx
How can i access multiple sqlserver database using VB
eg. insert 1 record in a database from other databse.
I migrated a DB from Access 2000 to SQLserver 2000.The tables are OK, but I see the old Access views... as TABLE inSQLserver!!Any suggestions?--
View 3 Replies View RelatedHi;
I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:
Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Any ideas?
thanks - dave
Hello
Normally we installs our SQLServers for internal use, but now we've a data supplier which we're going to expose a SQLServer at.
The datasupplier should be able to log on the SQLServer, so I've done the following.
Created an IP-adress from the outside to point at our server
Opened port 1438 in the firewall
Installed SQLServer 2000 Developer Edition as an instance (ie. ServerAINST001)
Opened SQL Server Network utility, selected the correct instance and TCP/IP and altered the default port to 1438
And tried to connect, but with no luck. Can anybody guide me in the right direction?
Kind regards
Janus
Hi,
How should I do to access a table in SQLServer Express database using VB.NET and ADODB?
Thanks!
I use Access 2007 SQLserver Upsize but get errors saying SQL Server not found. Is there another way of copying tables from Access to SQL Server 2005 Express.
I am not very familiar with SQL Server Express but did a course in SQL Server programming.
Hi,
I installed SQLServer with a instance using the following cmd:
/qn INSTANCENAME=MYINSTANCE ADDLOCAL=All SQLCOLLATION=Latin1_General_CI_AI=Latin1_General_CI_AI PIDKEY=ABCDE12345FGHIJ67890KLMNO SECURITYMODE=SQL SAPWD=Pass SQLAUTOSTART=1 ENABLENETWORKPROTOCOLS=0
When I try to connect to the server using VS2005 (VB) using the code:
Dim instance As System.Data.Sql.SqlDataSourceEnumerator = System.Data.Sql.SqlDataSourceEnumerator.Instance
Dim table As System.Data.DataTable = instance.GetDataSources()
For Each DRrow As DataRow In table.Rows 'DRrows
C1List1.AddItem(DRrow(0).ToString & ";" & DRrow(1).ToString & ";" & DRrow(3).ToString)
Next
I can see the Server Name, but not the Instance Name.
I've already checked the SQL Configurantion Manager, and I've allowed this instance to accept remote connections (created by the cmd install command).
NOTE: I'm testing the connection on a Domain, but only using the SA account (SQLmode).
Can somebody help me?
Thanks.
PS: I also created an Firewall exception in Windows on the port 1433.
Hi Friends ,
I have a problem to access the sqlserver Reporting on different server. Actually I created Sql Server Reporting in one server with in that server i able to access the report. but out of that server that means another server webapplication i unable to access it. how can i rectify this problem.
I need to access a MS-SQLSERVER with a Linux (SuSE 9.0) based computer.I need to do some selects.What do I have to do what kind of client Software and how do I have toinstall on the linux Maschine to comunicate with this Server?Probably some kind of odbc?thanx for any hints.Maximilian Gablinger
View 2 Replies View RelatedHello:
Having an extremely frustrating issue trying to connect to SQL once I've done the NET START MSSQL$SQL_DEV /c /m /T3608.
Briefly: SQL 2K and 2K5 named instances running on same DEV box. Can't open admin:<serverinstance> in SSMS, I get the following error:
"Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time. (Microsoft SQL Server, Error: 18461)
This happens regardless of credentials supplied (my AD acct (local admin on box), AD acct running SQL services or sa). Object Explorer is closed, remote connections disabled in SS Surface Area Config. I open SSMS and make no attempt to connect to server. Choose File >New > Query with Current Connection. In dialogue box, I attemp to utilize DAC and get the above error.
In DOS prompt where I issued the single user mode startup cmd, try to use sqlcmd to grab DAC session and receive the following error:
SQL Network Interfaces: An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number [xFFFFFFFF]. Sqlcmd: Error: Microsoft SQL Native Client : 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..
So, no matter what method I use, I've managed to disable ALL access to the instance, despite the tips I've seen here and on Google.
I need to move the system databases to new disk volume, but cannot do so until I can open a connection to the instance once I've put it in single user mode. Looking in the SQL Srvr log following startup in single user mode I see the following:
Message
Server is listening on [ 'any' <ipv4> 3560].
Message
Dedicated admin connection support was established for listening remotely on port 3560.
Do I need to call the port# specifically when using SSMS or sqlcmd?
I can include screenshots of the failures and mssgs if necessary.
More disturbing is in a DR situation, I CAN'T OPEN A SESSION TO THE INSTANCE, which would be a very bad thing...
Please Help!
Could someone point me to an article that shows how to configure SQLServer express so I can connect to it over the lan and Internet?
Thanks
So far I've been unable to connect to a test SQLServer Everywhere/Compact database with MS Access. I installed the new SQLServer 2005 Native Client to no avail. Has anyone done this?
View 10 Replies View RelatedHello All,I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose.This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rightsCan any one help??[:'(]Thanks Regards
View 1 Replies View RelatedHi, i need some help, i have a problem trying to access data in my local network.
I have a PC with ms windows server 2003 and ms sql server 2000, and i want that the others PC in the network can access the data. I installed the client sql server in the others PC, but i can't make it work. What i have to do?
Thanks
Hi:
I am getting access denied error "cannot connect to server" while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server.
I followed the document "Connecting to a Remove Intergration Services Server" , doc id: aa337083.
But I can connect to IS if I log remotely to the server.
Any thoughts on this ?
Thanks
-Rajesh
I am getting following errors.
===================================
Cannot connect to cvsslmdd1-vm.
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
I have used the Access 2003 Upsize Wizard to create SQLServer Tables, all worked fine except I cannot Update the tables from Access.
The idea being to use Access Forms as the front end to an SQLserver back end as the Access database is quite complex and filled with macros and queries, not one of mine.
I can update the table in SQLServer but the connected tables at the Access end are read only. Why?
Kind regards,
Johnv