I am writing a new Ole DB connection thru connection manager in Visual
Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
specify a database path as d:\temp\database.dbf and set up the extended
proporties in advance tab to dBase 5.0 and when I click "test connection"
button, I gives me an error:
"Test connection failed because of an error in initializing provider.
'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
spelled correctly and that you are connected to the server on which the file
resided. "
I used browser button to get the file and path and therefore I am sure it is
correct. Can anyone please help to fix this problem? Many thanks.Hi
"00EricClapton" wrote:
> I am writing a new Ole DB connection thru connection manager in Visual
> Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I
> specify a database path as d:\temp\database.dbf and set up the extended
> proporties in advance tab to dBase 5.0 and when I click "test connection"
> button, I gives me an error:
> "Test connection failed because of an error in initializing provider.
> 'd:\temp\database.dbf ' is not a valid path. Mare sure that path name is
> spelled correctly and that you are connected to the server on which the file
> resided. "
>
> I used browser button to get the file and path and therefore I am sure it is
> correct. Can anyone please help to fix this problem? Many thanks.
>
Are you sure that the file has the correct permissions and is not locked by
another application?
John
Showing posts with label visual. Show all posts
Showing posts with label visual. Show all posts
Tuesday, March 20, 2012
Monday, March 19, 2012
Connection Manager - No available servers
Hi
Windows XP Pro, SQL Server 2005 (Developer) & Visual Studio 2005 (Pro)
New SSIS project (Visual Studio)
New OLE DB/SQL Native client connection.
There's no servers available in the drop down box.
All the services that need to be running are running.
Guess I've missed the obvious here 
Cheers
Dave
Hi,
did you try to enter the nae manually ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Yes I did. Will re-try and then post the error.|||Just tried entering the name manually and it worked...
Any ideas why I can't browse to the instance/server?
|||Do you use another port than the default one 1433 ? If so, you will have to make sure that SQL Server browser is started. What for ? See the link here for more information about the SQL Browser.http://msdn2.microsoft.com/en-us/library/ms181087.aspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Connection management
hello, I'm using Visual Foxpro and ODBC / sql server 2000.
How should i manage conections ? opening and closing it on each form ? or
opening at the begining of application and closing it at application finish
?
Thanks
Open then close not on each form, but lower.
At each transaction, on add open connection then close it.
On Select open connection then close it.
Joe
"Pedro Jose Caceres" wrote:
> hello, I'm using Visual Foxpro and ODBC / sql server 2000.
> How should i manage conections ? opening and closing it on each form ? or
> opening at the begining of application and closing it at application finish
> ?
> Thanks
>
>
How should i manage conections ? opening and closing it on each form ? or
opening at the begining of application and closing it at application finish
?
Thanks
Open then close not on each form, but lower.
At each transaction, on add open connection then close it.
On Select open connection then close it.
Joe
"Pedro Jose Caceres" wrote:
> hello, I'm using Visual Foxpro and ODBC / sql server 2000.
> How should i manage conections ? opening and closing it on each form ? or
> opening at the begining of application and closing it at application finish
> ?
> Thanks
>
>
Connection management
hello, I'm using Visual Foxpro and ODBC / sql server 2000.
How should i manage conections ? opening and closing it on each form ? or
opening at the begining of application and closing it at application finish
?
ThanksOpen then close not on each form, but lower.
At each transaction, on add open connection then close it.
On Select open connection then close it.
Joe
"Pedro Jose Caceres" wrote:
> hello, I'm using Visual Foxpro and ODBC / sql server 2000.
> How should i manage conections ? opening and closing it on each form ? or
> opening at the begining of application and closing it at application fini
sh
> ?
> Thanks
>
>
How should i manage conections ? opening and closing it on each form ? or
opening at the begining of application and closing it at application finish
?
ThanksOpen then close not on each form, but lower.
At each transaction, on add open connection then close it.
On Select open connection then close it.
Joe
"Pedro Jose Caceres" wrote:
> hello, I'm using Visual Foxpro and ODBC / sql server 2000.
> How should i manage conections ? opening and closing it on each form ? or
> opening at the begining of application and closing it at application fini
sh
> ?
> Thanks
>
>
Sunday, March 11, 2012
Connection Help!
I can't connect to my sql server 2000 database from Visual Studio using vb.net.
I'm trying to use the gotdotnet quickstart tutorials but they just throw dumb errors all the time ...
For example, I'm trying to perform a simple SELECT query
Dim myConnection As New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
Dim myCommand As New SqlDataAdapter("select * from Authors", myConnection)Dim ds As New DataSet()
myCommand.Fill(ds, "Authors")
My error - "Too many arguments to 'public sub New()' " for the SQLConnection.
I then tried this
Dim dbconn As New SqlClient.SqlConnection
dbconn.ConnectionString = "server=(local);Database=northwind;User ID=sa;trusted_connection=true"
dbconn.Open()Dim myCommand As New SqlDataAdapter("select top 1 categoryname from Categories", dbconn)
Dim ds As New DataSet
myCommand.Fill(ds, "Authors")
Now this seems to work but I'm not sure if I need to bind the SELECT information to a textbox or something (response.write(ds) doesn't work.)
Any help appreciated as this is getting bloody annoying!
CheersThe quickest way to see all the data is to open the web form in design view and drop a DataGrid control from the Toolbox window onto the form. Then switch back to code view and add the follwing lines after the Fill:
DataGrid1.DataSource = ds
DataGrid1.DataBind()
connection from SQLS database to Visual Studio. Timeout failed.
I have a databse in SQL Server 2005 Sept Beta 2. On another partition I have Visual Studio 8. I want to establish a connection between the two.
Doing it programmatically in a C# code program fails.The connection string does not give me an error on debug.
Doing it via GUI in VS fails on the account of "timeout failed..."
I tried to copy the whole database from SQL Server directory into VS directory - the same result.
Amazingly, I was able to connect to my FoxPro 9 database with no problem. Also an Access database is connected.
Is there a way to increase this parameter: timeout? Where is set up?
Thanks.Most likely the SQL Server is not running. Is this the same machine (SQL Server and VS)? Copying files is not necessary. Being on different partitions is ok as well. Can you connect using sqlcmd? If not, what is the error message you get?
When you type 'net start' in the command line do you see SQL Server started? Or check services in the Control Panel.
Boris.
Wednesday, March 7, 2012
Connection error to SqlServer
When opened my table :
Unspecified error
(MS Visual Database Tools)
here is the detailed error:
Unspecified error
(MS Visual Database Tools)
what is this error?
please help me.
Please give more details about what you are doing when you encounter this error.
Mike
|||when I opened Microsoft SQL Server Managment Studio (Express Edition) and choose a table to open (by right click on it and select open table) this error message was appeared.here is the detailed error:
===================================
Unspecified error
(MS Visual Database Tools)
Program Location:
at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
And
when i draw diagram for my database, this error message was appeared:
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)|||
This seems like a problem specific to Management Studio Express so I'm going to move this thread to the tools forum.
Mike
|||I could not find solution for error that send to last posts and Other part of error when right click on server name and select properties :
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)
Connection error to SqlServer
When opened my table :
Unspecified error
(MS Visual Database Tools)
here is the detailed error:
Unspecified error
(MS Visual Database Tools)
what is this error?
please help me.
Please give more details about what you are doing when you encounter this error.
Mike
|||when I opened Microsoft SQL Server Managment Studio (Express Edition) and choose a table to open (by right click on it and select open table) this error message was appeared.here is the detailed error:
===================================
Unspecified error
(MS Visual Database Tools)
Program Location:
at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
And
when i draw diagram for my database, this error message was appeared:
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)|||
This seems like a problem specific to Management Studio Express so I'm going to move this thread to the tools forum.
Mike
|||I could not find solution for error that send to last posts and Other part of error when right click on server name and select properties :
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)
Connection error to SqlServer
When opened my table :
Unspecified error
(MS Visual Database Tools)
here is the detailed error:
Unspecified error
(MS Visual Database Tools)
what is this error?
please help me.
Please give more details about what you are doing when you encounter this error.
Mike
|||when I opened Microsoft SQL Server Managment Studio (Express Edition) and choose a table to open (by right click on it and select open table) this error message was appeared.here is the detailed error:
===================================
Unspecified error
(MS Visual Database Tools)
Program Location:
at Microsoft.VisualStudio.DataTools.Interop.IDTTableDesignerFactory.BrowseTable(Object dsRef, Object pServiceProvider)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
And
when i draw diagram for my database, this error message was appeared:
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)|||
This seems like a problem specific to Management Studio Express so I'm going to move this thread to the tools forum.
Mike
|||I could not find solution for error that send to last posts and Other part of error when right click on server name and select properties :
-
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (.Net SqlClient Data Provider)
Saturday, February 25, 2012
Connection error
Hi there,
I installed Visual Web Developer Express and SQL Server Express. I then installed the Time Tracker Starter Kit on my localhost. My instance of SQL Server Express is 'Express'. So I updated the root web.config file. I try out the app. by creating a new user and then get this error:
Exception Details: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I'm using a HTTP connection port 7080 (ie,http://localhost:7080/TimeTracker/), does that mean I have to update anything in the app?
I was told to update SQL Server 2005 Surface Area Configuration - Remote Connections to Using both TCP/IP and named pipes. So I already did that and rebooted.
Any suggestions?
Post your connection string, it may help
|||Hey it works.
I noticed that I had to modify the database connnection under the database explorer, even though I had updated the web.config
Take care
Friday, February 24, 2012
Connection Error
I am having a problem with creating any report in Visual Studio 2003 and
Reporting Services 2000.
I can create a datasource and test the connection without any problems.
However, when I create a report that uses this datasource (or try to create
an new one) it fails with the error message "A connection cannot be made to
the database. Set and check the connection string". This problem occurs using
a brand new VS Project and report and all existing projects/reports.
All my existing reports fail now too with the same error in all projects.
Unfortunately, I do no know what would have changed that would cause this
error. Did any recent security patches cause any problems?
Any suggestions would be most appreciated.
--
WCUI was able to determine the solution. The data source is for Oracle. The
password for the account that I was using was expiring. Oracle throws and ORA
error message when connecting with a password that is about to expire.
Testing the connection in Visual Studio must trap and ignore this password
expire warning (oracle error) while trying to use this data source in a
report just fails.
Hope this helps someone in the future...
--
WCU
"StanleyHammer" wrote:
> I am having a problem with creating any report in Visual Studio 2003 and
> Reporting Services 2000.
> I can create a datasource and test the connection without any problems.
> However, when I create a report that uses this datasource (or try to create
> an new one) it fails with the error message "A connection cannot be made to
> the database. Set and check the connection string". This problem occurs using
> a brand new VS Project and report and all existing projects/reports.
> All my existing reports fail now too with the same error in all projects.
> Unfortunately, I do no know what would have changed that would cause this
> error. Did any recent security patches cause any problems?
> Any suggestions would be most appreciated.
> --
> WCU
Reporting Services 2000.
I can create a datasource and test the connection without any problems.
However, when I create a report that uses this datasource (or try to create
an new one) it fails with the error message "A connection cannot be made to
the database. Set and check the connection string". This problem occurs using
a brand new VS Project and report and all existing projects/reports.
All my existing reports fail now too with the same error in all projects.
Unfortunately, I do no know what would have changed that would cause this
error. Did any recent security patches cause any problems?
Any suggestions would be most appreciated.
--
WCUI was able to determine the solution. The data source is for Oracle. The
password for the account that I was using was expiring. Oracle throws and ORA
error message when connecting with a password that is about to expire.
Testing the connection in Visual Studio must trap and ignore this password
expire warning (oracle error) while trying to use this data source in a
report just fails.
Hope this helps someone in the future...
--
WCU
"StanleyHammer" wrote:
> I am having a problem with creating any report in Visual Studio 2003 and
> Reporting Services 2000.
> I can create a datasource and test the connection without any problems.
> However, when I create a report that uses this datasource (or try to create
> an new one) it fails with the error message "A connection cannot be made to
> the database. Set and check the connection string". This problem occurs using
> a brand new VS Project and report and all existing projects/reports.
> All my existing reports fail now too with the same error in all projects.
> Unfortunately, I do no know what would have changed that would cause this
> error. Did any recent security patches cause any problems?
> Any suggestions would be most appreciated.
> --
> WCU
Friday, February 17, 2012
Connecting With Visual Studio .net
Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck
hi Chuck,
Charles A. Lackman wrote:
> Hello,
> I have MSDE Installed on a different computer (WIndows 2003) within my
> network. I also have MSDE Installed on my production computer for
> development.
> I have successfully created databases on both computers using OSQL.
> What I would really like to accomplish is a connection from the
> Server Explorer in Visual Studio .NET.
> I have a successful connection to the local instance of MSDE and I
> added my server to the server list with no problems.
> But, this is where the problem comes in.
> Lets Say my Server is called Moon, The Servers Tree in Server
> Explorer shows Moon, I can access the Event Logs, Message Queues,
> Performance Counters and Services with on problem. But, when I click
> on SQL Servers Moon is shown with a Red X, I click the Plus (+) sign,
> type in the Login and Password, I receive the following Error:
> {DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or
> access denied.
>
the most probable causes of this problem are listed in
http://support.microsoft.com/default...06&Product=sql
... please check with the Server Network Utility that the Moon MSDE instance
has enabled network protocols, as MSDE installs by default allowing local
connections only...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Read my How to (Msde related) at:
http://spaces.msn.com/members/sholliday/
12/16/2005 entry date.
The key is the
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
stuff.
Use the KB mentioned earlier, to manually make the fix.
My stuff will teach you how to avoid the issue in the future, if you
ever install MSDE again.
(Or if you get really really stuck and need to start over)
Charles A. Lackman wrote:
> Hello,
> I have MSDE Installed on a different computer (WIndows 2003) within my
> network. I also have MSDE Installed on my production computer for
> development.
> I have successfully created databases on both computers using OSQL. What I
> would really like to accomplish is a connection from the Server Explorer in
> Visual Studio .NET.
> I have a successful connection to the local instance of MSDE and I added my
> server to the server list with no problems.
> But, this is where the problem comes in.
> Lets Say my Server is called Moon, The Servers Tree in Server Explorer
> shows Moon, I can access the Event Logs, Message Queues, Performance
> Counters and Services with on problem. But, when I click on SQL Servers
> Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
> Password, I receive the following Error:
> {DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
> denied.
>
> Any Suggestions will be greatly appreciated,
> Chuck
|||Hello,
I found a way to fix the problem,
Below is what I needed to do.
Run the svrnetcn.exe on which you installed MSDE It will show you SQL Server
Network Utility Dialogbox, Make sure that TCP/IP is enabled and the port is
1433.
Chuck
"Charles A. Lackman" <Charles@.CreateItSoftware.net> wrote in message
news:O%23rnzwCGGHA.344@.TK2MSFTNGP11.phx.gbl...
Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck
hi Chuck,
Charles A. Lackman wrote:
> Hello,
> I have MSDE Installed on a different computer (WIndows 2003) within my
> network. I also have MSDE Installed on my production computer for
> development.
> I have successfully created databases on both computers using OSQL.
> What I would really like to accomplish is a connection from the
> Server Explorer in Visual Studio .NET.
> I have a successful connection to the local instance of MSDE and I
> added my server to the server list with no problems.
> But, this is where the problem comes in.
> Lets Say my Server is called Moon, The Servers Tree in Server
> Explorer shows Moon, I can access the Event Logs, Message Queues,
> Performance Counters and Services with on problem. But, when I click
> on SQL Servers Moon is shown with a Red X, I click the Plus (+) sign,
> type in the Login and Password, I receive the following Error:
> {DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or
> access denied.
>
the most probable causes of this problem are listed in
http://support.microsoft.com/default...06&Product=sql
... please check with the Server Network Utility that the Moon MSDE instance
has enabled network protocols, as MSDE installs by default allowing local
connections only...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Read my How to (Msde related) at:
http://spaces.msn.com/members/sholliday/
12/16/2005 entry date.
The key is the
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
stuff.
Use the KB mentioned earlier, to manually make the fix.
My stuff will teach you how to avoid the issue in the future, if you
ever install MSDE again.
(Or if you get really really stuck and need to start over)
Charles A. Lackman wrote:
> Hello,
> I have MSDE Installed on a different computer (WIndows 2003) within my
> network. I also have MSDE Installed on my production computer for
> development.
> I have successfully created databases on both computers using OSQL. What I
> would really like to accomplish is a connection from the Server Explorer in
> Visual Studio .NET.
> I have a successful connection to the local instance of MSDE and I added my
> server to the server list with no problems.
> But, this is where the problem comes in.
> Lets Say my Server is called Moon, The Servers Tree in Server Explorer
> shows Moon, I can access the Event Logs, Message Queues, Performance
> Counters and Services with on problem. But, when I click on SQL Servers
> Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
> Password, I receive the following Error:
> {DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
> denied.
>
> Any Suggestions will be greatly appreciated,
> Chuck
|||Hello,
I found a way to fix the problem,
Below is what I needed to do.
Run the svrnetcn.exe on which you installed MSDE It will show you SQL Server
Network Utility Dialogbox, Make sure that TCP/IP is enabled and the port is
1433.
Chuck
"Charles A. Lackman" <Charles@.CreateItSoftware.net> wrote in message
news:O%23rnzwCGGHA.344@.TK2MSFTNGP11.phx.gbl...
Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{ConnectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck
Connecting VSS to Query Analyzer
Anyone know of a way to connect Visual Source Safe to query analyzer? I love the functionality of Query analyzer but would like to use some source control with my code. Any help would be greatly appreciated.
Thanks in advance.
VSS has a CLI that can be used to integrate with SQL QA. Ken Henderson's
book "The Guru's Guide to SQL Server Stored Procs, XML & HTML" has a section
dedicated on how to set this up (Pg 113 I think). If you've got a copy of
that book, check it out - this way, you can check in & out of VSS directly
from the Query Analyser. Ken also provides a tool called "GGSQLBuilder" that
lets you build versioned db object scripts from VSS as well. If you haven't
got access to the book, post back & I can send you more instructions if you
want to do this..
Regards,
Greg Linwood
SQL Server MVP
"TCG_GILBERT" <TCGGILBERT@.discussions.microsoft.com> wrote in message
news:83BD4718-38EC-4F9B-ADE9-082B7EE902E0@.microsoft.com...
> Anyone know of a way to connect Visual Source Safe to query analyzer? I
love the functionality of Query analyzer but would like to use some source
control with my code. Any help would be greatly appreciated.
> Thanks in advance.
>
|||I you can, get a copy of "the Guru's Guide to SQL Server Stored Procedures..." by Ken Henderson. It has several pages about using source control with QA.
Basically you use the Q.A. tools/customize option to drive the VSS ss.exe program.
For example:
Menu Name: Set Project Path
Command: ss.exe
Args: cp $/path_to_your_project
Menu Name: Set Working Folder
Command: ss.exe
Args: workfold $(FileDir)
Menu Name: Check in Current File
Command: ss.exe
Args: checkin $(FileName) $(FileExt)
InitDir: $(FileDir)
Q.A. Will repace the tokens below when the command is run
$(FilePath) full path to current file (save first or you will get file name with *)
$(FileName) filename without extension
$(FileExt) file ext with leading "."
$(FileDir) dir path of the current file
HTH
-Kevin
"TCG_GILBERT" wrote:
> Anyone know of a way to connect Visual Source Safe to query analyzer? I love the functionality of Query analyzer but would like to use some source control with my code. Any help would be greatly appreciated.
> Thanks in advance.
>
|||Thanks a bunch Greg, I'll go try to get my hands on a copy of this book. If I can't I might ask for a little more help.
Josh
"Greg Linwood" wrote:
> VSS has a CLI that can be used to integrate with SQL QA. Ken Henderson's
> book "The Guru's Guide to SQL Server Stored Procs, XML & HTML" has a section
> dedicated on how to set this up (Pg 113 I think). If you've got a copy of
> that book, check it out - this way, you can check in & out of VSS directly
> from the Query Analyser. Ken also provides a tool called "GGSQLBuilder" that
> lets you build versioned db object scripts from VSS as well. If you haven't
> got access to the book, post back & I can send you more instructions if you
> want to do this..
> Regards,
> Greg Linwood
> SQL Server MVP
> "TCG_GILBERT" <TCGGILBERT@.discussions.microsoft.com> wrote in message
> news:83BD4718-38EC-4F9B-ADE9-082B7EE902E0@.microsoft.com...
> love the functionality of Query analyzer but would like to use some source
> control with my code. Any help would be greatly appreciated.
>
>
|||Thanks a bunch Kevin, I'll go try to get my hands on a copy of this book. If I can't I might ask for a little more help.
Josh
"googleqand@.yahoo.com" wrote:
[vbcol=seagreen]
> I you can, get a copy of "the Guru's Guide to SQL Server Stored Procedures..." by Ken Henderson. It has several pages about using source control with QA.
> Basically you use the Q.A. tools/customize option to drive the VSS ss.exe program.
> For example:
> Menu Name: Set Project Path
> Command: ss.exe
> Args: cp $/path_to_your_project
> Menu Name: Set Working Folder
> Command: ss.exe
> Args: workfold $(FileDir)
> Menu Name: Check in Current File
> Command: ss.exe
> Args: checkin $(FileName) $(FileExt)
> InitDir: $(FileDir)
> Q.A. Will repace the tokens below when the command is run
> $(FilePath) full path to current file (save first or you will get file name with *)
> $(FileName) filename without extension
> $(FileExt) file ext with leading "."
> $(FileDir) dir path of the current file
> HTH
> -Kevin
>
>
> "TCG_GILBERT" wrote:
Thanks in advance.
VSS has a CLI that can be used to integrate with SQL QA. Ken Henderson's
book "The Guru's Guide to SQL Server Stored Procs, XML & HTML" has a section
dedicated on how to set this up (Pg 113 I think). If you've got a copy of
that book, check it out - this way, you can check in & out of VSS directly
from the Query Analyser. Ken also provides a tool called "GGSQLBuilder" that
lets you build versioned db object scripts from VSS as well. If you haven't
got access to the book, post back & I can send you more instructions if you
want to do this..
Regards,
Greg Linwood
SQL Server MVP
"TCG_GILBERT" <TCGGILBERT@.discussions.microsoft.com> wrote in message
news:83BD4718-38EC-4F9B-ADE9-082B7EE902E0@.microsoft.com...
> Anyone know of a way to connect Visual Source Safe to query analyzer? I
love the functionality of Query analyzer but would like to use some source
control with my code. Any help would be greatly appreciated.
> Thanks in advance.
>
|||I you can, get a copy of "the Guru's Guide to SQL Server Stored Procedures..." by Ken Henderson. It has several pages about using source control with QA.
Basically you use the Q.A. tools/customize option to drive the VSS ss.exe program.
For example:
Menu Name: Set Project Path
Command: ss.exe
Args: cp $/path_to_your_project
Menu Name: Set Working Folder
Command: ss.exe
Args: workfold $(FileDir)
Menu Name: Check in Current File
Command: ss.exe
Args: checkin $(FileName) $(FileExt)
InitDir: $(FileDir)
Q.A. Will repace the tokens below when the command is run
$(FilePath) full path to current file (save first or you will get file name with *)
$(FileName) filename without extension
$(FileExt) file ext with leading "."
$(FileDir) dir path of the current file
HTH
-Kevin
"TCG_GILBERT" wrote:
> Anyone know of a way to connect Visual Source Safe to query analyzer? I love the functionality of Query analyzer but would like to use some source control with my code. Any help would be greatly appreciated.
> Thanks in advance.
>
|||Thanks a bunch Greg, I'll go try to get my hands on a copy of this book. If I can't I might ask for a little more help.
Josh
"Greg Linwood" wrote:
> VSS has a CLI that can be used to integrate with SQL QA. Ken Henderson's
> book "The Guru's Guide to SQL Server Stored Procs, XML & HTML" has a section
> dedicated on how to set this up (Pg 113 I think). If you've got a copy of
> that book, check it out - this way, you can check in & out of VSS directly
> from the Query Analyser. Ken also provides a tool called "GGSQLBuilder" that
> lets you build versioned db object scripts from VSS as well. If you haven't
> got access to the book, post back & I can send you more instructions if you
> want to do this..
> Regards,
> Greg Linwood
> SQL Server MVP
> "TCG_GILBERT" <TCGGILBERT@.discussions.microsoft.com> wrote in message
> news:83BD4718-38EC-4F9B-ADE9-082B7EE902E0@.microsoft.com...
> love the functionality of Query analyzer but would like to use some source
> control with my code. Any help would be greatly appreciated.
>
>
|||Thanks a bunch Kevin, I'll go try to get my hands on a copy of this book. If I can't I might ask for a little more help.
Josh
"googleqand@.yahoo.com" wrote:
[vbcol=seagreen]
> I you can, get a copy of "the Guru's Guide to SQL Server Stored Procedures..." by Ken Henderson. It has several pages about using source control with QA.
> Basically you use the Q.A. tools/customize option to drive the VSS ss.exe program.
> For example:
> Menu Name: Set Project Path
> Command: ss.exe
> Args: cp $/path_to_your_project
> Menu Name: Set Working Folder
> Command: ss.exe
> Args: workfold $(FileDir)
> Menu Name: Check in Current File
> Command: ss.exe
> Args: checkin $(FileName) $(FileExt)
> InitDir: $(FileDir)
> Q.A. Will repace the tokens below when the command is run
> $(FilePath) full path to current file (save first or you will get file name with *)
> $(FileName) filename without extension
> $(FileExt) file ext with leading "."
> $(FileDir) dir path of the current file
> HTH
> -Kevin
>
>
> "TCG_GILBERT" wrote:
Connecting Visual Studio to remote SQLExpress
Hello all,
I've been trying to find an answer to this to no avail. I'm not even sure if its possible. I like to do development at home in addition to work, like most of you do. Since it is my home computer, I like to play games, so I try to keep applications to a minimum. I would like to install sqlexpress on a virtual machine (which I have successfully done), and I can connect to it via Management Studio on my local machine (non-vm). Is there a way to set visual studio to use this connection as opposed to local host? I really do not want to load sqlexpress on my local machine and have yet another thing tying up system resources.
Your feedback is appreciated.
Barret
Visual Studio should use the same connection process (string) as SSMS.
Also, you have VM tying up resouces that are not then available to SQL or VS. Using a VM is an excellent way to constrain and protect various environments -as long as you clearly realize that you are consuming both VM and Client resouces. It is a small price for the compartmentalization, and has a performance hit. Often worth the performance hit, but use caution when setting benchmarks and performance timing...
|||The answer to the VS question is Yes and No.
If you are writing code to make a manual connection to SQL Express, you can happily use the copy of SQL Express on the VM. Make sure you have correctly enabled it for remote connectons since you are technically connecting to a different computer. If you are trying to work with the database integration features of VS that allow you to create database direclty in your project and work with them using User Instances, then you can not use the copy on your VM. User Instances are only supported via local connections, there is no way to configure VS to use a remote copy of SQL Express to support that.
Mike
|||Thanks Mike!Not the answer I was hoping for, but it is the answer I needed :)
Thanks again,
Barret
Connecting Visual Studio to remote SQLExpress
Hello all,
I've been trying to find an answer to this to no avail. I'm not even sure if its possible. I like to do development at home in addition to work, like most of you do. Since it is my home computer, I like to play games, so I try to keep applications to a minimum. I would like to install sqlexpress on a virtual machine (which I have successfully done), and I can connect to it via Management Studio on my local machine (non-vm). Is there a way to set visual studio to use this connection as opposed to local host? I really do not want to load sqlexpress on my local machine and have yet another thing tying up system resources.
Your feedback is appreciated.
Barret
Visual Studio should use the same connection process (string) as SSMS.
Also, you have VM tying up resouces that are not then available to SQL or VS. Using a VM is an excellent way to constrain and protect various environments -as long as you clearly realize that you are consuming both VM and Client resouces. It is a small price for the compartmentalization, and has a performance hit. Often worth the performance hit, but use caution when setting benchmarks and performance timing...
|||The answer to the VS question is Yes and No.
If you are writing code to make a manual connection to SQL Express, you can happily use the copy of SQL Express on the VM. Make sure you have correctly enabled it for remote connectons since you are technically connecting to a different computer. If you are trying to work with the database integration features of VS that allow you to create database direclty in your project and work with them using User Instances, then you can not use the copy on your VM. User Instances are only supported via local connections, there is no way to configure VS to use a remote copy of SQL Express to support that.
Mike
|||Thanks Mike!Not the answer I was hoping for, but it is the answer I needed :)
Thanks again,
Barret
Connecting Visual Studio 2003 to SQL Server Express 2005 Edition
I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done?Cos i seem to have an error if i do so.
You can check here for basic connectivity information:
http://msdn2.microsoft.com/en-us/library/ms345332.aspx
And make sure you check out the complete Express tutorial that Microsoft puts out for free:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
Buck Woody
Connecting Visual Studio 2003 to SQL Server Express 2005 Edition
I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done?Cos i seem to have an error if i do so.
You can check here for basic connectivity information:
http://msdn2.microsoft.com/en-us/library/ms345332.aspx
And make sure you check out the complete Express tutorial that Microsoft puts out for free:
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
Buck Woody
Tuesday, February 14, 2012
Connecting toTeradata .NET data provider
I need help connecting to the Teradata .NET data provider inReporting Services.
In Visual Studio I selectNew Project thenBusiness IntelligenceProject.
Once open, in theSolution Explorer I right-click onSharedData Sources and clickAdd New Data Source.
I do not understand how to get "Teradata" to show in theType list ofavailable data sources. I do not want toconnect to Teradata via ODBC or OLD DB. I want to connect directly to the Teradata .NET data provider.
Can anyone with more experience with SSRS help me shed somelight on this?
Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.
-kushpaw
|||
kushpaw:
Add a new report say Test.rdl. Double click on it. The on click on Data tab. This is where you set Datasource etc.
-kushpaw
Hi kushpaw, that did not answer my question.
I am aware of how to set a datasource of type ODBC, SQL Server, XML, OLE DB, or Orical. What I want to know is how add Teradata to that list. Keep in mind, from my original question, I do not want to connect to Teradata through ODBC or OLE DB, but connect directly to the Teradata .NET data provider.
|||Here is the solution for others who may want to do the same thing:
Inrsreportserver.config andRSReportDesigner.config add to the <data> tag
<ExtensionName="Teradata"Type="Teradata.Client.Provider.TdConnection,Teradata.Client.Provider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c"/>
*note* The Version, Cutlure, and PublicKeyToken can be found in C:\Windows\assembly
In RSReportDesigner.config add to the <Designer> tag
<ExtensionName="Teradata"Type="Microsoft.ReportingServices.QueryDesigners.GenericQueryDesigner,Microsoft.ReportingServices.QueryDesigners"/>
Connecting to wrong SQL Server
I have a machine where I have installed Visual Studio 2005 including SQLExpr
ess. I have also installed MSDE2000. They are both named instances:
MyMachine\SQLExpress and MyMachine\S3MSDE.
Locally everything works fine. But when I connect to MyMachine from an other
machine with the connectstring containing '...Data
Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the SQ
LExpress instance of SQL Server.
WHY?
ToschIt looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||It looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:
>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:
>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.
ess. I have also installed MSDE2000. They are both named instances:
MyMachine\SQLExpress and MyMachine\S3MSDE.
Locally everything works fine. But when I connect to MyMachine from an other
machine with the connectstring containing '...Data
Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the SQ
LExpress instance of SQL Server.
WHY?
ToschIt looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||It looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Tosch" <tosch_nospam@.swissonline.ch> wrote in message
news:o50292l98e45ugu0j7cej427gm5qeaj5ju@.
4ax.com...
>I have a machine where I have installed Visual Studio 2005 including
>SQLExpress. I have also installed MSDE2000. They are both named instances:
> MyMachine\SQLExpress and MyMachine\S3MSDE.
> Locally everything works fine. But when I connect to MyMachine from an
> other machine with the connectstring containing '...Data
> Source=MyMachine\S3MSDE,1234;...' I always end up beeing connected to the
> SQLExpress instance of SQL Server.
> WHY?
> Tosch
>|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:
>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.|||ok, since I changed the port number to the port number msde2000 uses everyth
ing works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.
Tosch
On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@.online.mi
crosoft.com> wrote:
>It looks like you are always connecting to the default port. Try starting
>the SQL Server Browser Service on MyMachine. It is the browser service that
>resolves the name to the correct port.
Connecting to Visual FoxPro
I am trying to setup a report that uses a Visual FoxPro database. I can get
the report to work fine on my development machine, but when I deploy it to
the web server I get different error message, depending on the data source
setup.
Here are some of the different error messages I get:
Setup 1:
Connection type: OLE DB
Connection String: Provider=VFPOLEDB.1;Data
Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
Connect Using: Creditials stored securely in the report server (using admin
credentials for testing)
Check "Use as Windows credentials"
Error Message: Cannot open file \\server\path\table.dbf
Setup 2:
Same as above except
Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
Sequence=MACHINE
Error Message: File "table.dbf" does not exist
Setup 3:
Sames as Setup 2 except "Use as Windows Credentials" is unchecked
Error Message: Invalid path or file name.
The web server that I am deploying the report project to has several ASP.NET
applications that use the same connection string as setup 1 with no problem.
Any help would be appreciated.Hi!
Problems like this are usually permissions issues. The account that the
report server runs under needs to have permissions to the directory where
the DBFs are located. As far as I know the credentials you mention are for
SQL Server logins and not for file server directory permissions.
--
Cindy Winegarden
cindy@.cindywinegarden.com
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"jweesies" <jweesies@.discussions.microsoft.com> wrote in message
news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
>I am trying to setup a report that uses a Visual FoxPro database. I can
>get
> the report to work fine on my development machine, but when I deploy it to
> the web server I get different error message, depending on the data source
> setup.
> Here are some of the different error messages I get:
> Setup 1:
> Connection type: OLE DB
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> Connect Using: Creditials stored securely in the report server (using
> admin
> credentials for testing)
> Check "Use as Windows credentials"
> Error Message: Cannot open file \\server\path\table.dbf
> Setup 2:
> Same as above except
> Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> Sequence=MACHINE
> Error Message: File "table.dbf" does not exist
> Setup 3:
> Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> Error Message: Invalid path or file name.
> The web server that I am deploying the report project to has several
> ASP.NET
> applications that use the same connection string as setup 1 with no
> problem.
> Any help would be appreciated.|||Thanks for your reply. The Report Server service runs under
NTAuthority/Network Services. Do you know if this needs to run under a
domain account that has access to the server where the dbfs exist? If we
change it to a domain account, will it have any effect on the reports that
are currently running or any other effect on security? Thanks.
"Cindy Winegarden" wrote:
> Hi!
> Problems like this are usually permissions issues. The account that the
> report server runs under needs to have permissions to the directory where
> the DBFs are located. As far as I know the credentials you mention are for
> SQL Server logins and not for file server directory permissions.
> --
> Cindy Winegarden
> cindy@.cindywinegarden.com
>
> VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
> VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
>
>
> "jweesies" <jweesies@.discussions.microsoft.com> wrote in message
> news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
> >I am trying to setup a report that uses a Visual FoxPro database. I can
> >get
> > the report to work fine on my development machine, but when I deploy it to
> > the web server I get different error message, depending on the data source
> > setup.
> >
> > Here are some of the different error messages I get:
> >
> > Setup 1:
> > Connection type: OLE DB
> > Connection String: Provider=VFPOLEDB.1;Data
> > Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> > Connect Using: Creditials stored securely in the report server (using
> > admin
> > credentials for testing)
> > Check "Use as Windows credentials"
> > Error Message: Cannot open file \\server\path\table.dbf
> >
> > Setup 2:
> > Same as above except
> > Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> > Sequence=MACHINE
> > Error Message: File "table.dbf" does not exist
> >
> > Setup 3:
> > Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> > Error Message: Invalid path or file name.
> >
> > The web server that I am deploying the report project to has several
> > ASP.NET
> > applications that use the same connection string as setup 1 with no
> > problem.
> > Any help would be appreciated.
>
>
the report to work fine on my development machine, but when I deploy it to
the web server I get different error message, depending on the data source
setup.
Here are some of the different error messages I get:
Setup 1:
Connection type: OLE DB
Connection String: Provider=VFPOLEDB.1;Data
Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
Connect Using: Creditials stored securely in the report server (using admin
credentials for testing)
Check "Use as Windows credentials"
Error Message: Cannot open file \\server\path\table.dbf
Setup 2:
Same as above except
Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
Sequence=MACHINE
Error Message: File "table.dbf" does not exist
Setup 3:
Sames as Setup 2 except "Use as Windows Credentials" is unchecked
Error Message: Invalid path or file name.
The web server that I am deploying the report project to has several ASP.NET
applications that use the same connection string as setup 1 with no problem.
Any help would be appreciated.Hi!
Problems like this are usually permissions issues. The account that the
report server runs under needs to have permissions to the directory where
the DBFs are located. As far as I know the credentials you mention are for
SQL Server logins and not for file server directory permissions.
--
Cindy Winegarden
cindy@.cindywinegarden.com
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"jweesies" <jweesies@.discussions.microsoft.com> wrote in message
news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
>I am trying to setup a report that uses a Visual FoxPro database. I can
>get
> the report to work fine on my development machine, but when I deploy it to
> the web server I get different error message, depending on the data source
> setup.
> Here are some of the different error messages I get:
> Setup 1:
> Connection type: OLE DB
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> Connect Using: Creditials stored securely in the report server (using
> admin
> credentials for testing)
> Check "Use as Windows credentials"
> Error Message: Cannot open file \\server\path\table.dbf
> Setup 2:
> Same as above except
> Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> Sequence=MACHINE
> Error Message: File "table.dbf" does not exist
> Setup 3:
> Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> Error Message: Invalid path or file name.
> The web server that I am deploying the report project to has several
> ASP.NET
> applications that use the same connection string as setup 1 with no
> problem.
> Any help would be appreciated.|||Thanks for your reply. The Report Server service runs under
NTAuthority/Network Services. Do you know if this needs to run under a
domain account that has access to the server where the dbfs exist? If we
change it to a domain account, will it have any effect on the reports that
are currently running or any other effect on security? Thanks.
"Cindy Winegarden" wrote:
> Hi!
> Problems like this are usually permissions issues. The account that the
> report server runs under needs to have permissions to the directory where
> the DBFs are located. As far as I know the credentials you mention are for
> SQL Server logins and not for file server directory permissions.
> --
> Cindy Winegarden
> cindy@.cindywinegarden.com
>
> VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
> VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
>
>
> "jweesies" <jweesies@.discussions.microsoft.com> wrote in message
> news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
> >I am trying to setup a report that uses a Visual FoxPro database. I can
> >get
> > the report to work fine on my development machine, but when I deploy it to
> > the web server I get different error message, depending on the data source
> > setup.
> >
> > Here are some of the different error messages I get:
> >
> > Setup 1:
> > Connection type: OLE DB
> > Connection String: Provider=VFPOLEDB.1;Data
> > Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> > Connect Using: Creditials stored securely in the report server (using
> > admin
> > credentials for testing)
> > Check "Use as Windows credentials"
> > Error Message: Cannot open file \\server\path\table.dbf
> >
> > Setup 2:
> > Same as above except
> > Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> > Sequence=MACHINE
> > Error Message: File "table.dbf" does not exist
> >
> > Setup 3:
> > Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> > Error Message: Invalid path or file name.
> >
> > The web server that I am deploying the report project to has several
> > ASP.NET
> > applications that use the same connection string as setup 1 with no
> > problem.
> > Any help would be appreciated.
>
>
Subscribe to:
Posts (Atom)