Friday, March 30, 2012
Problems with tables named 'User' and 'Workflow'
the two aforementioned tables. These show no INSERT statements. I know
there are problems with a table named 'User'. For example, one cannot SELEC
T
* FROM User. One must SELECT * FROM [User]. I guess something similar is
happening with 'Workflow'.
Q 1: Where do I find a list of the table names that will give me trouble?
Q 2: I do I generate INSERT scripts for these tables?
Thanks,
JerryRJerryR (JerryR@.discussions.microsoft.com) writes:
> Downloaded an app that scripts a Sql Server db. It works well--except
> with the two aforementioned tables. These show no INSERT statements. I
> know there are problems with a table named 'User'. For example, one
> cannot SELECT * FROM User. One must SELECT * FROM [User]. I guess
> something similar is happening with 'Workflow'.
> Q 1: Where do I find a list of the table names that will give me trouble?
Look in Books Online under "Reserved Keyword".
However, Workflow is not a keywords, so that one is funky.
> Q 2: I do I generate INSERT scripts for these tables?
Without knowing that app, it's quite difficult to tell. Maybe you should
ask the vendor/author of the app.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Wednesday, March 7, 2012
Problems with connecting to Sql Server 2005 from Java application, HELP!
Hello, Everybody.
Help me please with one problem which I'm facing with while deploying java server application on my computer (this java app is jBilling). I have configured it as it was said in docs, I have added environment variable CLASPATH as Microsoft documentation said. I'm using SQL Server JDBC driver 1.2 by Microsoft. The result is that I find this message in log file:
2007-05-27 17:21:41,906 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.jdbc.sqlserver.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.jdbc.sqlserver.SQLServerDriver))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:168)
... and so on.
I have copied sqljdbc.jar to lib folder of the server. That's how I specified connection string:
jdbc:microsoftqlserver://localhost:1434;DatabaseName=Billing;integratedSecurity=false;
Can not think out what to do else. Maybe somebody knows what to do about it?
Many thanks
Looking at your connection string URL:
jdbc:microsoftqlserver://localhost:1434;DatabaseName=Billing;integratedSecurity=false;
You are ending up trying to load the SQL Server 2000 JDBC driver.
The SQL Server 2005 JDBC v1.x driver uses the following connection string URL:
jdbcqlserver://
So if you would like to use the 2005 JDBC driver (highly recommended over the 2000 JDBC driver), your resulting connection string URL will look like:
jdbcqlserver://localhost:1434;DatabaseName=Billing;integratedSecurity=false;
Note: I assume you specified the SQL user name and password somewhere else and that the SQL Server instance is running on the same machine as the JBoss application.
Also, are you trying to connect to the DAC port? 1434 is typically reserved for the DAC port. I would recommend connecting to the normal TCP port of 1433 (if default TCP port settings are used).
HTH,
Jimmy
Saturday, February 25, 2012
Problems with accessing database remotely
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:
<addname="MyConnectionString1"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Product.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>
What is my problem?
There is no SQL Server 2005 Express running on the remote server.
Jos
|||Actually, you ARE using SQL Express. The Visual Studio environment does a great job in hiding this - but behind the scenes a SQL Express database engine is running on your local machine (you can see it in the Services.msc explorer). Your web application is using the web.config connection string tofind this SQL Express database.
As the previous reply says, the error message is due to the application trying to find a SQL Express database engine running on the remote computer and serving a database called Product.mdf.
The solution to your problem may be to install SQL Express on the remote computer. You will then need to copy (attach) the Product.mdf database to the remote database server.
However, if your "remote computer" is actually a hosting provider - they may not (and most don't) support SQL Express - and may insist that you use SQL Server Enterprise instead, which is a far more robust option anyway.
|||
Why I got the error message?
The error message you got was due to the using of SQL Express in your local (development) machine.
Ok, how to solve this issue?
It is easy. Eiteher use SQL Express on your production (e.g. hosting server) [NOT Recommended] or do the following:
Attach your .mdf file to a database (e.g. new database) in the sql server of the hosting company.
Change your ConnectionString to be as following:
<add name="MyConnectionString1" connectionString="Server=YourSqlServerName;Database=MyDatabase;Integrated Security=True;" providerName="System.Data.SqlClient"/>
YourSqlServerName: Type the name of the sql server as provided by the hosting company.
MyDatabase: The database you are using which reside in the hosting company sql server.
Note: The above ConnectionString is used with "Windows Authentication", for the "Mixed Mode" use the following ConnectionString:
<add name="MyConnectionString1" connectionString="Server=YourSqlServerName;Database=MyDatabase;User ID=MyUserID; Password:MyStrongPassword"providerName="System.Data.SqlClient"/>
Problems with [Microsoft][ODBC driver for Oracle][Oracle]
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
Pitdog
Sorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.
|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***
|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.
|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD
Problems with [Microsoft][ODBC driver for Oracle][Oracle]
I have a VB application that is running fine in prod on a box without
the .net framework installed. The app queries a Oracle 8.1.7 64 bit
database. It uses the Microsoft ODBC Driver for Oracle and it works
like a champ. However I am adding some enhancements to this application
and on my local machine I have the the .NET framework installed of
course. And I am finding that my simple select statement below is
failing.
Select * From is_sec_ipass Where TO_CHAR(start_time,'yyyymm') =
'200505' And type = 'I'
I looked at the driver version on the production box as well as my box
and this is what I have found.
Prd driver = 2.573.7713.00
my box = 2.573.7713.00
Is there something I am missing here? I even stripped down the query to
this SELECT * FROM ISSEC_DB.IS_SEC_IPASS and it still bombs out.
Here is the error I get.
Error (-2147217900): [Microsoft][ODBC driver for
Oracle][Oracle]ORA-00900: invalid SQL statement
This is just killing me. Any insight you have would be great.
Thanks,
PitdogSorry I messed up on the driver version numbers
Prd driver = 2.573.7713.00
my box = 2.573.9030.00
They are different.|||I had the same problem for the past few days. I think it has to do more
with the Oracle client installed on the machine.
I had installed Orcale 9i client on the user machine and tried to run
the vb application. I was getting the same error. So I uninstalled the
Oracle 9i client and installed Oracle 8.0 client. And as I had guessed,
the application ran perfectly fine. Now I am installing Oracle 8.0
client on each user machine before distributing the application.
Looks like the Microsoft ODBC oracle driver cannot work in sync with
Oracle 9i client. I would recommend you try uninstalling Oracle 9i and
install a previous version.
*** Sent via Developersdex http://www.codecomments.com ***|||Hey Lucky Thanks for the help. I will check it out tomorrow in the am.
Fingers crossed.|||Hey Lucky no dice on this. The DB is a 8.1 db and that client I am
using is the correct one. I have opened a ticket with the DBA's here I
am hoping they can shed some light on this issue. I will post back if I
find an answer.
PD