Hello
Does anyone know if it is possible to use the smo db.Create() method to
create a new sql server database with sql server 2005 express? The debugger
complains that remote operations are not allowed with the default install of
sql server express.
Thank you
Martin 7 3681
hi Martin,
Martin wrote:
Does anyone know if it is possible to use the smo db.Create() method to
create a new sql server database with sql server 2005 express? The debugger
complains that remote operations are not allowed with the default install of
sql server express.
That is correct, you have to enable it first using the Surface tool.
mfG
--stefan <--
"Stefan Hoffmann" <st****@ste5an. dewrote in message
news:eD******** ******@TK2MSFTN GP04.phx.gbl...
hi Martin,
Martin wrote:
>Does anyone know if it is possible to use the smo db.Create() method to create a new sql server database with sql server 2005 express? The debugger complains that remote operations are not allowed with the default install of sql server express.
That is correct, you have to enable it first using the Surface tool.
mfG
--stefan <--
Thanks Stefan
I've tried the surface area configuration tool, but the database engine
settings pages states sql server express version can only be run in local
mode. Is there another surface tool I'm not aware of?
I'm only trying to use smo with my databases on my local c disk, so I'm not
sure why smo needs remote connectivity to do this?
Martin
"Martin" <tr************ ****@shaw.cawro te in message
news:WY6vh.8249 24$R63.66669@pd 7urf1no...
>
"Stefan Hoffmann" <st****@ste5an. dewrote in message
news:eD******** ******@TK2MSFTN GP04.phx.gbl...
>hi Martin,
Martin wrote:
>>Does anyone know if it is possible to use the smo db.Create() method to create a new sql server database with sql server 2005 express? The debugger complains that remote operations are not allowed with the default install of sql server express.
That is correct, you have to enable it first using the Surface tool.
mfG --stefan <--
Thanks Stefan
I've tried the surface area configuration tool, but the database engine
settings pages states sql server express version can only be run in local
mode. Is there another surface tool I'm not aware of?
I'm only trying to use smo with my databases on my local c disk, so I'm
not sure why smo needs remote connectivity to do this?
Martin
It considers anything outside the database to be a remote connection.
When you run the Surface Area Configuration, and you go into Services and
Connections, and click on your database, does it show a line for "Remote
Connections" ? Set it to accept local and remote connections.
Robin S.
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:8J******** *************** *******@comcast .com...
>
"Martin" <tr************ ****@shaw.cawro te in message
news:WY6vh.8249 24$R63.66669@pd 7urf1no...
>> "Stefan Hoffmann" <st****@ste5an. dewrote in message news:eD******* *******@TK2MSFT NGP04.phx.gbl.. .
>>hi Martin,
Martin wrote: Does anyone know if it is possible to use the smo db.Create() method to create a new sql server database with sql server 2005 express? The debugger complains that remote operations are not allowed with the default install of sql server express. That is correct, you have to enable it first using the Surface tool.
mfG --stefan <--
Thanks Stefan
I've tried the surface area configuration tool, but the database engine settings pages states sql server express version can only be run in local mode. Is there another surface tool I'm not aware of?
I'm only trying to use smo with my databases on my local c disk, so I'm not sure why smo needs remote connectivity to do this?
Martin
It considers anything outside the database to be a remote connection.
When you run the Surface Area Configuration, and you go into Services and
Connections, and click on your database, does it show a line for "Remote
Connections" ? Set it to accept local and remote connections.
Robin S.
Thank you Robin
Yes it does show a 'remote connections' line but enabling this option didn't
work. I'll try re-installing the express version and selecting the 'mixed
mode' option to see if that helps.
Cheers, Martin
"Martin" <tr************ ****@shaw.cawro te in message
news:c0xvh.8219 65$1T2.115134@p d7urf2no...
>
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:8J******** *************** *******@comcast .com...
>> "Martin" <tr************ ****@shaw.cawro te in message news:WY6vh.824 924$R63.66669@p d7urf1no...
>>> "Stefan Hoffmann" <st****@ste5an. dewrote in message news:eD****** ********@TK2MSF TNGP04.phx.gbl. .. hi Martin,
Martin wrote: Does anyone know if it is possible to use the smo db.Create() method to create a new sql server database with sql server 2005 express? The debugger complains that remote operations are not allowed with the default install of sql server express. That is correct, you have to enable it first using the Surface tool.
mfG --stefan <--
Thanks Stefan
I've tried the surface area configuration tool, but the database engine settings pages states sql server express version can only be run in local mode. Is there another surface tool I'm not aware of?
I'm only trying to use smo with my databases on my local c disk, so I'm not sure why smo needs remote connectivity to do this?
Martin It considers anything outside the database to be a remote connection.
When you run the Surface Area Configuration, and you go into Services and Connections, and click on your database, does it show a line for "Remote Connections" ? Set it to accept local and remote connections.
Robin S.
Thank you Robin
Yes it does show a 'remote connections' line but enabling this option
didn't
work. I'll try re-installing the express version and selecting the 'mixed
mode' option to see if that helps.
Cheers, Martin
Isn't there another line under that one that says something about Piped or
TCP/IP connections? I have both enabled.
Good luck.
Robin S.
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:rp******** *************** *******@comcast .com...
>
"Martin" <tr************ ****@shaw.cawro te in message
news:c0xvh.8219 65$1T2.115134@p d7urf2no...
>> "RobinS" <Ro****@NoSpam. yah.nonewrote in message news:8J******* *************** ********@comcas t.com...
>>> "Martin" <tr************ ****@shaw.cawro te in message news:WY6vh.82 4924$R63.66669@ pd7urf1no...
"Stefan Hoffmann" <st****@ste5an. dewrote in message news:eD***** *********@TK2MS FTNGP04.phx.gbl ... hi Martin, > Martin wrote: >Does anyone know if it is possible to use the smo db.Create() method >to create a new sql server database with sql server 2005 express? The >debugger complains that remote operations are not allowed with the >default install of sql server express. That is correct, you have to enable it first using the Surface tool. > mfG --stefan <--
Thanks Stefan
I've tried the surface area configuration tool, but the database engine settings pages states sql server express version can only be run in local mode. Is there another surface tool I'm not aware of?
I'm only trying to use smo with my databases on my local c disk, so I'm not sure why smo needs remote connectivity to do this?
Martin
It considers anything outside the database to be a remote connection.
When you run the Surface Area Configuration, and you go into Services and Connections, and click on your database, does it show a line for "Remote Connections" ? Set it to accept local and remote connections.
Robin S. Thank you Robin
Yes it does show a 'remote connections' line but enabling this option didn't work. I'll try re-installing the express version and selecting the 'mixed mode' option to see if that helps.
Cheers, Martin
Isn't there another line under that one that says something about Piped or
TCP/IP connections? I have both enabled.
Good luck.
Robin S.
Thank you Robin
As it turns out, the 'remote connections not allowed' error message was not
the cause of my problem. I spent a day trying every surface area setting and
reinstalling but the problem was actually fixed by correcting an error in my
connection string.
Smo is working fine now with my server in local mode only and I am able to
create database and tables via csharp code.
Cheers, Martin
"Martin" <tr************ ****@shaw.cawro te in message
news:guSvh.8272 73$1T2.276879@p d7urf2no...
>
"RobinS" <Ro****@NoSpam. yah.nonewrote in message
news:rp******** *************** *******@comcast .com...
>> "Martin" <tr************ ****@shaw.cawro te in message news:c0xvh.821 965$1T2.115134@ pd7urf2no...
>>> "RobinS" <Ro****@NoSpam. yah.nonewrote in message news:8J****** *************** *********@comca st.com...
"Martin" <tr************ ****@shaw.cawro te in message news:WY6vh.8 24924$R63.66669 @pd7urf1no... > "Stefan Hoffmann" <st****@ste5an. dewrote in message news:eD**** **********@TK2M SFTNGP04.phx.gb l... >hi Martin, >> >Martin wrote: >>Does anyone know if it is possible to use the smo db.Create() >>method to create a new sql server database with sql server 2005 >>express ? The debugger complains that remote operations are not >>allowed with the default install of sql server express. >That is correct, you have to enable it first using the Surface tool. >> >mfG >--stefan <-- > Thanks Stefan > I've tried the surface area configuration tool, but the database engine settings pages states sql server express version can only be run in local mode. Is there another surface tool I'm not aware of? > I'm only trying to use smo with my databases on my local c disk, so I'm not sure why smo needs remote connectivity to do this? > Martin >
It considers anything outside the database to be a remote connection.
When you run the Surface Area Configuration, and you go into Services and Connections, and click on your database, does it show a line for "Remote Connections" ? Set it to accept local and remote connections.
Robin S.
Thank you Robin
Yes it does show a 'remote connections' line but enabling this option didn't work. I'll try re-installing the express version and selecting the 'mixed mode' option to see if that helps.
Cheers, Martin Isn't there another line under that one that says something about Piped or TCP/IP connections? I have both enabled.
Good luck. Robin S.
Thank you Robin
As it turns out, the 'remote connections not allowed' error message was
not the cause of my problem. I spent a day trying every surface area
setting and reinstalling but the problem was actually fixed by correcting
an error in my connection string.
Smo is working fine now with my server in local mode only and I am able
to create database and tables via csharp code.
Cheers, Martin
Yay! Congratulations .
Robin S. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I write some PHP code which should, I think, be able to to auto create
the tables.
The SQL looks like this:
|
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message that says:
'There was a problem retrieving printer information for this object.
The object may have been sent to a printer that was unavailable.'
...
|
by: John Hughes |
last post by:
Hi,
Is it possible to create an object from a stored (database,xml or variable)
name?
For instance I have 2 class names stored in my database. Depending on the
application settings I want to create an object based on the class name that
I store in the database.
Any ideas how to do this?
|
by: ASP Yaboh |
last post by:
I have an ArrayList of data gathered from a database. I want to create a web
page from this data by creating a <table>, each cell in each row displays the
appropriate data. One of those cells in each row needs a <textarea> control.
The background supporting classes are completed, the only task left now is
to create the web page. I am at a...
|
by: max |
last post by:
Hello,
I am a newbye, and I'm trying to write a simple application.
I have five tables with three columns; all tables are identical; I need to
change some data in the first table and let VB updates the same data in all
other four tables in the right places.
I know it would be possible by using the ForeignKeyConstraint object. I have
created...
| |
by: Big Charles |
last post by:
Hello,
I would like to create an array-class to be able to call like:
Dim oMyCar as New MyCar
' After initializing oMyCar, the object has to be like:
oMyCar(0).Brand
oMyCar(0).Wheels.NumberOfWheels
oMyCar(0).Wheels.ColorOfWheels
|
by: etuncer |
last post by:
Hello All,
I have Access 2003, and am trying to build a database for my small
company. I want to be able to create a word document based on the data
entered through a form. the real question is this: can Access create
the document and place it as an OLE object to the relevant table?
Any help is greatly appreciated.
Ricky
|
by: Hetal |
last post by:
Hi...
I am a newbie VB.NET developer and i am looking at working with
ADO.NET rather than ADO. In one of our native VB application with ADO,
we used to create 1 connection object and that would help us to
connect to MS-SQL and MySQL alternatively based on the database type
and connection string i provide. So, one connection object was good...
|
by: Dave |
last post by:
I have multiple forms that will create an object. Basically a energy
efficiency measure object. The measure object will have a couple of
required properties set but after that it can have 10-20 different fields
that are optional per measure.
How do I account for the different fields that will be
posted from the different forms when I...
|
by: TG |
last post by:
Hi!
I have an application in which I have some checkboxes and depending
which ones are checked those columns will show in the datagridview
from sql server or no.
After that I have 2 buttons:
1) export to excel button exports the visible columns from the
datagridview to excel (this works fine)
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |